Page 1 of 1
Cube Viewer suppress zeroes hiding non-zero cells
Posted: Fri Jan 25, 2019 1:38 pm
by 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?
Re: Cube Viewer suppress zeroes hiding non-zero cells
Posted: Fri Jan 25, 2019 1:40 pm
by Wim Gielis
Sure. Are these values properly fed ? I suspect they are not, and hence, they disappear.
Re: Cube Viewer suppress zeroes hiding non-zero cells
Posted: Fri Jan 25, 2019 1:47 pm
by 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.
Re: Cube Viewer suppress zeroes hiding non-zero cells
Posted: Fri Jan 25, 2019 2:02 pm
by David Usherwood
Have you checked? In Perspectives, right-click on a cell, select 'Check Feeders'.
Re: Cube Viewer suppress zeroes hiding non-zero cells
Posted: Fri Jan 25, 2019 2:26 pm
by jamesbennett
David Usherwood wrote: ↑Fri Jan 25, 2019 2:02 pm
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'.
Re: Cube Viewer suppress zeroes hiding non-zero cells
Posted: Fri Jan 25, 2019 2:35 pm
by 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.
Re: Cube Viewer suppress zeroes hiding non-zero cells
Posted: Fri Jan 25, 2019 4:57 pm
by jamesbennett
Definitely check feeders! See the picture if it works:
- Untitled.png (48.89 KiB) Viewed 12370 times
Re: Cube Viewer suppress zeroes hiding non-zero cells
Posted: Sun Jan 27, 2019 10:39 am
by 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.
Re: Cube Viewer suppress zeroes hiding non-zero cells
Posted: Sun Jan 27, 2019 1:11 pm
by Wim Gielis
When restarting TM1 delete the *.feeders file too, just to see if that helps too.
Re: Cube Viewer suppress zeroes hiding non-zero cells
Posted: Sun Jan 27, 2019 5:37 pm
by 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.
Re: Cube Viewer suppress zeroes hiding non-zero cells
Posted: Mon Jan 28, 2019 9:43 am
by qml
declanr wrote: ↑Sun Jan 27, 2019 5:37 pm
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.
Re: Cube Viewer suppress zeroes hiding non-zero cells
Posted: Mon Jan 28, 2019 2:54 pm
by David Usherwood
Returning to @jamesbennett's problem - you should be able to identify the feeder issue by careful review of your rules and feeders.
Re: Cube Viewer suppress zeroes hiding non-zero cells
Posted: Thu Oct 10, 2019 9:13 am
by 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;