Search found 3043 matches
- Sat Dec 30, 2023 10:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18796
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: 18796
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: 11959
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: 15134
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: 18796
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: 18796
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: 10092
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: 10092
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: 18796
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: 12157
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: 9275
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: 17354
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: 17354
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: 2856
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: 2596
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: 17354
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.
- Tue Sep 26, 2023 9:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Failed to open temp file for processing tm1rawstore.<DateTime>
- Replies: 5
- Views: 869
Re: Failed to open temp file for processing tm1rawstore.<DateTime>
Thanks for providing the resolution.
I have never put that directory inside the TM1 data directory.
Just like the TM1 logging directory, never located inside the TM1 data directory.
I have never put that directory inside the TM1 data directory.
Just like the TM1 logging directory, never located inside the TM1 data directory.
- Tue Sep 19, 2023 10:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Bedrock delimiter
- Replies: 5
- Views: 3795
Re: Bedrock delimiter
OK, that may be a long term solution. My question was, if I missed a detail or if I should use the function differently, because I never think, that I was the first one, who discovered an issue. :D If it is not a bug, but it is a feature, I can live with that. Thanks Wim! I would advise you to look...