Forum Discussion

NAS's avatar
NAS
New Contributor III
3 months ago

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|)

  • db_pdx's avatar
    db_pdx
    Valued Contributor

    T#PeriodPrior12(|WFTime|):Name(|MFTimeDesc|)

  • NAS's avatar
    NAS
    New Contributor III

    That worked perfectly!  Now I know what those "MF"'s are used for.  ğŸ˜ƒ Thanks!