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
Search found 801 matches
- Tue Nov 24, 2020 10:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Time period Dimension
- Replies: 9
- Views: 3180
- Tue Nov 24, 2020 10:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Link from Cognos to TM1 Web Contributor?
- Replies: 3
- Views: 1218
Re: Link from Cognos to TM1 Web Contributor?
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 ...
- Tue Nov 24, 2020 9:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Link from Cognos to TM1 Web Contributor?
- Replies: 3
- Views: 1218
Re: Link from Cognos to TM1 Web Contributor?
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...
- Fri Nov 13, 2020 6:31 pm
- Forum: Useful code, tips and tricks
- Topic: Month Dimension Generator with Named Hierarchies
- Replies: 0
- Views: 24240
Month Dimension Generator with Named Hierarchies
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...
- Thu Oct 08, 2020 9:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Asymmetric Views with MDX
- Replies: 1
- Views: 1264
Re: Asymmetric Views with MDX
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
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
- Fri Sep 25, 2020 8:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX views, where / how are they evaluated?
- Replies: 6
- Views: 2638
Re: MDX views, where / how are they evaluated?
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...
- Thu Sep 10, 2020 8:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Free Excel-to-Text converter
- Replies: 20
- Views: 7958
Re: Free Excel-to-Text converter
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...
- Mon Aug 24, 2020 9:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA Cubes recalculating different values
- Replies: 1
- Views: 1211
Re: PA Cubes recalculating different values
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...
- Wed Aug 05, 2020 6:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Spreading customisation
- Replies: 2
- Views: 1716
Re: Spreading customisation
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...
- Wed Jul 29, 2020 8:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Subnm index change
- Replies: 6
- Views: 2590
Re: Subnm index change
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...
- Wed Jul 29, 2020 5:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Subnm index change
- Replies: 6
- Views: 2590
Re: Subnm index change
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...
- Wed Jul 29, 2020 5:12 pm
- Forum: General
- Topic: Amazon Interview
- Replies: 2
- Views: 44895
Re: Amazon Interview
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...
- Mon Jul 13, 2020 9:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web Websheet Snapshot to Excel taking too long
- Replies: 2
- Views: 1804
Re: TM1Web Websheet Snapshot to Excel taking too long
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...
- Fri Jul 10, 2020 6:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Planning & Analytics Local Server Startup
- Replies: 3
- Views: 1499
Re: Planning & Analytics Local Server Startup
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...
- Wed Jul 01, 2020 8:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Automating TM1 in VBA
- Replies: 20
- Views: 12551
Re: Automating TM1 in VBA
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 ...
- Tue Jun 30, 2020 10:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Automating TM1 in VBA
- Replies: 20
- Views: 12551
Re: Automating TM1 in VBA
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...
- Tue Jun 30, 2020 10:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Experience with PAW and its future prospects
- Replies: 13
- Views: 6586
Re: Experience with PAW and its future prospects
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...
- Thu Jun 18, 2020 8:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Millennium Bug
- Replies: 8
- Views: 3754
Re: Millennium Bug
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...
- Thu Jun 18, 2020 8:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Millennium Bug
- Replies: 8
- Views: 3754
Re: Millennium Bug
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...
- Sun May 31, 2020 11:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Process Self Triggering
- Replies: 10
- Views: 4457
Re: TM1 Process Self Triggering
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 ...