Question:
Hi there,
I have an issue with displaying zero values. The business want's to have a BPS screen with the records that the need to maintain BUT with zero value in the key figure. The zero value will be manually changed to the actual value.
The structure of the cube is account, date, 0amount. I have records in my cube and all of them have value zero. When I want to display these values in BPS I do not get any records... (Records that have a value <> 0 are displayed). How can I display records with a zero in the key figure?
All Ideas are welcome.
LowHead
Answer:
Did face that issue a while ago...I think I created a hidden key figure filled with dummy data
Answer:
how do you create a hidden key figure?
_________________
Do you believe in co-incidence?
Yes?? Think again.
There is nothing like co-incidence... Everything is planned !!!
Answer:
if you use ' display transaction data' then it is not possible, but if you use ' display all chrarteristic relations' options then its possible perhaps!
why dont you give your users a value like 1 (guess!) instead of zero, anyhow they have to change it right??
cheers
sumeet
_________________
____________________
Is it a good day !!??