OBIEE fetch SAP-BW data - More than 1 million of cells

Question

Hello My Friends,

I've got a problem here I never faced before.

Actually I'm working on an integration of OBIEE and SAP-BW by XMLA (I'm trying with the infrastructure team to change XMLA by a BAPI conector, but nothing at this moment) and I'm facing a curious problem.

When I run MDX queries on SAP-BW (7.04) frequently bellow issue occurs:

MDX result contains many cells. (more than 1 million)

Looking for answers, I saw on SAP Forum that there is a limitation on SAP and so on...

I would like to know if someone know a way to control data fetching on OBIEE?

For example imagine that there are 100.000 rows on a cube X. If I query 20 columns from this cube we have 100.000 X 20 = 2 millions of cells and the problem occurs.

On above situation I'd like to query 500.000 cells (or 25.000 rows), after that more 500.000 and so on. Is it possible?

Thanks a lot

Felipe Idalgo

Felipe_Idalgo · Answer

Hello Cesar,

Thanks for your response.

I found something like that at MOS, anyway thanks a lot for your time and help.

Felipe Idalgo

cesar.advincula.o · Answer

Hello Felipe, Maybe this could be useful for you https://blogs.oracle.com/pa/resource/OBIEE_11G_on_SAP_BW_with_BAPI.pdf

Felipe_Idalgo · Answer

Hi Christian,

Thanks so much for your response.

Felipe