Tuesday Apr 30, 2013

EPM 11.1.2.3 - Essbase - Runtime Substitution Variables

With 11.1.2.3 being out, I would like to point out the biggest change that we got in Hyperion Essbase:

Runtime Subsitution Variables.

They have been documented in the new features guide.

In short - you can now define Substitution Variables on the fly in a Calc Script or MaxL script.
Nice eh?
How do you do it?

The MaxL syntax looks like this:

execute calculation "myscript" on <App>.<DB> with runtimesubvars 'Currmonth = "Jan";';

(make sure that if you have a list of RTSubVars, that you end EACH ONE with a semicolon
e.g.:

execute calculation "myscript" on Sample.Basic with runtimesubvars 'Currmonth=Jan;CurrProd=Cola;';


there is a slight glitch in the documentation about this - we will get that fixed soon)

In a calc script you can simply use

SET RUNTIMESUBVARS {
Currmonth = "Jun";
};

again - multiple need to end on semicolon each:

SET Runtimesubvar {
Currmonth = "Jun";
Currlocation = "Florida";
};

We were also told that a new function is included in the API to prompt a user for a variable but so far this has not been implemented in any product (MaxL, SmartView, CalcManager, EAS - none of them yet). Products based on the API (e.g. Calc Manager) may in the future make use of that though - so stay tuned.

Along with a few changes to the performance of XREF (should be a lot faster now) and some added calculation functions this is the main change in Essbase.


About


This blog talks about the latest news and upcoming events regarding Oracle EPM abd BI.
Author:
Tanya Heise




Search

Archives
« May 2016
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today