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 [...]
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 [...]
¶
Posted 10 February 2011
† ykud
§
‡
°
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 [...]
¶
Posted 18 January 2011
† ykud
§
‡
°
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 [...]
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 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 [...]
“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 [...]
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 [...]
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 [...]