I am trying to ask a cube on SQL Server 2008 with a huge mdx query.
This query contains more than 20 calculated members (defined in the query).
Each element contains a constraint for measuring on a cube. All sizes are not always needed, but sometimes it is necessary.
Well, it works fine for up to 16 participants. With more than 16 members, an error message appears: "The query optimizer generated too many subcubes in the query plan."
Is there any way to solve this error?
Thank!
Juliet
user250758
source
share