Is there any limitation on number of dimensions that can be added to a Straight table.

[ektarathi]

Hi all,

I am creating a straight table, which has 40 dimensions and one expression.But as soon as I add 30th dimension to table, the data in table starts shrinking.Like till 29th dimension, i get 50 employees.But as soon as I add 30th dimension, number of employee id's reduces to 16.And this happens irrespective of the dimension that I add(so its not a data issue i suppose).But, when i go and select one of the dropped employee id's(i.e the ones which got dropped after adding 30th dimension), the row with that employee id appears in straight table.Don't know whats going wrong.

Any help would be really appreciated.

Thanks

[phaneendra_kunc]

As far as I know there is no such limit..

I am using more than 50 columns in my chart.

[#3]

ektarathi

I am not sure there is a hard limit, but I can assure you that your performance is going to suffer if you have this many dimensions.  I cannot help but ask why so many in a single table?  What are these dimensions?  Regardless, it should work.  I just tested with +50 and besides lackluster performance, it worked as it should.

So perhaps something with your data, but impossible to say without seeing.

Phaneendra Kunche

More than 50 columns yes, but more than 50 dimensions?

[phaneendra_kunc]

Yes, Just now tried with 43 Dimensions and 5 expressions it is working...

[hic]

I am not sure about the hard limit (probably 255 or more if I know our developers correctly) so that should be no problem.

However, Donald Hutchins' point above is very relevant, A straight table is a hypercube with all the limitations of a hypercube. Too many dimensions will eat your memory and severly affect performance. You should instead

• put the different dimensions in different charts
• put the field as expression ( Only(<Field>) ) instead of as dimension.

HIC

[ektarathi]

Hi all ...thanks for all the help.As suggested by Donald, i had a issue with the expression that I was using, and I changed the expression now,and its working fine.But as suggested by all...performance is getting a huge hit.the table goes out of memory many a times.The reason for having so many dimension is, my client wants to see many fields(coming from many tables in database)in this report together, and be able to download it in a excel.They want to be just able to download it...and they are not looking forward to use it in front end :(:(. I will try and use Henric's idea and see if that improves performance.

[phaneendra_kunc]

I would rather do this same on the script and dump it into excel file...

And share the ftp location wiht your client.