Wednesday Jul 18, 2012

Essbase “Virtual Cube” BSO Tuning

Essbase “Virtual Cube” BSO Tuning

An Essbase “virtual cube” is a specific design setup where transparent partitioning is used and consists of multiple source databases that are partitioned to a single target Block Storage (BSO) database.  The single target BSO database is empty meaning contains no data.  The purpose of this design setup is so that end users have one consolidated BSO cube for reporting.  In some cases, the target BSO database may have different dynamic calc member formulas then the source databases.  Also, the target BSO database may have more dimensions to accommodate the source databases and may have different sparse/dense configuration since source databases are tuned with data accordingly.

The Essbase Database Administration Guide mentions how to tune Essbase BSO databases that contains data; however, there is no documentation on how to tune a BSO database that contains no data like in a “virtual cube” setup. 

[Read More]

Monday Jul 16, 2012

Charts in BI not rendering after applying OBIEE

Issue:  Charts are no longer rendering in IE or FF after applying OBIEE BP1

The reason that charts are failing to render is due to the fact that our update process does not touch the custom directories (skins, styles). It will only update the default skins and styles directories (s_blafp and sk_blafp). The reason is that we do not want to overwrite any customizations done by customers / partners.

Note: If you are using a custom skins directory, you will have to copy the BIChart.swf from the default directory or the install directory into your custom skins directory. If you do not replace the file, the charts will not render. This change requires that the OracleBI Presentation Services Component be restarted via the opmnctl process as well as for the browser cache to be cleared. Once that has been done, you will be able to render the charts.

[Read More]

Friday Jul 13, 2012

Oracle Hyperion Financial Management (HFM) Configurable Dimensions FAQ

What is Configurable Dimensions?

Configurable Dimension allows the HFM administrator to set the number of custom dimensions in the application. For each dimension it is possible to set the size of the dimension and give a short name and a long name (alias).

[Read More]