Skip to Content
0
Former Member
May 30, 2007 at 03:00 PM

MDX - more than one million cell error

674 Views

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,