Search found 3032 matches
- Thu Nov 09, 2023 11:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX With Member Dynamic
- Replies: 10
- Views: 12079
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: 9178
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: 16465
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: 16465
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: 2797
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: 2562
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: 16465
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: 817
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: 3722
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...
- Tue Sep 19, 2023 9:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Bedrock delimiter
- Replies: 5
- Views: 3722
Re: Bedrock delimiter
When you think that you stumbled upon an issue, you can create a new issue in the Bedrock repository in GitHub.
- Mon Sep 11, 2023 12:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Buttons - VBA to Change Server Name
- Replies: 6
- Views: 717
Re: Action Buttons - VBA to Change Server Name
Hi Chris, It's been a while since I used code like that, probably the 10 years that have elapsed since my article. PAfE buttons are a different beast too. That being said, the article says what to do without these references (but you lose intellisense and so on). The references were visible (at leas...
- Mon Sep 11, 2023 12:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1s.cfg parameter to have Excel serial dates
- Replies: 3
- Views: 618
Re: TM1s.cfg parameter to have Excel serial dates
For those of you who want to see a bit more coding on the 3 options, here is a preliminary version with more coding: DatasourceASCIIQuoteCharacter = ''; sDate = '2023-09-11'; ######################################################## # OPTION 1: the FormatDate function ################################...
- Sun Sep 10, 2023 11:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1s.cfg parameter to have Excel serial dates
- Replies: 3
- Views: 618
TM1s.cfg parameter to have Excel serial dates
When we want to enable the use of Microsoft Excel serial dates instead of Planning Analytics serial dates, we would use UseExcelSerialDate=T in the TM1s.cfg file: https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=pitf-useexcelserialdate However, this has implications, for instance on determ...
- Sat Sep 09, 2023 4:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Bedrock And Github vs Other Options
- Replies: 22
- Views: 20573
Re: Bedrock And Github vs Other Options
I should have added emojis to my post as we all know that you are not the biggest fan of PAW 😂 It was meant to be funny 😆 and certainly not as viable option beyond any work done for fun or demo purposes. But anyway, for completeness, custom snippets can be created. https://www.ibm.com/docs/en/planni...
- Sat Sep 09, 2023 3:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Bedrock And Github vs Other Options
- Replies: 22
- Views: 20573
Re: Bedrock And Github vs Other Options
Yes, it's been 3 years. Time flies and IBM is coming to rescue:
PAW with your own custom snippets (https://www.ibm.com/docs/en/planning-an ... ess-editor)
PAW with your own custom snippets (https://www.ibm.com/docs/en/planning-an ... ess-editor)
- Sat Sep 09, 2023 3:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBCOutput Vs Google Big Query - One Person's Experience
- Replies: 5
- Views: 2607
Re: ODBCOutput Vs Google Big Query - One Person's Experience
Thanks for the detailed descriptions. I have never used Google BQ but it appears that a flat file can be loaded: https://stackoverflow.com/questions/52119663/loading-a-csv-into-bigquery-using-bq Wouldn't that be quicker and safer ? At least I do a BULK INSERT into SQL tables (Epilog of a TI process)...
- Wed Sep 06, 2023 4:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX which takes Value from Cube
- Replies: 12
- Views: 7281
Re: MDX which takes Value from Cube
Like the CubeNext function in TIWilliamSmith wrote: ↑Wed Sep 06, 2023 3:43 pm Anyway... while we're here in 2023... using ChatGPT to help generate, as well as breakdown and understand MDX statements is invaluable. It also knows Turbo Integrator and rule/feeder syntax!
- Fri Sep 01, 2023 2:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Update a process with the TM1 REST API
- Replies: 6
- Views: 1717
Re: Update a process with the TM1 REST API
Good, elegant, solution.
Minor remark, you have the $url = part twice.
Minor remark, you have the $url = part twice.
- Thu Aug 31, 2023 1:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Update a process with the TM1 REST API
- Replies: 6
- Views: 1717
Re: Update a process with the TM1 REST API
What happens to the security assignments for the process, when you delete and recreate ?
In general, I try to update rather than recreate, to not lose other settings.
Another example, data against the process in the }Processes dimension in a cube: is it lost or not, when deleting and recreating ?
In general, I try to update rather than recreate, to not lose other settings.
Another example, data against the process in the }Processes dimension in a cube: is it lost or not, when deleting and recreating ?
- Tue Aug 29, 2023 10:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }ClientGroups cube not in sync. with Cognos
- Replies: 11
- Views: 1412