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.