I have a problem with creating a special query in Query Designer. The query has 2 structures, one structure has 100 selections, the second structure has 132 selections. This query is to show 10 years of plan data per period and a detailed account structure. The customer is not willing to reduce the number of rows.
When I try to check the query or execute the query, I get an error message:
Query is too large. Query contains 8192 differing selection cells. However, only 8191 selection cells can be processed in a query.
In fact the query has about 13000 selection cells!
I can not set up the query in a different way by using a drilldown by attribute period or something similar as the query should show actuals to a certain period in a certain year and from that period on the rest of the ten years should show plan data for an entered plan version. The row structure should not show all accounts and nodes of a hierarchy but only certain nodes. Therefore I can not use a hierarchy here.
Please could you tell me if there is a way to exceed the limit of '8192 selection cells' in a query ?
many thanks for your help in advance