cancel
Showing results for 
Search instead for 
Did you mean: 

Excel reporting comparison with two different Key Date in the same worksheet

0 Kudos

Hi experts,

I have a problem with the Excel reporting comparison when the account dimension have time dependant hierarchy activated (with two versions: one of them until 31 January 2020 and the other one from 01 February 2020 onwards).

According with SAP note 1800842: "User can only specify one key date for one report. Multiple reports from the same worksheet or workbook can have different key date".

In my case, I have two reports (Default Report and Report 001) in the same worksheet, where account dimension (with time dependant hierarchy activated, two versions) is placed at Rows, and this dimension is shared with both reports.

Default Report has 31 January 2020 harcoded, and Report 001 has Context Key Date (for example, 15 February 2022).

The problem is that the Key Date, although it is configured differently in each report, it always takes the context value, and does not allow comparing (in columns) a change in the hierarchy of an account (time dependant).

How could this parameterization be made, that according to the SAP note 1800842, it´s possible for each report to refresh with a different Key Date (in the same worksheet)?

Thank your very much for your help.

Regards, Juan.

former_member186338
Active Contributor
0 Kudos

What do you mean by "Default Report has 31 January 2020 harcoded"? Screenshot, please

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Dear Vadim,

Thank you very much about comments.

Related to the first comment, when you ask "Default Report has 31 January 2020 hardcoded"? Screenshot, please", you can see at Default Report screenshot that Key Date is fixed (hardcoded) with 31/01/2020 value; in the other hand, Report 001 Key Date is a value retrieved from Context (that is, one version of account dimension ends at 31/01/2020 and the other version beggins at 01/02/2020 onwards).

Then (second comment) account 6203000, that belows at different nodes (different versions account dimension nodes), then the same account should show the same amount at different hierarchy level (different nodes at different version hierarchy).

If you have any other explanations ask me again please.

Thank you very much and regards, Juan.

0 Kudos

Hello,

Please see attached the two different Layout (Default Report and Report 001):

The problem is that both reports (built into the same worksheet) don´t show the same group account (CUENTA = 6203000, for example) in different versions (account dimension time dependant hierarchy; the same group account should appears if different nodes).

Is there any way to build this comparison?

Thank you very much for your help.

Regards, Juan.

former_member186338
Active Contributor
0 Kudos

First - this is not an answer to your question, it's a comment!!!

Second: "The problem is that both reports (built into the same worksheet) don´t show the same group account (CUENTA = 6203000, for example) in different versions (account dimension time dependant hierarchy; the same group account should appears if different nodes)."

Not clear - please explain with screenshots