TM1 Forum

Where is the like button?

+1 I would also always use Expand for such cases. It's just easier.

There is a bedrock process which can do this task without writing any code. }bedrock.cube.data.copy.intercube

I think you might be confusing RunProcess (runs in parallel on a new thread in new transaction) with ExecuteProcess (runs in serial in same thread in same transaction). If you want the calling process to wait for the sub-process and easily read the status of the sub-process then using ExecuteProcess...

It seems that both Subset1 and Subset2 already exist.

Here pseudo-code is not your friend. Please provide the actual code! Otherwise no one can tell what you are actually querying as the pseudo code is so far off the mark that I don't even know where to start.

Well first you can make sure that your instance is using MTQ, e.g. MTQ= -1 ot MTQ = All to use all cores, MTQ = -2 to use all cores except 1 or MTQ = 16 to use just 16 cores (assuming the server has more). In all my experience even on big servers and big data models there hasn't ever been a performa...

The problem will be that you're creating the view in Workspace. All views in vorkspace are per definition MDX views. MDX views assign index order of variables based on the view structure . 1st column dimensions (MDX axis 0), then row dimensions (MDX axis 1), then slicer dimensions. So if you constru...

What he said.

It doesn't matter if an area statement on the LHS uses an alias, when !dimension is used on the RHS it will always evaluate as the principal name. This is how it has always been and will always be.

At least you understand that using aliases on the LHS is a bad idea. Don't do this.

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

This kind of thing should be configurable and left in the hands of the user. FWIW I agree. Ideally there should be a toggle in the row dimensions area for symetric vs asymetric drill-down. As a user this is what I would want. But if I have to choose between one and the other then I would take asyme...

I think the short answer is that indenting to indicate parent/child relationships when exporting from TM1Web wasn't considdered necessary as part of the MVP and it has never been an important enough missing feature to revisit. That's probably unlikely to change.

How can I achieve the old Architect-behaviour in a PAW cube view? By default, a consolidation is just extended in the row I click. What if I want to extend it in all rows? You have chosen to wake up quite an old thread. Short answer, you can't. PAW only does asymetric drill-down. In general I think...

Spreading over a rule does work as long as at the leaf level there is only 1 independent variable. As you have more than one potential input to flex spreading can't be done.

We are experiencing a similar issue after applying 2.0.9.15 meaning we can't load attributes into our control cubes with rule files attached. A TI process that took a few seconds now takes so long it doesn't finish after running for several hours. Looks like this has already been reported to IBM. T...

(Just thinking out loud about solutions, not trying to say it isn't a problem....) For a certain level of complexity of MDX you could probably have a TI whose only job was to parse an MDX statement and figure out the contents. Can certainly see how this would be challenging / impossible for all pos...

Search for
[PH50635] TI process updating attributes has significant performance degredation if attribute cube contains rules
It might apply in your case.
I'm skipping 2.0.9.15 until this is fixed.

I've not tried but can see how this could be generalised for any dimensioned cubes. All well and good if you can dictate the format of the query. If you can control the way the query is constructed then you can control the order of the variables. But what if the content of the MDX statement is unkn...

I can confirm that it is not fixed and certainly not ready to be used in anything generic where you cannot know upfront the variables that you will get in what order. This is very bad since cube views with PA alternate hierarchies are not accessible using traditional views. In a generic process I a...

Well it was discussed at length here https://www.tm1forum.com/viewtopic.php?p=73332&sid=ba5cbd3e85205d0af84de89c32557426#p73332 But I wouldn't call that recently. Well yeah this is my APAR https://www.ibm.com/support/pages/apar/PH24729 ... and according to IBM yes this was closed as "fixed&...

You can only access alternate hierarchies through MDX views not traditional views. At this time drill-through only supports traditional views as the target and not MDX views. You can vote for the RFE to support MDX views in drill-through here https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOC-I-393 No...