Qlik Sense Straight Table Export Data

sergio_loza — Tue, 05 Mar 2019 20:36:05 GMT

Hi Folks, looking for a any help/clarification to an issue we have been facing:

In February 2018 p2

I have a straight Table with 500,000 rows with 1 dimension and 6 Measures Which I wish to export using Right-click Export Data Feature.

I am presented with a "Hypercube is too large " error

I am using the Only function which allows me to create a measure of what other wise is a dimension. The one dimension I have is unique.

Alternatively, I have a straight table with 500,000 rows with 8 Dimensions

This File downloads fine.

I took a look at the document below which Qlik help documentation references as far as limitations.

https://help.qlik.com/en-US/sense-developer/february2018/apis/EngineAPI/services-GenericObject-ExportData.html

Unfortunately I don't seem to be able to make sense of the numbers.

Does anyone know how are the dimension of a straight table hypercube constructed?

or how to get the Hypercube size?

Re: Qlik Sense Straight Table Export Data

sergio_loza — Wed, 06 Mar 2019 23:16:33 GMT

FYI, I found that there was a fix for this in November 2018.

Export of complex data causes “hypercube results too large” error message Jira issue ID: QLIK-89542 Description: Large Excel export with many columns and rows fails. Export should now handle up the Excel maximum regardless of the data size

i'd still want to know more about how the straight table hypercubes are just to have that in mind .

topic Qlik Sense Straight Table Export Data in App Development

Qlik Sense Straight Table Export Data

Re: Qlik Sense Straight Table Export Data