Category Archives: MDX

MDX

YTD Calculations

Whether you’re creating a report, chart, KPI, or calculated measure, at some point you’ll probably need to add year-to-date calculations. It doesn’t matter if you’re using SQL or MDX, the technique to generate the From and To dates for a … Continue reading

Posted in MDX, SQL | Comments Off on YTD Calculations

PPS Filters: Beware of Changing Keys

The other day I thought it would be fun to arbitrarily change the keys for all the members in one of my dimensions.  Actually, there was a legitimate reason but after the fact I realized there was a much better … Continue reading

Posted in MDX, PPS | Tagged , , | Comments Off on PPS Filters: Beware of Changing Keys