Skip to Content
0
Former Member
Sep 23, 2008 at 04:12 AM

Default value for empty record

50 Views

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

following output:

Cost Center.....Amount A.....Amount B

100985...........1000 USD.....3000 USD

100986...........6050 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.