Skip to content

Category Archives: essbase

Cognos BI OLAP querying

Sometimes it’s best to be late with fulfilling promises. Was I to write this post a month earlier, I wouldn’t be able to give people using Cognos BI with Microsoft Analysis Services and Oracle Essbase a life-saving advice. At least, the advice that I’d be really grateful a couple of years ago.   A month [...]

Posted 19 August 2011 † ykud § bi § cognos ‡ Comments (0) °

Oracle Essbase and Oracle BI 11

Just in case you missed it — read this two posts by Mark Rittman (OBIEE 11g for Hyperion Users – Are We There Yet?, Incremental Essbase Metadata Imports Now Possible with OBIEE 11g) on the oh-so painful topic of Essbase-BI integration. I participated in some projects with this combination a couple of  years ago (when [...]

Posted 23 June 2011 † ykud § oracle ‡ Comments (1) °

Essbase ODBC configuration on Solaris

Using this blog as offline memory. Just ignore this post, if you’re not up to Essbase ) If you’re configuring DataDirect ODBC drivers on *nix system, be aware of following: There are 2 versions of odbc.ini file, one in 32bit driver folder, other in 64. 64 essbase uses 64 drivers. You should copy required odbc.ini [...]

Posted 19 July 2010 † ykud § ‡ Comments (0) ° Tagged: ,

Oracle BI Enterprise Edition vs Cognos BI

Since I’ve spent some time working with Oracle Business Intelligence last year, I think I’d write a simple comparison list of strengths\weaknesess of OraBI EE vs Cognos (see post on the same topic by Venkatakrishnan). All of this is imho, of course. Oracle BI EE Pro’s: 1) Aggregate navigation – ability to set up aggregate [...]

Posted 01 February 2010 † ykud § bi § cognos § ibm § oracle ‡ Comments (3) °

Essbase ASO key structure

Yet another post on Essbase ) Internal ASO storage structure is a block box, so unlike BSO. So while Roske haven’t writen a book on ASO option, we have to wonder in the dark.  The main description of ASO storage is “data is stored as key\value pairs”. This quote comes from ASO Tuning WhitePaper, the [...]

Posted 17 April 2009 † ykud § ‡ Comments (0) ° Tagged: ,

Loading data into ASO cube

Hm, I guess it’s the time for a first big essbase-related post. Today we’ll talk about data loading in ASO cube. Those who’ve listened to our recent Oracle events presentations (russian TechForum 2008, BI Forum 2009), know that we’ve made a nice PoC project with SportMaster, consisting of loading their year’s worth of daily stock [...]

Posted 02 April 2009 † ykud § ‡ Comments (0) ° Tagged: , ,