This process seems a bit manual. Is there a reason the process, does not go and look for the ispac file itself, or grab sql files from a location.
Also...

Ah, the error is caused by the IIF checking both sides anyway. So if I remove the reference altogether it works!

Getting there...

PB_BI (9/17/2014)

---

You could achieve this if you used an expression in your dataset and returned the appropriate columns based on the parameter. There's more info on an implimentation of that...

The problem is the dataset defines the fields at design time. So if design time query date parameter is the month, it will define 3 fields.

When it runs and the...

Seriously? Duplicate codes galore... maintenance is going to be nightmare.

SSRS is coming across really handicapped when dealing with mdx queries. How did MS manage to accomplish this?

Not only am I...

This is the result within SSRS

This is the query run in SMSS.

The way it works is the user can view a chart in Year, Quarter or Month format.

When they...