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&
Arrived in Singapore Well I've just arrived in Singapore, the view below is the view from my hotel room across the Singapore Marina. Flying in, down from the tip of Malaysia and across Singapore, you certainly get a feeling for where all the world's industry, shipping and so on
UKOUG BI & Hyperion Conference 2009 Just a short note to mention that the UKOUG are running a BI and Hyperion conference [http://www.oug.org/hyperion] at Twickenham Stadium on the 24th and 25th June. Part of the UKOUG Conference Series, this event brings together the worlds of BI and Hyperion and is in addition
The Rittman Mead BI Forum 2009, Brighton Well it's now the Sunday after the BI Forum, and it's time to take a look back at how the first ever expert-level BI Forum in Brighton went. We had fifty attendees from around the world, all of whom were at advanced level in Oracle BI
BI Forum Day 2 I'm sitting in the BI Forum on day two of the event, Antony Heljula is delivering a very good session on Oracle BI EE and Web Services. This is a particular area of interest for me as I worked on an article for OTN on this area; in
BI Forum Day 1 I'm sitting in the back row of the BI Forum in Brighton [http://www.rittmanmead.com/rittman-mead-bi-forum-brighton-may-14th-15th-2009/], the coming-together of Oracle BI, Essbase and ODI experts that we've organized in Brighton. The event started last night with a drinks reception in the hotel, after downing a
The Day Before the BI Forum Well, it's the night before the start of the BI Forum in Brighton [http://www.rittmanmead.com/rittman-mead-bi-forum-brighton-may-14th-15th-2009/], tomorrow the delegates start arriving and we begin with a drinks reception at 6pm. All the presentations are in, the speakers are ready for their sessions and the people who
