04-05-2023
12:28 PM
- last edited on
05-20-2023
03:14 AM
by
JackLacava
I am trying to get the description for prior year in my Excel header for cube views. There is a substitution variable for current year but nothing for prior year. Anyone have any suggestions? Instead of the format 2023M3, I want the header to bring in the description that says March 2023. Below is my current year variable.
04-06-2023 01:47 AM
If your format is not listed in substitution variable, then go for XFBR rule.
XFBR(businessRuleName, brFunctionName, Name1=[Value 1], Name2=Value2)