Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

chinmay7
New Contributor

Hypercube are too large error

Hi,

I am having one table chart in my dashboard and it contains multiple fields.but there is a one field called payload which contains xml value in the field and while exporting the same report in excel we are getting error saying that "Hypercubes are too large"

Kindly help me to resolve this.

5 Replies
mindaugas2048
New Contributor III

Re: Hypercube are too large error

The same issue happens when exporting table data (v 3.2 SR5):

export_failed.png

eduardo_dimperi
Valued Contributor II

Re: Hypercube are too large error

how many rows have this export?

mindaugas2048
New Contributor III

Re: Hypercube are too large error

In my case - 73000 rows and 24 columns. QlikView (November 2017 SR4) exports the same table successfully. Obviously this is a QlikSense issue...

_armoco_
Contributor II

Re: Hypercube are too large error

Hi,

As far as I understand there is a maximum size of 10,000 cells that can be returned from a hypercube.

So if your qWidth = 2,

                qHeight=5000, then that there 2*5000= 10,000 is your limit. Anything other than that will result in the below:

             

Capture.PNG

Maybe this is the issue?

If you need more than that you need to pay to the object for that additional data.(I'm not sure how this part works though)

Regards,

Arjun

eduardo_dimperi
Valued Contributor II

Re: Hypercube are too large error

I believe that problem are to export, no to display. If so, maybe he's trying to export more them maximum rows of Excel are

Community Browser