Feb 11, 2008
Incremental Administration Links
In 8.2 we’ve got incremental publishing, allowing us to create real-time reporting on contributor data and that sets up new frontier in model data transfer speed. Now the slowest part of models are administration links (who’d guessed that when 7.
Feb 6, 2008
SQL worst practices
If anything you do is somehow related to databases, you absolutely, definitely have to see these videos:
Part 1:http://www.youtube.com/watch?v=40Lnoyv-sXg
Part 2: http://www.youtube.com/watch?v=GbZgnAINjUw
Part 3: http://www.youtube.com/watch?v=y70FmugnhPU
Go the links from Tom Kyte’s blog.
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.
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.