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...
Cube View
  • db_pdx's avatar
    db_pdx
    3 months ago

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

BenvanBergen's avatar
BenvanBergen
Contributor
3 months ago

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