Feb 26, 2010
Oracle Data Integrator, Oracle XE and JDBC NLS problems
Since I’ve spent a day sweating through this mess, I’d share my way of getting ODI to work with XE as a repository.
ODI repository creation is sucessfull, but after that Topology Manager and all other ODI modules won’t work, throwing ORA-12705: invalid or unknown NLS parameter value specified while connecting to XE.
Feb 17, 2010
Macro functions and prompts in Cognos BI reports
This post spent a year in drafts ;-( But Macro functions are an interesting feature of Cognos BI and sometimes their usage is unavoidable.
You can use macro functions in Report Studio to do some manipulations with prompt values before they are used for actual processing in filters, report functions, etc.
Feb 1, 2010
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).
Oct 20, 2009
Memory leaking in Cognos 8.3 BI
You know why i’ve started this blog in the first place? To get advice, of course. And today DesiCresnet shared a wonderfull piece of information concerning memory troubles in BI 8.
Aug 6, 2009
Cognos 8 EP troubleshooting import data from package
Tip of the day: Having common metadata layer for BI and Enterprise Planning is really cool, especially with the ability to load data from BI packages to EP via links. Just that it sometimes doesn’t work.
Aug 5, 2009
Cognos 8 BI Tuning Hard Drive Usage
Just a quick hint and a reminder: there is a configuration option forcing Cognos to store temporary report results in memory rather than dropping them on disk. It’s especially usefull for DMR’s they are frequently cached on disk.
May 14, 2009
TM1 + Enterprise Planning, When, Why and How?
This post will be some extracts from a recent PoC, where we made a complex planning system including a rich scenario modeling part. So it was our first big TM1 + EP integration experience.
Apr 17, 2009
Essbase ASO key structure
Yay, 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.
Apr 2, 2009
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 and sales data (around billion fact cells with over a million elements in products dimension).
Mar 31, 2009
Cognos 8 BI Dashboard Studio
Finally got my hands to installing and trying it.
Well, it looks nice, allows flash-based chart formating and turns Cognos portal pages into more dynamic “dashboards”.
But it’s strangely slow (tried on a couple of computers) and all in all looks kinda “alpha” and plugged in at last moment.