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. 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. An Intelligent Cube has been created in a project. MicroStrategy provides modern analytics on an open, comprehensive enterprise platform used by many of the […] This article describes best practices to be taken when using a Teradata database in MicroStrategy. Release date: July 2016. For information on incrementally refreshing Intelligent Cubes, see Updating Intelligent Cubes without re-processing: Incremental Refresh. Number of Intelligent Cube Publishes: Number of Cube Publishes: Counts the number of times a cube was published. STEPS TO REPRODUCE 1. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. 1. x, create a simple Intelligent Cube with attribute Category and metric Revenue. 8 to help improve the performance of Quick Search on MicroStrategy Web. 8. Configure a Cluster with a Centralized Cache. Published: Apr 6, 2017. xKB441285: Optimization for the Intelligent Cube Data Structure at the time of publication. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. Because of this, OLAP cubes are traditionally built and maintained by advanced BI developers or architects. This feature is best illustrated with an example. Adaptations are teaching and assessment strategies especially designed to accommodate a student’s needs so he. Use the Intelligent Cube Editor to access all of the features and functionality for creating cubes. Integer ID of the project where the Intelligent Cube is stored. Filename. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Please make sure that this is disabled. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. 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. Published August 27, 2020 By akrish1982. Click 'Prepare Data' if further processing is required or click 'Finish' if it is not required. Performance also refers to the speed of loading or rendering data via in-built features like scanning,. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Place Intelligence Server close to the both the data warehouse and the metadata repository. 0. Apart from the best practices listed above, additional considerations apply when you are using Intelligent Cubes that are incrementally refreshed. Resources Company Bitcoin Lightning Home Published: August 11, 2022 • 619 Views Advanced Properties for Intelligent Cubes MicroStrategy Workstation. Title: Mastering Business Intelligence with MicroStrategy. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. 8: Monitoring information dirty. Agile BI - Learn how to stream data In-Memory within the MicroStrategy platform, and run analytics on top of that live data. Intelligent cube; Advanced reports; Creating and adding data to the document;To view an Intelligent Cube stored in your History List. 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. 3. The following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. 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. 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. After completing your certification, you’ll receive a digital badge that highlights your accomplishment, which you can post on social media. Afterwards the cube will start executing. LIST ALL INTELLIGENT CUBE CACHES IN PROJECT "Development Project 5"; ResultSet Columns. Before MicroStrategy 10. Job ID for the action on the Intelligent Cube. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. rare practice (British Columbia Ministry of Education, 2011, p. Integer ID of the project where the Intelligent Cube is stored. 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. If the Intelligent Cube must be re-processed based on a metric. The New Grid dialog box opens. KB31566: MicroStrategy 9. Create a report based on above Cube and add the prompt in view filter. 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. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. In-memory analytics enables you to create in-memory cubes using the Multi-Table Data Import feature. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. This article provides some best practices for decreasing the Intelligent cube publish time against Oracle in MicroStrategy. 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. Number of Views 3. 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. Publish the Intelligent Cube by executing it on either of the nodes. Take a Data Import Cube similar to below. The attached document details the differences between OLAP and MTDI cubes, including the basis for the performance profile of each and the available. The motivation of using the semantic layer in MicroStrategy SQL Query Engine when connecting to Snowflake. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. However, if the. The Full Refresh option is the default. MicroStrategy recommends the following best practices to reduce the memory size of your Intelligent Cubes: Attributes commonly use numeric values for their ID forms. 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. MicroStrategy Real-Time Analytics. 3. The Java XML API log will record all the XML communications between Intelligence Server and Web. 5. x?The value of Composite Metrics displays with “--“ in Intelligent Cube based Report in MicroStrategy 9. 88K. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. MicroStrategy Web Based Training (WBT), MicroStrategy World, Office Intelligence, Best in Business Intelligence, Pixel Perfect , Global Delivery Center,. view reports. Because a single Intelligent Cube cannot connect to more than one data warehouse, using a. Designing and creating documents: An overview. x. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Watch on. For example, these reports go from basic execution pointers, quarterly deals by item. Rather than returning data from the data warehouse for a single. 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. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. 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. 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 ID is found with the heading. 1. It remains available, but is not enforced if it is less than the default value of 100000. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and cube optimization techniques for MicroStrategy. In MicroStrategy Desktop 9. KB442525. HIT_COUNT: The current hit count of the Intelligent Cube, returned as an integer. It depends on the cube. 3. For more information on cache encryption, review the following article: KB31094: New feature in MicroStrategy Intelligence Server 9. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes. MicroStrategy’s new Gateway connector can enable analysts to derive new. 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. Web XML API log. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Required Status to Perform Action. 3 - Check the Make Intelligent. Visit the data visualization and data dashboard galleries for inspiration. 4. Starting in MicroStrategy 10. 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. Document number: 09481030Our product specialists walk you through best practices for successfully setting up and configuring the out-of-the-box tool Platform Analytics tool. x. For information on creating Intelligent Cubes using Cube Advisor, see Reviewing and creating recommended Intelligent Cubes. For best practices on compatibility and interoperability, as it relates to upgrading a MicroStrategy system,. x) or OLAP (first generation of in memory cubes, introduced in 9. Go to the Intelligent Cube monitor to identify the cube instance ID: under the three-tier project source, Administration > System Monitors > Caches > Intelligent Cubes. x: Back up metadata before copying any objects. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect Live. 1180 views | February 10, 2021 29:25. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal. This article describes the Intelligent Cube Population options available in MicroStrategy. 4. Best Practice for interview Preparation Techniques in MicroStrategy. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. E. Text and CSV files: Varies depending on the Intelligence Server memory. Ensure that the Dependency Search, Conflict Resolution, International, and Migration options in the Object. Analyze the low performance query using DBA knowledge, add. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. There are multiple components and services replying on MicroStrategy Messaging Services. 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. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes Number of Views 8. Do you have reports that currently access. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". In MicroStrategy 2020 Update 2, the size of the Intelligent Cube keeps gradually increasing even after setting the Maximum % growth of Intelligent Cube to 50%. Product information. Expand the Object Templates category, select General, and. You can edit project-level cache and Intelligent Cube settings. 4. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Create a Report 'R3' with 'Country' attribute. Object Manager cannot undo the copying and replacing of objects. Edit Project-Level Cache and Intelligent Cube Settings. For example, the objects developed in a development environment can be copied to a UAT environment to. In the Navigation pane, click , next to Datasets. Intelligent Cubes. MicroStrategy 9. Description. Such instances can be a problem, as they may impact the accuracy of your data analysis. IS_PROJ_ID. With MicroStrategy OLAP Services, transformation metrics used in standard reports can resolve against Intelligent Cubes under the following conditions:. Query Generation. 1. 0, the only way to create an intelligent cube (also. User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables. 1319 views | February 11, 2021 45:05. CREATOR: User who created the Intelligent Cube cache, returned as a string. Number of Views 18. Click ' Choose files' and select your Excel file or drag and drop the Excel file into the window. . For details, please refer to the Technical Note below. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". 1. All the attribute forms are in bold type and will display in Intelligent cube reports. 3. x and 10. It lets you various. 4. IS_CUBE_INST_ID. Before MicroStrategy 10. Number of Views 5. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. 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. STATUS_LIST: A ResultSet listing the statuses of the Intelligent Cube. Hear from eBay’s Business Intelligence Architect as he discusses big data best practices, top intelligent cube use cases, and cube optimization techniques for MicroStrategy. (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. 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. 4. The syntax is: FileLocation is the path to the saved test file. The Intelligent Cube Options dialog box opens. From the Edit menu, select Training Metric Wizard. Filters on the report must meet the following criteria: Attributes used in the filter should also be on the Intelligent Cube's definition. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. 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. Intelligent Cube Using Microstrategy 9. MicroStrategy Internal Reference Number for this technical note. In the grid display of the report, hold down the CTRL key and select multiple attribute elements within the same attribute. 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. Number of Views 15. You must belong to the System Administrators group to use this feature. Hardware requirements and recommendations. Number of Views 3. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. x Enterprise Manager, running the out-of-the-box report "Intelligent Cube Usage Statistics". They were used to improve subsequent query. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. x and later, users should make sure to take into account the following. x Intelligent Cube status indication and workflow This section describes the ways in which you can design and create a MicroStrategy Report Services document. Create Cube A and a report based on it. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. Download the attached PDF for an in-depth understanding of Object Migration best practices. rare practice (British Columbia Ministry of Education, 2011, p. Required Status to Perform Action. ACTION:15. x - 10. CACHE_STATUS: A status of the Intelligent Cube, returned as an integer: 1: Processing. Intelligent Cube design and utilization; how to build cubes, schedule them,. When we mention performance, we mean the speed by which HyperWeb scans keywords to present data via HyperIntelligence cards. 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. Converting Docs to Pixel-Perfect Dossiers | MicroStrategy. blogspot. Relationships with Multi-Table Data Import. x releases, and the new Multi-table Data Import (MTDI) cubes. SAP BW obtains data from R/3, CRM, SEM, or another SAP data source system. CACHE_FILE_SIZE: The file size of the Intelligent Cube, returned as an integer. KB439693: Best practices for MicroStrategy 10. ISBN: 9781785884405. OLAP cubes are authored through Developer and are tightly coupled to a MicroStrategy project schema. To learn more about Super Cubes and relevant best practices, refer to the following Community Article:In MicroStrategy 11. The report filter must include at least the same restrictions as the Intelligent Cube's filter, if present. x and 10. To enable. The Data Transfer Rate varies from 27 to 28 Mb/s. In MicroStrategy 10. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. 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. Number of Views 2. Locate the published cube, right-click on it and choose Quick View. 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. To enable. Go to Data -> Configure Intelligent Cube -> General and set both "Make Intelligent Cube available for Dynamic Sourcing" and "Allow Dynamic Sourcing even if Outer Join properties are not set" to ‘Enabled‘. Query Generation 3. MicroStrategy Intelligence Server, MicroStrategy Intelligence Server Universal, MicroStrategy Distribution Services, MicroStrategy Report Services,. x. A dataset is a set of data that can be displayed on a document. 3. A document that uses the Intelligent Cube as a dataset. For example, derived metrics can be used to subtract the data of one. 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. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. Derived metrics are easy to create and can be made on-the-fly when you are viewing or creating a report, allowing you to create a metric while focusing on a given report. This article also provides a workaround to avoid this behavior. x. To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor, select Create Freeform SQL report. WORKAROUND . x) and view reports based on MicroStrategy 9. Starting 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. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy environment. 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. 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. Published: Apr 6, 2017. Solution Gallery. 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. Recorded at World 2021. MicroStrategy recommends the following best practices to keep your system running smoothly and efficiently: Use the project life cycle of development, testing, production to fully test your reports, metrics, and other objects before releasing them to users. 4. From the CatalogCube drop-down list, select the MDX cube to create training metrics for. mstr) file size (MB) setting. 11 it is possible to have split child hierarchy attributes join through a shared fact table rather than through a parent with Data Import Cubes. 4. • Education Sandbox: Leverage new features and best practices, hands-on in your own environment. Number of Views 1. x product documentation "InMemoryAnalytics. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. Published: Dec 31, 2018; Last updated: Jul 25, 2023 Intelligence Everywhere. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesIn MicroStrategy 9. x. Replace the first “/” by “” in the Intelligent Cube file directory option. Intelligent cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement intelligent. Object Migration Best Practices. Features that can be supported by dynamic sourcing include, but are not limited to, the list below: Security filters. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. In direct connection deployments, client products (such as MicroStrategy Developer) should also. Die Erstellung eines Intelligent Cube ähnelt der Erstellung eines Berichts. MicroStrategy Reporting Suite is an absolute leader in the BI market and offers rich capabilities from basic data visualizations to predictive analytics. MDX, CSI" in Web. 05K. The metadata is a central repository, which stores all the objects used by it. To enable or disable dynamic sourcing for an Intelligent Cube. x. KB36667: Best practices for Dynamic Sourcing in MicroStrategy. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. KB441987: Best Practices for increasing. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. 4. The Intelligent Cube Options dialog box opens. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. 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. IS_CUBE_REP_ID. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. 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. Number of Views 18. , May 6, 2010 -- MicroStrategy® Incorporated (Nasdaq: MSTR), a leading worldwide provider of business intelligence (BI) software, today announced that its In-memory technology delivers significantly higher performance for BI applications, even at the highest scale. Object Migration is the process of migrating or moving objects from one environment to another environment. To do so, you can take advantage of URL API. x. It will track and log all. PublishCube". Microstrategy also recommends that customers to follow best practices for cache files during an upgrade: delete the cube caches > upgrade > republish them. 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. Place intelligence server close to the both the data warehouse and the metadata repository. x - 10. You should periodically reevaluate the system and. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Login MicroStrategy Developer, create User M20061 with security filter defined as: Month in {20061} Create Intelligent Cube C01 with: Attribute Quarter, Month, Country, Region and Metric Cost, Region, and publish the cube. This. If you are new to designing documents, see Best practices for designing effective documents before you begin a new document. 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. 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. KB19048: Best practices for collecting cache and history list (inbox) files for troubleshooting in MicroStrategy Intelligence Server 9. KB32618: How to provide Intelligent Cube files to MicroStrategy Technical Support for troubleshooting purposes in MicroStr… Number of Views 18. All articles. Generate Oracle AWR report or monitor the database to identify the low performance query. For example, if the Intelligent Cube restricts data to only the year 2010, the report must include the same restriction. Retail Optimize sales across channels. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. x. x and newer? Number of Views 4. ElasticSearch is an open-source search engine based on Lucene that provides multitenant-capable full-text search capabilities. Either import tables using Warehouse Catalog in MicroStrategy Developer or create Intelligent Cubes directly using MicroStrategy Web Data Import with the 'Databases' option. Save the Report and close. Tell a story with your data using the dossier chapter/page format. This document provides a list of settings that Administrators can tune to help improve Cube Publication times in MicroStrategy Secure Enterprise 10. Using attributes defined in this way can save space as compared to attributes that use character strings for their ID forms. Published: Jan 29, 2019;. Available PA data is stored in the cube that has a default limit set to 20GB or RAM. It will track and log all communications at the “XML API. MicroStrategy’s In-memory technology is engineered to meet the. The ‘’ at the start of the path is required to indicate to the MicroStrategy Intelligence Server that the specified path is a remote location. To Create an Intelligent Cube Using Freeform SQL or Query Builder. This documentation is intended to provide some guidelines for BI administrators to maintain Messaging Services. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. III. In section General at the bottom of displayed window there is a check box with option "Hidden". System Sizing Guidelines The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. Hear from Jeff Stitzel, Business Intelligence Architect at eBay, as he discusses big data migrations, intelligent cube use cases, and cube optimization techniques with MicroStrategy. Run the Report and check the SQL View. To build an Intelligent Cube. x?Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Our vision is to enable Intelligence Everywhere. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. 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. Ab MicroStrategy 2021 Update 5 können Sie Intelligent Cubes erstellen. x? Number of Views 5. Click All Objects View. x as the MicroStrategy environment is applying the System Prompt 'User Login' at the time of Intelligent Cube publication. This article provides information about system sizing guidelines, hardware requirements and recommendations, recommended system settings for UNIX and Linux, etc. Apart from the best practices listed above, additional considerations apply when you are using Intelligent Cubes that are incrementally refreshed.