SAP EPM how to control "Key Date" of Time Dependent Hierarchy

[ChristianSass]

Hi,

we would like to use TIme Dependent Hierarchy in our Data Model.

It is one requirement that we can control the "Key Date" within a sheet.

I've tried to set the KD via VBA and EPMobject.SetContextMember (Dim EPMObject As new FPMXLClient.EPMAddInAutomation) but without success.

The Dimension "Key Date" or "KeyDate" is invalied.

Is there any other way to set the Key Date?

Thank you!

[former_member186338]

Hi Christian,

Unfortunately there is no documented way to change report Key Date using VBA. Only manual changes...

Vadim

[McGreger]

Dear Vadim, we just tested with EPM SP38 and were able to change the keydate in the context using VBA

objEPM.SetContextMember(<connection>, "Key Date", "[__KEYDATE__].[].[2020-10-03]")

Best Regards
Eric

[former_member186338]

ericgreger

Yes, something was changed after 6 years 🙂

But still it's not possible to do it for a particular report (if multiple reports are on the sheet). Only context change.