DMR stands for Dimensionally Modelled Relational, a Cognos modelling technique allowing to present relational data sources as OLAP cubes (this meaning adding notion of dimensions with hierarchies and measures with various aggregation rules). All OLAP-style queries, roll-ups\drill-downs are then transformed into appropriate sql (group by’s, aggregations) by Cognos Server. It’s not a Cognos-only idea, see [...]
One more DIY article. This time we’ll talk about… You have more than a dozen Power Cubes (20?50?100?)? And since you can use only 2 CPUs per cube on Windows platform and “update-windows” are only narrowing, you have a couple servers (3?5?)? And so you get the task of carefully splitting cube creation tasks on [...]
Scrapped it out from my answer on cognos communities, maybe it’ll help someone. Drill-through is really to tough to debug. Prior to 8.3 I’ve used following routine: 1) Set the target report filter to optional 2) Add 2 new text item to target report, and change them to ReportExpressions of ParamDisplayValue (?param?) and ParamValue(?param?) This [...]
I’ve nicked the term “Multi-Line” model out from some cognos best practices presentations. Never known it was called that way ) Multi-Line is only way to go when you have a potentially huge dimension only a tiny bit of which should be available to end-user at a time. Like employee planning, whole dimension of 10k [...]
I’m more than just emotional right now since I’ve finally got that bugger of my neck. To those who’re interested in getting trend calculated in oracle — press page-down once. Trend line calculation in Cognos. It’s 2008 as my desktop calendar says and it’s “Targeted information to a broader range of users ” on top [...]
Since I’ve got a couple of questions considering how to do it, I’ll get in more details on setting up Event Manager to detect application changes. See original post, and mind the second PS, especially. Some background: datadatetime column in nodestate table of application database is changed when user saves data, so we want to [...]
New Supportlink‘s article on EP+BI led me to my 2cents on EP + BI integration topic: Carefully select dimension for publish. – Its elements will become columns in published table, so if you want database only processing, you’d be able to preform complex calculations (mean, percentile, variance) only on those columns. By adding local processing [...]
Nice overview and details. I’d only seen cubegeek posting Hyperion-related stuff.
Well, I’m last to notice — they’ve brought all hyperion apps on edelivery.oracle.com Started unwrapping this mid-summer present today. It took me quite a time to get to Hyperion Planning LogOn screen, I must admit. This is no Analyst out-of-box experience, this is serious software with lots of ports&services stuff ) And AIX 64 capable [...]
I’ve tried to pass Cognos BI Modeler exam this weekend and failed. That leaves me rather disappointed and anxious for another try. Some notes and comparison with EP certification:- BI Modeler is way faster (~110 questions in 2,5 hours vs ~135 in 3,5 for EP)- BI Modeler is problem oriented (most questions consider sql\modeling problems, [...]