Category Archives: BI&CPM

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 [...]

BI&DWH Booklist

More time I spend doing BI\DWH projects, I become more aware that such projects a totally a ‘craft‘, as my professor once said. And this ‘craft’ has many different aspects in it, each having a number of of very good texts. telling you all you need to know to avoid simple mistakes and deliver predictable [...]

Gartner BI Quadrant for 2010 is out

It’s an interesting reading indeed. I read vendor sections in these reports with interest, because after some years it’s possible to wipe all vendor-based marketing claims and assumptions made by people (analysts) who aren’t using the products daily and see something resembling “true state”. For example, if you take a statement “QlikTech offers limited metadata [...]


In case you haven’t heard about it yet — “Adaytum team” is back to business. With their new planning solution ) — Anaplan, or “In-Memory Analyst in the clouds”. Take a look at demos and site, especially History page — reminds you anything? My takes: Technology has all needed buzzwords, although I’d prefer some more [...]

Microsoft SQL Server reporting database configuration

A check-list for using Microsoft SQL Server as a reporting database. This is a ‘be aware’ list for myself in first place, since I forget some details as time passes. Table of contents Overall database settings Table configuration ETL Query tuning Books to read Overall database settings Use simple recovery mode Set up simple recovery [...]

Replacing strings in Oracle BI Publisher reports

Oracle BI publisher works awfully bad with Answers type of datasource in at least two points: – column names are created by answers formulas instead of column names, so if you have long formulae, it’ll be shortened to some 128 chars. And if first 128 chars of formulas are identical, you’ll get only one of [...]

Pivot Tables and temp files in Oracle BI EE

Pivot tables Pivot tables are by far most used data view in Oracle BI Answers, since they provide ‘multidimensional’ analysis capabilities, aka dimension drag&drop, filtering and some basic calculations. From server-side view — this component provides worst performance, since all future ‘cube’ data has to loaded into BI server, aggregations and formulas calculated and transformed [...]

BI system metadata impact analysis and what BI system APIs are for

“Okay, this column in our BI metadata was supposed to be named Sales, not Sals. But when we change it, what will happen to the reports that were created, using this name? And how many reports use this column anyway? Maybe we shouldn’t touch anything to keep things working…” Ever been in such situation? This [...]

Multidimensional reporting functions in Cognos and Oracle

As many of you already know I have a mixed attitude to Cognos BI DMRs (dimensionally modeled relational source) models: performance is allways a consideration, full-table scans are unpredictable there’s always ‘local processing’ vs ‘database only and some things not working’ dilemma using multidimensional functions in reports is oh-so-hard to debug when they don’t work in [...]

Connecting BI system to Active Directory. Oracle BI vs IBM Cognos BI. Scripts to extract Active Directory information.

I consider Single Sign-On setup through Active Directory(AD) a key point in every system’s life. Up to this point — it’s just a PoC, a prototype or a department (10-20 users) level application. AD integration step is usually prosponed, because it’s documented somewhere and there are much more important things to do, like showing that [...]