You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Essbase Calc Script to forecast a variable date range?

edited Aug 2, 2018 2:36AM in Essbase 2 comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!