TM1 Forum

Hi,
I'm searching for an opportunity for the users to caculate their own aggregation. I read about UDC. But actually I'm using Perspectives, in future I will use PAFé. I tried DefineCalc as a function in an Excel report, but this functions seems to be unknown. I'm using version 2.0.9 (Server 11.8.02200) as far as I know.
So do I need a different Version of TM1 to get this solved?

At minimum, you'll need Pafe to use DefineCalc.

With perspectives your options are likely to be:
- Use the rollup button in the subset editor... Select 2 or more elements and click rollup they'll be a temporary consolidation created.
- Use subsets... Subsets can be used in DBRW, DBR statements in place of an element name to return the total sum of all elements in that subset

These may not suit your use case, and if you require DefineCalc you will need to be on Pafe

schlemiel29 wrote: ↑Wed Nov 27, 2024 4:14 pm Hi,
I'm searching for an opportunity for the users to caculate their own aggregation. I read about UDC. But actually I'm using Perspectives, in future I will use PAFé. I tried DefineCalc as a function in an Excel report, but this functions seems to be unknown. I'm using version 2.0.9 (Server 11.8.02200) as far as I know.
So do I need a different Version of TM1 to get this solved?

Why would you still do work in Perspectives ? PAfE really is the future.

One option that was not yet given above and which continues to work in PAfE, is adding the consolidation to the dimension with the appropriate children (and weights). A small TI process could help the users.

Honestly if by now you would allow public subsets in DBRWs then in a few months time you can revise it again under PAfE.

Wim Gielis wrote: ↑Thu Nov 28, 2024 7:55 pm Why would you still do work in Perspectives ? PAfE really is the future.

Not as far as I'm concerned it's not. That (personal opinion) cack-handed abomination crosses our threshold over my cold, dead body. When we leave Perspectives behind it'll be for Slice.

Personally I wouldn't trust IBM to write a user interface that prints "Hello World". They'd probably demand that it be encapsulated in 14 different containers running on a cluster of Linux servers.

Alan Kirk wrote: ↑Thu Nov 28, 2024 9:19 pm

Wim Gielis wrote: ↑Thu Nov 28, 2024 7:55 pm Why would you still do work in Perspectives ? PAfE really is the future.

Not as far as I'm concerned it's not. That (personal opinion) cack-handed abomination crosses our threshold over my cold, dead body. When we leave Perspectives behind it'll be for Slice.

Personally I wouldn't trust IBM to write a user interface that prints "Hello World". They'd probably demand that it be encapsulated in 14 different containers running on a cluster of Linux servers.

That’s your opinion and entirely fine.

Hi
I try this DefineCalc as a title dimension in a Dynamic Report and it doesn't work.
Do you know why?

Keep the report structured just as you have it, but try removing the TM1RptTitle for that specific dim from the TM1RptView definition. You don't need to specify all of the title dims in the report definition, just treat it as if you're defining it in the columns but keep it up in the title elements.

Thank you. It works now by removing the TM1RptTitle.

ascheevel wrote: ↑Thu Dec 12, 2024 4:09 pm Keep the report structured just as you have it, but try removing the TM1RptTitle for that specific dim from the TM1RptView definition. You don't need to specify all of the title dims in the report definition, just treat it as if you're defining it in the columns but keep it up in the title elements.