Hyperion Essbase (MOSC)

MOSC Banner

Calc script - Sub set of database

edited Jan 25, 2016 7:50AM in Hyperion Essbase (MOSC) 4 commentsAnswered ✓

I wrote this script that is supposed to calculate for a subset of the database ("11-18-10") but each time I run it, it calculates for the entire database ("Company"). How do I fix this?

FIX("Working","Budget")/*Global Fix*/
  FIX(@IDESCENDANTS("11-18-10"), @IDESCENDANTS("Cost Elements"), @IDESCENDANTS("Cost Centers"))/*Fix on level of CO, CE and CC*/

FIX("CE12980","CE0985","CE136740","CE146750","CE156760","CE166770","CE170981","CE187880","CE191010","CE203310","CE215460")

&PlanYr2 = &PlanYr1 * 1.03;

   ENDFIX
  
  ENDFIX/*

  FIX(&PlanYr2)/*Fix on PlanYr2*/
    CALC DIM ("Company","Cost Elements", "Cost Centers","Projects");
   ENDFIX/*EndFix on PlanYr2*/
ENDFIX

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