Category Archives: 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 | Leave a comment

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 , , | Leave a comment