Finally got a chance to try essbase out on real data volumes. Building half-a-billion facts cube turned out into something like this: PS: I have very special attitude to David Lynch’s films. A physical one. Just the sight of road running away at “Lost Highway” makes me creepy. It takes me about 5 seconds to [...]
I’ve made this simple web-based closed cube drawing tool to explain what closed cubes are and how they’re good in removing redundant aggregates from storage. I’ve wrote this for myself initially to get better insights on different aggregate situations and thought somebody might get interested as well. Go check it out, if you’re interested in [...]
New digest: 1 This blog changed hosting once more. Now it’s ultra speed webfaction instead of Yahoo. Speed, ssh, svn are main switch reasons 2 I’ve started a more light-weighted blog in russian ykud.ru (who’d guess). 3 And I’m thinking about this blog’s future. I’ve got only one post laying in drafts (it’s called “Testing [...]
Finished Analytics&OLAP in SQL by Joe Celko today. A very “blog-style” book, some very good ideas, some repeats (read “Trees&Hierarchies in SQL” previously), sarcasm and a set of good examples. Not a starter-book, but a recommended reading for anyone interested in data analysis. “Tape-based” approach and Von Neumann logic still dominate IT. SQL is bad [...]
on DMR’s pros and cons
on DMR’s pros and cons on DMR’s pros and cons
on DMR’s pros and cons on Macro functions and prompts in Cognos BI reports