- OBIEE 11.1.1 - Advanced Usage of nqcmd command
- BI Checks with WLST - Enable debug, login and parse logs - Part 3
- OBIEE 11.1.1 - Tuning Guide Whitepaper - update available
- BI Check with WLST - SQL Datasources part 2
- BI Check with WLST - Providers and Technical users part 1
- Essbase 11.1.2.x - Web Launched EAS Console jnlp
- OBIEE 11.1.1: Load Testing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Using Oracle Load Testing (OLT) 12.x
- Calculations Using Dates Stored in Planning
- EPM Infrastructure Tuning Guide v220.127.116.11 / 18.104.22.168
Wednesday Jan 22, 2014
Saturday Nov 23, 2013
By Keith Rosenthal on Nov 23, 2013
Planning allows users to enter date values in Planning. For example, a start date can be entered as 11/01/2013 if the format is MM/DD/YYYY. Although the values are entered in date format, it is possible to calculate values based on dates entered.
Thursday Sep 26, 2013
By user809526 on Sep 26, 2013
Wednesday Sep 04, 2013
By Jane Story on Sep 04, 2013
ODL (Oracle Diagnostic Logging) information is recorded for both the Essbase agent and the Essbase application server. The level of the logging that is recorded can be amended if required.
These are the 2 ODL logs for Essbase:
- EssbaseAgentODLLogger is for the Essbase agent. This writes to the ESSBASE_ODL.log in MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/Essbase/Essbase
- DefSvrLogger is for the Essbase application server (ESSSVR). This writes to the <appname>_ODL.log in MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/Essbase/Essbase/app/<appname>
The level of logging for these Essbase ODL logs is controlled by the logging.xml file.
Thursday Aug 22, 2013
By Keith Rosenthal on Aug 22, 2013
An earlier blog entry, https://blogs.oracle.com/pa/entry/planning_11_1_2_massgridstatistics, discussed the Planning 22.214.171.124 MassGridStatistics utility for displaying web form load times. Starting with the 126.96.36.199 release, MassGridStatistics has been replaced by the grid diagnostics functionality located with the Planning web interface.[Read More]
Tuesday Jul 30, 2013
Saturday Jul 20, 2013
By sujata on Jul 20, 2013
After upgrading Essbase from the 11.1.1.x to 11.1.2.x releases, run through your sanity tests, such as outline dimension build updates, data loads, calculations, queries, etc. If you encounter any performance issues on the newer release of Essbase (for either ASO or BSO models) as compared to the previous release, rebuild the problematic outline on the current 11.1.2.x release. It is possibly that the outline did not migrate properly during the upgrade process.
Once you have rebuilt the outline, run through your tests again and if you still encounter performance issues, open an SR with Support.
Friday Jul 19, 2013
By Vinay Manikyam on Jul 19, 2013
For details on configuration steps on-how to perform HFM 188.8.131.52 / OBIEE 184.108.40.206 Integration using the new ADM thin driver, download this pdf document.
Tuesday Jun 11, 2013
By Jane Story on Jun 11, 2013
The latest release of HPCM provides several new features as well as performance improvements.
V220.127.116.11 provides the following:
- Standard Profitability – Smart View Integration
- Detailed Profitability – new calculation rules
- Detailed Profitability – Essbase Integration
- Detailed Profitability – Stage Balancing Report
Monday Jun 03, 2013
By Keith Rosenthal on Jun 03, 2013
The latest release of Planning includes several performance improvements as well as some new features not present in earlier releases. Some highlights of the new features include:
“Member on the Fly” functionality – For Workforce Planning, Capital Asset Planning, Project Financial Planning and Public Sector Budgeting customers, Planning offers “member on the fly” functionality where end users can dynamically add sparse dimension members and use the added members on a form without performing a Planning refresh. The administrator determines how many new members can be added prior to the next regularly scheduled refresh. Below is an example on how to the “member on the fly’ functionality can be implemented:
Wednesday Apr 24, 2013
Essbase Aggregate Storage (ASO) - Incremental Outline Updates Triggers a Full or Light Outline Restructure
By Ann Donahue on Apr 24, 2013
When performing incremental updates to an Essbase Aggregate Storage (ASO) outline, depending on the nature of the incremental updates, could trigger either a full or light outline restructure.
Thursday Mar 21, 2013
By Jane Story on Mar 21, 2013
In HPCM, users access the “Job Status” task area to view the status of submitted jobs/task flows. In 18.104.22.168.x, the task flow information viewed on these screens within HPCM is cached in order to provide better performance. A refresh occurs after each configured interval and new entries are shown after this interval.
Friday Jan 25, 2013
By Ann Donahue on Jan 25, 2013
Merge Data Slices Before Copying an Aggregate Storage (ASO) Application
When performing an Aggregate Storage (ASO) application copy, it is necessary to merge all data slices first so that all data in the ASO application will be copied properly. The current Essbase documentation does not clearly state a merge of the data is required before running an ASO application copy. An update to the Essbase documentation will be done. However, you can find the documentation update in the current Essbase 22.214.171.124.100 readme documentation. See the current Essbase 126.96.36.199.100 readme documentation under Documentation Updates: http://docs.oracle.com/cd/E17236_01/epm.1112/esb_11122100_readme.pdf
Wednesday Dec 19, 2012
Wednesday Dec 12, 2012
By Marc Schumacher on Dec 12, 2012
This is the third post on Oracle EPM System Architecture. It will cover all Financial Performance Management Applications, namely Financial Management, Essbase Analytics Link, Planning, Profitability and Cost Management, Strategic Finance and Disclosure Management. Please be aware of the fact that I also updated the previous posts on Foundation and Reporting and Analysis based on the feedback I got so far.
A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]