Different intermediate table types that can be used in MicroStrategy are defined below. These can be found in the VLDB properties. Permanent TablePermanent tables are normal tables and are accessible ... read more

Data Mart report is a feature in MicroStrategy which allows a report to insert the results set into a table which can be created  on any relational database. MicroStrategy objects can be built on the ... read more

Application partitioning in MicroStrategy is of two types – Warehouse partitioning and Metadata partitioning. By the name it self, it defines that the partitioning is implemented in Warehouse ... read more

I wanted to list all the metric types we come across in MicroStrategy in my words. Let me start with the word “metric” it self. Metric: To keep it simple, a metric can be defined as a ... read more

Sounds simple, but little tricky Scenario: I have two date fields (two attributes, D1 & D2). The requirement is to build a report with two prompts, one on each of the attributes. The first prompt ... read more

MicroStartegy has many flexible drilling options. Drilling could be done in many directions and in many ways. Below are few that I would like to mention. Report Drilling Drilling from an attribute ... read more