Essbase Error (10200638): Internal Error

[#1]

Hi,

I can pull data into Qlik using the Essbase connector, but it seems that if I choose too large of an intersection, it bombs out with the following error. Are there known limitations when pulling data via the Qlik Essbase Connector?

Essbase Error (10200638): Internal Error: Query output is too large to be executed. Query Result exceeds 2^32 cells.

I have set the following in the Essbase config:

SSPROCROWLIMIT 1000000

Obviously I am just asking for too much data, but how much is too much? I am pretty sure that what I am calling for is no where near 4.3 Billion cells. Is it possible that because I am choosing "Entity" (for a hierarchy tree) that is re-pulls data for alternate hierarchies with the same base entities?

Any information you can provide is appreciated!

[Chanty4u]

chk

http://qonnections.geoqlik.com/GeoQlik/proxy/QvAjaxZfc/opendoc.htm?document=2%20-%20FEMA%20Disaster%...

[#3]

Not sure how that applies to my problem, but thanks for a reply anyway