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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.