Venkatakrishnan J - Rittman Mead (Page 4)

Oracle Warehouse Builder 11gR2 – Importing Essbase Cubes using ODI Knowledge Modules – Part 1

One of the new features introduced in OWB 11gR2 is the ability to import metadata objects through JDBC drivers. So, as long as we have an external API providing the JDBC interface to OWB, OWB should be able to leverage that and import the metadata through the API. For example,

Oracle BI EE 10.1.3.4.1 – Solutions – Puzzle 4

The 4th puzzle in this series was a reasonably simple one which basically demonstrates a capability that allows end users to bypass the security applied in the BI Server layer. There are 3 possible solutions for this Solution 1: Using Evaluate EVALUATE was introduced in the 10.1.3.3.

Oracle BI EE 10.1.3.4.1 – Puzzlers – Puzzle 4 – Bypassing Security

On to the 4th puzzle in this Puzzle series. This is a very interesting Puzzle at least from the perspective of BI EE Security. We all know that BI EE provides comprehensive security within the repository. For example, the screenshot below shows that the column CHANNEL_DESC can be accessed

Oracle BI EE 10.1.3.4.1 – Solutions – Puzzle 3

After almost a week of me giving out the Puzzle 3, there was hardly any interest for this one (just couple of odd replies requesting clarification of the Puzzle). Probably this is because this one has no direct practical usage and also there are lots of possibilities. But to me

Oracle BI EE 10.1.3.4.1 – Puzzlers – Puzzle 3 – Negative Modeling

Now that i have blogged about the solution for Puzzles 1 and 2, its time for the next puzzle. This one requires you to actually build a very simple repository and show me how you can do negative modeling i.e a model that will produce the longest single SQL(

Oracle BI EE 10.1.3.4.1 – Solutions – Puzzles 1 & 2

Well its been almost a week since i blogged the first 2 puzzles in this puzzle series. I guess it is time for me to blog about the solutions. I have been amazed by the response so far. Its been really positive, so more puzzles to come during this week

Oracle BI EE 10.1.3.4.1 – Puzzlers – Puzzle 2

I received some interesting replies through email as well as in the blog comments for the last Puzzle. I will blog about the solution for that and the solution for the 2nd puzzle together later this week. So far 3 people have answered and all are right which i will

Oracle BI EE 10.1.3.4.1 – Puzzlers – Puzzle 1

If you had noticed the news last week [http://money.cnn.com/news/newsfeeds/articles/marketwire/0583321.htm], Oracle’s BI EE has achieved a leader status in the Gartner’s BI Magic Quadrant(i think 3rd year in a row). This can only mean one thing. More and more

Technical

Oracle BI EE 10.1.3.4.1 – Modeling Measure Dimensions on Relational Sources – Essbase Style

One of the biggest differences between Essbase and most other reporting/OLAP tools like BI EE/Oracle OLAP etc is in the way Measures are treated(comparison only in terms of data modeling and reporting and not on physical implementation). In Essbase, every data/value(cell) is attributed by a

Technical

Oracle Fusion Middleware 11g - BI ADF Components - First impressions

One of the few things that i have been working on this week is in understanding how the recently released Fusion Middleware 11g will influence Oracle BI EE in the near future. As was demonstrated & presented in the last Open World by Oracle, the strategic direction of Oracle is

Technical

Oracle BI EE 10.1.3.4.1 – Modeling Degenerate dimensions – Fact attributes

Degenerate dimensions are quite common when we do a Data Warehouse implementation. They are nothing but a set of dimensions that can be classified as Fact attributes and are hence maintained in the fact table itself instead of separate dimension tables. One of the key advantages of using Degenerate dimensions

Technical

Oracle BI EE 10.1.3.4.1 – Understanding Logical Calculations & Native DB Calculations – Repository Modeling

Ever wondered what is the actual difference between the logical calculated measures in the repository and the native DB calculated measures? I have had this question asked to me quite a few times in the recent past that i thought it made sense to create a separate blog entry for

Technical

Oracle EPM 11.1.1.3 - Deploying EPM reporting Portlets in Weblogic Portal 10g

There are multiple ways of integrating reporting tools(oracle or non-oracle) to external portals. The most commonly used ones are the URL based integration, Web Service calls and calling native portlets directly from the portals. I have covered the details of the techniques some time back here [http://oraclebizint.wordpress.

Technical

Oracle EPM 11.1.1.3 - Life Cycle Management - Part1 - Essbase Migration

One of the major issues that i commonly encountered while doing 9.3 based essbase implementations was the fact that there was no built in utility within the Hyperion stack that could migrate various applications from a Development to a Test/Production machine(not essbase alone but also other related

Technical

Oracle BI EE 10.1.3.4.1 – Level Based Measures & Grand Totals

One of the features that Oracle could add to BI EE, is in opening up the BI Server in the form of updatable APIs. Currently, the biggest stumbling block is if there are any lack of features we will have to completely depend on Oracle to add that feature. I

Fantasy Football and OBIEE Part 2 : The Next Man City?

In the last blog entry, i basically did a quick run-through of our 1st part of the "Fantasy Football" demo we put together for the recent UKOUG Conference in Birmingham. Today, i shall be covering the 2nd part of the demo which is actually even more interesting. The

Fantasy Football and OBIEE Part 1 : You Can Be Statto!

One of the demos that we showed off at the recent UKOUG Conference in Birmingham was a football stats demo build using BI EE. The basic idea here was to upload a few years worth of Premier League statistics, create a semantic model and then use it to answer two

Technical

Oracle EPM 11.1.1.3 - Customizing EPM Workspace

A common requirement that always comes up as part of an Organization wide EPM rollout, is in customizing the look and feel of the products to match the company logo, style etc. In the case of BI EE, the customization is quite straight forward, as BI EE segregates the look

Oracle BI EE 10.1.3.4.1 – Setting up Disconnected Analytics

Recently in the UKOUG, we exhibited a demo (more details in the coming blog entries) wherein we also showed the capabilities of the new iphone app, BI Indicators. This actually triggered a chain of thoughts for me on the pros and cons of 3 commonly used BI EE remote access

Technical

Oracle EPM 11.1.1.3 - Installing Hyperion Components on Multiple Machines

In any EPM deployment, rarely do all the components get installed on a single machine. In majority of the cases, you will see that each component is actually installed on separate machines with their own application and web servers. So, how does this all work and how do we go

Technical

Cognos 8 & Oracle BI EE 10.1.3.4.1 - Reporting using Cognos on BI EE Metadata - BI Server ODBC

In the last blog entry i had given a high level overview of the various components comprising the Cognos 8 BI Suite. One of the most common questions that we tend to get in conferences is how do we go about using Cognos to report out of the model designed

Introduction to IBM Cognos 8 Business Intelligence

One of the few things that i have been doing in the last 3 weeks is in finding a good research topic for my part-time PhD thesis. Actually it is a Weekend PhD as i work during the weekdays and in the weekends devote some time to the PhD. Its

Technical

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

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 [http://www.rittmanmead.com/articles/]. One of the scenarios

Oracle BI EE 10.1.3.4.1 – Sub-Totals & Pivot Calculations

One intriguing or not-so obvious feature of BI EE is the way it does its Sub-Totals & Pivot Table calculations. As with any reporting tool, we expect almost every part of a report to be pushed back to the database in the form of native SQL. But there are certain

Technical

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

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