Does the order in which you expand dimensions matter in Crystal Analysis?
It seems that sometimes when I expand my dimensions, it takes CA a long time to display the results, but when I collapse the dimensions (or start over after stopping the app.) and expand them in a different order CA responds much more quickly. It seems that when I expand the from the largest dimension to the smallest dimension, I get better performance.
I have not been able to identify a clear rule for this and was wondering if anybody knows one.
As an aside, does anyone know any general rules that will speed up the process of expanding dimensions in CA. When I look at the query log, none of the queries seem to take very long (seconds, not minutes).
Thanks,
Asa Monsey
samonsey@houston.rr.com
Tek Systems, Inc. Consultant
Visual Basic / SQL Server
It seems that sometimes when I expand my dimensions, it takes CA a long time to display the results, but when I collapse the dimensions (or start over after stopping the app.) and expand them in a different order CA responds much more quickly. It seems that when I expand the from the largest dimension to the smallest dimension, I get better performance.
I have not been able to identify a clear rule for this and was wondering if anybody knows one.
As an aside, does anyone know any general rules that will speed up the process of expanding dimensions in CA. When I look at the query log, none of the queries seem to take very long (seconds, not minutes).
Thanks,
Asa Monsey
samonsey@houston.rr.com
Tek Systems, Inc. Consultant
Visual Basic / SQL Server