Essbase Calc Script to forecast a variable date range?
Summary
Essbase Calc Script to forecast a variable date range?Content
I have an Year(FY17,18,etc) dimension, Period(Month-->Jan,Feb,etc) dimension, Day(1-31) dimension. I have a Start_date and End_date(Data Type as Numeric) in my Accounts dimension. If a user writes yyyymmdd in both Start_date & End_date and runs a Calc Script he should be able to see a forecast value say "100" to only those Start and End date range.
How to write a calc script for the above requirement?
Please Advice,
0