Search found 284 matches

by ascheevel
Fri Mar 15, 2024 2:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 49
Views: 5225

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 ...
by ascheevel
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: 536

Re: Can not see models list in TM1 Architect

Post your question in a new thread instead of attaching to this one.
by ascheevel
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: 256

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 ...
by ascheevel
Thu Feb 29, 2024 7:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exploration View Cleaning up
Replies: 1
Views: 169

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...
by ascheevel
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: 479

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. ...
by ascheevel
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: 479

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...
by ascheevel
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: 536

Re: Can not see models list in TM1 Architect

Did you populate anything for Admin Host in File->Options within Architect?
by ascheevel
Fri Feb 09, 2024 6:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Code: Records per Second Tracking
Replies: 0
Views: 210

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...
by ascheevel
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: 196

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.
by ascheevel
Fri Feb 02, 2024 7:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 49
Views: 5225

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...
by ascheevel
Tue Jan 30, 2024 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 49
Views: 5225

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...
by ascheevel
Fri Jan 26, 2024 8:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 49
Views: 5225

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...
by ascheevel
Mon Jan 22, 2024 2:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 49
Views: 5225

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...
by ascheevel
Fri Jan 19, 2024 6:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 49
Views: 5225

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...
by ascheevel
Thu Jan 18, 2024 2:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - GIT Repository Connection issue
Replies: 9
Views: 4022

Re: PAW - GIT Repository Connection issue

Well....that worked. Thanks @wcoffen!
by ascheevel
Mon Jan 08, 2024 4:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - GIT Repository Connection issue
Replies: 9
Views: 4022

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...
by ascheevel
Mon Jan 08, 2024 2:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - GIT Repository Connection issue
Replies: 9
Views: 4022

Re: PAW - GIT Repository Connection issue

Tried both, I get the RSA with SHA-1 no longer supported by github error.
by ascheevel
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: 2125

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...
by ascheevel
Tue Dec 12, 2023 4:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW - GIT Repository Connection issue
Replies: 9
Views: 4022

Re: PAW - GIT Repository Connection issue

Public or enterprise Github? I ran into similar errors trying to connect on-prem PAW to an enterprise Github repo and so far haven't got it working. I suspected that the connection was being blocked/rejected by enterprise github admins but haven't confirmed that. You are using the SSH url and not th...
by ascheevel
Fri Dec 01, 2023 2:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM usage exploding with CubeUnload and ViewConstruct
Replies: 5
Views: 11698

Re: RAM usage exploding with CubeUnload and ViewConstruct

How big is the view in your ViewConstruct? You should be able to construct a small view to trigger the cube load back into memory. Also, when a cube is reloaded to memory, feeders are reprocessed which takes time & memory. The server theoretically should be reusing the garbage memory from the pr...