Hyperion Essbase (MOSC)

MOSC Banner

ESSBASE-Report Script for Level0 for ASO

edited Sep 17, 2016 5:00AM in Hyperion Essbase (MOSC) 4 commentsAnswered

Hello,

Anyone have any idea why the following Report script for ASO is giving an error: Mathematical operation results in integer overflow/underflow. reduce the size of the report region.

we would like to extract the 0 level members from 5 demensions. Accout and period are dense.

{ROWREPEAT}

{SUPBRACKETS}

{NOINDENTGEN}

{SUPMISSINGROWS}

{SUPFEED}

{TABDELIMIT}

{SUPZEROROWS}

{WIDTH 25}

<COLUMN("Period")

"Jan"

<ROW("Unit","Process","Product","Resource","Project","Center","Account")

"20005_BU""20048_BU""50125_BU"

"Current"

"Projections User Adjustment"

"[NONE]"

"FY16"

"NO PRODUCT"

<LINK(<LEV("Process",0))

<LINK(<LEV("Resource",0))

<LINK(<LEV("Project",0))

<LINK(<LEV(" Center",0))

<LINK(<LEV("Unit",0))

<LINK(<LEV("Account",0))

Is there a more efficient way to accomplish this? or are we missing something?

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