get Oracle SmartView plugin

Essbase: Create Block. UnDocumented.

Essbase: Create Block. UnDocumented.

This undocumented functions for saving your time and money.  You don’t need any more export data and load trick.

You can use it for creating blocks for agg value for allocation purposes if used Essbase Hybrid Options.

Undocumented possibility is :  use  ‘Cross Dim (->)’ operator on the left side assign operator (=)  ; Example below :

FIX(SPARSE02_NA,SPARSE03_NA)

SPARSE01_NA=#MISSING;

ENDFIX

FIX(@REMOVE(@RELATIVE(SPARSE01 ,0),SPARSE01_NA)   @REMOVE(@RELATIVE(SPARSE02 ,0),SPARSE02_NA) )

SPARSE03_NA (

SPARSE01_NA-> SPARSE02_NA-> SPARSE03_NA= SPARSE01_NA-> SPARSE02_NA-> SPARSE03_NA + SPARSE03_NA;/* It’s   “classic” loop for agg or collect some value */

)

ENDFIX