Get Planning SubVar value in Reference Value — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Get Planning SubVar value in Reference Value

Hi all,

I'm attempting to make a mostly touchless report package that is driven off of the substitution variables in our Planning application.

For the purposes of getting data in reports/reference doclets, having a the subvar for period and year called out either in the report definition or as a static variable works fine. However, I'm hitting a wall when I try to get the subvar value as a text item (for example, &CurPeriod = Jun and I want to dynamically pull the text of "Jun" into my PPT).

Does anyone have any neat tricks or hacks to get this to work? I've tried subvars in Excel reference doclets, but those just resolve to the value and don't dynamically refresh. I also looked into the Hs functions, but the one that would be helpful (HsGetVariable) is only valid for Essbase connections.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!