How to get a list of all Disabled Users?

There are 3 ways to get a list of all Disabled users in the system

What is the purpose of Multi-Pass SQL?

The MicroStrategy SQL Engine uses multiple SQL passes i.e. SELECT statements to retrieve report results from the data warehouse. This enables the users to create more complex reports, and have more flexibility in answering business questions on the reports.

Data Mining, Statistics & Machine Learning

Microstrategy has integrated Data mining into its mainstream BI platform. Using this technology, users are just not limited to historical analysis but also have access to predictive analysis of their data, thereby empowering the decision makers to make more insightful decisions for their businesses.

Data Mining is extracting of useful information from data using any means such as statistical analysis, modeling techniques, machine learning or database technologies.

Report Caches Memory Capacity Planning

Report caches are first created in memory within Intelligence Server. They are later backed up to disk and reloaded into memory when accessed. If Intelligence Server memory is insufficient to hold all new requested report caches, the least recently used caches are unloaded automatically from memory to make space for the new caches.

Object Caches Overview and Best Practices

An object cache is a recently used object definition stored in the memory of Desktop and Intelligence Server. You can create object caches for both application objects (project, report, document, etc) and schema objects (facts, attributes,etc).

Element Caches Overview and Best Practices

An element cache is a recently used attribute element list stored in memory for faster retrieval. When it hits a cache, a request for attribute elements runs against Intelligence Server memory instead of issuing a SQL statement against the database, thereby reducing response times significantly. Between 25% and 30% of all queries issued against the database in a typical BI implementation are element queries. This means that performance gains on element browsing will have a significant impact on overall system performance.

Document Caches Overview and Best Practices

Document caches are created at run time or on a schedule and behave in a manner similar to report caches. At run time, document caches are created only in MicroStrategy Web. When you execute a prompted document in MicroStrategy Web, an XML document cache is generated. When you reprompt the document, a new XML cache is generated with the data reflecting new prompt answers.