GeoAnalytics: map extension error: "The results of the hytpercube are too large"
Article Number: 000040013 | Last Modified: 2018/09/07
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.
The limit of the HyperCube from Engine.
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.