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

Can Essbase store dates and perform calcs with dates?

Received Response
edited Aug 2, 2018 2:36AM in Essbase 6 comments


Can Essbase store dates and perform calcs with dates?


Hello All,

I am struggling with finding a solution in creating an application that can calculate employee bonuses.

I’ve always worked with values in Essbase and never stored calendar dates.  Basically say we had an employee start date of 03-15-2019 and bonus were calculated and paid effective 9-30-2017.  We would need to calculate the pro-rated bonus based upon the number of days between the 2 dates. Same concept would apply for employees that received promotions during the year.  That is just a very basic example.

Can Essbase work with dates like that?

Howdy, Stranger!

Log In

To view full details, sign in.


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