Oracle BI EE 10.1.3.4.1 & Essbase Connectivity – Enriching Essbase reports with relational attributes

Tuesday, November 24th, 2009 by Venkatakrishnan J

If you had attended our training days event or one of our Open World sessions, you will have noticed that we had covered the various aspects of integration between Essbase and relational sources using BI EE. The presentations are available here. One of the scenarios that we had not covered was the ability to display [...]

Oracle BI EE 10.1.3.4.1 – Single Table Repository Design – Modeling Statistics of common Sports – Tennis, Football etc – Part 2

Monday, November 16th, 2009 by Venkatakrishnan J

In the last blog entry i had shown a simple scenario of creating a BMM layer for one physical table. In today’s entry i will be covering a practical use case of creating a BMM layer from one physical table. This is a very interesting use case and can be used to demonstrate the reporting [...]

Oracle BI EE 10.1.3.4.1 – Single Table Repository Design – Part 1

Tuesday, November 10th, 2009 by Venkatakrishnan J

One of the best ways to understand the BI EE repository design is to start designing the Business Model Layer for a single Physical table. Any person who is new to BI EE will always start with testing the repository for a single physical table. This is where BI EE can be quite confusing for [...]

Oracle BI EE 10.1.3.4.1 – Multi-Select Prompts, String Aggregation

Friday, November 6th, 2009 by Venkatakrishnan J

One of the issues that people often face while using BI EE is the lack of control on Multi-Select prompts. One cannot set Multi-Select prompts to a presentation variable & similarly one cannot display the multi-selected values in a report (only filter view supports the display of all the selected values). The most common requirement [...]

Oracle BI EE 10.1.3.4.1 and Essbase Connectivity – Fragmentation on Essbase Sources

Monday, October 19th, 2009 by Venkatakrishnan J

In our BI EE – Essbase session in OOW, we covered 2 important use cases in bringing BI EE and Essbase together. They are
1. Horizontal Federation
2. Vertical Federation
There is one more use case that only BI EE as a reporting tool can do on an Essbase source(not possible in Smartview or any other Hyperion reporting [...]

Website Design & Build: tymedia.co.uk