Hyperion Planning (MOSC)

MOSC Banner

How to make Simple Data Copy from a Parent Yeartotal to a member Dec in Hyperion Planning/Essbase

edited May 19, 2016 11:23AM in Hyperion Planning (MOSC) 3 commentsAnswered ✓

How to make Data Copy from a Parent FY16 Yeartotal to a member FY17 Dec

Copy From:

YearTotal      (Period)

FY16           (Year)

Cost center (Entity)

USD           (Currency)

LE1            (Scenario)

Final           (version)

All operating income accounts (Account)

Copy To:

Dec                 (Period)

FY17               (Year)

Cost center      (Entity)

USD               (Currency)

VSP_2016       (Scenario)

Working           (version)

All operating income accounts (Account)

Data is not Copied after executing Below Calculation Script.

FIX("HSP_InputValue",@RELATIVE("Operating Income",0),@RELATIVE("Currency",0),@RELATIVE("Market Segment",0),@Relative("Cost center",0))

DATACOPY "Final"->"LE1"->"FY16"->"YearTotal" TO "Working"->"VSP_2016"->"FY17"->"Dec";

ENDFIX

Using Hyperion Planning version 11.1.2.2.303

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