TM1 Forum

Thank you for the update.

You can turn a dynamic subset into a static subset because you don't want to evaluate the expression anymore. That can improve performance.

Do you have a calculation rule at C level ?

Apologies, I did not answer the question and you can disregard my reply.

Hi

What about element security on the element attributes dimension ?

Hello Mark,

Don't use dynamic subsets on such dimensions.
Use TI to populate a subset in a static way, either at the push of the button, either after updating the dimension.

vAccountLastRow = '';

in the Prolog tab of the process.

True Steve, we could do that. The idea could be to have a menu item in the ribbon in Excel that would enter these missing headers. When you snapshot or slice to Excel, it's often to check with for example an autofilter or a pivot table. Then you would need the headers filled in. If I would look in t...

Here's a challenge for those of us with too much time on their hands. If you slice, snapshot or 'active form' data out of a cube and bring it to Excel, the row dimensions (if any) do not have a header. Given the layout of dimensions in titles, rows, columns, come up with a solution to determine what...

RTFM

No idea honestly, that would require experimentations - for which I have no time. Hopefully one of the other helpers know what is going on.

Hello,

Just don't feed a rule like that one.

Hi, Here is a separate topic about how we can list properties of processes and chores. The Main process can be used to execute the 2 subprocesses. You can set up a cube (starting with }TECH_ so show the control objects when the processes have run), or you can clean up the cube and its dimensions. Th...

I don't come across this one.
What happens if you first paste in Notepad++ and then copy from Notepad++ to the rules editor ?

I wrote a generic TI process that can go through all processes' PRO files Would I be rude in asking to see that?! Voilà, there you go. 1,900 lines of coding ;-) Unedited these processes will need at least TM1 10.2.2 FP4. The MAIN process executes the 2 other processes. Any questions / remarks / err...

mattgoff wrote:

Alan Kirk wrote:You may need to strip down the consolidation tree but you don't need to strip out the N elements..

Sounds like a good enhancement request. It would be handy to have a DimensionDeleteAllHierarchy as a easier alternative than coding it up yourself.

Matt

+1

But what if there's something wrong in Metadata and the script fails? Is my entire dimension (and the data) gone forever? I wrote a generic TI process that can go through all processes' PRO files, and listing (in a control cube) many properties, line counts, parameters, ... Also, it detects the pre...

Hello,

Can you first go through the material on this page?
http://www.wimgielis.com/tm1_subsetsthataddup_EN.htm

Thanks

Hi, thank you for the feedback, glad it's solved !

VReddy wrote:My Thought is there is some "ghost code" that remains in the background file but I can't bring myself to believe that.

A chore maybe

Steve's comments are what you should look at to get to the bottom of this.