How to do performance tuning on reports?
Submitted by: AdministratorFor performance tuning there some areas where you need to look and work accordingly.
like
1) is there sufficient space so that MSTR can create temporary tables.
2)proper filtering condition.
3)proper joining between required tables.
4) VLDB property
5)optimization (manual, logical and global)
its better if go go in the same order....
Submitted by: Administrator
like
1) is there sufficient space so that MSTR can create temporary tables.
2)proper filtering condition.
3)proper joining between required tables.
4) VLDB property
5)optimization (manual, logical and global)
its better if go go in the same order....
Submitted by: Administrator
Read Online Micro Strategy Job Interview Questions And Answers
Top Micro Strategy Questions
☺ | what is the difference between documents and dashboards in mstr? |
☺ | How to use consolidations in microstrategy report? |
☺ | What are the roles & responsibilities of microstrategy developer? |
☺ | Is it possible to see the data in dataset? |
☺ | Difference between standard, absolute and ignore condition in metrics? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |