TM1 Forum

Hi, I am trying to achieve functionality in PAW view where I have a dimension with default hierarchy and a selector dropdown from the same dimension but different hierarchy. I want to make the view dynamic in a way that when a user makes a selection in the drop down, the view displays only those mem...

Trace Calculation shows 0.
I tested it out by slicing it to excel and divided a value by the exception to prove it to myself that it is indeed a zero as I got #DIV/0!

Hello Tomok,
I was showing it expanded for clarity.
When the Period dimension is collapsed to only show Consolidation. It is not suppressing the exception column.

See collapsed screenshot.

Hi, I have a rule that applies to both N and C levels. There are instances where the value of Consolidation might be zero, but the N level might have values. The issue is when zero suppression is on while only looking at C level zero values are not suppressed. SKIPCHECK; ['Exception']= ['Value'] * [...

Thanks,
Not the most elegant solution but it works. I was hoping to achieve this without the need of an extra element.

Thanks,
That is exactly what i thought would work. But the outer order resorts the data based on the values in Amount column, breaking the inner ordered set.

Hi, I have an active form with a requirement to sort on multiple levels like in excel (sort by col1 then by col2). The active form needs to be sorted by the value in the cube based on selected parameters (SUBNM). In the rows i have territory dimension at the level zero. in the columns are Amount &am...