Search found 3515 matches
- Thu May 16, 2024 11:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 83
- Views: 14790
Re: Ultimate Long TM1 quiz
Anybody else? I think it's one of the hardest questions in this quiz @MVPs, @Admins, can you share your thoughts also? [‘a’] = [‘b’] + 4; Well this specific case is highly, highly theoretical as I can't imagine any practical use for such a rule in real life. Seem as it is an open rule applying at a...
- Thu May 16, 2024 7:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Is it possible to open a PAW report in PAX?
- Replies: 5
- Views: 984
Re: Is it possible to open a PAW report in PAX?
We have a few PAW books created in PAW and want to open them from PAX. The reports have attributes displaying along with measures. It's a completely different UI. Sure you could recreate a PAW book in Excel with the same content and layout but you would be recreating it. You could have a hyperlink ...
- Wed May 08, 2024 4:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Profit and Loss Driven By Dept or By Site
- Replies: 4
- Views: 673
Re: Profit and Loss Driven By Dept or By Site
I think the easiest way to solve this (assuming the GUI is PAfE or Perspectives or Apliqo UX) would be to have a helper dimension which encodes valid reporting selections. (This dimension is artificial and just for lookups and isn't in the cube.) The helper dimension would have attributes for Accoun...
- Tue May 07, 2024 7:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Profit and Loss Driven By Dept or By Site
- Replies: 4
- Views: 673
Re: Profit and Loss Driven By Dept or By Site
It's not possible to answer your question without you first providing more information about the current structure of the GL cube. What are the dimensions of the cube? Do Department and Site Code map to existing dimensions? What do you mean by the "measure" dimension? (Usually in a GL cube...
- Mon May 06, 2024 9:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Create Parent Child from N_Level Element.
- Replies: 3
- Views: 363
Re: Create Parent Child from N_Level Element.
You are going about this all wrong. Just accept that a element type in TM1 once defined is immutable. However, *news flash* it doesn't matter since you also have aliases. In your hypothetical scenario there is no need to do anything to "1234_A". The element doesn't need to be recreated, th...
- Mon May 06, 2024 9:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Universal reports
- Replies: 7
- Views: 2605
Re: Universal reports
Is anyone aware of any utility that can help to migrate perspective reports to Universal Reports? Even if it does only half of the work, it will still be helpful No this doesn't exist and never will unless a 3rd party comes up with something. Because PAfE also supports slice reports and active form...
- Fri May 03, 2024 1:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Create Parent Child from N_Level Element.
- Replies: 3
- Views: 363
Re: Create Parent Child from N_Level Element.
What you are describing honestly makes no sense at all. In the real-world prices change all the time and in any sensibly designed system you do not change product code identifiers for a change in price. The same product may sell for different prices in different channels, or in the same channel in d...
- Tue Apr 30, 2024 8:06 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Architect/Perspectives to be removed from PAoC
- Replies: 3
- Views: 515
Re: Architect/Perspectives to be removed from PAoC
The reason may be a little bogus but it certainly won't lessen the user experience for Modlers/Admins. And bear in mind that PAoC RDP and Arcitect/Perspectives are only available for Modlers not the general user population who have only ever had Workspace and PAfE. From a model building and administ...
- Mon Apr 29, 2024 3:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: log file for tm1a.exe
- Replies: 4
- Views: 1218
Re: log file for tm1a.exe
Your OS seems a little outdated ... Won't help with your issue but just for clarity: - tm1a.exe is architect - admin server is tm1admsrv.exe (or tm1admsd.exe for the service runner) Are you attempting to use the 32 bit version from bin or the 64 bit version from bin64? There have been issues in the ...
- Tue Apr 23, 2024 7:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Can MDX work across alt hierarchies from one dim?
- Replies: 7
- Views: 921
Re: Can MDX work across alt hierarchies from one dim?
Looks like it gives me incompatible dimensionality error. Could anyone help to confirm? Thanks. e.g. Union( [dim].[a].children, [dim].[c].children ) This can't work by definition. The hierarchies are separate entities. No C elements are shared. You could use Generate to loop a set on one hierarchy ...
- Mon Apr 22, 2024 7:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI Process with Cube and View Name as Parameter
- Replies: 5
- Views: 1706
Re: TI Process with Cube and View Name as Parameter
hmmm ... a generic process for exporting TM1 cube data you say ...
https://github.com/cubewise-code/bedroc ... export.pro
https://github.com/cubewise-code/bedroc ... export.pro
- Tue Apr 09, 2024 8:08 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX analysis of what you are feeding
- Replies: 10
- Views: 1385
Re: MDX analysis of what you are feeding
Thanks Wim, that's an interesting read, most of the items are pretty obscure. A few items stand out though TI Functions. Interesting that the ASCIIOutput function is not listed, the one thing that has been known for a long while to not be possible. Same for ExecuteCommand. AssignClientPassword - I'...
- Thu Mar 28, 2024 7:19 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to avoid queuing at the end of processes parallelization ?
- Replies: 5
- Views: 2723
Re: How to avoid queuing at the end of processes parallelization ?
Data commit (the last step of the process) is single threaded / locking as it updates the cube index structure, so it might be the case when a lot of Tis are committing at the same time and are queuing due to this. It might be better to split data less evenly, so that they're committing at differen...
- Wed Mar 27, 2024 8:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Rule to Propagate Values Between Dimensions
- Replies: 7
- Views: 3091
Re: TM1 Rule to Propagate Values Between Dimensions
Hi MarenC, Thank you so much for your reply, but I tried this, this isnt working. And I am writing the rule in product attribute cube only. 2 rules I tried:- 1.) ['at_PBBU'] = S: If( (DB('}ElementAttribute_Cpg_hierarchy', ATTRS('Product', !Product ,'at_CPG'), 'att_PPBU') @= 'Y') , 'Y' , '' ); 2.) [...
- Fri Mar 22, 2024 9:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CubeSecurity and ProcessSecurity
- Replies: 4
- Views: 2007
Re: CubeSecurity and ProcessSecurity
If I am not mistaken, the TI process will generate error if there is command to update the cube. You are mistaken. TI processes always run with DataAdmin rights (full Admin if the "Security Access" option is also selected). Therefore users can update dimension and cubes they don't have th...
- Tue Mar 19, 2024 7:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
- Replies: 18
- Views: 2457
- Mon Mar 04, 2024 12:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }Drill process return handle
- Replies: 3
- Views: 818
Re: }Drill process return handle
I wasn't aware of this. Will have to look up ReturnCSVTableHandle and see if I can get it to work. The "classic" way of doing this is to use a text to ODBC driver and set up a public ODBC DSN pointed to a specific folder then have a TI process write a CSV to the folder which can then be di...
- Mon Mar 04, 2024 11:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Concentrating two dimensions elements together to form a unique identifier
- Replies: 4
- Views: 801
Re: Concentrating two dimensions elements together to form a unique identifier
It might help if you can explain why you need to do this. Do you need to flatten data and export using the key to another system?
- Thu Feb 29, 2024 12:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ViewConstruct on XBV view
- Replies: 1
- Views: 299
Re: ViewConstruct on XBV view
I assume the version in your profile isn't up to date? What version are you on as I am quite sure this has been solved for quite some time.
- Wed Feb 28, 2024 6:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RAM and PVU licensing
- Replies: 6
- Views: 1004
Re: RAM and PVU licensing
+100 for George’s 1st post.