TM1 Forum

Dear friend, This is not an enhancement, so you are posting in the wrong subforum. You registered to this forum more than 3 years ago, so this should not be new to you. I assume this topic will be moved shortly. and im sure you cant do <= and => between strings. True, but you can use @<= and @=> whe...

Thank you for the update.

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