NAS
3 months agoNew Contributor III
Using Variables in a Cube View to Get Description on a Prior Period
Hi, All
I have a column in a cube view for which I need to get the time description prefaced by "YTD".
This was no problem for the current period as I could use a variable "wfTimeDesc" as follows:
T#WF:Name(YTD |wfTimeDesc|)
However, when trying it for a prior period, I couldn't find a variable to use that gave me a description.
This is close, as it returns "YTD M9 2023" but what I really need is "YTD Sep 2023":
T#PeriodPrior12(|WFTime|):Name(YTD |WFSubPeriod| |WFYearPrior|)
I know I could add a header row and put it underneath, but this was the request, if I can do it.
Thanks in advance!
T#PeriodPrior12(|WFTime|):Name(|MFTimeDesc|)