Cube Viewer suppress zeroes hiding non-zero cells

[jamesbennett]

I have just discovered that in (at least) one of my cubes, toggling the 'suppress zeroes' function on and off hides a row of non-zero cells in the cube viewer, as well as the zero-value cells. The suppressed cells are leaf-level and calculated via the cube rules. Has anyone encountered this before, or know why it might be happening?

[Wim Gielis]

Sure. Are these values properly fed ? I suspect they are not, and hence, they disappear.

[jamesbennett]

I believe so. The rules calculate values for five divisions using an 'All divisions' consolidation. On an unsuppressed view, values show up for all five divisions. When zeroes are suppressed, one of the five disappears.

[David Usherwood]

Have you checked? In Perspectives, right-click on a cell, select 'Check Feeders'.

[jamesbennett]

Have you checked? In Perspectives, right-click on a cell, select 'Check Feeders'.

What should I be seeing here? I do this and it shows the formula in the top half of the window, but nothing in the Trace / Value columns as in the 'Trace Calculations' window.

Same result for the cells that are not disappearing on 'suppress zeroes'.

[David Usherwood]

You selected 'Trace Calculations'. You need to select 'Check Feeders'. Make sure you are at the N level and on a calculated value.

[jamesbennett]

Definitely check feeders! See the picture if it works:

Untitled.png (48.89 KiB) Viewed 12142 times

[David Usherwood]

That does look correct - but I am pretty sure you do have a feeder issue. Suggest you restart the server and recheck - possibly you have conditional feeders and the parameters have changed without a restart or refeed.

[Wim Gielis]

When restarting TM1 delete the *.feeders file too, just to see if that helps too.

[declanr]

There is a bug that one my customers currently has, I believe they are on PA 2.0.5 but not 100% as I don’t have access to install etc in their environment.
The issue means that check feeders never shows “not fed” - I tested this with a simple a = b rule on a 2 dim cube. Again due to not having access to the install/admin side I can’t confirm it’s not a setup issue but I can’t think of any configuration that could cause it so I am assuming a bug and will go through the internal customer (large enterprise) procedures to get it logged with IBM.

[qml]

There is a bug that one my customers currently has, I believe they are on PA 2.0.5 but not 100% as I don’t have access to install etc in their environment.
The issue means that check feeders never shows “not fed” - I tested this with a simple a = b rule on a 2 dim cube. Again due to not having access to the install/admin side I can’t confirm it’s not a setup issue but I can’t think of any configuration that could cause it so I am assuming a bug and will go through the internal customer (large enterprise) procedures to get it logged with IBM.

Yup, we have that too. Same version, same problem. I think we already had it with 2.0.4.

[David Usherwood]

Returning to @jamesbennett's problem - you should be able to identify the feeder issue by careful review of your rules and feeders.

[konstantin-spb]

Suppose you have the right feeders...
What rules (calculations) do you use for totals? N or C?

If you use the calculation of totals (sum or percent) like this ("supress zeroes" will hide them):

Code: Select all

['Accounts{PL':'GM' , 'Measures{PL':'1'] = C:['Accounts{PL':'60'] + ['Accounts{PL':'61'];
['Accounts{PL':'GMP' ,'Measures{PL':'1'] = C:['Accounts{PL':'61'] \ ['Accounts{PL':'60'] * -1;

You can change them to like this:

Code: Select all

['Accounts{PL':'GM' , 'Measures{PL':'1'] = N:['Accounts{PL':'60'] + ['Accounts{PL':'61'];
['Accounts{PL':'GMP' ,'Measures{PL':'1'] = N:['Accounts{PL':'61'] \ ['Accounts{PL':'60'] * -1;

If these are your final totals (other totals do not depend on them), you can also change them to like this:

Code: Select all

['Accounts{PL':'GM' , 'Measures{PL':'1'] = N:0.001;  C:['Accounts{PL':'60'] + ['Accounts{PL':'61'];
['Accounts{PL':'GMP' ,'Measures{PL':'1'] = N:0.00001;C:['Accounts{PL':'61'] \ ['Accounts{PL':'60'] * -1;