I need to calculate adjusted Revenue based on Total Revenue - Tax - COGS.
But my Tax/COGS are based on Product Types, Partners, etc...
Partner 1 10% 5%
Partner 2 5% 10%
Partner 3 5% 0%
My questions are as follow:
1. Is this kind of calculation best done in MDX or TSQL?
I have about 280K rows per month, and 28 calculations per row (e.g. c= a x b is 1 calculation, then d = c * 0.1 is another), so about 8 Million calculations. It's done using Excel 2010 currently.
2. How do I deal with zero or empty cell, will MDX speed up the performance?
3. How do I do this kind of calculation in MDX? I don't know how to setup
with Calculated Measures.
The books I have seen so far shows me easy calculations like [Measures].[Total Sales] - [Measures].[Discount] but each combination of Partner/Product
View Complete Post