Question:
In one of my Bex report of Purchasing , where for each vendor I am getting Conformed Quantity, Conformed Value, Delivery Quantity,& Delivery Value. I want to suppress records where key figures have blank records.
Please suggest how it can be done in query defination.I am using 3.0B.
Thanks,
Ajay
Answer:
Look in the query properties, there is a check box in the display tab, named suppress zero columns/rows
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Dear Fred,
With this setting I can suppress records with Zero values, but records which are blank I am not able to supress.
Zero and Blank I think there is a differenece.
Please suggest asap.
Thanks & Regards,
Ajay
Answer:
I don't understand what you're talking about.
For me, a Key Figure is a valuated field, so containing numbers (or perhaps null value, speaking SQL). So, blank (null) values look strange...
Are you sure that you're not displaying the zeroes like blanks ? (with option suppress zeroes in query properties).
If yes, try to convert all the KF with formulas, or put conditions.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Hi Ajju,
Country(D) Sales(F) Profit ( F )
Rec1 INDIA $ 0 $0
Rec2 UK $100 $ 0
Rec3 USA $200 $100.
u can supress the display in BEx for Blank Keys.
is it consistent to delete a Record2 for because of Profit is 0..?
is it not deleting Sales $100 which having data for same record.
am not getting is it need to delete a record or manage a purticular cell
(2 * 3) for blank values
but records which are blank I am not able to supress.
Let us discuss whats are ur actual input.
Cheers
Martin Leo
---------------------------------------------------
Welcome for any inputs or Corrections
Answer:
In my Bex report on Inventory management, because client is not using Confirmation Control Key for all Purchase Orders , confirmed quantity does not appear for the PO's where its not maintained. Its neither Zero nor have any value. The record is simply blank. I know we can suppress Zero values & I have already that setting in place from Query properties.
Now I think its clear about what am interested.
Please suggest asap.
Thanks,
Regards,
ajay
Answer:
Are you reporting on a multiprovider ?
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
No its cube 0PUR_C07 for query 0PUR_C07_Q0002
Ajay
Answer:
I am having the same problem. I have many null values and I would like to suppress these rows. Suppressing zero values is already done but these are NULL, not zero values and I can't find a way to do this. Can someone help??
Thanks,
T.
Answer:
hi,'
what about adding a value (say a 'zero 'or' some numerical' and multiplying it with zero) for all the values that are 'null" in the way of coding(ABAP)while loading in rules!!
then you will get all zeros in those places and they will be automatically suppressed by BEx report? ( i dont think null*zero is Zero)
I dont know how it works but try giving it a shot..
regards
rao duttaluri
Answer:
Thanks for the reply but replacing NULL values in the Fact Table will greatly grow the database with unnecessary values. NULL values are by far, more efficient.
Thanks,
T.
Answer:
Try replacing each key figure with a furmual which is the key figure *1.
If the key figure value is null, the formula answer is zero.
Then suppress zeros and zero-filled rows.
Answer:
Thanks Guest. Unfortunately, this didn't work. I multiplied my key figures by 1 and the NULL values didn't change to zero. They remained NULL values. It was worth a shot. Thanks again.
T.
Answer:
null values cannot be used for calculations..its theoratically a value.
so we can deal with them only thru coding which will assume some thing (say a number) if null value is there then this thing(number) can be multiplied by zero in reporting and thus can get our thing done.
but this will definitely add more values in the fact table..and so....
not acceptable..to 'T' and possibly to ajay khattar tooo...what say..
regards
rao duttaluri
Answer:
Thanks for the response Rao. I think you are correct. Also, changing the NULLs to zero values would not be an option. I think what I'll have to do to get around this issue is to use hierarchies (spec. account hier.). Unfortunately, hierarchies create me another problem because I'll need to insert calculated rows in my account hierarchy. I guess I'll just have to use Excel functionality to insert rows in my query. One problem on top of another.... What can you do....?
Thanks,
Tracey