TM1 Forum

I tried the CellPutS but the trick didnt work. :-( Maybe also try CellPutS to the element security cube. What George said rang a bell and I think I can recall needing to do this. (Why I don't know becasue AFAIK ElementSecurityPut should alone be adequate). HierarchyElementSecurityPut(sElSecurity, p...

I agree this sounds strange. If element security cubes don't contain rules then the ElementSecurityPut function should be sufficient to update security without needing a SecurityRefresh.

At least as far as Arc goes you can raise a feature request

If you want to expose transaction logs to non-admin users then you have no alternative but to do the work yourself and load the transaction logs into another database which users have access rights to becasue non-admin users don't have access to transaction logs via rest API (or process error logs f...

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.