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

NAS's avatar
NAS
New Contributor III
3 months ago

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