Just in case anyone is interested I did find a solution. You have to specify the result set which is new to SQL 2012. The error with the stored procedure...

Thanks mate. This looks awesome. Will give it a go. Many thanks to all!!

Thanks for the advice guys, appreciated. I am thinking SSIS is the way to go as advised. Will let you know how it turns out. Cheers.

Thanks Adam,

Will give it a go. Cheers.

Scott

Hi, haven't heard of any resolution to this. However have not encountered any other problems because of it.

Thank Dan,

Will do some reading and some tuning. Thank you for the info. Cheers.

Scott

Thanks Dan,

Muchly appreciated for this. Out of interest the quesry being run is:

With

Set [SetAxisX] As '{[Measures].[Procedure Count]}'

Set [SetAxisY] As '{{NONEMPTY( {[Patient].[T2 Episode].[T2 Episode].AllMembers}

* {HIERARCHIZE ( [Patient].[Admission Date].[Admission Date].AllMembers...

Sorry about that - my bad.

The original settings in the file were

NamedSetShallowExistsMode

AxisSetShallowExistsMode

- both were set to 0 and we changed both to 1

and restarted the SSAS service for it...

Many Thanks Deepak, that answers my questions. Thanks mate.

Thanks Pete,

I checked with the users and apparently none of the measures in the query are calculated measures. I have tried a few things with the non_empty_behavior property but unsuccessfully....