Essbase function to calc data of that month depending on the input value
Summary
Essbase function to calc data of that month depending on the input valueContent
HI
I am looking for an option to calculate member depending on the user input value in Essbase calc script. For example we have two years FY16,FY17. Depending on the user input for month (1 to 12) script should traverse that many months back and pick the value. If in our example we have FY16 Jan and user input value is 3, our calc should traverse to FY15 OCT value. I can use @Prior function, but unfortunately I can only hard code the value in the @Prior
0