Forum Discussion
NAS
1 year 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|)
3 Replies
- db_pdxValued Contributor
T#PeriodPrior12(|WFTime|):Name(|MFTimeDesc|)
- NASNew Contributor III
That worked perfectly! Now I know what those "MF"'s are used for. 😃 Thanks!
- BenvanBergenContributor
MF is Member Filter, unfortunately it can only be used in descriptions.
Related Content
- 3 years ago
- 2 years ago