Suppress zero rows in a structure

Question: I have a structure for key figures in the columns and another structure for the rows. The structure is made up of a high level material grouping. When a user drills down to display a lower level for each high level grouping, all values for each grouping are display either with a value or a zero. I would like only the lower level groupings that have values to diplay for each not a full row of zeros. I have tried the suppress zero in query properutes and that did not fix the issue.

Any idea,
Steve

Answer:
Try to install the Patch 12 if you're working with Query Designer 3.0B. You will have a check box in the properties of the structure called "Also Use Zero Suppression for Structure Elements"
Good luck.

Answer:
We loaded Gui Patch 45 and Bex Patch 12. I went into the query designer and do not see what you referenced. When I click on the properties of the structure, I get the technical name and description. I also looked under query properties. What am I missing?

Regards,
Steve

Answer:
Thanks for the information. I found you must be at a service pack level higher then 19. We just loaded service packs 20, 21 and 22 in our BWR system. This option is now available.

Steve
Copyright ?2007 - 2008 www.jt77.com