I have fact table which is having almost 200 millions of records and almost 12 dimensions joining with with this table. With tables prepared data model and dash board. It is taking long time to open dashboard and charts.
Is there any way to increase the performance of loading records into dash board.
And also how to increase(taking long time to open) the opening time of charts.
Please share any thoughts on this issue.
1.Try to avoid complex expressions in front end.
2)Create a flags in back end and call in front end expressions.
3)which the fileds not required in front end or back end just drop the fileds .
Thanks for responding.
Here I am excluding unused columns and I don't have any long keys. It is simple joins directly with one to one.
My application size is almost 50 gb. Here is the problem
This post may be a few years old but the information in it is still relevant.
Thanks to swuehl for bringing the post to light!
First, I would suggest you don't use "Aggr Function" on UI Level.
Second, try to use N-Tier Architecture (i. Extraction Layer, ii. Transformation Layer, iii. Visualization or Presentation Layer).
Please note, 20 million records are not more to degrade your dashboard performance. I think you are doing all of the things on a same QVW and not dropping tables after use.