MDX Query: Two sets specified in the EXCEPT function have different dimensionality

[Shreekant Jadon]

Hi Team,

I am using Syncfusion Tools for OLAP Reports.

In the reports we are fetching data from the cubes in witch we are getting below exception.

Query (1, 8430) Two sets specified in the EXCEPT function have different dimensionality.

Query (1, 4829) Two sets specified in the EXCEPT function have different dimensionality.

Could you please have a look into the issue and let us know what actually we need to do.

Hoping a gentle reply from you.

Thanks

Shreeaknt

[Prabu S]

Hi Shreekant,

Thank you for using Syncfusion products.

We would very much appreciate if you could provide us a “MDX Query” or OLAP reports reproducing the reported problem. This will help us investigate further.

Please let us know if you have any concerns.

Thanks,

Alagarsamy D

[Shreekant Jadon]

Hi Alagarsamy,

Thanks For your reply.

I checked my code but I didn't find the MDX Query. I debug the code, ran QSL Profiler and try every possible way that I know but not able to get MDX Query.

Could you please give me some hint where I need to look for this. I mean like page load and other events.

I help would be much appreciated.

Thanks

Shreekant  

[Alagarsamy D]

Hi Shreekant,

Thanks for the update.

Please use the below KB article link for achieving your requirement.

KB Link:

http://www.syncfusion.com/kb/3143/how-to-read-and-alter-the-mdx-query-programmattically

Please let us know if you have any concerns.

Thanks,

Alagarsamy D.