|
Hi, I'm trying to ask to a cube on SQL Server 2008 with a huge mdx query. This query contains more than 20 calculated members (defined on the query). Each member contains a restriction for a dimension on the cube. Not always need all dimensions, but sometimes it is needed. Well, it works fine until 16 members. With more than 16 members a message error appears: "Query Optimizer generated too many subcubes in the query plan". Is there any way to solve this error? Thanks! Julieta |
