MSIT-MARS MDX Query Returning Tuples Error
When I run a MDX Query I get the following error
The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples.
When the same is MDX Query is restructured (with the exact same dimensions & Measures) this error goes away
Please contact me (firstname.lastname@example.org) if you need any access to our AS database
Upvotes: 0<=-=Jun 18 2008 11:52AM=-=>
Parveza – thanks for reporting this. Looks like this was resolved with a workaround back in SP2. However, I wanted to follow up and let you know that we have moved this to an area we are reviewing for consideration in the next major release of SQL Server.
The Analysis Services Team