Search found 583 matches

by PavoGa
Tue Oct 24, 2023 1:53 pm
Forum: Useful code, tips and tricks
Topic: MDX - Intrinsic Members
Replies: 12
Views: 14479

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...
by PavoGa
Tue Oct 24, 2023 1:49 pm
Forum: Useful code, tips and tricks
Topic: MDX - Intrinsic Members
Replies: 12
Views: 14479

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...
by PavoGa
Tue Oct 24, 2023 1:46 pm
Forum: Useful code, tips and tricks
Topic: MDX - Intrinsic Members
Replies: 12
Views: 14479

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...
by PavoGa
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: 18946

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...
by PavoGa
Tue Oct 03, 2023 1:42 pm
Forum: Useful code, tips and tricks
Topic: MDX - Intrinsic Members
Replies: 12
Views: 14479

Re: MDX - Intrinsic Members

Got a question. Can we use "ELEMENT_TYPE" to filter for Aliases?
by PavoGa
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: 803

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...
by PavoGa
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...
by PavoGa
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...
by PavoGa
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...
by PavoGa
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...
by PavoGa
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 ...
by PavoGa
Fri Jun 16, 2023 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ServerSandboxDelete function not working
Replies: 0
Views: 9179

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/...
by PavoGa
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: 1028

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.
by PavoGa
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.
by PavoGa
Wed Jan 25, 2023 3:42 pm
Forum: Enhancements
Topic: Python Integration PA on Cloud
Replies: 4
Views: 7320

Re: Python Integration PA on Cloud

Voted.
by PavoGa
Thu Dec 08, 2022 3:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX escape special character
Replies: 7
Views: 4629

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...
by PavoGa
Tue Dec 06, 2022 10:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX escape special character
Replies: 7
Views: 4629

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...
by PavoGa
Tue Dec 06, 2022 3:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX escape special character
Replies: 7
Views: 4629

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...
by PavoGa
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...