1 Report Different Key Date

[Former Member]

Hi Expert,

I have a requirements in Balance Sheet report using different Time Dependent Hierarchy. Is it possible to view one report with different TDH? Balance Sheet is always a comparison from current year with previous year Dec.

E.g.

Balance Sheet Report

Jan 2020 is using different hierarchy compare to 2019 Dec.

Thank you in advance.

Regards

[former_member186338]

Sorry, but what system are you using?

[former_member186338 · Accepted solution]

You can use multiple reports sharing some axis... for each report you can have individual key date!

Also, starting from EPM SP36 you can use Key Date in Member parameters of EPM functions:

https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.36/en-US/69d89226b201479fa1192cfc9...

Ex: EPMRetrieveData

[Former Member]

Thank you very much Vadim

[Former Member]

Hi Vadim,

Is there another way to cater the requirements? is there any EPM formula to call the key date?

Thank you

[former_member186338]

Key date is a report feature, single report can have only single Key Date.

[Former Member]

Hi Vadim,

I am using SAP BPC 10.0 Netweaver

Thank you.