Venkatakrishnan J - Rittman Mead (Page 3)

Oracle BI EE 11g - BI Server Upgrade Considerations

One of the important points to consider when moving from BI EE 10g to 11g is in understanding the BI Server behavior changes. Though there are quite a lot of changes in the underlying code for performance improvement etc, introduction of new features in 11g can potentially alter your generated

Oracle BI EE 11g - Parent-Child Hierarchies - Differing Aggregations

Mark has already explained the new Parent-Child hierarchy new feature in 11g here [https://www.rittmanmead.com/blog/2010/07/12/obiee-11gr1-support-for-ragged-skip-level-value-based-hierarchies/] . Parent Child hierarchies are different from normal level based hierarchies not only in the nature of their structure but also in the way aggregations are done. For example,

Oracle BI EE 11g - Upgrading from BI EE 10g - Repository & Web Catalog

BI EE 11g is a significant feature filled release when compared with the previous 10g release. Most customers who are planning to upgrade to 11g have an automated way of upgrading their 10g Web Catalogs and repositories to the 11g version. When moving from 10g to 11g, we will have

Oracle BI EE 11g - Reporting on CLOBs - Lookups

One important new feature of BI EE 11g is the ability to report on CLOBs and other large objects. The main difference between normal Varchar/Numeric columns and LOB datatype columns is, LOB columns do not support GROUP BY, DISTINCT & ORDER BY operations on them (from a reporting perspective)

Oracle BI EE 11g - Map Views - Integration with Mapviewer

One of the biggest new features in BI EE 11g is the ability to create native mapviewer maps and then overlay reporting components/visualizations on top of maps. For example if you are doing a country based sales analysis, its easy to color code each country across the world right

Oracle BI EE 11g - Handling Double Columns - ID/Description interoperability

The other big change in BI EE 11g as mentioned before here [https://www.rittmanmead.com/blog/2010/08/14/oracle-bi-ee-11g-%e2%80%93-bi-server-new-features/], is the ability to assign ID columns for descriptive columns more commonly known as Double Columns. This feature has 2 fold advantages 1. In BI EE

Oracle BI EE 11g - Lookup Tables - Sparse and Dense Lookups

A very important feature that has been introduced in 11g is the ability to model lookup tables in the repository. If you have worked with ETL tools before, lookup tables are quite common especially when we want to do a lot of lookup operations (id to description mappings). In 10g,

Oracle BI EE 11g - Vertical Clustering - Fault Tolerance & Multiple BI Servers in a Box

One of the significant changes in the BI EE 11g is in the way clustering is done. Mark has covered horizontal clustering (using the scale-out option in the installer) in his previous post here [https://www.rittmanmead.com/blog/2010/07/20/obiee-11gr1-scaleout-clustering-and-high-availability/] . The entire process of clustering is much

Oracle BI EE 11g – BI Server new features

As Mark has shown in the previous 11g related blog entries [http://www.rittmanmead.com/obiee11g/], BI EE 11g introduces a lot of new features across the entire spectrum of BI EE. If you had got a chance to look at the list of new features, you can realize that

Oracle BI Suite EE

Oracle BI EE 11g - Released & Available for Download

Looks like BI EE 11g silently made it to OTN yesterday. The software is available for download now. It can be downloaded from here [http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html] . Currently its available only for Windows (32 bit & 64 bit) & Linux (32 bit &

Technical

Oracle OLAP 11g - Reporting in Excel using Simba MDX OLE-DB Provider

If you had looked at my blog entry here [https://www.rittmanmead.com/blog/2010/04/19/oracle-epm-11-1-1-3-oracle-olap-11g-reporting-on-oracle-olap-using-essbase-excel-add-insmartview-xolap/] , i would have shown a way of reporting on Oracle OLAP 11g using the newly introduced Essbase XOLAP. As mentioned there, one of the biggest advantages of using Essbase is its tight

Oracle BI EE 10.1.3.4.1 – Catalog Manager Command Line Options

One of the common drawbacks with BI EE currently is the inability to use any automated scripting methods to add users/groups/folders/reports to the web catalog. Following are the possible ways to add/create new groups, create new folders, copying reports etc 1. Use Catalog Manager to do

Technical

Oracle BI EE 10.1.3.4.1 – Currency Conversions & FX Translations – Part 1

One of the common requirements when implementing BI EE is the ability to handle multiple input currencies. This is a pretty common requirement especially in business scenarios where multiple countries/currencies are involved. In such cases, many of the finance related measures like Sales etc will come in local currencies.

Technical

Oracle BI EE 10.1.3.4.1 – Do we always need AGO and ToDate functions for Time Series Analysis?

In my last blog post, i basically showed how we can do multi-dimension OLAP aware reporting by altering the physical data-warehouse model. Along similar lines, one other common thing that i have found recently in many implementations is the extensive use of AGO and ToDate functions. AGO and ToDate are

Technical

Oracle BI EE 10.1.3.4.1 – Do we need measures in a Fact Table?

I know this blog title can be classified as a deviation from my more conventional ones but i have been planning on writing this for a while now, so hopefully this should be of some interest to everyone. As we start working with BI EE more and more, we get

Technical

Oracle EPM 11.1.2 - Allocations in Essbase ASO Cubes - Using MaxL scripts

In the last 2 blog entries, i showed how the calculations in ASO work. Today lets look at another new feature in ASO cubes i.e the ability to run allocations directly. In a BSO cube, Allocations and Calculations are all driven through a set of calculation commands. Some Allocation

Technical

Oracle EPM 11.1.2 - Essbase Calculations on ASO Cubes - Part 2 - Maxl scripts and EAS

In the last blog post, i covered the new calculation manager feature to run calculations on an ASO cube. But to be honest, i somehow felt it was an overkill atleast for running ASO specific calculations alone. The advantage of calc manager can become apparent if you are using Planning

Technical

Oracle EPM 11.1.2 - Essbase Calculations on ASO Cubes - Part 1 - Using Calc Manager

One of the significant new features of EPM 11.1.2 release, is the ability to write custom calculation scripts for calculating & allocating data to level-0 members in an ASO Cube. Till now, in many cases/implementations, BSO option had to be used in some form or the other

Rittman Mead India - Call for very good Oracle BI Developers/Architects

As Mark mentioned in his blog posting a couple of weeks back [https://www.rittmanmead.com/blog/2010/03/28/an-update-on-the-bi-forum-obiee-emg-and-us-conferences/] , we now have an office in India. We now have a total of 3 people working out of our India office currently with myself overseeing the operations. Personally this

Technical

EPM 11.1.2 - Getting Started and Installation

I have finally managed to download & install the necessary binaries for the EPM 11.1.2 Essbase installation. When i started the download, i was actually wary of downloading the 64 bit Essbase since 11.1.2 is a significant rewrite when compared with the previous 11.1.1.

Technical

Oracle EPM 11.1.2 – Finally released and available on E-Delivery

After checking non-stop for the last couple of weeks, finally managed to start the download of EPM 11.1.2. Yes, its officially released for download now and is available in E-Delivery [http://edelivery.oracle.com]. Some of the significant new features in this release are 1. Oracle Financial Close

Technical

Oracle BI EE 10.1.3.4.1 – Number of Members in a Level & Aggregate Navigation

One of the less known/less used capabilities of BI EE is the ability to switch between Aggregate tables based on the number of members in a level. For example, lets consider the screenshot shown below In most cases, we will not have the necessity to alter the number shown

Technical

Oracle EPM 11.1.1.3 & Oracle OLAP 11g – Reporting on Oracle OLAP using Essbase Excel Add-in/Smartview - XOLAP

This is the week of Colloborate 2010 [http://www.collaborate10.org/] conference. Mark, myself, Pete and Stewart were scheduled to present this year but due to the European Airspace closure, myself and Pete haven’t been able to actually travel this year. Its a real shame as we all really

Technical

Hyperion Financial Reporting (HFR) 11.1.1.3 – Reporting on Relational Sources – XOLAP

Hyperion Financial Reporting (HFR) is one of the simplest and very robust reporting tools that is currently part of the Oracle BI EE Plus bundle. It has excellent multi-dimensional reporting capabilities and scales very well unlike Web Analysis. Part of the reason for this is, there is not much metadata

Technical

Oracle Warehouse Builder 11gR2 - Using Code Templates - Loading Metadata from Essbase to Relational Tables - Part 2

In the first part of this series here [https://www.rittmanmead.com/blog/2010/03/17/oracle-warehouse-builder-11gr2-importing-essbase-cubes-using-odi-knowledge-modules-part-1/] , i had shown how to go about using the ODI RKM's from within Warehouse Builder to reverse engineer Essbase metadata. Though i did promise to come back sooner on the rest