Search found 587 matches

by PavoGa
Fri Mar 22, 2024 1:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Referencing a lookup cube or Attribute in a TI Process
Replies: 5
Views: 629

Re: Referencing a lookup cube or Attribute in a TI Process

Hi Pavo, Thanks for the reply. I have actually have 10 dims in my source cube and 11 in my target cube - apologies! vValue holds the physical value. Here is a extract of the variables i am creating in the prolog: #=========================================================== # Set Variables #========...
by PavoGa
Thu Mar 21, 2024 12:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Referencing a lookup cube or Attribute in a TI Process
Replies: 5
Views: 629

Re: Referencing a lookup cube or Attribute in a TI Process

A couple of questions: I count 11 dimension variables in the CellPutN. Were you including the measure in the ten dimensions mentioned for the target cube? Second, what variable in the CellPutN is dependent upon the Sub Function value? What is this: '!006 Main - Cost Centre ? Bang notation does not w...
by PavoGa
Thu Mar 21, 2024 12:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: A couple of strange TM1 bugs
Replies: 4
Views: 2292

Re: A couple of strange TM1 bugs

Could it be some kind of string length that is exceeded, when concatenating parameter names and parameter values at runtime ? I don't know. The sheet was trying to pass 20 parameters of which 19 were strings. None of which were very long. Works just fine in PAfE. But after publishing, clicking the ...
by PavoGa
Wed Mar 20, 2024 11:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: A couple of strange TM1 bugs
Replies: 4
Views: 2292

Re: A couple of strange TM1 bugs

This looks like I'm resurrecting a dead issue here, but ran smack into the first issue Harvey talked about. But this was the only thing I found in trying to find something about the problem I was having. Had an action-button for a process that would not execute in TM1 Web. Trying to pass about 20 pa...
by PavoGa
Tue Oct 24, 2023 1:53 pm
Forum: Useful code, tips and tricks
Topic: MDX - Intrinsic Members
Replies: 12
Views: 16047

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: 16047

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: 16047

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: 19744

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: 16047

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: 817

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: 4049

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: 4049

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: 4049

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: 4049

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: 4049

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: 10342

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: 1046

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: 2844

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: 8219

Re: Python Integration PA on Cloud

Voted.