Skip to main content
October 15, 2024
Solved

Using Variables in a Cube View to Get Description on a Prior Period

  • October 15, 2024
  • 3 replies
  • 0 views

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!

 

 

Best answer by db_pdx

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

3 replies

db_pdxAnswer
October 15, 2024

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

NASAuthor
October 15, 2024

That worked perfectly!  Now I know what those "MF"'s are used for.  😃 Thanks!

October 18, 2024

MF is Member Filter, unfortunately it can only be used in descriptions.