Suppress 0 in Subset/Dynarange

Blumbak · Apr 2nd 2015, 3:55pm

Hi at all,

I want to suppress zero values in my report which is based on dynaranges.
As source for the dynarange I using a subset where some element measure values equals 0. Those lines shall not appear in the report but I could not find any function for this.

Could you help me out?

Kind regards

Roman

p.hildebrandt · Apr 7th 2015, 7:55am

The function you are looking for ist data filtering.
Following this article knowledgebase.jedox.com/knowle…e/subset-editor-tab-data/ you should be able to prefilter to nonzero results.

You have use "<>" as slice operator and enter a "0" in the field right next to the slice operator.
Depending on what you want to achieve with filtering, you have to choose the criteria above.

Regards
Peer

Blumbak · Apr 16th 2015, 12:11pm

Great!
it works. thank you!

BenoitR · Apr 4th 2019, 8:34am

Well when i try to use the slice operator, it kills the server. I just entered <>0 and it is now hanging. what do i do wrong?

what i am trying to achieve is the following: on the first report i have a number display. Next to it i added a Hyperlink to a second report where i get this number broken down by another dimension. On the second report i have a dynarange where i want to suppress all 0 lines...

Share