Hi,
When using a query in APD I get an error
<b>MDX result contains too many cells (more than 1 million)</b>
Message no. BRAINOLAPAPI121
This is a system limit it seems. I didn't find any OSS note saying it is a bug 😊
My query is bound to return more than a million cells - there is no further filtering I can add (unless I want to run 100s of queries) to reduce the no of records/cells returned by the query. I am taking this to another cube after putting it into a txnl ODS.
I tried the 'advanced setting' for the query in the APD - specifying a partitioning char, but it had no effect (or at least none I could see).
Q1 - My understanding is RSCRM_BAPI uses similar MDX (from the query), so should I be expecting the same error there as well?
Q2 - The query is based on a non-cumulative cube. Would an infospoke work correctly (calculate the stock balances before pushing it out) - or will it bring the changes only? My assumption is the infospoke won't get me the balances correctly.
Q3 - Anybody has any workaround for this limit?
Thanks,