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 Disk and Memory RAM of your Intelligence Server machine.
The idea is pretty simple:
Create a single report to be used in more than one document.
For example, if you have to bring: category and subcategory in one report and region and city in another one, you can create 1 report that contains all of those attributes and use this report for a dashboard that contains region and city and another one that contains category and subcategory.
So, always think about creating 1 report to cover more dashboards instead of creating one report for each document.
Hope it helps.
God bless you!