I hope this one is going to be straight forward and simple.
Taking the existing table-template.js file as an example I am trying to create a simple table extensions object. Everything works fine and I seem to be able to populate my HyperCube but only with up to 10 dimensions or metrics. I reckon this must be due to the defined attribute qWidth: 10, however extending it to more than that does not make any difference. It seems to me that a hypercube can only fetch a maximum of 10. Can someone confirm if this is true?
Furthermore, I thought, adding a second hypercube (based on the same underlying dataset) should solve the problem but here I am running in, to me, unknown areas. How do I properly populate the second hypercube (let's say with columns from 11-20 .e.g) and refer to them?
My requirement in summary: I am trying to display a table extension object with more than 10 dimensions/metrics. How do I approach it?
I appreciate any hints or examples if available.
Solved! Go to Solution.
no you can define more than 10 columns, just extend qWidth (number of columns) and qHeight (number of rows). Note that you will (per data page) not get more than 10.000 cells, so if you have qWidth=10 you can enter a maximum of qHeight=1000
Read more here:
Hope this helps!
I have increased the qWidth to 20 but still there are only the first 10 columns that can display data. The columns from 11, I can add them to the table but the columns do not show any data. How to fix that?
I also believe the number of dimensions is limited to 10.
I changed the inital properties, recreated the chart etc...
Every time I want to add an 11th dimension, I get a specific error message: "The calculation page is too large. Reduce the number of cells and try again.". I also tried reducing the number of rows, but the error remains.
Hi to all, I have fixed this for the following extension: https://github.com/stefanwalther/sense-export
there is a file which is called properties.js
In this file are defined the min and max properties of dimensions and measures. 🙂
By default they are 0-10 , so you can change them to whatever you like.
I am testing this with the following properties
dimensions: min-0 max-25
And its working fine 😉 I just exported over 25 measures with 11 dimensions 🙂
BR, Angel Tomov