Tell a story with your data using the dossier chapter/page format. 3. As part of generating an Intelligent Cube MicroStrategy uses a normalized data structure similar to a Relational Database with a series of Fact and Lookup tables. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. Rather than returning data from the data warehouse for a single. Number of Views 8. " maps to the Intelligence Server working directory (when using default locations, this will be C:Program Files (x86)MicroStrategyIntelligence Server). Take a Data Import Cube similar to below. Our MicroStrategy certification training helps you to learn the basics of MicroStrategy, so you can easily apply what you’ve learned in the real world. 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. Best practices to design or utilize mobile dashboards in offline mode in MicroStrategy Mobile. Unable to edit the Intelligent Cube which is published via Data Import in MicroStrategy Developer 9. Best practices for mapping MDX. x clustered environment may observe that after a period of time from the initial publishing of the cube and executing reports based off it, the size of the cubes as reported by the Intelligent Cube monitor in some cases is different in one node than the other node(s). Rather than returning data from the data warehouse for a. This article provides information about system sizing guidelines, hardware requirements and recommendations, recommended system settings for UNIX and Linux, etc. We, at Intellipaat, provide the best online classes to help you learn its architecture, database connections, cubes, clustering, and security models. x Intelligent Cube status indication and workflowInvoke the MicroStrategy Integrity Manager executable MIntMgr. Type of action against the Intelligent Cube: •What is MicroStrategy? MicroStrategy is a Business Intelligence software that can be connected with any data including data files, big data, social media data, and so on to create and modify highly detailed reports and dashboards. For detailed information refer to the System Administration Help. x?This is a guest blog post co-written by Amit Nayak at Microstrategy. x, the folder attribute shows only the paths for folders containing Intelligent Cubes when used as a report filter. By the end of the book, you will become proficient in evaluating any BI software in order to choose the best one that meets all business requirements. Refer to Product Manual for more detailed information. A dataset is a set of data that can be displayed on a document. Defining Intelligent Cube refresh settings. Number of Views 18. 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. A set of data is returned from the. Text and CSV files: Varies depending on the Intelligence Server memory. C:Program Files (x86)MicroStrategyWeb ASPxWEB-INFlog. We cannot include custom groups, consolidations, derived metrics, prompts, or view filters in an intelligent cube. The Full Refresh option is the default. 4. IS_PROJ_ID. Shipped vs Native. The report and Intelligent Cube must be based on the same source MDX cube. This knowledge base article assumes that the user has a month attribute whose format is YYYYMM as shown below and s/he wants to delete more than 12 months’. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Download the attached PDF for an in-depth understanding of Object Migration best practices. (Titled: "Cube broken aplysimple") No data is returned the following SQL view is seen: Report: cube broken applysimple Job: 198 Total Number of Passes: 1 Number of Intelligent Cube SQL Passes: 1 Number of Analytical Passes: 0 Intelligent Cubes Accessed:The Incremental Refresh feature allows users to update cube information without having to republish the entire cube. Share query results in-memory across multiple dossiers and. x ODBC calls by default. In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. Watch on. In MicroStrategy 2019 and earlier, a visualization with data from an In-Memory Intelligent Cube returns incorrect data for an Aggregate From Base metric made using the Case() function when there is a Derived Attribute on the template, and the dossier contains an unused dataset. MicroStrategy version 9. Also Oracle does not support data blending capabilities from the enterprise platform 3 Built-in Best Practices for Visual Exploration: A number of visual exploration best practices embedded within the product. This technical note provides a detailed explanation on how Intelligent Cube index generation works in MicroStrategy 9. MicroStrategy recommends the following best practices to reduce the memory size of your Intelligent Cubes: Attributes commonly use numeric values for their ID forms. Expand Intelligent Cubes, and then select General. In a MicroStrategy Web dashboard, from the File menu, choose Dashboard Properties. Published: Dec 31, 2018; Last updated: Jul 25, 2023 Intelligence Everywhere. x, but not to publish it, the minimum privileges that the Administrator would need to. This includes "Personalized Intelligent Cube" reports (which have the same structure as OLAP Services reports in MicroStrategy 8. This can improve the performance of. This command can get the correct cube status and table status only when the cube is being refreshed or published in the same session between Command Manager and Intelligence Server as this command's. Refer to Product Manual for more detailed information. Sie können Daten für Ihren Intelligent Cube hinzufügen, indem Sie Objekte wie Attribute, Metriken, Filter usw. 10 MicroStrategy Design Challenges Design Tips & Best Practices for MicroStrategy BI Architects and Developers. Intelligent Cube refresh options supported for dynamic sourcing MicroStrategy 10. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. The ‘’ at the start of the path is required to indicate to the MicroStrategy Intelligence Server that the specified path is a remote location. 2. Consider a data import dataset which has been imported into MicroStrategy. Enter Reports folder and then right click on "Blank EMMA Cube Report" and choose Properties. 2. 7. In 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. KB441236. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. 4. 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. e. The dataset is automatically saved as a cube and is available in the Datasets section of the Navigation pane. It serves as the starting point for new developers to getThis article describes the best practices for using dynamic sourcing in MicroStrategy. 2) Choose "Database" and select the 3rd option to "Pick tables". Normalization is critical to obtain correct results, particularly for dimensional metrics, in any aggregation performed by the Analytical Engine. For information on creating Intelligent Cubes using Cube Advisor, see Reviewing and creating recommended Intelligent Cubes. For information on incrementally refreshing Intelligent Cubes, see Updating Intelligent Cubes without re-processing: Incremental Refresh. In MicroStrategy, users can trace MicroStrategy Intelligent Cube activity via the Cube Server Trace which can be enabled through MicroStrategy Diagnositcs Configuration as seen below: The following section displays excerpt from the Cube Server trace when different actions are performed on the MicroStrategy Intelligent Cube. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. For example, an Intelligent Cube includes the attributes Year and Region, and the metric Revenue. Microstrategy is a well-known enterprise BI application software vendor known to enable many businesses keeping when pace with Intelligence in the long run. Query Optimization 2. Watch on. Open the Workstation window. Open the Workstation window. 3. To learn more about Super Cubes and relevant best practices, refer to the following Community Article: Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. By moving the cursor over the microchart, a tooltip is displayed that lists the various reports that could connect to the Intelligent Cube using dynamic sourcing. Recorded at World 2021. 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. Intelligence Server generates the SQL to execute against the data source (can use Multi-Source)The governing setting 'Maximum Report Execution Time' can be defined at the Project Configuration level in MicroStrategy, as shown below: Although there is no direct equivalent to this setting at the report level, there is an alternative that should suit many scenarios. If the Intelligent Cube must be re-processed based on a metric. x improves the performance of user reports by executing reports against published Intelligent Cubes, when the SQL generation engine is able to determine that the cube contains all information required for the report. You must belong to the System Administrators group to use this feature. 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. Intelligent Cube refresh options supported for dynamic sourcingMicroStrategy 10. It is a very popular BI tool since it allows organizations to analyze their data in-depth and make better decisions. 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. Published: Dec 31, 2018 Intelligent Cubes. This article provides some best practices for decreasing the Intelligent cube publish time against Oracle in MicroStrategy. The Intelligent Cube Options dialog box opens. This can be done in one node of the cluster because the information is stored in the metadata then used. Try to include only information that would be imperative at-a-glance. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Interact with the data in real time (with targeting, filtering, and more). 1 or later, with the following characteristics:. Updating Intelligent Cubes without re-processing: Incremental Refresh. However unlike MicroStrategy it cannot join data between different cubes into the a single visualization. x-10. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. The report retrieves data from Cube B now. The MicroStrategy platform supports interactive dashboards, scorecards, highly formatted reports, ad hoc query, thresholds and alerts, and automated report distribution. First, define one visualization as the source. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. 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. Within the set. 4. Number of Views 15. Then, select a page from a different dossier that you want to filter as the target. 1K. 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. 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. Now that that’s settled, let’s jump into some best practices for. A list of data sources available in this project appear. Intelligent cube; Advanced reports; Creating and adding data to the document;To view an Intelligent Cube stored in your History List. iCubes or Intelligent Cubes are objects that provide pre-cached data which can be queried on the reports. Release date: July 2016. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. mstr file then uploads to another Intelligence Server without the user's specific database connection, the user will need to republish the cube first. SAP HANA Query Execution. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The target visualizations only display data that also appears in the source. • Education Sandbox: Leverage new features and best practices, hands-on in your own environment. IS_CUBE_ACT_ID. 4. x - 10. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. Because every company is a data company—no matter which market it competes in. I possess exceptional proficiency in analysing extensive data sets, deciphering intricate trends, patterns, and customer behaviors, and unveiling invaluable insights that may otherwise remain concealed. In MicroStrategy Secure Enterprise an Intelligent Cube goes through an Attribute Index based optimization during the publication to produce the smallest effective size based on cardinality. Always consider to collect database statistics as the query execution plan is generated based on that. 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. A set of data is returned from the data warehouse and saved directly to the Intelligence Server memory. 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. Query Generation. Do you have reports that currently access. x and later, users should make sure to take into account the following. We did internal performance test for both report execution and cube publishing. 88K. Document Number: 09481030. 0. The GUID is part of the project's Intelligent Cube directory path. 4. 13K KB31566: MicroStrategy 9. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. 8. Integer ID of the project where the Intelligent Cube is stored. This cube can be used to improve the performance for normal report execution that run against databases, Intelligent cube publishing and connect live to project dossier execution. The Intelligent Cube opens in the Report Editor. Visit the data visualization and data dashboard galleries for inspiration. This data is stored in cubes or other SAP objects. STATUS_LIST: A ResultSet listing the statuses of the Intelligent Cube. x - 10. From the CatalogCube drop-down list, select the MDX cube to create training metrics for. The ODBC connection uses 3. The default value is 256 megabytes. In the MicroStrategy Intelligence Server Configuration dialog, go to Governing Rules > Default > Catalog cache. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. You will also work on real-world projects to gain hands-on experience. exe using the command line. This presentation helps users understand MicroStrategy's in-memory architecture. 1 and 10. Version 9. Select Build a Query and click Next. MicroStrategy provides modern analytics on an open,. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. MicroStrategy Internal Reference number for this technical note is KB483620 and DE128512. The steps to create an intelligent cube are as follows: Navigate to the folder where you want to create an intelligent cube; the best practice is to create it under Public Objects | Reports . In the Data Source column, select the checkboxes for the tables to update. In the Refresh Policy column, choose one of the following options:The MicroStrategy Intelligence Server will execute all children datasets on the dashboard by either generating SQL and running this against the data warehouse, or by fetching data from a cache. This cube can be used to improve the performance for normal report execution that run against databases, Intelligent cube publishing and connect live to project dossier execution. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. To use a personal Intelligent Cube, you can begin by creating reports in MicroStrategy as usual, and then analyze your reports with OLAP Services features such as view filters, derived metrics, and. Retail Optimize sales across channels. Afterwards the cube will start executing. This section describes only the most basic guidelines. 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. This command will list the table information only when the intelligent cube is a super cube. Prerequisites to creating Intelligent Cubes. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. Unable to edit the Intelligent Cube which is published via Data Import in MicroStrategy Developer 9. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube. McLean, Va. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. 0 has a dedicated section to memory used for Intelligent Cubes. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Navigate to the folder location of the Intelligent Cube. 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. 1180 views | February 10, 2021 29:25. 46K. Expand the Object Templates category, select General, and. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. 38K. Easily add or change pre- and post- SQL statements. Rather than returning data from the data warehouse for a single. In section General at the bottom of displayed window there is a check box with option "Hidden". These are meant to restrict the ability to perform certain privileged actions. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. MicroStrategy Platform is an enterprise analytics, data management, and BI software platform for managing big data. Prompts in a report. A document is used to format data from multiple datasets in a single display of presentation quality. For a new column to be added to an existing Intelligent Cube, users need to edit an existing Intelligent Cube and map the new column manually, as. The tooltip will show the dataset type listed as a Super Cube. Features that can be supported by dynamic sourcing include, but are not limited to, the list below: Security filters. 4. This article describes best practices to be taken when using a Teradata database in MicroStrategy. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy environment. To enable or disable dynamic sourcing for an Intelligent Cube. C:\Program Files (x86)\MicroStrategy\Web ASPx\WEB-INF\log. KB45837: How does the Incremental Refresh option work in MicroStrategy Analytics Enterprise 9. x installation and deployment. Relationships with Multi-Table Data Import. In MicroStrategy Intelligence Server 9. 4. Converting Docs to Pixel-Perfect Dossiers | MicroStrategy. Choose File > New > Intelligent Cube. 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. 3. An Enhancement Request for implementing this functionality is. Environment connection is lost when using Kerberos and creating an Intelligent Cube in MicroStrategy Workstation. Click Select. To Create an Intelligent Cube Using Freeform SQL or Query Builder. KB321029: In MicroStrategy 10. Defining the partition for Super Cubes. There are multiple components and services replying on MicroStrategy Messaging Services. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. MicroStrategy has a metadata-driven architecture. Select Intelligent Cubes > General > Intelligent Cube File directory. Description. #Microstrategy Best Practices; #Microstrategy custom group; #Microstrategy dashboard; #Microstrategy delimited file; #microstrategy filter;Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. 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. From the Edit menu, select Training Metric Wizard. Number of Views 3. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. Although this setting is listed Caching > Result Caches under the Project Configuration it also applies to the Intelligent Cube caches for that project. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent Cube is repeated for every row. Starting in MicroStrategy 10. 3. Click the link below to view this article: This document summarizes the best practices and the general conventions for MicroStrategy product suite. MicroStrategy recommends the following best practices to reduce the memory size of your Intelligent Cubes: Attributes commonly use numeric values for their ID forms. If the Intelligent Cube must be re-processed based on a metric. KB442526. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesIn MicroStrategy 9. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Lastly, you will learn to use Hadoop for MicroStrategy reporting. When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. 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. Starting in MicroStrategy 10. Once activated, the user loads the cube in memory. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. In MicroStrategy 10. KB442424: Best Practices for MicroStrategy Messaging Services. Best Practices Privileges and Security Access in Workstation MicroStrategy has a rich security model that consists of three major components - privileges, security filters, and permissions. For more information on cache encryption, review the following article: KB31094: New feature in MicroStrategy Intelligence Server 9. Publisher (s): Packt Publishing. The Intelligent Cube that serves as the source for the example view report is configured to normalize incoming attribute data in the database using the option "Normalize Intelligent Cube data basing on dimensions with NO attribute. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. Will it affect the performance of already existing MicroStrategy components?How to Start and Stop Intelligence Server Services in Microstrategy By Mohan Vamsi PentakotaOverview of MicroStrategy Training in Chennai. MicroStrategy Developer, Web, and Office users can slice and dice data in reports within Intelligent Cubes without having to re-execute SQL against the data warehouse. Number of Views 1. Intelligent Cubes allow you to create sets of data that can support multiple reports that answer variations to similar business queries. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. MCE features a fully optimized version of the MicroStrategy Intelligence Platform built specifically forThe status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Dedicate a machine for the metadata repository. application performance and security best practices. x-10. The cube population process could be expensive in time and memory if the cube is large. With OLAP Services features, your report designers can create Intelligent Cube reports. Web log. For an Intelligent Cube to satisfy the data requirements of a report, the Intelligent Cube and report must have matching settings for VLDB properties that can affect the data that. Object Manager cannot undo the copying and replacing of objects. We're using a RaspberryPi with Sense HAT to capture telemetry, which is directly pushed in a MicroStrategy In-Memory cube. 0. All articles. Click the link below to view this article: This document summarizes the best practices and the general conventions for MicroStrategy product suite. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. MDX Cube Reporting Guide Version 10. If user downloads the . By default, the location configured will be a relative path where ". Create Cube B which contains all objects in the report and publish it . It happens in MicroStrategy Developer 9. Start a Pilot Solutions Powerful analytics for any industry. A document that uses the Intelligent Cube as a dataset. x product documentation "InMemoryAnalytics. This article explains why the Intelligence Cubes are not published via subscriptions to both nodes of a cluster in MicroStrategy 2019 and later versions. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. IS_PROJ_ID. 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. IsCubeRepStats, but not in PA warehouse tables LU_CACHE or fact_latest_cube_cache . Ensure that the Dependency Search, Conflict Resolution, International, and Migration options in the. This article narrates large cubes appear in ‘LP’ status and some other cubes not shown up in cube monitor in MicroStrategy 2021 is due to loading cube info thread being blocked by loading the large cube instance. KB31566: MicroStrategy 9. Best practices for supporting dynamic sourcing. x Intelligent Cubes. In your Datasets panel, hover over the name of your dataset. 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. ACTION: 1. To enable. x and 10. KB415730. The SQL-based DI model is described in Providing Data Internationalization. KB441987: Best Practices for increasing performance of publishing. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube. Agile BI - Learn how to stream data In-Memory within the MicroStrategy platform, and run analytics on top of that live data. Place intelligence server close to the both the data warehouse and the metadata repository. x-10. 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. If you are new to designing documents, see Best practices for designing effective documents before you begin a new document. x and later, users should make sure to take into account the following. x - 10. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;This section describes the ways in which you can design and create a MicroStrategy Report Services document. Number of Views 18. CAUSE: It is designed behavior that History List subscription job cannot be assigned to other than the user who is creating the subscription. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes Number of Views 8. Number of Views 15. Creating an Intelligent cube is similar to creating a report. The following diagram depicts the role of the intelligent cube. Expand the Object Templates category, select General, and from the Show templates for the. x Enterprise Manager, running the out-of-the-box report "Intelligent Cube Usage Statistics". Using Object Manager, the above cube based reports are migrated into Production. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformHello<br><br>Please allow me to elucidate how my data analyst skills can significantly contribute to your organisation's business growth. 4. This knowledge base article documents the best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy and how duplicate columns can be created. Microstrategy Dossiers With the release of MicroStrategy 10. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. On the toolbar, choose Data > Configure Intelligent Cube. 46K. First, you open a blank document and select a report to use as the document's dataset. This.