I am building an aging report( 0 to 30, 31 to 60, etc) into a power cube. When I go to create the cube, if any of the age ranges has zero records it does not display that range as a column in the power cube. My users would still like to see this column regardless. Please Help !
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I display zeros in my cube
- Thread starter fens3
- Start date
fens3
Is the zero suppresion button on in PP, or are the zeros being suppressed in Transformer?
First case is simple, just turn off the suppression button.
In transformer, go into the data element(s) that are being suppressed (right click them). By default they should say "as required", change this to "always include".
If your cube is very large, you might take a proformance hit however.
Good luck
Bruce
Is the zero suppresion button on in PP, or are the zeros being suppressed in Transformer?
First case is simple, just turn off the suppression button.
In transformer, go into the data element(s) that are being suppressed (right click them). By default they should say "as required", change this to "always include".
If your cube is very large, you might take a proformance hit however.
Good luck
Bruce
- Status
Similar threads
- Locked
- Question