Page 1 of 1

User defined consolidations in a slice

Posted: Tue Sep 12, 2017 3:24 pm
by NPTM1
Hi

I am looking to find a way to create a temporary consolidation based on cells in Excel. I've seen that Active Forms have the functionality (where the TM1RPTROW formula references a hidden worksheet called {AR01} and the user can add elements to the list). However I've tried to do something similar in a slice but can't get it to work.

I need something that works similar to a rollup, but where I can define which elements go into that rollup from Excel.

Thanks in advance!

Re: User defined consolidations in a slice

Posted: Tue Sep 12, 2017 4:25 pm
by rafaewolie
Hi NPTM1,

If I understood, You want to make consolidations in a slice perspectives?

The rows are static at slice option, so You include or exclude every row that You want. Them You have to make a formula to that Consolidation that Doesn't exist as a dimension element to have a value in that data point!

I made an example attached below.

PS.: This only works in rows, I don't know If there is a rollup available to Subnm for example!

Best Regards

Re: User defined consolidations in a slice

Posted: Tue Sep 12, 2017 4:47 pm
by tomok
What you're asking for can only be done using the Server Explorer/Architect interface. When you are in Excel only there is no functionality to modify a user-defined consolidation. There is an undocumented feature in TM1 where you can reference a subset name, in place of a member name, in a DBRW formula, and it TM1 will return the sum of the members in the subset. However, you'd still have to use Perspectives to modify the subset, which basically means not doing it in Excel.

Re: User defined consolidations in a slice

Posted: Tue Sep 12, 2017 11:56 pm
by Wim Gielis
Hello

Why don't you use a simple TI process to update the hierarchy? It can be executed with an Action button in Excel and TM1Web.

Re: User defined consolidations in a slice

Posted: Wed Sep 13, 2017 11:12 am
by NPTM1
Thanks all.

As I suspected this can't be done without a TI process, which i'll take a look at.

Thanks all!