The. 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. 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. Save the Report and close. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. A document that uses the Intelligent Cube as a dataset. CACHE_FILE_SIZE: The file size of the Intelligent Cube, returned as an integer. x installation and deployment. MicroStrategy is an enterprise business intelligence (BI) application software vendor. Relationships with Multi-Table Data Import. In direct connection deployments, client products (such as MicroStrategy Developer) should also. Apart from the best practices listed above, additional considerations apply when you are using Intelligent Cubes that are incrementally refreshed. Define MicroStrategy Best practices for development, testing. To learn more about Super Cubes and relevant best practices, refer to the following Community Article:In MicroStrategy 11. From the Data menu, select Configure Intelligent Cube. Part 1. 13K KB31566: MicroStrategy 9. 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. Starting in 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. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. mtc is the name of the saved test file. Snowflake Conventional data warehouses weren’t designed to keep up with the exploding demand for data-driven insight at modern organizations. 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. Create Intelligent Cube Reports; Explain different types of derived elements; Creating derived elements; Group and Filter derived elements;This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. Designing and creating documents: An overview. Please refer to the following article to check all the. SAP HANA Query Execution. For example, if the Intelligent Cube restricts data to only the year 2010, the report must include the same restriction. 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. MicroStrategy 9. 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 main thing to keep in mind is that the A,F size is the I-servers best guess as to what the size in-memory will be once it is loaded. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. More about Feature flags can be found in this article. Published August 27, 2020 By akrish1982. The tooltip will show the dataset type listed as a Super Cube. Normalization is critical to obtain correct results, particularly for dimensional metrics, in any aggregation performed by the Analytical Engine. 98K. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Number of Intelligent Cube Publishes: Number of Cube Publishes: Counts the number of times a cube was published. The motivation of using the semantic layer in MicroStrategy SQL Query Engine when connecting to Snowflake. From the Edit menu, select Training Metric Wizard. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube. 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. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. Text and CSV files: Varies depending on the Intelligence Server memory. Existing best practice recommendations for needle and syringe programs are out of date. IS_CUBE_INST_ID. Within the set. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Replace the first “/” by “” in the Intelligent Cube file directory option. Memory Storage for document or dossier. 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 the use of dynamic sourcing between reports and Intelligent Cubes. This article describes the Intelligent Cube Population options available in MicroStrategy. Module 14: Practices on MicroStrategy Best . The path for cube files must be shared as "ClusterCube". It serves as the starting point for new developers to get This article describes the best practices for using dynamic sourcing in MicroStrategy. From the results of single cube publish testing which records and compares the time spent for a single cube (4M rows) republish, JDBC driver has better performance than ODBC driver. We cannot include custom groups, consolidations, derived metrics, prompts, or view filters in an intelligent cube. Trending Articles. The report filter must include at least the same restrictions as the Intelligent Cube’s filter, if present. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. 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. Our MicroStrategy Admin certification training course lets you master MicroStrategy administration. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. In MicroStrategy Developer or Web, log in to a project that contains Intelligent Cube reports. MicroStrategy version 9. System Sizing Guidelines The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. view reports. Number of Views 8. 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. This can improve the performance of. 4. 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. SAP BW obtains data from R/3, CRM, SEM, or another SAP data source system. 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. Intelligent Cubes erstellen. 88K. CACHE_STATUS: A status of the Intelligent Cube, returned as an integer: 1: Processing. 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. 4. 13K. Number of Views 18. If the Intelligent Cube is at Month level, the user's report should also be at Month level. 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. x environment, Cache Hit Count or the Last Hit Time of a. 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. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. 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. 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. 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. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. 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. Number of Views 15. 29K. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. x product documentation "InMemoryAnalytics. 6 and below, this feature was only available when re-pointing an existing report from one OLAP cube to another OLAP cube or re-pointing the report from one MTDI cube to another OLAP cube. 4. Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. 4. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. For more information, refer to the following MicroStrategy Knowledge Base technical note: KB6022: MicroStrategy Intelligence Server Cluster Configuration GuideIn Enterprise Manager 10. Best practices for supporting dynamic sourcing. Open the Workstation window. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 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. The objects stored in the metadata are reusable. Please make sure that this is disabled. 84K. 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. x and newer? Number of Views 4. Office Intelligence, MicroStrategy Office. Expand Intelligent Cubes, and then select General. 3 - Check the Make Intelligent Cubes. The Training Metric Wizard opens. From the results of single cube publish testing which records and compares the time spent for a single cube (4M rows) republish, JDBC driver has better performance than ODBC driver. In MicroStrategy Intelligence Server 9. Defining the partition for Super Cubes. 4. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. A user creates a report that connects to this Intelligent Cube, and includes Year and Revenue on the report. , Cube Filter: Year between 2006 and 2010; Report Filter: Year in (2007, 2008) Report filter should at least filter on all attributes and attribute forms. Use the Intelligent Cube Editor to access all of the features and functionality for creating cubes. Job ID for the action on the Intelligent Cube. A report that runs against the Intelligent Cube. als Berichtsobjekte oder Berichtsfilter einschließen. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. Description Starting in MicroStrategy 2021 Update 1, you can connect to the on-premise database from the MicroStrategy cloud via Gateway Agent. Using attributes defined in this way can save space as compared to attributes that use character strings for their ID forms. This article explains why the Intelligence Cubes are not published via subscriptions to both nodes of a cluster in MicroStrategy 2019 and later versions. Number of Views 3. The following list summarizes which privileges can be assigned for which user groups: Common privileges: The predefined MicroStrategy Web Reporter and Analyst user groups are assigned the set of common privileges by default. It lets you various. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and. x. For example, these reports go from basic execution pointers, quarterly deals by item. Type of action against the Intelligent Cube: •Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. 86K KB31566: MicroStrategy 9. If you use Enterprise Manager (EM), dedicate a machine for. When an Intelligent Cube is in this status, any reports based on this cube have. MicroStrategy recommends the following best practices to reduce the memory size of your Intelligent Cubes: Attributes commonly use numeric values for their ID forms. Currently, project duplication does not involve Intelligent Cube File Directory. 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. MicroStrategy Developer, MicroStrategy Web 및 MicroStrategy Office 사용자는 데이터 웨어하우스에 대해 SQL을 다시 실행할 필요 없이 Intelligent Cube 내의. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesIn MicroStrategy 9. 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. Designing and creating documents: An overview. C:\Program Files (x86)\MicroStrategy\Web ASPx\WEB-INF\log. Style and approachThis book will be focusing on providing extensive guide to plan how to design and develop complex BI architecture. Object Manager cannot undo the copying and replacing of objects. 2) Choose "Database" and select the 3rd option to "Pick tables". 16: Intelligent Cube dirty. These are meant to restrict the ability to perform certain privileged actions. Education. The data in this cube is as given below. 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. MicroStrategy Platform-intelligence server is an improved testing system for big business questions. xMicroStrategy recommends that you observe the following practices when copying objects with Object Manager in MicroStrategy 10. 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. Such instances can be a problem, as they may impact the accuracy of your data analysis. Learn more about it at MicroStrategy. . Overview. In MicroStrategy 2021, we introduce a new cube type called Attribute Form Caching cube. 11, a new feature is available for performance optimization when dealing with derived attributes. table_name: is the name of a table. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9. Shipped driver refer to Data Direct driver which installed along with MicroStrategy Intelligence ServerThis article describes features that are not supported when using Dynamic Sourcing. In your multi-form attribute, right-click on the Image attribute and select Change Data Type > HTML Tag. 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. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. x as the MicroStrategy environment is applying the System Prompt 'User Login' at the time of Intelligent Cube publication. Retail Optimize sales across channels. Synapse Analytics leverages a scale out architecture to distribute computational processing of data across multiple nodes. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. KB45837: How does the Incremental Refresh option work in MicroStrategy Analytics Enterprise 9. To access the setting, in MicroStrategy Developer right-click on the project and select Project Configuration…Then, In the Project Configuration dialog box, choose Project Definition >. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. x Attributes used in the filter should also be on the Intelligent Cube’s definition. Run the Report and check the SQL View. 3. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. 4. In-memory Cube Reporting: OLAP vs MTDI and Best Practices. If the Intelligent Cube must be re-processed based on a metric. KB442424: Best Practices for MicroStrategy Messaging Services. MicroStrategy’s In-memory technology is engineered to meet the. Published: 4월 6, 2017. Recorded at World 2021. C:Program Files (x86)MicroStrategyWeb ASPxWEB-INFlog. In MicroStrategy Desktop 9. xTo Create a Report that Accesses an Intelligent Cube. x - 10. 000007431. 4. 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 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. x Intelligent Cube status indication and workflow. 4. You should periodically reevaluate the system and. By default, the location configured will be a relative path where ". 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. 0, the only way to create an intelligent cube (also. Number of Views 15. 1319 views | February 11, 2021 45:05. 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 . 0. x and later, users should make sure to take into account the following. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Required Status to Perform Action. Updating Intelligent Cubes without re-processing: Incremental Refresh. Forecast Sales. 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. Web log. Recorded at World 2021. 4. SHOPMAN, powered by MicroStrategy, delivers sensor data, inventory management, and financial data to enable users make data-driven. Rather than returning data from the data warehouse for a single. 1. Before MicroStrategy 10. This will create an Intelligent Cube for the data of the Excel file to be accessed. x? This is a guest blog post co-written by Amit Nayak at Microstrategy. A set of data is returned from the data warehouse and saved directly to the Intelligence Server memory. This article describes best practices to be taken when using a Teradata database in MicroStrategy. Version 9. x releases, and the new Multi-table Data Import (MTDI) cubes. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. IS_PROJ_ID. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. 15K. Published: Apr 6, 2017. For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. On the toolbar, choose Data > Configure Intelligent Cube. This article provides some best practices for decreasing the Intelligent cube publish time against Oracle in MicroStrategy. rare practice (British Columbia Ministry of Education, 2011, p. x-10. Expand Intelligent Cubes, and then select General. 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. Our vision is to enable Intelligence Everywhere. To build an Intelligent Cube. It must be ensured that the Windows NT account used to run the MicroStrategy Intelligence Server on every node has access to the shared folders. x. Place Intelligence Server close to the both the data warehouse and the metadata repository. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. MicroStrategy Internal Reference number for this technical note is KB483620 and DE128512. OLAP vs MTDI and Best Practices. The path for cache files must be shared as "ClusterCaches". Therefore we need 20GB RAM memory to store the cube. 10/12 videos | 6H 47M 28S total runtime. 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. Intelligent Cubes. x Intelligent Cube status indication and workflow. Microstrategy also recommends that customers to follow best practices for cache files during an upgrade: delete the cube caches > upgrade > republish them. This data is stored in cubes or other SAP objects. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. There is a distributed database for the MicroStrategy metadata and statistics. Query Optimization 2. mstr) files that can be sent through Distribution Services is defined by the MicroStrategy (. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. The ‘’ at the start of the path is required to indicate to the MicroStrategy Intelligence Server that the specified path is a remote location. 4. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. There are multiple components and services replying on MicroStrategy Messaging Services. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Number of Views 5. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement intelligent. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. Drilling can also be enabled outside of an Intelligent Cube for full ROLAP analysis. Intelligence Server Statistics . Query Generation. Relationships with Multi-Table Data Import. Rather than returning data from the data warehouse for a single. (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. Option 1: Publish the cube in the Intelligence Server node not being in Maintenance Mode. Click the MicroStrategy icon at the upper left of any page and select History List. Instead of always executing against the data warehouse. x: Ability to encrypt cache files stored to disk. The first step in analyzing. A dataset is a set of data that can be displayed on a document. Discover MicroStrategy 2021 > It serves as the starting point for new developers to get familiar with the MicroStrategy architecture and development framework. Conditional metrics. x, but not to publish it, the minimum privileges that the Administrator would need to. First, you open a blank document and select a report to use as the document's dataset. x product documentation "InMemoryAnalytics. Required Status to Perform Action. Object Migration Best Practices. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. MDX Cube Reporting Guide Version 10. The Dynamic Sourcing feature in MicroStrategy OLAP Services 9. iCubes or Intelligent Cubes are objects that provide pre-cached data which can be queried on the reports. 3. This command will deactivate the Intelligent Cube cache so reports from this Intelligent Cube will not be able to run while it is being re-published. Because of this, OLAP cubes are traditionally built and maintained by advanced BI developers or architects. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. Die Erstellung eines Intelligent Cube ähnelt der Erstellung eines Berichts. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Open the Workstation window. Person-centred care is a collaborative approach in which health care professionals’ partner with patients to deliver personalized care with a focus on physical. KB439693: Best practices for MicroStrategy 10. 3. 4. 2. application performance and security best practices. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. From the CatalogCube drop-down list, select the MDX cube to create training metrics for. You must belong to the System Administrators group to use this feature. How to configure, monitor, and manage Intelligent Cubes. This paper provides an overview of MicroStrategy and Azure SQL Data Warehouse (SQL DW) architectures and best practices for integrating the two technologies to deliver business intelligence at scale. For detailed information refer to the System Administration Help. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. The report and Intelligent Cube must be based on the same source MDX cube. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. The Editor and Filter panels are stacked together by default. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. 0 MicroStrategy releases. Consider a data import dataset which has been imported into MicroStrategy. Discover MicroStrategy 2021 > Events;It serves as the starting point for new developers to get familiar with the MicroStrategy architecture and development framework. g. Build world-class enterprise Business Intelligence solutions with MicroStrategy 10 About This Book Fix the gap between BI tools and. In-memory analytics enables you to create in-memory cubes using the Multi-Table Data Import feature. 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. 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 . x. If the New Intelligent Cube dialog box does not open, from the Tools menu, select Developer Preferences. x. Adaptations are teaching and assessment strategies especially designed to accommodate a student’s needs so he. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. The Intelligent Cube Options dialog box opens. Title: Mastering Business Intelligence with MicroStrategy. MicroStrategy Reporting Suite is an absolute leader in the BI market and offers rich capabilities from basic data visualizations to predictive analytics. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. DESCRIPTION: Starting MicroStrategy 10. 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. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. Prompts in a report. Description. x: Back up metadata before copying any objects. Refer to Product Manual for more detailed information. Published: May 29, 2019; Last updated: Oct 29, 2019; Related versions: To build an Intelligent Cube. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. The Full Refresh option is the default. Navigate to the Data Refresh category. • Education Sandbox: Leverage new features and best practices, hands-on in your own environment. 7. This is the most popular MicroStrategy Interview Question asked in an interview. KB485674: Create Super Cube from Excel file and update it with a script in. Run report off cube.