Report Performance Tips

Hello there, I was searching for report performance and I found a nice post in this url: https://community.microstrategy.com/t5/Reporting-Dashboards-and/Report-Performance-Tips-and-Tricks/m-p/278300#M11431 The user Omar V wrote some tips to help improving the report performance that you should try and see if those VLDB settings works for you. Hope it helps! God bless you

Parallel Query Execution

Hello there! There is a excellent vldb option to execute in parallel independent sql passes.So. if you have more than one pass in your SQL and those aren't dependent, you can instruct Microstrategy to execute them separately. Microstrategy will open DB connections to execute those SQLs. Example: You have a query with some passes like: Pass1  Pass2   Pass3   …

Removing Auto Apply changes in Page-by

Hello there! Today I'm going to show you how to remove the auto apply changes made in a Page-by in a report for Web. When you put an attribute in a page-by section of your report, and changes to a different element, it will automatically apply that change. To change that behavior inserting an apply button, you …

Performance in Reports (Part III)

Hello there! Today I'm going to talk about a simple technique to reduce the amount of cache used in your project. As you may know, Microstrategy is able to cache the reports to run it much faster than normal. It's stored in memory ram and disk. So, it reduces the amount of space of your Hard …

Performance in Reports (Part II)

Hello there! Today I'm going to talk about the second part of the series "Performance in Reports". If you would like to read the first part just click on this link "Report Performance (Part I)". I believe that nowadays I always see the query that Microstrategy creates when creating a new report. It recommend you to do so. Sometimes …