Search found 3032 matches
- Mon Jan 22, 2024 9:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Perspectives Report
- Replies: 6
- Views: 1390
Re: Perspectives Report
You can do without a cube. You use alternate hierarchies and use PAfE.
- Sat Jan 20, 2024 1:43 pm
- Forum: Useful code, tips and tricks
- Topic: Transfer private objects from one user to another
- Replies: 7
- Views: 14331
Re: Transfer private objects from one user to another
You’re welcome Jim
- Fri Jan 19, 2024 4:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Perspectives Report
- Replies: 6
- Views: 1390
Re: Perspectives Report
What you try to do is exactly alternate hierarchies. Do you have PAW and PAfE as well ? It will be much easier. If not, is A through D a real dimension in the cube of data ?
An example output would be useful too ?
An example output would be useful too ?
- Fri Jan 19, 2024 4:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Perspectives Report
- Replies: 6
- Views: 1390
Re: Perspectives Report
Can you show a picture of the dimension ? Only the relevant part and no alias for exanple. Then we see better the element names and what is at play.
- Fri Jan 19, 2024 7:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Perspectives Report
- Replies: 6
- Views: 1390
Re: Perspectives Report
How is it set up in the dimension, more precisely, a hierarchy might better suit your purposes although Perspectives is out then and PAfE will be better. Do you have your rollups to aggregate in a cube ?
- Sat Jan 13, 2024 12:57 am
- Forum: Useful code, tips and tricks
- Topic: Transfer private objects from one user to another
- Replies: 7
- Views: 14331
Re: Transfer private objects from one user to another
Updated version below.
- Sat Jan 06, 2024 5:31 pm
- Forum: Useful code, tips and tricks
- Topic: Exporting and importing users and groups for security
- Replies: 0
- Views: 1574
Exporting and importing users and groups for security
Hello all, I am in the last steps of a migration from an on-premise TM1 model to the IBM cloud. The majority of my time was spent changing TI process data sources of Cognos Framework Manager packages to plain text files. "Thank you" IBM for removing the good old TM1 Package Connector :evil...
- Fri Jan 05, 2024 8:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW MDX Query
- Replies: 3
- Views: 1509
Re: PAW MDX Query
Or, use the Descendants function with an easier syntax.
- Mon Jan 01, 2024 11:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18675
Re: REST API Dimension Clone
Thank you. Happy new year to all
- Sat Dec 30, 2023 10:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18675
Re: REST API Dimension Clone
Thank you Ardian. Good additions. Maybe useful to post a sample file for 'config.ini' (though probably standard and not too difficult to do it ourselves) ? Of course without sensitive information but just the structure and some examples of entries. I would also skip the If test for the PRO extension...
- Thu Dec 28, 2023 12:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18675
Re: REST API Dimension Clone
Thanks Dan.Kelleher. After some modifications, this works fine for me: #.\hot_promote_process.ps1 my_process_name DEV PRD PATCH $processName = $args[0] $sourceEnv = $args[1] $targetEnv = $args[2] $method = $args[3] function Set-Header { param ( $EncodedText ) $header = @{ "Content-Type"=&q...
- Fri Dec 15, 2023 12:21 pm
- Forum: Useful code, tips and tricks
- Topic: Get the most out of Planning Analytics/TM1 Logging
- Replies: 2
- Views: 11268
Re: Get the most out of Planning Analytics/TM1 Logging
Informative as always
- Fri Dec 01, 2023 7:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Saving and Reusing user settings
- Replies: 10
- Views: 12792
Re: Saving and Reusing user settings
Very sad
- Fri Dec 01, 2023 3:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Saving and Reusing user settings
- Replies: 10
- Views: 12792
Re: Saving and Reusing user settings
What is unfortunate, is that subsets for the picklists all have to exist. It is not possible to inject an MDX for a subset (combining several inputs in a string for the MDX) and have the server execute it at run-time. That would be much neater. You can work around with a button and a simple TI proce...
- Thu Nov 23, 2023 6:50 pm
- Forum: Useful code, tips and tricks
- Topic: Transfer private objects from one user to another
- Replies: 7
- Views: 14331
Transfer private objects from one user to another
Hi all, I thought this TI process might be useful to others as well. I have been writing this over the past couple of days, so if anyone wants to further test it, much appreciated ! The idea is that users in a TM1 model can have private objects: - subsets (*.sub files) - classic views (*.vue files) ...
- Thu Nov 16, 2023 12:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18675
Re: REST API Dimension Clone
I clearly need some help, so if someone can share a powershell script that does something similar, i would really appreciate it Hello, I do hope that someone can post code here. Until then, I would advise to start yourself because if no one does, you still have nothing. Build it gradually, hardcode...
- Wed Nov 15, 2023 10:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18675
Re: REST API Dimension Clone
Can you provide some details about your Powershell Script you use to hot promote TI Processes? I am trying to do the same thing but I cant find any help online Where are you in your TM1 REST api journey ? Do you use a tool like Postman to execute requests and capture the response ? Do you use Pytho...
- Wed Nov 15, 2023 10:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance drop between 2.0.9.1 and 2.0.9.15
- Replies: 7
- Views: 10001
Re: Performance drop between 2.0.9.1 and 2.0.9.15
I understand all of that, but it’s a repetition of what you wrote. If you want to narrow down the problem you will need to comment out code and see it in more detail using asciioutput or similar. On both machines. Then compare and narrow down even further if needed.
- Tue Nov 14, 2023 6:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance drop between 2.0.9.1 and 2.0.9.15
- Replies: 7
- Views: 10001
Re: Performance drop between 2.0.9.1 and 2.0.9.15
What are you loading those data to ? Regular cube cells ? Cells in attribute cubes ?
Did you try limiting the TI processes to only an AsciiOutput ?
Is connecting to the source taking a long time or processing the data/metadata tabs ?
Did you try limiting the TI processes to only an AsciiOutput ?
Is connecting to the source taking a long time or processing the data/metadata tabs ?
- Tue Nov 14, 2023 6:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18675
Re: REST API Dimension Clone
AFAIK, indeed you need the elements and the edges.
No direct endpoint to do this although that would be useful.
No direct endpoint to do this although that would be useful.