How to use EPMRetrieveData in TDH report

[Former Member]

Hi everybody

I want to use the  EPMRetrieveData function on report, and select the Key Date to control the Time Dependent Hierarchies.

But  the  EPMRetrieveData function doesn't follow the Key Date. Always show the current date result.

Help me please.

Best Regards

[Former Member]

Hi Muta,

Is your EPM Add-in version new enough? The issue should be resolved after EPM Add-in SP19 according to note:2047454.

Best Regards,
Arjen

[Former Member]

Hi Arjen

Thanks for your reply and My BPC Version is NW 10.1.

My situation is following this:

----------------------------------------------------------------------------------------------------------------

Report1<Key Date=Current Date>                              Report2 <Key Date=TDH1>

                                   Formula                                      Formula

Account1      <EPMRetrieveData Function>         Account1      <EPMRetrieveData Function>

Account2      <EPMRetrieveData Function>         Account2      <EPMRetrieveData Function>

----------------------------------------------------------------------------------------------------------------

The BPC report includes two the same report,only Key Data is different .

I use the same EPMRetrieveData Function to report1 and report2.

I wish report1 and report2's result is different(because TDH is different).

But report2's result is wrong, it's the same with report1.

How do I use the EPMRetrieveData function by KeyDate?

Best Regards

Muta