TM1 Forum

We can write N: right instead of S : for string element 'comment' Can you please write a proper question ? So Wim made a very reasonable request since your question made little, if any sense. okay got it. this was the full ques actually. thanks!! And you responded with something completely irreleva...

Hi, I would try replacing the STRTOMEMBER part of your MDX, so rather than looking at currentmember.PROPERTIES("dimname1attr") it looks at a mapping cube. Even if you don't like the idea, if it works, you know it is an issue with the currentmember.PROPERTIES. Maren Think you missed the po...

I am seeing problems in v12 with MDX. I posted in this thread because of the StrToMember references. Consider the following MDX structure: GENERATE( FILTER( TM1SUBSETALL( [dimname2].[dimname2] ), [dimname2].[dimname2].currentmember.PROPERTIES("Element_Level") = "0" AND LEN([dimna...

Resurrection of an older thread. Client has PAoC. Processes reading cube views with and MDX view (CreateViewByMDX) using one alternate hierarchy have been returning the dimensions in the order documented in my earlier post on the subject regarding TABDIM order with the alternate hierarchy usage exce...

Looks like it gives me incompatible dimensionality error. Could anyone help to confirm? Thanks. e.g. Union( [dim].[a].children, [dim].[c].children ) What is it you are trying to accomplish exactly? Also, the example could be confusing. From the coversation, it is assumed that a and c are separate h...

Hi there I get a "Process Failed" message from an action button. No error log or entry in Tm1Server log. Any ideas? Many thx! Make sure all the parameters you're passing include an "=" in the box. Easy to miss this if using named ranges. dimAccount (wrong) =dimAccount (correct)

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 #========...

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

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

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

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

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

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

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

Got a question. Can we use "ELEMENT_TYPE" to filter for Aliases?

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

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

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

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

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