TM1 Forum

Hi

This post might help you

viewtopic.php?f=21&t=15596

It generates a time dimension using TI with the elements in the right order.

Regards

Paul Simon

Hi I haven't used contributor but it is basically TM1 Web so you may be able to use the TM1 Web URL API. With that you can pass eg a value into a WebSheet Cell or set the Title Dimension Element selection of a view. Once you have worked out what you need to pass, you then need to built the required ...

Hi I have never used contributor because it has never had the workflow that any client has wanted, and it is a while since I last used Cognos BI/Analytics however, this should be fairly simple. Get the link to contributor In Cognos BI add an HTML tag. Paste the link between that. You might need to r...

zTD_Month_Dim_Gen - Description This is free under the GNU license. This generates a series of CSV files which can then be read by the provided Turbo Integrator Processes to produce a month level time dimension. The start and end calendar years can be selected. It will always generate the dimension...

Hi

You can create an MDX View in TI.

Start by looking at the MDX for the Asymmetric Axis in PAX. Copy the MDX and then work out how to generate it in TI. It is just a text processing job.

Regards

Paul Simon

Hi Steve What I am wondering is whether the MDX is doing all the Cross Joins and then only applying the NONEMPTY at the end. I use a slightly different form SELECT NON EMPTY CROSSJOIN( {[actvsbud].[Actual],[actvsbud].[Budget] }, { [month].[Jan],[month].[Feb] } ) on columns FROM PNLCube I haven't exp...

Hi I think I hit a similar problem with the quotes recently. I traced the problem to the fact that when you output a string from textoutput/asciioutput it will always enclose that string in double quotes so if you put double quotes around every bit of text it doesn't work. The answer is just to omit...

Hi I have not seen this in a cube that has no rules. One possible cause might be that the formatting that gets applied can vary depending on the position of the dimensions. Do you possibly have formatting in the Version dimension on a Variance Ratio as well as on the Measures dimension? Could this p...

Hi This probably only answers part of your question, but you can control spreading as follows : In Architect/Perspectives, Right click on the Server and select Capability Assignments. You can Grant or Deny the right to Consolidation TypeIn Spreading by Group. I am not sure what else you are trying t...

Hi So there is a M:N between Entity and Branch. However, you could still create an Entity_Branch dimension. That would then allow you have a dimension where a Branch could be linked to more than one Entity and you could then use the expand approach. If you are more familiar with TI than VBA that mig...

Hi I think what you are actually trying to do is some sort of cascading selection, so the user looks up the Entity, in the Entity dimension and then looks up Branches related to that Entity in the Branch dimension and picks a Branch. Is that you are trying to do? The problem that you are seeing is a...

Hi I have just spent most of my last two days interviewing candidates (not for Amazon), however, I would guess that Amazon follow a similar process. There are only so many questions that they can ask, and if they published those there is a chance that someone could look up the answers in advance, me...

Hi Yes we have the same issue. We deploy Perspectives via Citrix and tell our users to export any big sheets using that. TM1 Web was built for small data capture sheets, not big exports. You might want to make sure that they aren't ticking any boxes in TM1 Web and effectively generating a print repo...

Hi You can start a Local Server for development purposes, if that is all you want? You probably won't be able to use Performance Modeler against it, but you can use Perspectives and Architect. I tend to agree with the previous poster - don't use Performance Modeler. AFAIK IBM are going to drop it an...

Hi Wim Looking at my code the key thing is that for the VBS to work you need to have the following folder C:\Windows\SysWOW64\config\systemprofile\desktop Below is some DOS Batch that creates this if it doesn't exist. We found that it worked better to get the TI to run a DOS Batch (.BAT) file which ...

Hi Wim I will have a look tomorrow. We have the following working as part of our system a) TI Process uses ExecuteCommand to run a DOS Batch b) The DOS Batch runs a VB Script c) The VB Script opens an Excel .xlsm and runs a macro, passing parameters In our case, the macro only merges a CSV file outp...

Hi I would agree with the comment about the usefulness of Named Hierarchies. However, I use PAX for that rather than PAW because I find it easier to use, apart from the issue of half the buttons not showing in the Set Editor, which is still an issue in 2.0.9. Some people have this issue and some don...

Hi Jim That was just an example - the important thing is the conversion factor. Date serial numbers in Excel start at 1900, and in TM1 they start at 1960. That conversion factor of - 21916 is the number of days different between 1st Jan 1900 and 1st Jan 1960. I suspect that you might be hitting a pr...

Hi Jim I am not sure that I understand the point you are making and I haven't read your rules but I am wondering if the issue is because of an anomaly between Excel's base date and TM1's base date for date values? # Adjust using Max and Min so we can rely on what goes into Date 1 YYYY-MM-DD being th...

Hi Just as a gut feel, a process that runs for 9 hours seems excessive. Are the processes perhaps reading from a SQL data source that is delivering data very slowly? I have certainly seen cases where concentrating on the data source has brought more benefits than any tinkering with TM1. Are the SQL ...