Hi to all,
I am interested if anyone has detailed (and maybe tested) experiences related to my question:
The situation:
- I am having an application which needs to display table-diagramms with many, many columns and rows (sometimes over 50.000 rows)
- so performance is the big issue
- for most of the table diagramms we are showing several dimensions (e.g. product-group, product-sub-group, product-id, product-name)
So my question:
- Does using several dimension columns SIGNIFICANTLY slow down the calculation-time for table-diagrams?
- Is is better to use "calculated" fields instead (e.g. using product-name as dimension) and just displaying the product-group, etc. as formula?
I am really interested in your answers/experiences!
Best regards
Stefan