Integrating Oracle EPM with IBM Cognos Command Center

Generally, you would not think to use IBM products when working with Oracle EPM solutions.  There is at least one combination that I would recommend exploring.  Below I will walk through the advantages of using the IBM Cognos Command Center to control the processes of your Oracle EPM environment. IBM Cognos Command Center (Overview) IBM…

Read More

Error Handling in Smart View Queries

I often hear new Smart View users concerned about properly formatting their queries or ensuring the member names are correct.  In this post, I will discuss the “Enhanced Comment Handling” feature in the Smart View options.  When selected, this option prompts the user to resolve errors whenever an ad-hoc refresh has invalid members in the…

Read More

OBIEE – Alternate Solution to Refresh User Group Privileges

When users are moved from one catalog group to another group, the privileges of the new group do not automatically get refreshed, i.e the user will still hold privileges from their previous catalog group. Once 'Reload Files and Metadata' is run from the Administration page the proper changes will take effect. If navigating to the…

Read More

Multiple Hyperion Workspace Instances with Internet Explorer

Have you ever tried to open multiple instances of the Hyperion Workspace only to find that it immediately closes itself? Older versions of the Hyperion EPM suite allowed multiple instances in different windows, but the latest versions do not allow this. Multiple instances of the Planning Workspace are useful for the following: Testing user security…

Read More

Custom Styles on Hyperion Planning Forms

Planning web-forms through the Smart View Planning connection often have better formatting than an Essbase ad-hoc connection. Planning web-forms have the blue-shaded metadata, the grey-shaded non-writable data cells, and the yellow-shaded writeable data input cells. In addition, the form layout (POV, Page, Row, and Column members) generally focuses on a business requirement. But there are…

Read More