Hi Mark.

This is a supported scenario, just need to go over the steps to make sure it's configured properly. While it's correct to say that using a single fixed...

A good example of a non aggregatable measure might be 'Price' on a sales record. It would make no sense to ever add these up or do any other...

First off, you will probably have to build a physical date dimension to hold your unusual fiscal date information, then create your Analysis Services dimension from that. Make sure...

You could do this by getting the records for each office one at a time, and inserting a null record between each set of results. I'd do it with...

Thanks!