hi I'am new to microstrategy.i would like to know some information about report optimization.
if the report is taking too long,what are the steps i got do?
is ther any specific things i got to do before going to vldb properties?
1) go to SQL view of the report and check to see if you have any cross joins.
2) Try running the report during off peak hours to see if it still errors.
3) Take the SQL from the report and query your database directly to make sure it's the data retrival that is causing the issue. If the SQL takes faster to execute against the DB directly then it's your Analytical Engine that might be causing problems.
1) Simple attributes, avoid using consolidations or custom groups because they cause multi pass sql sentences and will take up to 3 or 4 times more than the expected
2) Simple Metrics: avoid use metrics with filters in its definition. Each metric with filter in it will generate a diferrent sql pass, is better to use the cross-tab option when you can.
3) When designing a report remember that size of the report is multiply by the number of elements an attribute has that is located on the page-by section, try eliminate o reduce it using filters or prompts.
4) View the Sql to see what fact tables the report is reading an consider maybe generat and aggregate fact table to a higher level so report runs faster.
5) Talk to DBA to see the possibility to generate Partitions over the fact tables you are working.
6) Talk to the final user and try to understand what he is looking for, if the report is generating more than 10,000 lines consider redesigning it (to many information to analyze)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.