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
Discoverer 11g Now Available for Download Blink and you may have missed it, but the 11g release of Discoverer is now available for download as part of Oracle Fusion Middleware 11g [http://www.oracle.com/products/middleware/index.html]. Now back in the old days, a major new release of Discoverer such as this would have
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 An Update on Rittman Mead Things have been pretty busy for us at Rittman Mead over the last six months, and so I thought it'd be a good opportunity to bring everyone up to speed as to where we are. Rittman Mead now has two offices, one in the UK run by Jon
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 Hybrid SCDs using OWB and OBIEE If you attended my ODTUG Kaleidoscope presentation on Oracle Warehouse Builder (feel free to view the presentation [http://www.rittmanmead.com/files/odtug_owb_considerations.pdf]), then you know that certain aspects of the product leave me scratching my head, especially as a follower of the dimensional modeling approach popularized
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
Memories of Monterey Well we're back now from two weeks in the States, the first week of which was vacation in San Francisco and Yosemite, the last was at ODTUG Kaleidoscope 2009 [http://www.odtugkaleidoscope.com] in Monterey. Well done to the ODTUG team and to the Oracle ACE program for
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
UKOUG Conference Series Hyperion & BI 2009 Whilst Mark, Stewart are Joe are enjoying Monterery, I am on the train going up to London to meet Borkur to do a joint presentation entitledHigh Availability in Oracle BI EE [http://hyperion.ukoug.org/default.asp?p=3078&dlgact=shwprs&prs_prsid=3464&day_dayid=28]
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/
Breaking News - Venkat Joining Rittman Mead Well this year has certainly seen some interesting and exciting developments for Rittman Mead. Earlier in the year we launched Rittman Mead in America [http://www.rittmanmead.com/america/], along with our colleagues Joe Leva and Stewart Bryson; shortly after that Adrian Ward and the team from Majendi joined us
Gearing up for ODTUG Currently, I'm flying toward Los Angeles for my connecting flight to Monterey, and with internet access (thanks Gogo [http://www.gogoinflight.com/]) and nothing but time, I decided to have a look at the technical sessions [http://www.technicalconferencesolutions.com/pls/caat/caat_abstract_reports.schedule?conference_id=
Getting Ready for ODTUG Kaleidoscope 2009 I'm currently sitting in the Hyatt lobby at 6am, with the family fast asleep back in their hotel rooms and myself getting ready for ODTUG Kaleidoscope 2009 [http://www.odtugkaleidoscope.com]. This I brought the family over and we took a week out before the conference to visit
Technical Cardinality of Rowsources One of the things I sometimes come across when looking at legacy ETL code for data loading is the misuse of query hints to "improve" data load performance. Sometimes DBAs or developers do not remember that "tuning the select" may not be the same thing as
Technical Materialized View and Partitioning "Gotchas", Part II If you follow the blog, then you know that Mark recently posted about materialized views for aggregation, located here. [https://www.rittmanmead.com/blog/2009/04/18/materialized-view-and-partitioning-gotchas/] One of the issues he encountered was how to refresh materialized views based on tables loaded with partition exchanges... a common approach
Technical OBI-ForumLive, and Gerard Braat on the BI Server and BI Apps I'm currently waiting in the departures lounge at Amsterdam Schiphol Airport, coming back from Utrecht after speaking at OBI-ForumLive [http://www.obi-forumlive.nl/], an OBIEE experts event organized by Ciber and Scamander in the Netherlands. Thanks to Rene and John from Ciber for inviting me over, and this
Technical Fun and Games with OBIEE Connection Pools and Essbase Logins When you bring in an Essbase database into the Oracle BI EE 10.1.3.4 and higher semantic model, you typically import it using the "admin" Essbase user ID. This is a standard account that comes with the default installation of Essbase and provides full access to
Troubleshooting OBIEE : Connectivity and Server Issues So if you're administering OBIEE and you're looking out for connectivity issues, what's the sort of thing that can go wrong? From where I'm standing, the major things to look out for include: * The Presentation Server going down * The Presentation Server being
Troubleshooting OBIEE : Diagnostic Files I'm over in Singapore at the moment, and the client I'm working with is looking for some help with troubleshooting Oracle BI EE installations. This is an interesting area because as developers, we generally focus on building new applications rather than supporting existing ones, but if
Technical Dynamic SQL One of my pet hates is the inappropriate use of dynamic SQL within ETL processes, for example building a command as VARCHAR2 string then using it in an "execute immediate" statement. Putting commands into strings whether hard-coded ones within the package or procedure, retrieved from some 'code&
