Microstrategy Analytics

Understanding FROM Clause Order in MicroStrategy How SQL table order can affect execution plans and when to tune it using VLDB settings. Most modern databases optimize joins effectively regardless of table order in the FROM clause. But some engines still produce different execution plans depending on how tables are arranged. MicroStrategy handles this with the From Clause Order VLDB property under Joins . Default Table Order in MicroStrategy Fact Tables Metric Qualification (MQ) Tables Relationship Tables Lookup Tables SQL optimization and join planning concept VLDB Setting View From Clause Order options in MicroStrategy From Clause Order Options 1) Normal FROM clause order (Default) Uses the standard sequence: Fact Tables MQ Tables Relationship Tables Lookup Ta...

Evaluation order of calculations Evaluation order is the order in which objects are calculated by MicroStrategy’s Analytical Engine. Changing the order in which data is calculated can change report results. You change the evaluation order of a report’s data calculation by changing the order in which compound smart metrics, consolidations, derived metrics, derived elements, report limits, and subtotals on the report are calculated. The  default order of calculation is as follows: Compound smart metrics (which are compound metrics with smart totals enabled) Consolidations, which are evaluated by their relative position on the report template: Rows, from left to right Columns, from top to bottom Report limits Subtotals Compound metrics that are not the direct aggregations of other metrics can be used in the evaluation order by setting the  Allow Smart Metrics  option of the Metric Editor to  Yes .

Evaluation Ordering Evaluation Ordering is an advanced property that is hidden by default. For information on how to display this property, see  Viewing and changing advanced VLDB properties . An evaluation order is the order in which the MicroStrategy Analytical Engine performs different kinds of calculations during the data population stage. The Evaluation Ordering property determines the order in which calculations are resolved. MicroStrategy objects that are included in the evaluation order include consolidations, compound smart metrics, report limits, subtotals, derived metrics, and derived elements. Some result data can differ depending on the evaluation order of these objects. • 6.x order - Calculate derived metric/smart compound metric before derived elements/consolidation and all subtotals as smart : This option is used primarily to support backward compatibility. It is recommended in most scenarios to update your project to use the 9.x evaluation order described below. • ...

  The amount of data retrieved and objects being used in a Report Services Dashboard have a direct impact in the size of the final Dashboard. The bigger the Dashboard size the longer it will take to be prepared, be sent to the client, and render.   Client Rendering Once the data reaches the end user's browser window the data has to be formatted according to the definition of the Dashboard as specified in the formatting set by the architect. To do so the browser will have to either build the HTML page in DHTML mode or initialize the flash container and parse the XML.   Client rendering greatly varies depending on the hardware used. More powerful machines will render dashboard faster for a list of recommended client hardware specifications please refer to the Readme File for the specific version of MicroStrategy.   Optimization Techniques common to DHTML and Flash Client rendering time greatly relies in the amount of XML that needs to be parsed. In order to ensure that...