Venkatakrishnan J - Rittman Mead

Rittman Mead BI Masterclass India Tour - Update

Just a quick blog post to give an update about our Masterclass tour in India in partnership with ODTUG. As you probably know, Mark Rittman (Oracle ACE Director & Rittman Mead Co-Founder), Stewart Bryson (Oracle ACE, Rittman Mead America Managing Director) & myself (Oracle ACE, Rittman Mead India Managing Director)

Technical

EPM 11.1.2.2 - Planning New Features

As mentioned in my previous post here, EPM 11.1.2.2 has introduced a bevy of new features that customers have been asking for a while. Also, 11.1.2.2 theoretically is the actual Fusion release as all components now use ADF UI natively. In today's post we

HPCM 11.1.2.2 - Detailed Profitability

2 Weeks back, EPM 11.1.2.2 released with a lot of new features. The number of new features are so much so that it will take at least 8 to 10 posts to go over all them in detail. I thought i will start off with writing about

Oracle Endeca (OEID) - Exploring Unstructured Data - Twitter & Blog Analytics - Part 1

Recently the entire BI landscape of how we do reporting and how the data is consumed seems to be on the change constantly. Until a year back, the whole world of BI (at least from a perspective of Oracle) revolved around building Data Warehouses (& OLAP/Essbase cubes) and then

Anatomy of BI EE Page Rendering - Use of HTTP/Web Server & Compression

There are many aspects/variables thatcan affect the performance of a BI Deployment. Generally whenever a BI Dashboard is slow the general tendency is to attribute the slowness in performance to eitherthe BI Reports or underlying databases. Of course, in 90% of the cases this will be truebut there are

Oracle BI Suite EE

Hyperion Profitability & Cost Management - Overview

Recently i have been doing lot more work on the Oracle EPM stack than on the Oracle BI stack. So, i will be writing more on the various Oracle EPM products like HFM, Planning, FDQM etc in the forthcoming weeks. To sort of kick start the series of postings, i

Oracle BI Suite EE

BI EE 11.1.1.5 - Calling BI EE 11g Agents through Oracle Data Integrator 11g

I was asked recently to come out with a way of calling BI EE 11g agents directly from Oracle Data Integrator 11g. There are many ways of accomplishing this. I thought i will write a quick blog post about the various possible solutions and more importantly get back to blogging

Oracle BI Suite EE

Oracle BI EE 11g - Hyperion Financial Management Analytics (HFM Analytics)

If you had watched the announcements in Open World this year, one of the products that got silently released was HFM Analytics. Basically this is an Analytics Suite under the umbrella of BI Applications but without any ETL. This suite provides comprehensive set of pre-built reports/dashboards for customers who

Business Insights

Oracle BI EE 11g - Security Auditing - Web Catalog Security

BI EE Web Catalog security is an area that generally requires a lot of understanding especially while migrating Web Catalogs. There is not a lot available in the documentation that goes into detail on how .ATR files store security. Its a known fact that doing a file system copy of

Oracle BI Suite EE

Oracle BI EE 11g - Reporting on Hyperion Financial Management (HFM) - Part 1

This has been my second longest sabbatical since i started blogging 4.5 years back. More than a month since my last post. Rather than going into the reasons of why(& sounding cliched) i thought i will kick start my postings again with one another new BI EE 11g

Oracle BI Suite EE

Oracle BI EE 11.1.1.5 - Repository Command Line Switches - Importing New Projects into RPD

One of the hidden features of BI Admin Tool is the ability to run certain commands from command line. I have written about some of the use cases of this here. In addition to the ones that i have written there are some more set of parameters that we can

Oracle BI Suite EE

BI Applications 7.9.6.3 - What's New?

Along with BI EE 11.1.1.5, there was also a major release of BI Apps 7.9.6.3. This is a major release not because of the new features but instead this is the first release that uses BI EE 11g natively. In fact this release does

Oracle BI Suite EE

Oracle BI EE 11.1.1.5 - New JDeveloper Extensions

