Uncheck the 'Use default inherited value' check box, if it is checked, and set the option to 'Permanent Table,' as. See Template Editor. This property determines how values for metrics are calculated when unrelated attributes from different datasets of a dossier or document are included with metrics. The property "RowGoverning4CostlyFunctions" is a hidden limit that was introduced in MicroStrategy to prevent memory issues or crashes when many complex metrics are used at the same time. The VLDB properties at the different levels work together to affect report results. You can configure properties such as SQL join types, SQL inserts, table creation, Cartesian join evaluation, check for null values, and so on. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. MicroStrategy added an Advanced Properties dialog that includes elements formerly know as VLDB properties, as well as other items including report data properties such as Evaluation Order. x where report SQL statement containing semi-colon (;) in the Report Pre Statement 5 VLDB properties will cause report to fail in MicroStrategy 10. Right-click on an existing environment and choose Properties. Property: Description: Possible Values:. Intermediate Table Type . Certain VLDB properties use different default settings depending on which data source you are using. In MicroStrategy it is possible to generate outer joins between metrics at different levels, but there was the possibility of report results that could vary in ways outside the user's control if a straight outer join was performed. Group by column. To create and review a detailed list of all the default VLDB settings for different DBMS types, see Default VLDB Settings for Specific Data Sources. Choose Tools > VLDB Properties. 0. 4. Disallow joins based on unrelated common attributes. KB441418: Supplemental reference for installing Hotfix on MicroStrategy version 10. A given VLDB setting can support or. When you change a VLDB property setting at the database instance or project level, you must restart Intelligence Server for the MicroStrategy Engine to read the latest schema information from the metadata. See Template Editor. The Results Set Row Limit VLDB property is used to limit the number of rows returned from the final results set SELECT statements issued. 1, this property was known as Final Pass Result Table Outer Join to Lookup Table. For example, the report shown below ranks the NULL values. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformHyperIntelligence and its Architecture. Open the Workstation window. ")This is a known issue prior to MicroStrategy SQL Engine 9. Flash-memory-based solid-state drives (SSDs) are used widely for secondary storage. MicroStrategy SQL Generation Engine 9. Check the report SQL again, observe that "with" clause (aka common table expression) is applied. Some databases do not support implicit creation, so this is a database-specific setting. This occurs when the data type of the attribute is timestamp. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X". Project. The system reads them from the same location. NULL values can be treated as zeroes (0) for computational purposes by enabling suitable settings in the Very Large Database (VLDB) properties at the project, report, and metric levels. Determines whether MicroStrategy attempts to execute multiple queries in parallel to return report results faster and publish Intelligent Cubes. You can configure properties such as SQL join types, SQL inserts, table creation, Cartesian join evaluation, check for null values, and so on. Since full outer joins can require a lot of database and Intelligence Server resources, and full outer joins are not supported for all databases, it. Fact Tables 2. 3. When using a Snowflake database it may appear that the Metric Outer join option is turned on. To access the VLDB properties editor at the project level in the MicroStrategy Cloud Environment, please use either a Desktop Designer or Architect user account to connect to MicroStrategy Developer. KB440837: MSTR 10. You can set additional metric VLDB properties at other levels, such as the report and project levels. Zillow has 471 homes for sale in Victoria BC. Based on these VLDB (Very Large Data Base), the Intelligence server manages the query optimization, calculations, and metrics. MicroStrategy application developers can further optimize SQL for their specific Oracle environment using these string insertion settings. Both properties are located in the Query Optimizations folder in the VLDB property editor. x order - Calculate. Alter VLDB Properties You will need to alter two properties: Additional final pass option and Apply filter options. When the VLDB property Intermediate Table Type is set to "True Temporary Table", each "SQL pass" is specified as a DECLARE GLOBAL TEMPORARY TABLE statement to define a. The table b elow summarizes the MultiDimensional Expression (MDX) related VLDB properties. " The default value here is "Include only lowest-level attribute in metric level (recommended for version 9. Learn the basics of VLDB properties in MicroStrategy Developer, an advanced environment providing a complete range of analytical functionality designed to fa. Recommendations. 1 and 10. b. In the Source area, select a database instance for the database to access using Freeform SQL. MDX cubes are also referred to as MDX cube sources. MicroStrategy supports reporting and analysis with SAP BW, Microsoft Analysis Services, Hyperion Essbase,. The table b elow summarizes the Export Engine VLDB properties. The dimensional model is included for backward compatibility with MicroStrategy 6. Lookup Tables VLDB Settings provide minimal modifications to this order. The XQuery Success Code VLDB property lets you validate Transaction Services reports that use XQuery. 1 and 10. The first four statement VLDB properties, each can contain single SQL statement. Dimensionality Model. A few common ones are for Attribute or Metric join types, cross join check, type of intermediate table, etc. It also displays all current settings for each VLDB property. Microstrategy VLDB Properties; MicroStrategy VLDB properties with Hive;. The MDX cube report is executed. Workstation is a unified tool that brings the power of administration and design together for the individual business user. For a detailed explanation of how to support financial reporting in MicroStrategy, along with using this VLDB property to identify attributes that include empty elements, refer to the Project Design Help. At the metric level, it can be set in either the VLDB Properties Editor or from the Metric Editor's Tools menu, and choosing Metric Join Type. This property is report-specific. Expand the 'Administration' Icon, and select the Database Instance Manager. Click VLDB Properties. The "Evaluation Ordering" VLDB setting affects the order in which the Analytical Engine will perform various calculations. To use automatic attribute role recognition, you must select the Engine Attribute Role Options, found in the database instance-level VLDB Properties under Query Optimization. 2. For examples and details to enable these properties, see SQL Generation and Data Processing: VLDB Properties. 3. . The Parallel Query Execution is an advanced property which determines whether MicroStrategy attempts to execute multiple queries in parallel to return report results faster and publish Intelligent Cubes. This article describes best practices to be taken when connecting an instance of PostgreSQL in MicroStrategy. In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster. Select Project Configuration. 4. Property owners benefit from a fair number of nearby clothing stores. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties. In the VLDB Properties dialog, go to Analytical Engine > Data Engine Version. Refer to the MicroStrategy System Administration Guide for a detailed description of these properties. Double-byte language support. These values are set by default when the "Oracle 11g" database object is used (set at Configuration Managers > Database Instances > Database Instance > Database connection Type ). VLDB_PROPERTY_VALUE: The value of the property, returned as a string. Restart the Intelligence server to apply the changes. The Preserve all lookup table elements. Pre- and Post-statements defined in the VLDB Properties of a project's primary warehouse database instance also apply to attribute element browsing requests, which are issued when browsing attribute elements in the data explorer in MicroStrategy Developer, or when a prompt must display a list of attribute elements. To view VLDB properties. The VLDB Properties Editor opens. 4. Victoria's peaceful atmosphere and vibrant real estate market make it a great place to search for your next home. (The original name for this property, in fact, was "Incomplete lookup table. Both properties are located in the Query Optimizations folder in the VLDB property editor. 2021 Update 7 (September 2022) MicroStrategy Workstation. This VLDB property has the following options: Disable parallel query execution (default) : All queries for MicroStrategy reports and Intelligent Cubes are processed sequentially. Total views 28. In MicroStrategy 7i, new methods were introduced to evaluate the calculation level of metrics which prevent the incorrect result demonstrated in this document. It sets the general standards. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform14. It is recommended to always stay on the latest MicroStrategy release so you can always have the best Snowflake experience out of the box. VLDB Settings These settings can be changed in the VLDB Properties dialog box for either reports or the database instance. Notice that the 4 options shown on the upper right are the same as those in the VLDB dialog box (internally they are read from the same location). 0. . In our current design, report pre/post statement 5 is different from 1-4. Below are the list of parameters that the URL must. There is NO difference between the 'Preserve lookup table elements' options under the VLDB Properties editor vs. Most major databases have allowed the creation of special tables that have characteristics that separate them from 'normal' or 'permanent' tables in the. For a project, right-click it and choose Advanced Properties. -1 (Use value from higher level) Limiting Report Rows, SQL Size, and SQL Time-Out: Governing. The 'Where clause driving table' Very Large Database (VLDB) property indicates to the MicroStrategy Engine which table to use when a filter needs to be applied. This section tells you how to do the following:When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The MicroStrategy Knowledge Base document KB6100-071-0031 explains how to change default Very Large Database (VLDB) properties for all database instances on the same MicroStrategy Intelligence Server. From the Tools menu, select Show Advanced Settings. You can change VLDB properties to alter the syntax of a SQL statement and take advantage of database-specific optimizations. Click VLDB Properties. Choose Data > Configure Bulk Export. Open “Database instances” in the Categories menu, and click on “SQL Data warehouses”. However, you want to show all the store. In Developer, right-click the report to set the limit for and select Edit. 4. For example, if a VLDB property is set one way for a report and the same property is set differently for the database instance, the report setting takes precedence. If this is required by MicroStrategy Technical Support for trouble-shooting an issue, copy and paste the contents of this report into notepad and send it. Very Large Database (VLDB) properties are settings in charge of performing database specific optimizations (customizing Structured Query Language (SQL)). Rank) calculated in Analytical Engine" found under the 'Metrics' folder in the list of VLDB properties. Scribd is the world's largest social reading and publishing site. In MicroStrategy Developer, open a report in the Report Editor. " button under the warehouse name, as shown below: Open the "Metrics" folder and select "Metric Join type. MicroStrategy periodically updates the default settings as database vendors add new. x. Launch Project Configuration, select "SQL Data warehouses" under "Database instances" tab. On MicroStrategy Web and Workstation, the same. The Project Configuration Editor opens. You can choose to have the report display or hide the information described above, by selecting. VLDB properties allow you to customize the SQL that MicroStrategy generates. The Year - Define a new member attribute. Select either Disable or Enable depending on whether you want to disable or enable. Calculate each attribute individual weight according to the level in the hierarchy (level in hierarchy/number of levels in hierarchy * 10). x has changed the default value of the "SQL Global Optimization" VLDB property. Choose the database instance and then open VLDB Properties. VLDB Properties Editor. As mentioned, these steps will need to be done for each report that sorting in this way is desired. Accessing Report VLDB Properties. VLDB properties allow you to customize the SQL that MicroStrategy generates, and determine how data is processed by the Analytical Engine. pdf), Text File (. Click the "VLDB Properties. This article describes what the evaluation ordering property is in MicroStrategy 9. For more information about all the VLDB properties, see SQL Generation and Data Processing: VLDB Properties. For this scenario, you can use these two VLDB properties to define which MicroStrategy data types support the character sets of your Teradata database. Other VLDB Properties are mentioned below. If the report result set exceeds the limit specified in the Result Set Row Limit, the report execution is terminated. To view VLDB properties. Modify the VLDB property you want to change. Maximum SQL Size (Database Instance) You can limit the size (in bytes) of the SQL statement per pass before it is submitted to the data warehouse. For use cases, examples, sample code, and other information on every VLDB property. See the Advanced Reporting Guide. Additional VLDB Settings. Group by position. Metrics using count or average, metrics with dynamic aggregation. Be careful though, because these settings are applied set as the defaults for. x, the only options were to drop tables or do nothing. One of the options under Analytical Engine folder is called "Metric Level Determination. These properties govern the working of the Analytical and SQL Engine, which have a significant influence on the business reports. There is one VLDB property in MicroStrategy that controls the join behavior between different datasets. In this course, you will study specific reporting scenarios and the MicroStrategy Engine’s techniques for composing the SQL queries that produce MicroStrategy reports. When a report that includes these financial line item attributes is exported to Excel or as a PDF using MicroStrategy Web, all rows of data are exported. In the VLDB Properties, locate option "Distinct/Group by Option (when no aggregation and not table key)" under Select/Insert tab. Microstrategy VLDB Properties; MicroStrategy VLDB properties with Hive;. Expand the Database instances folder. Order of Precedence. 7 regarding null checking performed by the Analytical Engine. 4. This allows MicroStrategy to both properly support and take advantage of certain characteristics of each third-party data source. 👉 Free PDF Download: Microstrategy Interview Questions & Answers. The Use default inherited value option indicates the level that is active, while the SQL preview box displays a description of the selected setting. After the Administrator sets up SSO, they only have to login once and take advantage of both MicroStrategy and Snowflake from the same credentials. A possible business case that could be solved by this approach: A large fact table that summary reports are sourcing, from which it is necessary to drill down through a report (or report template) to row level data. The VLDB property's behavior will be demonstrated using the following attribute and report. Details for All VLDB Properties Modify VLDB properties with caution and only after understanding the effects of the VLDB settings you want to apply. This property determines how values for metrics are calculated when unrelated attributes from different datasets of a dossier or document are included with metrics. MicroStrategy TutorialPublic ObjectsReportsMicroStrategy Platform CapabilitiesAd hoc ReportingSortingYearly Sales!i inserts the. Modifying any VLDB property should be performed with caution only after understanding the effects of the VLDB settings that you want to apply. VLDB (Very Large DataBase) properties allow you to customize the SQL that MicroStrategy generates. 0 and higher). This article explains the behavior of the commit level VLDB propertyThe MicroStrategy Engine Essentials course explains the inner workings of the MicroStrategy Engine. Loading × Sorry to interruptPlaces to Set VLDB Properties. This allows MicroStrategy to both properly support and take advantage of certain characteristics of each third-party data source. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. This Knowledge Base article describes how using Snowflake data base outer joins are automatically set as off/ (nosupport) SYMPTOM. The VLDB properties are grouped into different property sets, depending on their functionality: Viewing and Changing VLDB Properties. List all parent groups of a user group 'sGroup'. VLDB properties allow you to customize the SQL that MicroStrategy generates. Character. pdf - MicroStrategy. See the MicroStrategy Developer Help (formerly the MicroStrategy Desktop Help) or the (missing or bad snippet) for steps to set this VLDB property. MDX cubes are also referred to as MDX cube sources. This article documents an issue observed in MicroStrategy 2019, where the session ID parameter is not correctly set when using wildcards. Upgrading Your Database Type Properties. The method used for multiple data source access is controlled by a project-level VLDB Property. A given VLDB setting can support or. One might be yours!Victoria Homes by Postal Code. Published: 4ě›” 6, 2017. Set the additional final pass property to force an additional pass of SQL. They can be set at different levels throughout a project to establish a specific behavior regarding the object type. Based on these VLDB (Very Large Data Base), the Intelligence server manages the query optimization, calculations, and metrics. ; By default, the Bulk export database instance, which is the database instance for the database containing the report data, is defined as the data warehouse for the project. Parallel Query Execution is an advanced property that is hidden by default. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. x, users notice that Null checks are ignored in the HAVING clause when the VLDB property "change the Additional Final Pass Option" is set to "One additional final pass only to join lookup tables". VLDB. The 'Where clause driving table' Very Large Database (VLDB) property indicates to the MicroStrategy Engine which table to use when a filter needs to be applied. Clear the Use default inherited value check box. Local temporary tables, indicated with the "#" character, are stored in tempdb and incur less overhead. However, platform administrators can toggle this functionality if needed: In MicroStrategy Developer, platform administrator can select/deselect the Use parameterized queries checkbox under the Advanced tab of the Database Connections dialog. When VLDB settings are configured at the report level to allow for an outer join to the lookup table in MicroStrategy Developer, the SQL does not show an outer join. VLDB properties (sometimes called VLDB settings) allow you to customize the SQL that MicroStrategy generates. To View and Change VLDB Properties Open the VLDB Properties Editor to display the VLDB properties for the level at which you want to work. This article describes how the "Set Operator Optimization" VLDB property works in MicroStrategy Introduction to VLDB Properties Optimizing processing with VLDB properties. 0, a VLDB property is available to control. col2…) While the default values should result in the. " Save and close. Certain VLDB properties exist at the database instance level but are viewed by the SQL Engine as unrelated to the database used. Use the Navigation pane to locate an Intelligent cube, incremental refresh report, project, or data source. The following settings are advanced properties which are. If you choose Temp Table Join. Case 3: Cross Join due to the VLDB setting Downward Outer Join Option. This property determines how values for metrics are calculated when unrelated attributes from different datasets of a dossier or document are included with metrics. Open navigation menu. 203 Exercise 7. See the MicroStrategy Developer Help (formerly the MicroStrategy Desktop Help) or the System Administration Help for steps to set this VLDB property. It can be enabled on project level: Open MicroStrategy Developer. An example is: \MicroStrategy Tutorial\Public Objects\Reports\MicroStrategy Platform Capabilities\Ad hoc Reporting\Sorting\Yearly Sales!i inserts the job priority of the report which is represented as an integer from 0 to 999 (can be used in all Pre/Post statements). The user should locate the VLDB. Fact extensions may require subqueries, depending on their definition. Click the Joins folder to expand it and then choose Preserve all lookup table elements. In statement 5:An example is shown with MicroStrategy Tutorial Project: - In Microstrategy Developer, log into the project where it is desired to obtain a report's VLDB properties. Select VLDB Properties from the Data menu to access the VLDB Properties (Report) dialog box. 3. VLDB properties also help you configure and optimize your system. Level dimensionality in a metric interacts differently with different features such as view filters, report filters, other metrics and certain VLDB properties. For instructions on how to display this property, see Viewing and Changing Advanced VLDB Properties. The attribute uses a CASE statement to replace NULL values with -999. "The table below summarizes the Joins VLDB properties. 5 : If the Use default inherited value check box is selected, clear it. For a data source, right-click it and choose Edit. Then set the apply filter options property to. Join common key on both sides. x, select 'Project Documentation' from the Tools menu to start the wizard. These values are set by default when the "Oracle 11g" database object is used (set at Configuration Managers > Database Instances > Database Instance > Database connection Type ). Beginning with MicroStrategy 9. This property limits the maximum amount of rows to 80,000. You can configure this setting. Choose Tools > Show Advanced Settings option if it is not already selected. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. VLDB Settings These settings can be changed in the VLDB Properties dialog box for either reports or the database instance. This is reflected in the checkbox “Use default inherited value for all VLDB properties”. Select the Database Instance used for the project warehouse, right-click and select 'VLDB properties'. Properties set at the report level override properties at every other level. If a table has been imported from only one database instance, the secondary database instance panel will be empty and disabled. ; Click the General tab. This feature is similar to what we see in. <Setting> If that level is also set to the default or if the VLDB property is not set at the project level, the setting at the database instance is used. " In MicroStrategy SQL Generation Engine 8. By default, MicroStrategy generates SQL creating the primary index on all attribute ID columns that are used in the intermediate table. In the Report Editor click on 'Data'> 'VLDB Properties' option, as illustrated below. (For information on object levels, see Order of Precedence . In the VLDB Settings list, expand Dynamic Sourcing, and then select Enable Dynamic Sourcing for Report. When a Database Instance is configured to use the “Azure SQL Data Warehouse” database connection type, the recommended values for all VLDB properties will automatically be. Metric-specific VLDB properties that can be set at the metric level include. Pages 100+ Identified Q&As 2. xml file in the "Program Files (x86)Common FilesMicroStrategy" folder on a machine with MicroStrategy Developer installed and create a backup of this file, and then edit it. These settings affect how MicroStrategy Intelligence Server manages joins, metric calculations, and query optimizations, among other options. You can specify another. Any existing projects will retain the null checking behavior that was. This VLDB setting is located in the 'Indexing' folder and has the following options:MicroStrategy constantly optimizes the queries and sets new defaults for the VLDB properties so customers can take advantage of the best performance possible. This article describes how to use wildcards to display temporary table names in pre/post statements. Allows the MicroStrategy SQL Engine to use a new algorithm for evaluating whether or not a Cartesian join is necessary. Property Type. The resulting report in the 'VLDB Settings Report' dialog box represents a list of non-default VLDB properties that have been enabled for that report. VLDB properties allow you to customize the SQL that MicroStrategy generates, and determine how data is processed by the Analytical Engine. 201 Modifying VLDB properties at the report level. This setting is useful if you have only a few attributes that require different join types. They are exactly the same. To view a summary of the system components that contain VLDB properties for a given report, select one of the system-level folders displayed under the VLDB Settings. The Parallel Query Execution property determines whether MicroStrategy attempts to execute multiple queries in parallel to return report results. In the Database Instance Manager, right-click the database instance you want to modify VLDB settings for, and choose VLDB Properties. VLDB (Very Large DataBase) properties allow you to customize the SQL that MicroStrategy generates. •. The “#n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. For users with environments and metadata updated to MicroStrategy 2020, the Analytical Engine will ignore null values for aggregation functions in new projects by default. It is very. In the VLDB Editor open the 'Tables' folder and click on 'Intermediate Table Type. Use VLDB property editor: use the VLDB Properties Editor: USEVLDBEDITOR: View ETL information:. What are the various ways of incorporating security in Microstrategy? 40. NIT Rourkela. 3) In Joins, select Join Type. In the confirmation window that appears, click Yes. The following diagram shows how VLDB properties that. To view a summary of the system components that contain VLDB properties for a given report, select one of the system-level folders displayed under the VLDB Settings headings to view a summary of the properties listed for that folder. From the Tools menu, select Create VLDB Settings Report. For example, tutorial datasets may contain unrelated attributes and cross join metric values rather than joining the metric values. NOTE: For information regarding the hierarchy of the different MicroStrategy VLDB settings, refer to the following MicroStrategy Knowledge Base technical note: When the grand total metric and another metric exists on a grid, Cross Join is produced to join to grand total metric and is exempted from the Cartesian Join Governing property. You can use MicroStrategy for different types of data analysis on a variety of data warehouse implementations. If the option for multiple passes is selected, all metric calculations will be performed in separate passes. Access the VLDB Properties Editor. Currently this issue is being reviewed by MicroStrategy for a potential enhancement request on an upcoming MicroStrategy release. The root cause is unknown, however it is related to an issue with the upgrade where the property set object that contains the two properties is not properly updated. Please right-click a project>Project Configuration>Database Instances>VLDB Properties (for the appropriate database instance) to access the VLDB properties. You can check out the 3 options in VLDB Properties / Joins / From Clause Order While you are there, check out the last option under VLDB. Navigate to 'Pre/Post Statements' and 'Report Pre Statement 1. close menuNote: Changing the Analytical Engine VLDB property "Metric Level Determination" to the option "Include higher-level related attributes in metric level (deprecated)" bypasses the Analytical Engine normalization logic and also produces the expected report results. MicroStrategy Office privileges. These settings affect how MicroStrategy Intelligence Server manages joins, metric. A given VLDB setting can support or. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. In this course, you will study specific reporting scenarios and the MicroStrategy Engine’s techniques for composing the SQL queries that produce MicroStrategy reports. Open the database instance for the project. x order - Calculate derived metrics/smart compound metric before derived elements/consolidation and all subtotals are smart" and "7. - On MicroStrategy Developer main toolbar, cick on ToolsProject Documentation - Follow the wizard selecting: (1) Application Objects (2) Advanced DefinitionIt is found in the Analytical Engine folder of the VLDB Properties (Metric) dialog box, pictured below. Double-click Time to open the folder, then double-click Year. In MicroStrategy 10. A few common one are for Attribute or Metric join types, cross join check, type of intermediate table, etc. These settings affect how MicroStrategy Intelligence Server manages joins, metric calculations, and query optimizations, among other options. The maximum file size of dashboard (. Close suggestions Search Search. Multiple passes are generated only when necessary to resolve all the metric definitions. NULL values can be treated as zeroes (0) for computational purposes by enabling suitable settings in the Very Large Database (VLDB) properties at the project, report, and metric levels. MicroStrategy uses a user editable XML file to control what VLDB properties are visible in the different GUI parts of MicroStrategy client products. MicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. When you open a web page the extension automatically scans web pages in your browser and underlines keywords that you can hover over to trigger cards. Right-click a database instance and select Edit. List Nondefault Report VLDB Properties. The Display mode setting determines how the drilled-to report is displayed, as one of the following options: Default: Uses the original report's display setting. In the VLDB Settings list, expand Dynamic Sourcing, and then select Enable Dynamic Sourcing for Report. All entries follow a set format as noted below. 2. MicroStrategy Engine Components 27 MicroStrategy supported database platforms 276 MovingAverage function 255 Multipass SQL 37 N Nested Metrics 160 Non-Aggregatable metrics 142 O Oracle 292, 299, 304, 318, 327, 328, 329 Output level 193 P Partitioning 330 Permanent table 330 Permanent Tables 326 Pre/Post Statements 299 wildcards 301. . The fact columns can also be included in the primary index, using the Allow index on metric VLDB property. For example, the report shown below ranks the NULL values.