The considerations and steps required to fully support dynamic sourcing are listed below: While many MicroStrategy features can be used with dynamic sourcing, some features may prevent. In MicroStrategy 10. Adaptations are teaching and assessment strategies especially designed to accommodate a student’s needs so he. The default value is 256 megabytes. Click Close, then "Finish" on the "prepare data" view and save the cube. Create a Report 'R3' with 'Country' attribute. To fully leverage Teradata for analytical SQL requests, the Teradata DSN configuration should be modified from its default values as follows: · Maximum Response Buffer Size - should be increased to an acceptable value. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in. PlatformAnalytics. In-memory analytics enables you to create in-memory cubes using the Multi-Table Data Import feature. x and 10. x Intelligent Cubes. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. x a new concept is introduced called Intelligent Cubes. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. 5K KB438759: In-memory Cube Reporting: OLAP vs MTDI and Best PracticesMicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Rather than returning data from the data warehouse for a single. 1. Set the path for the cube cache file directory to . The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. 27K. Expand Intelligent Cubes, and then select General. In Intelligent Cube editor, the default display attribute forms cannot be modified after choosing "Use the following attribute forms" and adding a new attribute form in "Attribute Display". Do you have reports that currently access. Designing and creating documents: An overview. To identify if your cube is MTDI or OLAP it’s really simple, if the cube was created through the Data Import Web Interface (“Add External Data” section on MicroStrategy Web. The report and Intelligent Cube must be based on the same source MDX cube. Transformation metrics, under the following conditions: -A metric with the same formula and transformation exists in the Intelligent Cube. x-10. This can be achieved via the report level VLDB property > SQL Time. Shipped vs Native. This presentation helps users understand MicroStrategy's in-memory architecture. Recommended for Platform Administrators, System Administrators, and Intelligence Directors, this session provides a foundational understanding of how Platform Analytics works and the reporting capabilities it offers. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Best practices for supporting dynamic sourcing. The Intelligent Cube opens in the Report Editor. Agile BI - Learn how to stream data In-Memory within the MicroStrategy platform, and run analytics on top of that live data. Run the report, notice that the filter does not work, all attribute elements pop out, as below picture shown: CAUSE: This is a known issue in MicroStrategy Developer 10. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Our vision is to enable Intelligence Everywhere. Best practices: Importing data into MicroStrategy Web; Importing data from a data source; Previewing, modifying, and refining your data before importing; Editing, republishing, and linking imported data; Configuring OAuth parameters for data sources integrated using Data Import; Scheduling updates for an Intelligent Cube created using imported dataThis issue has been classified as a none defect by MicroStrategy. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. Start Learning with us ACTE MicroStrategy. Place Intelligence Server close to the both the data warehouse and the metadata repository. Integer ID of the Intelligent Cube report that was published, if any. CONTENT: Enable cube partitioning, the partition attribute should be the attribute with more cardinality in the cube (more cardinality means the attribute with more different elements, for example in the Tutorial project the. 5 To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the software version shownDrilling is allowed within an Intelligent Cube for quick-response MOLAP analysis. CONTENT: Enable cube partitioning, the partition attribute should be the attribute with more cardinality in the cube (more. mstr file then uploads to another Intelligence Server without the user's specific database connection, the user will need to republish the cube first. Document Number: 09481030. Learn more about it at MicroStrategy. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. Intelligent cube; Advanced reports; Creating and adding data to the document;To view an Intelligent Cube stored in your History List. x?The value of Composite Metrics displays with “--“ in Intelligent Cube based Report in MicroStrategy 9. mstr) files that can be sent through Distribution Services is defined by the MicroStrategy (. Compound attributes and joint element lists. Filters on the report must meet the following criteria: Attributes used in the filter should also be on the Intelligent Cube's definition. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Because of this, OLAP cubes are traditionally built and maintained by advanced BI developers or architects. 1. Supported data structure and distribution on Gateway. In a MicroStrategy Intelligence Server cluster environment, Intelligent cubes don’t load on remote nodes when the node which published the Intelligent cube has been shut down normally, and cube based reports can’t be run . This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. The second part discusses the common challenges and better practices on using Snowflake as a warehouse in MicroStrategy, and the third part discusses making it available to business users and self-service users. Disconnect from the project source and restart both Intelligence servers. A bar in the microchart represents that the report is covered by the Intelligent Cube and no bar means that report is not covered by the Intelligent Cube. The attached document details the differences between OLAP and MTDI cubes, including the basis for the performance profile of each and the available. KB441236. The Intelligence Server will then join all the dataset results into one master table, called the virtual dataset or master dataset, to store in memory. mtc is the name of the saved test file. Number of Views 3. 0. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. More about Feature flags can be found in this article. x. LIST ALL INTELLIGENT CUBE CACHES IN PROJECT "Development Project 5"; ResultSet Columns. MicroStrategy Web Based Training (WBT), MicroStrategy World, Office Intelligence, Best in Business Intelligence, Pixel Perfect , Global Delivery Center,. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. Before MicroStrategy 10. intelligent cube use cases, and cube optimization techniques with MicroStrategy. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Edit Project-Level Cache and Intelligent Cube Settings. ACTION: 1. It will track and log all. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. System Sizing Guidelines The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. These Intelligent Cubes are created in a folder along with shortcuts to all the reports that can connect to the Intelligent Cube using dynamic sourcing. It lets you various. 1 or later, with the following characteristics:. Recorded at World 2021. Run report off cube. IS_PROJ_ID. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. They can save you time and make your Intelligent Cubes more effective for your reporting environment: Define your business query: Before you can determine what objects to place on an Intelligent. The objects stored in the metadata are reusable. The New Intelligent Cube dialog box opens. Required Status to Perform Action. x. als Berichtsobjekte oder Berichtsfilter einschließen. Since the Quick Search indices make use of the Change Journaling data, they can easily update their existing indexes based on this data instead of having to do a full table scan. When editing an Intelligent Cube which is published via Data Import, by default the Intelligent Cube Editor is opened in Read Only mode, any modification performed on top of the Intelligent Cube could not be saved. x MicroStrategy recommends that you observe the following practices when copying objects with Object Manager in MicroStrategy 10. MicroStrategy Intelligence Server will submit all queries as prepared statements if the following registry key is created on the Intelligence Server machine:To Create an Intelligent Cube Using Freeform SQL or Query Builder. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. Take a Data Import Cube similar to below. MicroStrategy has a metadata-driven architecture. Conditional metrics. E. Prior to MicroStrategy 2020 the Maximum % of growth of an intelligent cube due to indexes governing setting was used to limit the growth of Intellgent cubes over time due to the creation of indexes. KB14009: In a clustered MicroStrategy Intelligence Server 9. MDX, CSI" in Web. IS_CUBE_REP_ID. STEPS TO REPRODUCE 1. For information on incrementally refreshing Intelligent Cubes, see Updating Intelligent Cubes without re-processing: Incremental Refresh. This will render the attribute as an image. 3. 438832. Object Manager cannot undo the copying and replacing of objects. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Business intelligence is becoming more important by the day, with cloud offerings and mobile devices gaining wider acceptance and achieving better market penetration. MicroStrategy’s In-memory technology is engineered to meet the. The tooltip will show the dataset type listed as a Super Cube. For a report to successfully retrieve its information from an Intelligent Cube, various conditions must be met. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as a single in-memory copy among many different report created by multiple users. The Java XML API log will record all the XML communications between Intelligence Server and Web. Use the Intelligent Cube Editor to access all of the features and functionality for creating cubes. 1To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. 3. x and later, users should make sure to take into account the following guidelinesIt describes how MicroStrategy Intelligence Server converts MDX cube source data and objects into MicroStrategy using MultiDimensional Expressions (MDX). KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. Right mouse click on the cube, and “Search for dependent subscriptions” as shown below; it shows two subscriptions have been created based on the Intelligent Cube. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. 2. x - 10. 88K. Let us assume the Intelligent Cube is published on Node B: Create an event called "Refresh Cubes" Create an event-based schedule called "Refresh Cubes" The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Recorded at World 2021. One of the first steps in formatting HyperIntelligence cards is to choose the best-fit template. The MicroStrategy Cloud Environment (MCE or MicroStrategy Cloud) is a platform-as-a-service (PaaS) offering that MicroStrategy manages on its customers’ behalf as a unique Amazon Web Services (AWS) or Microsoft Azure implementation. Click the MicroStrategy icon at the upper left of any page and select History List. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. You must belong to the System Administrators group to use this feature. Description. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 1. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. Enter Reports folder and then right click on "Blank EMMA Cube Report" and choose Properties. These reports allow data to be returned from the. Solution Gallery. Microstrategy Dossiers With the release of MicroStrategy 10. This is the most popular MicroStrategy Interview Question asked in an interview. Shipped driver refer to Data Direct driver which installed along with MicroStrategy Intelligence Server This article describes features that are not supported when using Dynamic Sourcing. Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. You will also work on real-world projects to gain hands-on experience. MicroStrategy - Architecture. SHOPMAN, powered by MicroStrategy, delivers sensor data, inventory management, and financial data to enable users make data-driven. Published: Dec 31, 2018; Last updated: Jul 25, 2023 Intelligence Everywhere. x). To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. How to Import Data from a SAP HANA Database Into MicroStrategy Web. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. Publisher (s): Packt Publishing. 4. x as the MicroStrategy environment is applying the System Prompt 'User Login' at the time of Intelligent Cube publication. It serves as the starting point for new developers to getThis article describes the best practices for using dynamic sourcing in MicroStrategy. . Click Databases . Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Description. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. In your multi-form attribute, right-click on the Image attribute and select Change Data Type > HTML Tag. It illustrates tips and tricks, such as enabling parallel data fetch, enabling the correct number of partitions, enabling partition on the appropriate attribute, and using cubes vs. MicroStrategy provides modern analytics on an open,. blogspot. xIn order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. The Intelligent Cube refresh settings change the way the Intelligent Cube is updated when you re-execute it manually, or when it is published on a schedule, as described in Publishing Intelligent Cubes using a schedule. 0, you have the option to use Data Import to create an in-memory dataset (sometimes referred to as an super cube) containing data from multiple tables. 4. x Intelligent Cube status indication and workflow This section describes the ways in which you can design and create a MicroStrategy Report Services document. Let us assume the Intelligent Cube is published on Node B: Create an event called "Refresh Cubes" Create an event-based schedule called "Refresh Cubes"Best Practices Super Cubes in MicroStrategy 2019. To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the software version shown in “About MicroStrategy. 8. For example, these reports go from basic execution pointers, quarterly deals by item. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. Publish the Intelligent Cube by executing it on either of the nodes. x - 10. If the Intelligent Cube must be re-processed based on a metric. Number of Views 2. MicroStrategy Dossier Design Best Practices for Performance. Existing best practice recommendations for needle and syringe programs are out of date. In Developer, from the File menu select New, and then Intelligent Cube. A set of data is returned from the data warehouse and saved directly to the Intelligence Server memory. This can be encountered when you're dealing with raw data volumes which have not yet been processed through an ETL. Dozens of Intelligent Cube caches are invisible in one Intelligence Server among the six nodes cluster in MicroStrategy 2021 GA, is due to Intelligence Server starting up before mount of the cube shared location. Log the communication between the MicroStrategy Web server and the MicroStrategy Intelligence Server. It happens in MicroStrategy Developer 9. x, it is possible for administrators to setup encryption of result caches that are saved to disk. Locate the published cube, right-click on it and choose Quick View. x and 10. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Consider a data import dataset which has been imported into MicroStrategy. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. That is, the metadata must be upgraded to MicroStrategy ONE/2021 to use MicroStrategy Intelligence server on MicroStrategy ONE/2021. iCubes or Intelligent Cubes are objects that provide pre-cached data which can be queried on the reports. 4. 1180 views | February 10, 2021 29:25. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). Webinars. Intelligent Cube Using Microstrategy 9. Using attributes defined in this way can save space as compared to attributes that use character strings for their ID forms. KB441987: Best Practices for increasing. 4. For background, we will give a brief introduction about each. The report filter must include at least the same restrictions as the Intelligent Cube’s filter, if present. 10. When thinking about choosing a template, think about the words and descriptions that will be included on the card. x - 10. Create a Report 'R3' with 'Country' attribute. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. 0. The Intelligent Cube Options dialog box opens. If the Intelligent Cube must be re-processed based on a metric. The ID is found with the heading. 0 MicroStrategy releases. The data in this cube is as given below. Within the set. . A user creates a report that connects to this Intelligent Cube, and includes Year and Revenue on the report. After the Intelligent Cube has finished republishing, the Cube. This article describes the Intelligent Cube Population options available in MicroStrategy. KB31566: MicroStrategy 9. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. Create Cube B which contains all objects in the report and publish it . This technical note provides a detailed explanation on how Intelligent Cube index generation works in MicroStrategy 9. Web log. ElasticSearch is an open-source search engine based on Lucene that provides multitenant-capable full-text search capabilities. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. The Intelligent Cube Options dialog box opens. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. The New Grid dialog box opens. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create a report in MicroStrategy Web. x. Easily add or change pre- and post- SQL statements. The dataset is automatically saved as a cube and is available in the Datasets section of the Navigation pane. 0, the only way to create an intelligent cube (also known as an ROLAP cube or an OLAP cube) was from a report (which is a single table dataset). MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Published August 27, 2020 By akrish1982. 31K. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. To achieve the best performance possible, it's important to delete all unused objects like datasets, visualizations, tabs (for VIs. When an Intelligent Cube is published, the Intelligent. Tell a story with your data using the dossier chapter/page format. Generally, to increase the speed of aggregation and filtering, a one-to-many relationship is best. 46K. It will track and log all communications at the “XML API. When editing an Intelligent Cube which is published via Data Import, by default the Intelligent Cube Editor is opened in Read Only mode, any modification performed on top of the Intelligent Cube could not be saved. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Intelligent Cubes Intelligent Cubes With OLAP Services features, your report designers can create Intelligent Cube reports. Reports using Dynamic Sourcing do not hit the Intelligent Cube when using the NullToZero function in MicroStrategy 9. 0 has a dedicated section to memory used for Intelligent Cubes. While you can connect an older MicroStrategy Developer client to a newer Intelligence Server (such as an 8. The Data Transfer Rate varies from 27 to 28 Mb/s. x and later, users should make sure to take into account the following. It improves 30% performance in. 2. Once you select a specific. An Intelligent Cube is an In-Memory data structure which. 2. 0, the only way to create an intelligent cube (also. For information on incrementally refreshing Intelligent Cubes, see Updating Intelligent Cubes without re-processing: Incremental Refresh. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. Expand the Object Templates category, select General, and. For example, derived metrics can be used to subtract the data of one. Synapse Analytics leverages a scale out architecture to distribute computational processing of data across multiple nodes. The first step in analyzing. Number of Views 18. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). Connect to MicroStrategy Web (this example) or MicroStrategy Desktop. In the Data Source column, select the checkboxes for the tables to update. Right-click the project and select Project Configuration. 4. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. Start a Pilot Solutions Powerful analytics for any industry. Number of Views 1. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . 0+, you have the ability to see how long it takes each visualization to execute, what query is being sent to the DataWarehouse, or what request is being done to an In-Memory intelligent cube. Apart from the best practices listed above, additional considerations apply when you are using Intelligent Cubes that are incrementally refreshed. Open Command Manager and type the following commands to execute the Intelligent Cubes. Click ' Choose files' and select your Excel file or drag and drop the Excel file into the window. This article describes a known limitation where users are unable to republish a data import intelligent cube for dashboards or dossiers that were created in MicroStrategy Analytics Desktop with an In-Memory data set and a DSNless connection after being imported into MicroStrategy Web 10. VI). It serves as the starting point for new developers to get This article describes the best practices for using dynamic sourcing in MicroStrategy. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. All articles. A document is used to format data from multiple datasets in a single display of presentation quality. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. 5. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. Ensure that the Dependency Search, Conflict Resolution, International, and Migration options in the Object. Click OK. Browse to and select a previously saved Intelligent Cube on which to build your report. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. x product documentation "InMemoryAnalytics. If prompting is not a requirement for this dataset then the best method to improve performance is to directly utilize the Intelligent Cube within the Dossier to reduce both the. x Intelligent Cube status indication and workflow. x and 10. rare practice (British Columbia Ministry of Education, 2011, p. Download the attached PDF for an in-depth understanding of Object Migration best practices. The maximum file size of dashboard (. KB442526. 4. x. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. This can. KB439693: Best practices for MicroStrategy 10. Now that that’s settled, let’s jump into some best practices for. Talk to an expert. 16: Intelligent Cube dirty. Learn more about it at MicroStrategy. Share query results in-memory across multiple dossiers and. The Full Refresh option is the default. If you are using or plan to use MicroStrategy Intelligent Cubes, and you plan to implement data internationalization, it is recommended that you use a SQL-based DI model. x - 10. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Title: Mastering Business Intelligence with MicroStrategy. Why MicroStrategy Why MicroStrategy; Customer StoriesMaintaining data access security. KB31566: MicroStrategy 9. g. This. A dataset is a set of data that can be displayed on a document. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. Result caches: Report and document results that have already been calculated and processed, that are stored on the Intelligence Server machine so they can be retrieved more quickly than re-executing the request against the data warehouse. To enable or disable dynamic sourcing for an Intelligent Cube. The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Platform Analytics and to address issues encountered during the statistics logging and data load processes. MicroStrategy Web Based Training (WBT), MicroStrategy World, Office Intelligence, Best in Business Intelligence, Pixel Perfect , Global Delivery Center,. The syntax is: FileLocation is the path to the saved test file. 4. 35K. This can be done in one node of the cluster because the information is stored in the metadata then used. KB321029: In MicroStrategy 10. Object Migration is the process of migrating or moving objects from one environment to another environment. Since this is the first time the cube and cube based objects are being migrated into Production, there is no conflict resolution and all the new objects are copied into. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. Filename. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. table_name: is the name of a table. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. g. After completing your certification, you’ll receive a digital badge that highlights your accomplishment, which you can post on social media. 1K. To enable or disable dynamic sourcing for an Intelligent Cube. The ‘’ at the start of the path is required to indicate to the MicroStrategy Intelligence Server that the specified path is a remote location. x. Intelligent Cube refresh options supported for dynamic sourcing MicroStrategy 10. x-10. To enable. 4 the connection mapping of the u… Number of Views 1. The columns ID1 and ID2 correspond to attributes and M1 corresponds to a metric. In direct connection deployments, client products (such as MicroStrategy Developer) should also. Number of Views 15.