Search found 3045 matches
- Fri Jan 05, 2024 8:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW MDX Query
- Replies: 3
- Views: 1556
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: 18799
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: 18799
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: 18799
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: 11985
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: 12865
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: 12865
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: 15154
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: 18799
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: 18799
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: 10093
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: 10093
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: 18799
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.
- Thu Nov 09, 2023 11:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX With Member Dynamic
- Replies: 10
- Views: 12164
Re: MDX With Member Dynamic
Good information Declan. In the first code snippet, I would calculate the variance based on the 2 variables above. Less hardcoded elements, shorter code too. WITH MEMBER [Period].[Period].[Latest Period] AS StrToMember ( "[Period].[Period].[" + [System Variables].([System Variables Lines]....
- Mon Oct 23, 2023 8:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW How to make View Filters work together
- Replies: 9
- Views: 9277
Re: PAW How to make View Filters work together
What you are looking for is something IBM has talked about doing for a long time, but I don't see it on the roadmap. https://bigblue.aha.io/published/30f7b700d5eb7d18cfdd19c793f4a10d?page=4 Basically it would be an extension of synchronisation where the target set MDX is dynamically driven by the s...
- Fri Oct 20, 2023 5:52 pm
- Forum: Useful code, tips and tricks
- Topic: MDX - Intrinsic Members
- Replies: 12
- Views: 17369
Re: MDX - Intrinsic Members
Hi, I found one use case as follows FILTER( [ DimensionName ].MEMBERS , [ DimensionName ].CURRENTMEMBER.PROPERTIES(" AttributeName ") = IIF([}ElementAttributes_ DimensionName ].[ AttributeName ].PROPERTIES("Element_Type") = "2" , " SearchTerm1 " , " Sear...
- Thu Oct 19, 2023 7:16 am
- Forum: Useful code, tips and tricks
- Topic: MDX - Intrinsic Members
- Replies: 12
- Views: 17369
Re: MDX - Intrinsic Members
Probably, which attributes are aliases, which are string attributes, which are numeric.
Something like the DType or ElementType functions.
- Wed Oct 11, 2023 5:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW Git repository integration Issues
- Replies: 1
- Views: 2858
Re: PAW Git repository integration Issues
Same question in the IBM PA community: https://community.ibm.com/community/user/businessanalytics/discussion/paw-git-repository-integration-issues?ReturnUrl=%2fcommunity%2fuser%2fbusinessanalytics%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3d8fde0600-e22b-4178-acf5-bf4eda43146b#bm4...
- Thu Oct 05, 2023 6:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel formula with links - Tm1 Web
- Replies: 2
- Views: 2597
Re: Excel formula with links - Tm1 Web
Won’t work
- Tue Oct 03, 2023 9:43 pm
- Forum: Useful code, tips and tricks
- Topic: MDX - Intrinsic Members
- Replies: 12
- Views: 17369
Re: MDX - Intrinsic Members
Good question. After 30 min trying a few things I could not come up with a solution using MDX for subsets.