Skip to Content
avatar image
Former Member

SAP BPC NW 10.1 / BW 7.5 - False amounts when calling the node "YEAR.TOTAL" of TIME dim. in a report

Hello BPC experts,

I'm facing an unexplainable issue : the amounts of my reports become false when I'm calling a node of TIME dimension "YEAR.TOTAL" in my report.

System informations :

SAP BPC 10.1 NetWeaver

SAP BW 7.5

Model : FINANCIAL / PERIODICAL amounts

Tested perimeter :

2017.01 / ACTUAL / VOLUME / AMOUNT = 964 516

BW screen - Amount is OK

Exemple 1 - Amount is OK - Report on the tested perimeter above with only 2017.01

Exemple 2 - Amount is KO - Exactly the same report than the one above but with 2017.TOTAL and base level

What I tried before posting this message :

1. Tried all MEASURES (PERIODIC / YTD) - Same problem

2. Tried all the possibilities of the report (changing axes, setting all the dimensions, etc., ect.) ---> when the node "2017.TOTAL" is called, the amount of the base level change immediately.

3. Processing the model

4. Processing all dimensions

5. Refreshing the dimensions cache

6. Deleting the data and importing them again

Nothing worked...

Your help will be highly appreciated.

Regards,

Karim

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 05 at 12:52 PM

    The problem came from a "corrupted" hierarchy of one of the "user defined" dimensions created.

    After removing it, and recreate the last, the problem is resolved.

    Regards,

    Karim

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03 at 04:34 PM

    BW SP please!

    TIME dimension screenshot please! (Including nonstandard members if any)

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03 at 07:20 PM

    P.S. Try to delete PARENTH1 in Time dimension, save, process, then recreate PARENTH1, save, process.

    Add comment
    10|10000 characters needed characters exceeded

    • Sorry, but I do not understand what are you doing: "I tried to add manually this missing crossing at the end of to my BPC report by activating the data recognition."!

      Please show the report with base values amounts - not sure that you are correctly comparing BPC and BW data.