- Error Connecting to Planning Application from Smartview
- BI Web service security client - authentication operations for 188.8.131.52 and 184.108.40.206.x
- 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
Wednesday Apr 23, 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 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 220.127.116.11 MassGridStatistics utility for displaying web form load times. Starting with the 18.104.22.168 release, MassGridStatistics has been replaced by the grid diagnostics functionality located with the Planning web interface.[Read More]
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:
Friday Mar 08, 2013
By Keith Rosenthal on Mar 08, 2013
Many Planning customers today are designing forms containing user variables. User variables allow the user to customize the information presented on a form based on the user’s security. In addition, the number of forms maintained in the application is reduced since multiple versions of the same form having different dimension members do not need to be created.[Read More]
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.
Friday Nov 30, 2012
By Keith Rosenthal on Nov 30, 2012
Data recovery is typically performed by restoring data from an archive. Data added or removed since the last archive took place can also be recovered by enabling transaction logging in Essbase. Transaction logging works by writing transactions to a log store.[Read More]
Wednesday Oct 31, 2012
By Marc Schumacher on Oct 31, 2012
Running into a Java out of memory error, it is very common behaviour in the field that the Java heap size will be increased. While this might help to solve a heap space out of memory error, it might not help to fix an out of memory error for the Thread Local Area (TLA). Increasing the available heap space from 1 GB to 16 GB might not even help in this situation.
Friday Aug 24, 2012
By Keith Rosenthal on Aug 24, 2012
By Keith Rosenthal on Aug 24, 2012
Wednesday Mar 07, 2012
Wednesday Nov 16, 2011
By Keith Rosenthal on Nov 16, 2011
A utility is available for Oracle Hyperion Planning that determines web form load times. This utility, MassGridStatistics, opens all web forms within the Planning application. After the forms are opened, an html page will appear showing the form options, suppression, number of row column and page members, and load times. Any form having a load time longer than one second could potentially have scalability issues in a multi-user environment and should be considered for re-design. Adding suppression (especially block suppression) and reducing the number of rows and columns are potential fixes that will reduce load times.
The MassGridStatistics utility is located in a .7z file called MassGridStatistics.7z. Extract the file using 7-Zip. A readme file is provided listing the installation instructions and the steps to run the utility.
MassGridStatistics is included with the 22.214.171.124.101 patch set and will also be in all future releases starting with 126.96.36.199. For earlier Planning releases, an SR will be necessary to have Support provide the utility.
Saturday Sep 03, 2011
By Ruben Verghese on Sep 03, 2011
You can extract security information out planning application using the following script on Planning SQL tables,
SELECT A.OBJECT_ID AS GROUP_ID,
A.OBJECT_NAME AS GROUP_NAME,
E.OBJECT_NAME AS USER_NAME,
AND B.OBJECT_TYPE ='6'
ORDER BY A.OBJECT_ID
A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]