Question:
Hello BW Gurus,
NOTE : I have looked into the forum with all the postings but couldn't get a solution for my problem. So please advise.
I have a multiprovider with 3 infocubes and BW version 30B,SP 17, and PI 2003_1_620.
In my report I have some rows with keyfigure values as ZERO and BLANK. I want to suppress those rows with these ZERO and BLANK cells.
Thanks in advance.
SCY
Answer:
I also did a search on the forum, and found this. Even if I am not an expert, it really looks like a good idea, so pasted it here :
I just tried this, and it worked (in spite of the "correct" way for null values to be treated).
The steps I followed:
I started with a restricted key figure (Quantity key figure for a range of cost elements) that was returning values in some cells, zeros in some cells, and a 'blank' in other cells (where there were no values to satisfy the restriction in the column). The query also contains other columns with restricted key figures (e.g. Amount for a certain range of cost elements).
The row definition is just 'Cost Element'.
I then created two new formulae, one being the restricted key figure *1, and the other being the restricted key figure *-1. Both formulae returned zeros where teh RKF was blank, zeros where the RKF value was zero, and the proper values where the RKF had a non-zero value. When I changed the Number Format setting in the query definition to 'Suppress Zeros', all of the zeros became blanks, including the formula results.
I then 'Filtered' the columns ("Key Figures") so that only the two formula columns remained. All non-zero rows were still displayed, but the zero/null rows were not displayed. I then changed the 'All Characteristics / Suppress Zeros' setting so that zeros would be displyed, and the suppressed rows re-appeared. I then changed the query property (in the global query definition) to 'Display zeros', and the zeros re-appeared in the formulae columns, even where the value was originally blank.
In short, creating a formula to multiply the null values by either 1 or -1 DID give me an answer of 0, and the zero suppression worked, as long as the 'display/number format' property was set appropriately in the query definition.
We're on BW version 3.0B support pack 10.
Answer:
Try to create a condition and display the query... I am sure this will work
Answer:
Thanks SBodla..But in my case condition is not right ansewer
CHC:
First of all thanks a lot for your time.
I tried your suggestion,I can see ZEROS in all my Keyfigure's but still All Characterstic "Suppress Zero Column/Rows" is not working Note: I have set the Display Number format to "Display Zeros" in Query Properties.
My report environment:
I have two structures one for Rows with selection criteria with Cost element and other for Columns with formulae of RKF.
I have for free characterstic COSTELEMENT,0COMPONENT.
The way i run report as per user requirement.
I drill down with COSTELEMENT first and with 0COMPONENT secondly then These get link with the selection criteria of rows.
Please advise if i'm missing some thing to get that "Suppress Zero Column/Rows" to work so that users don't have to see elements with ZERO values.
Thanks in Advance,
SCY