Tuesday Apr 30, 2013

BI Apps 7.9.6.4 with OBIEE 11.1.1.7 - Installation Issue

If you are trying to install BI Apps 7.9.6.4 on OBIEE 11.1.1.7.0, you will encounter an issue.

 Please be advised that BI Apps 7964 (which was released on OBIEE 11.1.1.6.2. BP1) requires BI EE 11.1.1.6.4+.

You will therefore need to install BI EE 11.1.1.6.0 and then patch to 11.1.1.6.4 or higher. Then run the BI Apps installer. Once BI Applications has been installed, you can then upgrade BI EE to 11.1.1.7.0, if required.

Please note that “Certified” doesn’t automatically mean you can Install apps into the .7 environment. You must first install into what was originally certified and then upgrade the techstack.

EPM 11.1.2.3 - Documentation is online

(in via Mel)

Additional to the EPM 11.1.2.3 Software, the Documentation has also been updated.

You can find it under:

http://www.oracle.com/technetwork/middleware/performance-management/documentation/index.html

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 initiated by the EPM/BI Proactive Support Team.

Authors:

italia.nowodworska@oracle.com
paul.anderson@oracle.com





Search

Archives
« April 2013 »
SunMonTueWedThuFriSat
 
1
3
6
7
9
11
12
13
14
16
17
19
20
21
23
24
27
28
    
       
Today