Business Intelligence – Oracle

Workshop Series

This page contains all the article series that i am planning to write in the coming future. This would get updated with more topics going forward. For example, this would contain articles on advanced topics like BI EE and Essbase Integration(Reporting), BI EE and Essbase Security Integration, Enterprise Performance Foundation(EPF) and CPM Analytics etc. As always i would try to make this as error free as possible. But if there are any like typos, screenshot errors etc, feel free to add them in the comments section. All of these will always be available for public consumption here. These articles will be available in the main blog page as well. This page is more of an article grouping page so that the content searching becomes easier. Some of these below are not documented anywhere and are based on personal experience with these toolsets and also due to an extensive study on these toolsets.

1. Hyperion Essbase and BI EE Connectivity – 7 article series containing some complex integration scenarios primarily from a reporting perspective.

  1. Oracle BI EE 10.1.3.4 & Essbase Connectivity – Understanding MDX Queries and Reports Tuning – Introduction
  2. Oracle BI EE 10.1.3.4 & Essbase Connectivity – Understanding MDX Queries and Reports Tuning – Level Based Aggregations and No Aggregations
  3. Oracle BI EE 10.1.3.4 & Essbase Connectivity – EVALUATE and MDX Functions – Multi Level Reporting
  4. Oracle BI EE 10.1.3.4 & Essbase Connectivity – EVALUATE and MDX Functions – Multi Level Reporting – Continued
  5. Oracle BI EE 10.1.3.4 & Essbase Connectivity – A Report Use Case
  6. Oracle BI EE 10.1.3.4 & Essbase Connectivity – Report Use Case2 – Drills from Prompts – EVALUATE in Prompts
  7. Oracle BI EE 10.1.3.4 & Essbase Connectivity – Report Use Case 3 & 4 – CASE Statements and Variable Measures – Adding and Subtracting Measures
  8. Oracle BI EE 10.1.3.4, BI Publisher & Essbase Connectivity – Security Integration

2. Hyperion Essbase 9.3.1 – Walk Through – A 8 article series explaining the process of creating rule files, doing data loads, handling security in both ASO as well as BSO cubes. This would also cover currency conversions in ASO as well as BSO.

  1. Hyperion Essbase 9.3.1 – OBE Series – Designing Essbase Databases – BSO Outlines & Data Load – Global Schema – Part 1
  2. Hyperion Essbase 9.3.1 – OBE Series – Designing Essbase Databases – BSO Outlines & Data Load – Global Schema – Part 2 – Building Dimensions
  3. Hyperion Essbase 9.3.1 – OBE Series – Designing Essbase Databases – BSO Outlines & Data Load – Global Schema – Part 3 – Building Dimensions
  4. Hyperion Essbase 9.3.1 – OBE Series – Designing Essbase Databases – BSO Outlines & Data Load – Global Schema – Part 4 – Loading Data
  5. Hyperion Essbase 9.3.1 – OBE Series – Using Outline Migration Wizard to Convert BSO to ASO outlines – Understanding ASO Cubes – Part 5
  6. Hyperion Essbase 9.3.1 – Alternative Approach to Currency Conversion in BSO Cubes – Using Calculation Scripts – Part 1
  7. Hyperion Essbase 9.3.1 – Alternative Approach to Currency Conversion in BSO Cubes – Using Calculation Scripts – Part 2

3. Hyperion Financial Reporting – A 5 article series explaining the process of creating some complex reports using Hyperion Financial Reporting

4. Web Analysis – A 5 article series explaining the process of creating some complex reports using Hyperion Web Analysis

5. Integration of BI EE Plus – A 2 article series explaining the complex integration between BI EE, Web Analysis and Hyperion Financial Reporting (This should give an idea of how to integrate any 2 reporting tools in general)

  1. Integration of all Oracle and Non-Oracle Reporting Toolsets – URL Parameters – An introduction
  2. Oracle BI EE 10.1.3.4 – Integration between BI EE & Hyperion Financial Reporting(HFR) – Drilling from BI EE to HFR by passing parameters – Part 1
  3. Oracle BI EE 10.1.3.4 – Integration between BI EE & Hyperion Financial Reporting(HFR) – Drilling from HFR to BI EE by passing parameters – Part 2

6. Enterprise Performance Foundation – An overview and walk through of Data Model – A 2 article series giving the basics of Enterprise Performance Foundation along with a detailed explanation of the data model (from a data warehousing perspective).

7. Corporate Performance Management Analytics (CPM Analytics) – A detailed 2 article series explaining how the repository was designed. This would be correlated to the data model explanation above.

  1. Enterprise Performance Foundation (EPF or FEM) – Data Model Introduction

8. OWSM and BI EE – A 2 article series explaining how Oracle Web Services Manager can be used to manage the Web Services API of BI EE.

3 Responses to “Workshop Series”

  1. […] Workshop Series […]

  2. Giriprasad said

    Good work Venkat. If you would like to motorize your effort/website, let me know.. I can help you.

    Thanks
    Giriprasad

  3. […] Workshop Series […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: