Remove Empty and Zero Values not working - Multiple Page Axis Selected

[Former Member]

Hi,

I have a report which is set to "Remove Empty and Zero Values" in the rows. It works fine until...I just changed the page axis to select multiple members and now this setting doesnt seem to work? I have many lines which are showing that are zeros. 

I have "Set Default Value in Empty Cell" to 0. Then I decided to remove this setting and found that the zero lines disappeared.

This a bug? Workaround?

Cheers,

[former_member186338 · Accepted solution]

Hi Leo,

I don't have the issue like you described!

Please show screenshots for simple report...

With multiple page axis members the report has the same behavior!

Vadim

[former_member186338 · Accepted solution]

Sample:

Initial report (multiple members for BE dimension in page axis):

Set default value in empty cell=0

Rows - Remove empty and zero values:

Vadim

[Former Member · Accepted solution]

Hi,

With the following setting zeros do not disppear

With the following they do

If you cant recreate it - probably due to an old EPM i have. I did have this problem a few weeks ago and i re-created the report and the problem went away. I dont really want to recreate this one though - take too long.

Cheers

[former_member186338 · Accepted solution]

At least on EPM SP19 everything is working fine! No issues.

B.R. Vadim

[Former Member · Accepted solution]

Hi - it seems like the problem only occurs when I use member recognition and it happens ad-hoc. that is i have re-created my report twice and the problem occurs at a certain stage. It doesnt make sense why though.

[former_member186338 · Accepted solution]

How do you use member recognition?

In general member recognition has to be switched off...

Vadim

[Former Member · Accepted solution]

Hi - Just to clarify, it is when i am creating the report initially and adding the column headings. At a certain stage the report decides that it is not going to supress zeros anymore. I do switch it off once a report is completely created. I still think it is a bug though.

[former_member186338 · Accepted solution]

Member recognition is a very specific mode - strange things can happen Just use it for adding column axis members and then switch it off!

Vadim