Search found 286 matches
- Fri Apr 26, 2024 5:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15125
Re: Ultimate Long TM1 quiz
Dimension attributes or element attributes? Attributes for elements of the primary hierarchy of a dimension are stored in a separate, two-dimension cube with name like "}ElementAttributes_<DimensionName>". The two dimensions are the dimension itself and a measures dim called "}Element...
- Mon Apr 01, 2024 4:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15125
Re: Ultimate Long TM1 quiz
Couple options, you can try to claim that your boss's view just isn't set up right, but that only gives you enough time to get out of the building. I'd try to say it's the budget planners' faults if there's nothing there and they must not have correctly submitted their forecasts either by forgetting...
- Fri Mar 15, 2024 2:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15125
Re: Ultimate Long TM1 quiz
I'll say it depends, but the default behavior since 9.5.2 is that the value inputted at 0 value consolidation will be spread evenly amongst the leaves. Since there are 3 leaf children, there will be a value of 3 in each month. If the TM1 admins have been bit one too many times by users spreading on ...
- Thu Mar 07, 2024 2:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Can not see models list in TM1 Architect
- Replies: 9
- Views: 1108
Re: Can not see models list in TM1 Architect
Post your question in a new thread instead of attaching to this one.
- Fri Mar 01, 2024 10:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Concentrating two dimensions elements together to form a unique identifier
- Replies: 4
- Views: 803
Re: Concentrating two dimensions elements together to form a unique identifier
Am I understanding correct that you want to populate a new dim with the cartesian product of two source dims? Consider dim1 and dim2 below, the cartesian product would be what's listed in dim3. Is that what you're looking for? Dim1: A B C Dim2: D E F Dim3: AD AE AF BD BE BF CD CE CF If so, what you ...
- Thu Feb 29, 2024 7:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exploration View Cleaning up
- Replies: 1
- Views: 213
Re: Exploration View Cleaning up
You can turn all of the column headers off in a PAW Exploration via the Properties, but I suspect you'd like a couple of the dim element names in the columns to still be visible. Another option would be to define custom members in the MDX which would be the tuple of each dim selection in your column...
- Thu Feb 22, 2024 2:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Element Order in Dimension, PAW vs PAfE
- Replies: 7
- Views: 621
Re: Element Order in Dimension, PAW vs PAfE
I do see now in PAW where I can modify the MDX in the subset editor. Is there a way I can modify the ordering returned by TM1SUBSETALL? No, TM1SubsetAll takes only one argument: [<dim>].[<hierarchy>]. You would need to apply other MDX functions to the result of TM1SubsetAll to get desired results. ...
- Wed Feb 21, 2024 6:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Element Order in Dimension, PAW vs PAfE
- Replies: 7
- Views: 621
Re: Element Order in Dimension, PAW vs PAfE
The dimension editor in PAW Workbench will always show the result of the MDX expression [<dimension>].[<hierarchy>].members which will show every consolidation fully expanded resulting in elements being represented twice when they are children of multiple consolidations. Since an element can only ha...
- Tue Feb 20, 2024 8:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Can not see models list in TM1 Architect
- Replies: 9
- Views: 1108
Re: Can not see models list in TM1 Architect
Did you populate anything for Admin Host in File->Options within Architect?
- Fri Feb 09, 2024 6:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Code: Records per Second Tracking
- Replies: 1
- Views: 1666
Code: Records per Second Tracking
I occasionally need to test/monitor throughput of TIs, especially when tuning parallel execution or debugging sluggish TI performance usually traced to one specific cube action. Below is code that I drop in the Prolog, Data, & Epilog tabs for limiting execution to the first N records, optionally...
- Wed Feb 07, 2024 3:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Password expiration message for PAfE?
- Replies: 1
- Views: 268
Re: TM1 Password expiration message for PAfE?
I don't have anything for you for prompting on the other frontend tools, but what we did at a mode 1 shop was to use a nightly chore to send reminder emails to people whose password is about to expire and include in the email instructions on how to change password using TM1Web or Architect.
- Fri Feb 02, 2024 7:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15125
Re: Ultimate Long TM1 quiz
ABC1 A1: 31 B1: 0 C1: 0 From cube ABC, leaf children of consolidated element A will feed the mapping attribute of A since you hard coded the element reference in the ATTRS statement. Feeder has same effect as your feeder in Question #3 only this time you've cleared all prior feeders. From ABC B wil...
- Tue Jan 30, 2024 2:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15125
Re: Ultimate Long TM1 quiz
Ooohhh, you're a hard one to please :D CubeUnload, if it stopped purging feeders at some point it appears to be working in the newer versions. BUT, if you're stuck on one of the versions where you can't rely on that to purge feeders. You could right-click the ABC1 cube in Architect and unload. In PA...
- Fri Jan 26, 2024 8:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15125
Re: Ultimate Long TM1 quiz
With rule & feeders in place from Q3, unload the ABC1 cube and process feeders for cube ABC. TI code: CubeUnload('ABC1'); CubeProcessFeeders('ABC'); edit: also, ardi deserves at least half, if not full, credit for Q3 for his correct answer after I foolishly assumed you would be unloading cubes b...
- Mon Jan 22, 2024 2:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15125
Re: Ultimate Long TM1 quiz
No additional actions were announced ;) Just changed the feeder and saved the rule Then I concur with ardi, ABC1:B1 and ABC1:C1 retain their fed status from previous feeder. If model is configured with persistent feeders ON, this will persist even after a server restart. If persistent feeders is OF...
- Fri Jan 19, 2024 6:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15125
Re: Ultimate Long TM1 quiz
We're assuming persistent feeders are off and cube is unloaded/reloaded after each feeder change right? ABC1('A1', 'Total Year') = 31 (fed from ABC:B & ABC:C) ABC1('B1', 'Total Year') = 0 (not fed) ABC1('C1', 'Total Year') = 0 (not fed) ABC:A is consolidation so leaf children of A will feed ABC1...
- Thu Jan 18, 2024 2:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW - GIT Repository Connection issue
- Replies: 9
- Views: 4193
Re: PAW - GIT Repository Connection issue
Well....that worked. Thanks @wcoffen!
- Mon Jan 08, 2024 4:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW - GIT Repository Connection issue
- Replies: 9
- Views: 4193
Re: PAW - GIT Repository Connection issue
Yep, that's what I tried using the same github documentation you linked. I can see when I add the key in Github that's it's labeled as a SHA256 key, but same error when trying to connect from TM1. Thanks for suggestion, hopefully it works for anyone else stumbling onto this. For me, I've all but giv...
- Mon Jan 08, 2024 2:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW - GIT Repository Connection issue
- Replies: 9
- Views: 4193
Re: PAW - GIT Repository Connection issue
Tried both, I get the RSA with SHA-1 no longer supported by github error.
- Thu Dec 21, 2023 5:48 pm
- Forum: Free And Open Source Tools
- Topic: Can TM1py return Alias values rather than base member in MDX
- Replies: 2
- Views: 2657
Re: Can TM1py return Alias values rather than base member in MDX
edit: When I use your original mdx with execute_mdx_dataframe_shaped with argument display_attribute=True instead of execute_mdx_dataframe_pivot , I get the expected results. Might be an issue with the pivot function, but would need to look into it further. original: You could use a WITH MEMBER stat...