Report Portal

Adventures in context with MDX

One of the key concepts in MDX is context - that a calculation's results are affected by the slicers that are applied to the portion of the cube the calculation works with. Today I had some fun with getting the context right in a query through subcubes and where clauses, so here's some useful lessons. Note the below examples run against the "Internet Operation" cube of the AdventureWorks tabular model.

Read more...

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.