Search found 583 matches
- Tue Oct 24, 2023 1:53 pm
- Forum: Useful code, tips and tricks
- Topic: MDX - Intrinsic Members
- Replies: 12
- Views: 14568
Re: MDX - Intrinsic Members
Can you expand on how would you like to filter? Probably, which attributes are aliases, which are string attributes, which are numeric. Something like the DType or ElementType functions. Hi, I found one use case as follows FILTER( [ DimensionName ].MEMBERS , [ DimensionName ].CURRENTMEMBER.PROPERTI...
- Tue Oct 24, 2023 1:49 pm
- Forum: Useful code, tips and tricks
- Topic: MDX - Intrinsic Members
- Replies: 12
- Views: 14568
Re: MDX - Intrinsic Members
Got a question. Can we use "ELEMENT_TYPE" to filter for Aliases? Can you expand on how would you like to filter? Use the MDX filter function with ELEMENT_TYPE property to filter for aliases. i.e., is there an ELEMENT_TYPE value for aliases on an }ElementAttribute dimension. As Wim referre...
- Tue Oct 24, 2023 1:46 pm
- Forum: Useful code, tips and tricks
- Topic: MDX - Intrinsic Members
- Replies: 12
- Views: 14568
Re: MDX - Intrinsic Members
Got a question. Can we use "ELEMENT_TYPE" to filter for Aliases? Can you expand on how would you like to filter? Use the MDX filter function with ELEMENT_TYPE property to filter for aliases. i.e., is there an ELEMENT_TYPE value for aliases on an }ElementAttribute dimension. As Wim referre...
- Tue Oct 03, 2023 9:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Bedrock And Github vs Other Options
- Replies: 22
- Views: 18966
Re: Bedrock And Github vs Other Options
Interesting, but it's not exactly the 7th cavalry , I'm afraid. It's only for people who can get PAW working (and I admit that our uber-locked down environment doesn't help with that) or who could tolerate the idea of working with PAW (and I admit that such a concept is beyond me, and forever shall...
- Tue Oct 03, 2023 1:42 pm
- Forum: Useful code, tips and tricks
- Topic: MDX - Intrinsic Members
- Replies: 12
- Views: 14568
Re: MDX - Intrinsic Members
Got a question. Can we use "ELEMENT_TYPE" to filter for Aliases?
- Wed Aug 16, 2023 2:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Filter doesn't see value Calculation by CalculatedCount
- Replies: 3
- Views: 805
Re: MDX Filter doesn't see value Calculation by CalculatedCount
So what is desired is to return a set of the top level elements where at least one leaf element is populated with a flag value in the cube? Instead of another dimension, consider adding an alternate hierarchy with the only components of the top level consolidation are the leaf elements: --9000000000...
- Thu Jun 22, 2023 1:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Run Process - How to Determine When All Completed.
- Replies: 24
- Views: 3969
Re: Run Process - How to Determine When All Completed.
Wasn't there a post the other day about some additional variables available for use with RunProcess? I searched but have not found it. You may be referring to my earlier post in this thread. The NEW PA engine (What was to be Server 12) has some useful new functions to handle communication between t...
- Tue Jun 20, 2023 5:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Run Process - How to Determine When All Completed.
- Replies: 24
- Views: 3969
Re: Run Process - How to Determine When All Completed.
File semaphores is what I use currently to control a parent process. I believe I read about using adding/removing attributes or elements and tested it a few years back, but never used in production. The file semaphores seem to work well enough. Wasn't there a post the other day about some additional...
- Tue Jun 20, 2023 4:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Run Process - How to Determine When All Completed.
- Replies: 24
- Views: 3969
Re: Run Process - How to Determine When All Completed.
With RunProcess I observe huge increases in memory. Also, Synchronized when used in PAW does not seem to make the parent process wait for all child processes to finish. Not sure if others see this behavior as well ? I would not expect SYNCHRONIZE to make the parent process wait for the child proces...
- Tue Jun 20, 2023 2:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Run Process - How to Determine When All Completed.
- Replies: 24
- Views: 3969
Re: Run Process - How to Determine When All Completed.
With RunProcess I observe huge increases in memory. Also, Synchronized when used in PAW does not seem to make the parent process wait for all child processes to finish. Not sure if others see this behavior as well ? I would not expect SYNCHRONIZE to make the parent process wait for the child proces...
- Fri Jun 16, 2023 1:22 pm
- Forum: Enhancements
- Topic: Enable ViewZeroOut against asymmetric MDX views.
- Replies: 7
- Views: 8925
- Fri Jun 16, 2023 1:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Run Process - How to Determine When All Completed.
- Replies: 24
- Views: 3969
Re: Run Process - How to Determine When All Completed.
This can be accomplished with SYNCHRONIZE. Say you have two groups of processes to execute. The second group should not execute until after the first group has all finished. For each RunProcess of the first group, SYCHRONIZE a distinct object (remember, it is just a token and does not have to be an ...
- Fri Jun 16, 2023 12:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ServerSandboxDelete function not working
- Replies: 0
- Views: 9235
ServerSandboxDelete function not working
Ran into this gotcha yesterday as we are implementing Sandboxing. ServerSandboxDelete does not appear to work. The client can delete a sandbox from the PAW user interface, but forget doing it with a TI once the Sandbox has been loaded into memory according to this: https://www.ibm.com/support/pages/...
- Wed Mar 22, 2023 2:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Add an element to a control dimension with non-Admin user ID?
- Replies: 7
- Views: 1034
Re: Add an element to a control dimension with non-Admin user ID?
If you have a TI with security access checked, I think you can.
- Wed Jan 25, 2023 9:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: quote issue on a MDX TurboIntegrator function
- Replies: 7
- Views: 2843
Re: quote issue on a MDX TurboIntegrator function
Always use EXPAND() as well. Makes parsing more complex MDX easier to read vs. concatenations to me.
- Wed Jan 25, 2023 3:42 pm
- Forum: Enhancements
- Topic: Python Integration PA on Cloud
- Replies: 4
- Views: 7348
- Thu Dec 08, 2022 3:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX escape special character
- Replies: 7
- Views: 4630
Re: MDX escape special character
After reading the link Wim provided, I have to say it makes a good point about not using the shortcut. I have used both the cube query and the short cut although most of the time I've used the shortcut syntax. Will probably adjust that going forward as it is more clear using the cube query. Also on...
- Tue Dec 06, 2022 10:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX escape special character
- Replies: 7
- Views: 4630
Re: MDX escape special character
Thanks PavoGa, for my own MDX I rarely use the ".CurrentMemember.Properties", can you advise when it should be used? After reading the link Wim provided, I have to say it makes a good point about not using the shortcut. I have used both the cube query and the short cut although most of th...
- Tue Dec 06, 2022 3:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX escape special character
- Replies: 7
- Views: 4630
Re: MDX escape special character
If you're filtering by an attribute string, you don't need to use StrToMember, the below should work assuming no typos on my part. FILTER( TM1SubsetAll([investmentID]), [investmentID].[creation_date] = [SysParameters].([Parameters].[sCurrentYear], [sysParameterMSR].[sDate] ) This can be refined and...
- Thu Jul 14, 2022 4:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX oddity on }Cubes dimension
- Replies: 6
- Views: 1201
Re: MDX oddity on }Cubes dimension
Hi, I tried on a later version (11.8.1200) and on a completely different windows server, and on a complex model, and it still works fine for me. Maren Thank you again for confirming it does work. Just do not know why it is not working here for me. :roll: ***UPDATE*** Okay, I have been sleep walking...