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)