Applied Dimensionality

Recent posts

Feb 1, 2008
Ways of calculating Running Count to import data into Multi-Line models

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 people, strictly less than a 100 in department. So you create a fake dimension of 1..100 and add an Employee name column, decreasing cube volume by 100. Access tables + cut-down might help, but it’s sometimes better to allow people pick up any employee,client, product given up that there won’t be more than fixed number of rows.

Jan 25, 2008
Calculating trend lines in Cognos Report Studio and Oracle SQL

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.