Default value for empty record
I have created a multiprovider to join the two cube (Plant A, and Plant B).
This report will list the Cost Center amount for both Plant. I have placed the Cost Center Characteristic in the MultiProvider and
Identified them with Plant A and B. I also placed the Key Figure Amount in the MultiProvider (KF PlantAmtA and PlantAmtB).
In the MultiProvider, the KF PlantAmtA is assigned to Plant A, and KF PlantAmtB is assgined to Plant B.
Now in the Query Designer, I have placed the Cost Center in the Row, and the two KF in the Row. When I run the query, I have the
Cost Center.....Amount A.....Amount B
100985...........1000 USD.....3000 USD
100989...........9020 USD.....3500 USD
I noticed that Cost Center 100986 does not exist in the InfoCube Plant B, and hence it is blank in the Amount B column.
Is there a way to force and default it as 0.00 instead of blank in the Amount B column?
Kindly advice. Thank you.