Hyperion Essbase (MOSC)

MOSC Banner

Essbase calculation between two dates

edited Apr 24, 2015 10:03AM in Hyperion Essbase (MOSC) 1 commentAnswered

Hi,

Is it possible to develop a dynamic calculation in Essbase (ASO) to calculate

a sum between two dates.

Assuming there is daily transaction,

01/01/15

02/01/15

.

.

.

30/12/15

31/12/15

And our user want to analyse a sales data for a specific period, e.g. between 12 Jan - 27 Jan 2015.

Is there a way in essbase to be able to dynamically calculate the total between the two dates?

The idea is the user can dynamically specify the range of the date which they want each time they retrieve the data.

I'm open to suggestion, either using essbase or smart view or other intelligent tools to do this.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center