Venkatakrishnan J - Rittman Mead (Page 6)

Oracle BI EE 10.1.3.4.1 – Drills on Union Requests – Fragmentation

One another issue with BI EE is the fact that, whenever we try to build a report with a Union All request, we would lose the capability of using repository based drills in the front-end. There was a question recently on how to overcome this limitation. This is very valid

Oracle BI EE 10.1.3.4.1 – Drills without Automatic Filters – Discoverer Style Drills – Repository Design

One of the questions that i was asked recently is a means for doing discoverer style reporting in BI EE. As you might probably know, one of the major drawbacks of BI EE (atleast untill 11g comes out) is the fact that during drills we lose the information about other

Oracle BI EE 10.1.3.4.1 – Multi Hierarchy reporting – Shared Parents and Shared Childs - IndexCol

In the last blog entry, i had shown an approach using fragmentation to model multiple hierarchies having common and uncommon parents. Though it can be used in most cases, it has certain drawbacks atleast as of the 10.1.3.4.1 release. One of the main drawbacks is the

Oracle BI EE 10.1.3.4.1 – Multi Hierarchy reporting – Shared Parents and Shared Children - Fragmentation

One of the drawbacks of BI EE as of the 10.1.3.4.1 release, is the fact that one cannot do multi hierarchy reporting wherein parents and the Children are the same across hierarchies. For example, lets take a use case below If you look at the above

Technical

Hyperion Planning 11.1.1.2 – New Smart view OracleSV protocol – Integration into smart view and other desktop applications – Part 1

In the last few blog entries, i have been covering some of the new features of the EPM 11 release. Continuing on the same line, lets look at another new feature that was introduced for integrating smart view with Hyperion Planning. The most common way of integrating multiple web based

Technical

Hyperion Essbase 11.1.1.2 – XOLAP – MDX to SQL Conversion – Part 1

One of the interesting aspects of XOLAP is the fact that it exposes Essbase as a dynamic relational aggregation engine. XOLAP to an extent is pretty good in determining what kind of sql should be pushed back to the relational sources and what requires custom in-memory calculations. For example, lets

Technical

Hyperion Essbase 11.1.1.2 – XOLAP – Reporting on Relational and Essbase sources together – Transparent Partitions

In the last 2 blog entries, i had covered 2 new features of EPM 11 Essbase. They were Format Strings [https://www.rittmanmead.com/blog/2009/06/26/hyperion-essbase-11112-altering-measure-formats-format-strings-and-text-measures/] and Varying Attributes [https://www.rittmanmead.com/blog/2009/06/29/hyperion-essbase-11112-varying-attributes/]. In today’s blog entry we shall see another

Technical

Hyperion Essbase 11.1.1.2 – Varying Attributes

Another excellent feature that was introduced as part of the EPM 11 release was the support for varying attributes. Varying attributes help in providing different perspectives of multiple attributes of a dimension over time. One can visualize this as SCD 2 in a relational world. For example, lets take the

Technical

Hyperion Essbase 11.1.1.2 – Altering Measure Formats – Format Strings and Text Measures

If you had read my blog entry here [http://oraclebizint.wordpress.com/2008/12/10/hyperion-essbase-1111-handling-textual-facts-text-list-manager-and-text-measures/] , i would have shown how to go about creating textual measures in Essbase. Though that was a new feature introduced as part of the EPM 11 release, one related feature that i did not

Technical

Visualizing relational data as Essbase/OLAP cubes – Partition Outer Joins and MODEL Clauses – Part 3

In a prior blog entry here [http://oraclebizint.wordpress.com/2009/05/16/oracle-bi-ee-10-1-3-4-1-%e2%80%93-report-sum-and-pivot-calculations-%e2%80%93-an-alternative-sql-on-oracle-10g-and-above-%e2%80%93-equivalence-to-mdx-%e2%80%93-model-clause-%e2%80%93-part-2/] , i had shown the advantages of using the MODEL clause. I also showed how the MODEL clause can be used to

Technical

Oracle BI EE – Bulk Write backs to Essbase – Using JAPI, Global Temporary Tables and UTL_HTTP – Part 2

I had covered an approach here [http://oraclebizint.wordpress.com/2009/05/25/oracle-bi-ee-10-1-3-4-1-writebacks-to-essbase-using-japi-and-custom-html-part-1/] to do write backs into Essbase from BI EE. In some cases that approach would be sufficient. But in most of the cases, end users would want the capability to do a bulk write back similar

My First Post here - Joining Rittman Mead

As you might have read from Mark’s post here [https://www.rittmanmead.com/blog/2009/06/22/breaking-news-venkat-joining-rittman-mead/], i now have officially joined Rittman Mead. And this is the big news that i had alluded to in my blog post last week here [http://oraclebizint.wordpress.com/2009/06/