Commonly Used VLDB Properties

In this post I am going to discuss the most important and commonly used VLDB properties available in Microstrategy.

Before going into details let's first understand what VLDB properties are exactly. The name stands for Very Large Database properties. But don't take the name very seriously because VLDB properties can do lot of things irrespective of database size. Basically these are settings to tweak and fine tune the behavior of Microstrategy. It can control how different engines will work, can do database specific settings to improve performance.


Analytical Engine :

1. Display NULL on Top : This property determines where NULL values are displayed when data is sorted.  

        Possible Values: - Display Null Values in bottom while sorting

                                     - Display Null Values on top while sorting

         It can be set at Project, Report, Template level

         Default Value: - Display NULL values on top while sorting.

    2. Evaluation Ordering : Determines the order in which Analytical Engine                   performs different kinds of calculations.

         Possible Values: - 6.x evaluation order
                                    - 7.x evaluation order

         It can be set at Project, Report, Template level

         Default Value: - 6.x evaluation order.

    3.  Null checking for Analytical Engine : Determines whether or not NULL is            interpreted as the number 0 when the Analytical Engine does calculations.

         Possible Values: - True

                                    - False

         It can be set at Project, Report, Template, Metric level

         Default Value: - True

   4.  Subtotal Dimensionality Aware : Determines if subtotals are dimensionality         aware or not.

         Possible Values: - True

                                    - False

         It can be set at Project, Report, Template, Metric level

         Default Value: - True

Governing :

    5. Intermediate Row limit : Controls the maximum number of rows returned to the Intelligence Server for an intermediate pass.

        Possible Values: User Defined. 

                                   0 = no limit on number of rows returned

         It can be set at Report level

         Default Value: -1

To be continued ..