Archives
DeltaMaster clicks!
February 2009
Trick of the month:
Hierarchical relationships
between measures
Archives
Missed a number? Here are the past issues.
Current issue
DeltaMaster clicks! 07/2010:
Comparing relative changes
with logarithmic scales
Download
The February 2009
DeltaMaster clicks! as PDF
Subscribe
Get your clicks! delivered every month
About DeltaMaster
More about our software suite for Analysis, Planning and Reporting
February 2009
Greetings, fellow data analysts!
There are certain words in a foreign language that are just difficult to translate. The German word "schadenfreude," for example, simply has no punchy English equivalent. Most people, therefore, prefer to use the original term instead of paraphrasing it into the "pleasure taken from observing the misery of others".
In an artificial language such as MDX - the standard query language for OLAP databases - that can be a bit more challenging. Defining a measure like production costs (for the sake of simplicity, the sum of labor and material costs) is relatively easy in English. In MDX, however, you have to formulate that in a very roundabout expression. The reason is that MDX doesn't understand hierarchies in measures.
That's where DeltaMaster comes to the rescue! In this case, you can still create the desired hierarchies with just a few clicks of a mouse. We'll show you how in this edition of clicks!.
Best regards,
Your Bissantz & Company team
Download the full February 2009 DeltaMaster clicks! in PDF format