TM1 Forum

So, I want to reference a cell within a cube located at the intersection of several alternate hierarchies. Do not want to use DB() to an external cube or on this internal reference because speed of [ element1, element2, ..., elementN ] is faster. However, the only thing that seems to work is DB(). H...

Has anyone used ViewZeroOut against a view created by MDX? It is failing and complaining that the element in the hierarchy it needs cannot be found. It is the hierarchy element, not the hierarchy it is complaining cannot be found, as I changed the element name to determine exactly what it was compla...

Really neat utility. Getting better reductions in memory footprint vs. the built-in optimizer. Ran into some issues with query speed last week, but conducting some additional testing.

An abacus operated by an octopus.

I would go for 2.0.8 unless you would want to use the feature: Use the ViewZeroOut TurboIntegrator function on MDX views (https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_cloud_mg.2.0.0.doc/pa_nf_viewzeroout_support.html) or other features that were added in 2.0...

2.0.09 was supposed to allow the use of ViewZeroOut again MDX views. As mentioned in some other threads, ViewZeroOut was virtually useless if leaf elements existed in alternate hierarchies but not the base dimname:dimname. I was hoping for a resolution of this issue with ViewZeroOut against MDX subs...

A shot in the dark here, but have you tried applying security to the }Hierarchies_dimname dimension?

I'm still new to TM1 and I need help to extract data from a cube and save it as csv using TI process. I would recommend investing in some training. I'm not having a go at you in saying that but this is TM1 101, so if you can't do this you're really going to struggle. There are a lot of consultants ...

And we have some more coming don't we?

Have been using my own as well for years.

I think what is happening here is the ViewZeroOut is contained within the transaction of the overall process; it does not commit until the process completes. So, the command line operates in a different thread and actually performs its work (and commits its changes) with the master process waiting u...

I was reading that you don't need the dimension qualifier in a DB. I also read that you shouldn't use the pipe. 'By Bucket1': ElementParent('Products','By Bucket1',!Products,1) Is this incorrect? Maren I've not read that on the pipe, but we do use it without any problems. However, I am UP with not ...

In the DB statement, the argument for the hierarchy element has to be fully qualified:

'dimname:By Bucket1:' | ElementParent('Products','By Bucket1',!Products,1)

Sorry Jim, I did not look at this until too late. Would have voted for you though!

Thanks!

Thanks ykud!! As you and declanr said, the reason for rollback is that one of the sub processes was having a cubesavedata over a particular cube . That was the reason for roll back , i removed it but facing another issue which was the reason for above lock you had mentioned I am having a sub proces...

What wizardry is this? I never heard of this DimensionDeleteElements function! Anyone know since which version this one has been with us? October 2018, PA 2.0.6 https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_nfg.2.0.0.doc/pa_nf_delete_leaf_elements_ti_process.htm...

Voted.

Can you be more specific about your issues Ty? We are using the same method that Paul indicated and not seeing any issues with functionality. (Yes of sure there are some issues that the object names displayed in the UI don't seem to be updated, but the more important thing is that it actually works...

This can be done through the Architect Subset Editor. However, can it be done through a TI? No it can't. Paste via Perspectives/Architect is the only way to achieve this. (Unless you want to roll your own UI with the old C API). There is a difference between a subset file created through the UI and...