Hyperion Essbase (MOSC)

MOSC Banner

CREATEBLOCK

edited Nov 14, 2013 2:35AM in Hyperion Essbase (MOSC) 3 commentsAnswered ✓
I have added the CREATEBLOCK to my formula but it is still missing copying some of the data to the dimensions.  I need some guidance on this one.  Thanks.

Entity - Sparse

Scenario - Dense

Year - Dense

Time - Dense

Accounts - Sparse

_________________________________________________________________________________________________

SET UPDATECALC OFF;
SET CACHE ALL;
SET CACHE HIGH;
SET CREATEBLOCKONEQ ON;

FIX (@DESCENDANTS(NETINC,0), @DESCENDANTS("BCS",0))

/* Clear current budget version */
 CLEARDATA "FY14"->&BudgetScenario;

/* XREF 2014 budget data from SCFCST */
FIX("Period1","FY2014")
 &BudgetScenario
 (IF(@ISUDA(Entity,SCFCST))
  &BudgetScenario = @XREF(_SCFCST_,Jan,FY14,Budget,"Version_1");
 ENDIF);
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