Hyperion Essbase (MOSC)

MOSC Banner

Convert P&L Data into Balance Sheet Data

edited Oct 18, 2016 7:12AM in Hyperion Essbase (MOSC) 2 commentsAnswered ✓

Greetings,

we're on 11.2.2.x Essbase

we get P&L data coming into our Balance Sheet database. Users now want to see movements per month instead of activities.  This a temporary 'fix' until we can get the GL extract to provide the data as intended.  Example below shows the movement per month on the BS row and is what the users are looking for.  If we wanted to keep this within an Essbase Calc script for the time being, what would be the best approach to getting the BS data - would something like this be sufficient?

FIX( BS, Jan, &CurrYear )

Tagged:

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