Can any one please help me on how to increase the straight table performance to load quickly.
In Straight Table i have total 17 Dimensions and 1 expression with 1523 rows.
I have moved the calculated dimensions to back end script and called direct fields in the straight table but still there is 5 secs lag.
Once thing i didn't understand is when i have opened the app for the first time i am facing this lag after that when i have opened the app again not finding this lag.
Please let me know is there any other ways to increase the performance.
if you use any key field in table,you can remove the key field that will slowdown your table.
load only 2 years of data instead of load 6 years of data (limit your data).
user first need to perform some selection then only straight table data will be visible. This is the best way to do overcome this issue as you are filtering the table data before the table data presented to the user.
Avoid calculated dimension if you are using it. do the all calculation to script itself.
