GeoAnalytics: map extension error: "The results of the hytpercube are too large"
Article Number: 000040013 | Last Modified: 2018/09/07
Description
Map extension gets data from Qlik Sense in a way that is different from other charts. In other charts only a portions of the data is requested and shown on the screen, if the overall data amount is bigger than a threashold. This is so called paging in those charts. But in the Map extension, there is no paging and it will try to get and show all the data in one attampt.
If the data in the areas is too big, e.g. too many polygons, it is possible that it exceedes the maximum limit of the HyperCube for Engine, which is around 200,000,000. Then the error message will appear.
Cause
The limit of the HyperCube from Engine.
Resolution
There are several things can be considered to make optimization:
1. Reduce the density from the geometric data file so that the precision level is adjusted according to the need. 2. Or using the Simplify operation in the GeoAnalytics Connector to lower the details. 3. In the object level, aggregate the data using the cluster, binning or within function so that not all the objects are shown at the same time. 4. Or set a limit on the layer under 'Layer Options'->'Calculation Conditions'. Thereby only showing things on the map if they have a smaller selection than a certain limit.
Get Answers
Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.