We faced with quite a strange pattern in behavior of our essbase application. I have a special essbase monitoring MDX query that calculates a single value in a Hybrid mode. Here it is:
Continue reading “What is the best processor for Hybrid?”
Category: Undocumented
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
Essbase. FIX and ENDFIX. UnDocumented.
Essbase. FIX and ENDFIX. UnDocumented.
Did you know :
instant
FIX ()
/* some calculations here */
ENDFIX
you can write
FIX () {
/* some calculations here */
}
Essbase. MaxlScript. UnDocumented
You can use system variables in the MAXL integration scripts. You don’t need anymore create templates and fill it in the bash script.
Just use $PATH Maxl variable to get value from %PATH% system variable.
Essbase: CalcScript. Undocumented
Essbase: CalcScript. Undocumented
You can use arithmetic calculations instant logical operations
Instant
A ( IF (A+0 > 10) B=A; ENDIF )
You can write
A ( B=A * (A+0 > 10) ; )
Because result of logical operations it’s always (1 )or (0)