Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 23, 2008 at 07:38 AM

    Hi

    Pls create two calculated key figures based Amount A and Amount B and Display those calculated key figures in the report

    Thanks & Regards

    Rohit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 23, 2008 at 07:37 AM

    Hi Linda,

    You can use formula for each key figure.

    Formula for Amount A: "Amount A" - 0

    Formula for Amount B: "Amount B" - 0

    this might slow down your query performance depending on size of your report, as it will need to perform calculation for each row.

    At the same time, you need to be aware of the unassign (blank or "#") meaning no values, not even zero, as zero is a value. For example, if one of your cost center has offset figures, e.g. +10 (credit) and -10 (debit)amounts for the same cost center, depend on the query details it will show zero due to these amounts offset each other. if you fix formatting issue by introducing forumla, you might not be able to tell if there are no values or the particular transactions contains offset amounts.

    regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 23, 2008 at 07:42 AM

    good info

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 23, 2008 at 07:44 AM

    Dear Linda,

    You can maintain settings at TCode: RSCUSTV4 . These settings are global, effects to all workbooks.

    Or you can write a simple formula or calculated keyfigure.

    Hope it Helps

    Srini

    Add comment
    10|10000 characters needed characters exceeded