As covered by Mark earlier, BI EE 11.1.1.5 has some significant new features and is a definite upgrade for customers using BI EE 11.1.1.3(even for 10g customers). I know the release is only a week old, hence calling it a definite upgrade requires

Oracle BI EE 11.1.1.5 - Released and Available for Download

As you might have noticed from Oracle Press Releases recently, both BI EE 11.1.1.5 and BI Apps 7.9.6.3 were released this week. Now the softwares are available for download at http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/biee-111150-393613.html. The documentation hasn't been

Oracle BI Suite EE

Oracle BI EE 11g - Decoding Essbase Connectivity - Part 5 - Security

I was actually compiling all my findings of the last 4 posts as a summary post but then realized i haven't actually covered another important part of the Essbase Connectivity i.e. Essbase Security. In today's post let's look at how Essbase Security is handled in BI EE 11g. I

Oracle BI Suite EE

Oracle BI EE 11g - Decoding Essbase Connectivity - Part 4 - Logical SQL Generation

In the last 3 posts we saw how BI EE generates the MDX and what major factors influence the MDX generated. As a recap, there are 4 main things that we noticed. BI EE generates the most optimal MDX as long as we have all the attribute or Hierarchical columns

Oracle BI Suite EE

Oracle BI EE 11g - Decoding Essbase Connectivity - Part 3

Continuing along with our Essbase series, today lets look at how the various Pivoting operations that are done at the BI EE layer affect the MDX generated. We noticed that whenever we brought in an attribute column from the row-edge to the column edge, the MDX generated by BI EE

Oracle BI Suite EE

Oracle BI EE 11g - Decoding Essbase Connectivity - Part 2

In the last post we saw how BI EE generates Essbase specific MDX while using Attribute columns for a specific case. In today's post we shall look at how the new BI EE 11g specific features like Hierarchical columns and Value-Based hierarchies affect the MDX generated. For continuation sake, i

Oracle BI Suite EE

Oracle BI EE 11g - Decoding Essbase Connectivity - Part 1

If you had gone through my blog series for BI EE 10g and Essbase here, i would have covered the different ways of controlling the BI EE MDX generated for Essbase Sources. With 11g, that too with the introduction of Hierarchical Columns and Value Based Hierarchies, the entire series needs

Oracle BI EE 11g - Migrating Security - Credential Store - Part 3

In the last 2 posts we saw the process involved in migrating the Identity as well as the Policy Stores. In today's post we shall see the process involved in migrating Credential Stores from one environment to the other. To recap, Credential Stores are nothing but a physical file that

Oracle BI EE 11g - Migrating Security - Policy Store - Part 2

In the last post, we saw how to go about doing a security migration of the Identity Stores. Today we shall look at the migration process of the Policy Stores. Just to give a brief background, Policy Store is nothing but a physical file that contains the Application Role, Applications

Oracle BIEE 11g - Migrating Security - Identity Stores - Part 1

One of the most important tasks while moving environments, say from Dev to Test or to Prod is in migrating the security objects. In 10g, it was a lot easier to move security as everything was embedded within the repository. But in the case of 11g, with the introduction of

Oracle BI EE 10g/11g - Querying Directly on the BMM layer - SELECT_BUSINESS_MODEL

Though we are now almost 7 months after the 11g release, there still are some hidden gems in 10g that sometimes seem to come up time and again(atleast for me). This week, i chanced upon a method of querying the BMM layer directly while working on one of our

Oracle BI Suite EE

Oracle BI EE 11g and Oracle ADF - Part 2 - Real Time reporting using View Objects

In the last part i showed how BI EE 11g and Oracle ADF are integrated through the same Security Framework. In this part, we shall look into another reporting innovation (by use of the common ADF Framework) i.e. real time reporting using BI EE by directly reversing metadata from

Oracle BI EE 11g & Oracle ADF - Part 1 - Understanding Security Integration

Over the past few months myself and Mark have written about some major BI EE 11g new features. In addition we had also covered how the security has changed from BI EE 10g to 11g. But what we have not yet covered in detail is how much Oracle ADF or