To enable or disable dynamic sourcing for an Intelligent Cube. Until then, efectively delivering the last. Navigate to the Data Refresh category. Business intelligence is becoming more important by the day, with cloud offerings and mobile devices gaining wider acceptance and achieving better market penetration. Two unique methods to implement Intelligent Cube Technology: •Personal Intelligent Cubes: You can begin by creating reports in MicroStrategy as usual, and then analyze your reports with OLAP Services features such as. To enable. Click the “Add history list subscription” link near the bottom of the screen to open the. To enable or disable dynamic sourcing for an Intelligent Cube. In an Intelligent Cube report, only the "Data Population for Intelligent Cubes" will be visible; in standard reports, it will be "Data Population for Reports. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. In the left panel, click Cubes. Published: May 15, 2018;This document provides settings that can be adjusted to help decrease Intelligent Cube publication times in MicroStrategy Secure Enterprise 10. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Creating Intelligent Cubes The Freeform SQL Editor and the Query Builder Editor provide alternative methods to create reports in MicroStrategy. x - 10. 3. 2. Right-click the dataset, and choose Schedule. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. The procedure below provides the steps to manually publish an Intelligent Cube. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. The Intelligent Cube “xxx” for locale <German (Germany)>has not been published. Expand the Object Templates category, select General, and. 0. Server Logout. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. In HTML View and PDF View, a dashboard is displayed as a static document. 88K KB41697: "The Intelligent Cube must be published before this report can be executed. To that end, we’ve designed a program of continuous training and certification for every role in your Intelligent Enterprise. Analyzing SQL and For detailed information about Intelligent Cubes, see the In-memory Analytics Guide. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. If an attempt to load an Intelligent Cube is made that would exceed the limit, an Intelligent Cube is removed from Intelligence Server memory before the new Intelligent Cube is loaded into memory. 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. If the objects (metrics/attributes) on an Intelligent Cube have restricted access (via ACLs), such cubes will be implicitly treated as live-connection cubes and hence won't be eligible for use with delivery as an MSTR fileThe Intelligent Cube Editor offers control over advanced properties. Navigate to the folder location of the Intelligent Cube. Build a cube of customer data that’s relevant to all employees and publish it. INTELLIGENT_CUBE_MAX_NO: The maximum number of Intelligent Cubes allowed in the project, returned as an integer. Select a schedule from the Schedule drop-down list. Export to PDF, web sort, document design. 4. 4. 0: Balance MicroStrategy Server threadsReporting on an Intelligent Cube provides quick access to data, as the data has been pre-aggregated. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Intelligent Cube storage on disk mirrors report cache storage. Sie können Daten für Ihren Intelligent Cube hinzufügen, indem Sie Objekte wie Attribute, Metriken, Filter usw. Expand Intelligent Cubes, and then select General. An Intelligent Cube is a set of data that can be shared as a single in-memory copy, among many different reports created by multiple users. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. The Intelligent Cube Monitor is displayed. The Intelligence Server brings the live-connect intelligent cube definition from the metadata and analyzes the information requested from that definition. In addition to creating reports directly, you can use the Freeform SQL Editor or Query Builder Editor to create an Intelligent Cube. This document discusses a specific case regarding how security filters are applied when the Intelligent Cube has non-aggregatable metrics. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. 0. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. Data in Intelligent cubes can be either marked as available for time zone conversion when running objects against it or set within a specific time. 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. It depends on the cube. Sharing Sets of Data Among Reports: Intelligent Cubes describes the role of OLAP Services in the overall MicroStrategy architecture and how you can take advantage of Intelligent. This data can be used to create a. This is the most popular MicroStrategy Interview Question asked in an interview. This defect is addressed in MicroStrategy 11. This article also provides a workaround to avoid this behavior. Report Data Manipulation 5. To create a report that connects to an Intelligent Cube, in MicroStrategy Developer. Create an attribute element prompt for the. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. 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. Interested in learning more about Platform Analytics or new MicroStrategy features? Visit the Learning Center on Community! Or feel free to visit our Documentation pages for product information. KB485673: When "Create Intelligent Cubes by database connection" is enabled, the cube published with the latest data can't… Number of Views 157 KB484562: Intelligence Cubes are not published via subscriptions to both nodes of cluster in MicroStrategy 2019 and later. This article notes how support for transformation metrics in Dynamic Sourcing works. 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%. 0 or above, to pick up the fix, enable project level setting "Data Engine Version. The Subscription Editor opens. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 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 SQL Engine matches a view report, or a report that uses dynamic sourcing, with the corresponding Intelligent Cube. Drilling can also be enabled outside of an Intelligent Cube for full ROLAP analysis. Create Cube1 with the Region attribute and the metric created in step 1. x releases, and the new Multi-table Data Import (MTDI) cubes. Limit data to specific values: Filters 4. Introduction to advanced analytics 3. In order to set this limit, log on to MicroStrategy Desktop/Developer, right click on the desired project, and select “Project Configuration…” Navigate to Intelligent Cubes >> General, and enter your desired limit. Currently, project duplication does not involve Intelligent Cube File Directory. 4. - Normalize Intelligent Cube data in the. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. About this book. 0 MicroStrategy releases. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. com Format: A MicroStrategy Online Training Video blog. 4. After upgrading to MicroStrategy 2019 Update 2 or above, republishing a cube created by the MicroStrategy connector may fail and produce the error, "Refreshing dataset failed. 438832. Intelligent Cubes. 3. This article describes features that are not supported when using Dynamic Sourcing. Maximum memory usage for Intelligent Cubes (MB) Defines the amount of data required for all Intelligent Cubes to limit the amount of Intelligent Cube data stored in Intelligence Server memory at one time for a project. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is executed in. Published: Nov 19, 2018; Last updated: Nov 18, 2022;MicroStrategy version 9. User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables. In the left panel, click Cubes. All necessary privileges are included in the Administrator role by default. You can edit project-level cache and Intelligent Cube settings. Open the report or Grid/Graph (the example scenario uses a report connected to an Intelligent Cube), as follows: To access the Derived Elements Editor for a report connected to an Intelligent Cube: Execute the report. Right mouse click on the cube and choose Schedule 3. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Number of Views 1. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. 1. To plan for. Subsequently the requests made by other users can. 15K. x This is a new feature introduced in MicroStrategy version 9. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many different reports created by multiple users. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Intelligent Cubes can be partitioned,. x. 1 and 10. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. By the same token, our platform is also the source of valuable data. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and then select Intelligent Cubes. For more information on security filters, see the System Administration Guide. Prompts on reports that connect to Intelligent Cubes can only access data that is available within the Intelligent Cube. The storage for Intelligent Cubes was not setup properly. This can improve the performance of. 6, the MicroStrategy PDF Exporter (also known as New Export Engine or NEE) service has been added to support exporting from Visual Insight / Dossier to PDF format. If you are upgrading to MicroStrategy 11. You can also define when Intelligent Cubes. Choose Data > Configure Intelligent Cube. 54K KB31040: How to enable font size smaller than. Limit the use of derived attributes or derived metrics Derived elements like derived attributes and derived metrics are calculated on the fly by the MicroStrategy Analytical Engine, even when the data is coming from an intelligent cube, MicroStrategy still needs to calculate the derived elements and depending on the data size and. 1 and 10. KB30713: Data outside a user's security filter are indirectly available through set qualifications used in Intelligent Cubes in MicroStrategy OLAP Services; KB30714: Handling of security filters with multiple qualifications applied to Intelligent Cube view reports in MicroStrategy OLAP Services; Article Reference Number: KB99998 In the Navigation pane, click Monitors. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. idx file is cleaned up. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. If you select any Intelligent Cube reports, make sure that the Intelligent Cube the reports are based on has been published before you perform the integrity test. . When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. Click the Cube Mapping tab. Publish the cube. We empower you with the skills to get the most out of your analytics investment. 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. By default this is set to 256 megabytes. Published: Jun 1, 2017. In the Navigation pane, click Applications. 1 and 10. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. 1 and 10. Intelligent Cube file directory Specifies the file location in which Intelligent Cubes are stored when you select to save an Intelligent Cube to secondary storage. Action This issue is fixed in MicroStrategy 11. In MicroStrategy 2020, the password can be found in the Default_Accounts. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server memory reduces response time for reports using them. Users don’t have to mention the cube to which they want to connect. 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. Publishing Intelligent Cubes. 1 and 10. Administer database connections. This copy of report data is stored in Intelligence Server memory only. * Details on 2 possible causes for connectivity issues preventing the publication of Platform Analytics Intelligent Cubes. To support this configuration, you must ensure that the Intelligence Server host machine uses values greater than or equal to the resource limits described below. Name the different export. Dedicate a machine for the metadata repository. The default value is 256 megabytes. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. Save the file in . Welcome to Platform Analytics! The vision of MicroStrategy is Intelligence Everywhere. intelligence company. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. Browse to and select a previously saved Intelligent Cube on which to build your report. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Number of Views 8. Published: Jun 29, 2018;Data Population for Intelligent Cubes. In MicroStrategy 9. The Intelligent Cube Options dialog box opens. KB440822. You can add data for your Intelligent. The display of data is handled by the reports that access the Intelligent Cube. Publish the specified Intelligent Cube to the Intelligence Server, so that it can be used by reports. • Meta data that is very scalable and can reach beyond 1TB. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. OLAP cubes make it easy to answer additional questions that will drive strategy with near-instant analysis of large amounts of data. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. x. It uses Business Scenarios to provide examples of each concept. Number of. To test the new batch file, the user can execute the batch file by entering its file location in the command line as shown below. The Intelligent Cube Editor opens. Microstrategy is used to interact on Hadoop, Microsoft SQL Server Tables, and SSAS MDX Cubes. What are advantages of cubes? It perform fast It Schedule the Cube It is used for Drilling It helps in Data Sharing. MicroStrategy reference numbers for this technical note are KB442285 and DE101600. "Maintaining data access security. Select the data set and click Prepare Data. In the Navigation pane, click Applications. The default value is 256 megabytes. To Create an Intelligent Cube Using Freeform SQL or Query Builder. 4. It manages high performance interactions involving terabytes of data and tens of thousands of users by leveraging in-memory intelligent cubes, caching, load balancing, resource prioritization, and connection pooling. This issue prevents the nodes in a MicroStrategy cluster to successfully load the remote Intelligent Cubes into memory once the MicroStrategy Intelligence Server node is restarted. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Afterwards the cube will start executing. 5 GB, the Data Transfer from Datasource(s) time is 77. INTELLIGENT_CUBE_FILE_DIR: The path to the disk storage of unloaded Intelligent Cubes, returned as a string. x a new concept is introduced called Intelligent Cubes. In the Data Source column, select the checkboxes for the tables to update. Introduction to MicroStrategy BI Architecture . x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. This technical note provides a detailed explanation on how Intelligent Cube index generation works in MicroStrategy 9. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. 11 on Unix/Linux Number of Views 2. Defining the partition for Super Cubes. You can use Integrity Manager to perform a before and after test to identify which reports actually connect to a suggested Intelligent Cube and also to test data integrity. They also provide the ability to use ROLAP by drilling into the full set of data outside of the Intelligent Cube. 1 release. grouping attributes MicroStrategy Cloud Creating attributes on dossiers Filtering reports, metrics, and attribute groups Filtering dossiers Improving performance with intelligent cubes Preparing complex data for enhanced storytelling Visualizing, filtering, and linking your data Designing documents Building enterprise mobile applications 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‘. In certain situations users may want to configure success and failure notifications for the scheduled refreshes of Intelligent Cubes that are created through Data Import in MicroStrategy Web. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. Interested in learning more about Platform Analytics or new MicroStrategy features? Visit the Learning Center on Community! Or feel free to visit our Documentation pages for product information. Intelligent Cubes are part of the OLAP Services feature in Intelligence Server. 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. Creating an Intelligent cube is similar to creating a report. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). 5. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. Share query results in-memory across multiple dossiers and reports. Refer to the tech note below for more information: KB32502 - Support for transformation metrics for Dynamic Sourcing in MicroStrategy OLAP ServicesWhen an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. The Intelligent Cube Options dialog box opens. The blog series consists of four blog posts: Unlocking Data Value #1: SAP BTP Data and Analytics overview: Learn about our objectives, SAP products, and real. The following project governing settings are being retired beginning with MicroStrategy 2020 Update 1. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. To publish an Intelligent Cube, see. Required Status to Perform Action. You can add data for your Intelligent cube by including objects such as attributes, metrics, filters, and so on, as report objects or report filters. Business users might not want MicroStrategy to build any M:M Relationship tables while publishing the Intelligent Cube In-Memory due to the following reasons: 1) It distorts the actual relationship between a tuple of 3 or more attributes related to each other through M:M relationship in Project Schema by creating individual tables and joining. The "Refresh Cube Subscription Editor" allows for a "Name", "Schedule", and "Delivery Notification" to be set. Built For The Internet, Office Intelligence, MicroStrategy Office, MicroStrategy Report Services, MicroStrategy Web MMT, MicroStrategy Web Services, Pixel Perfect, Pixel-Perfect, MicroStrategy Mobile, MicroStrategy Integrity Manager and MicroStrategy Data Mining Services are all registered trademarks. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. MicroStrategy Intelligent Cubes Eliminate the Need to Maintain a Proprietary Cube Environment and Redundant Hardware and Databases In order to provide BI functionality, many vendors use proprietary cubes, which require additional hardware storage 7 4%: Breakdown of TCO for IT Infrastructure workloads over a five-year period. Creating Intelligent Cubes is as easy as creating reports. For instance, let’s say you have an Intelligent Cube with 2 million rows and 10 attributes and 5KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Create Incremental Refresh Reports directly in Workstation to define how the data is updated on Intelligent Cubes, all with an improved user experience. The Intelligence Server executes the previous query against the Data Warehouse. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. For information about non-aggregatable metrics, refer to the following MicroStrategy Knowledge Base document: KB16070: How to define nonaggregatable metrics in MicroStrategy DesktopWhen exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Intelligent cubes support time zone based reporting. Disconnect from the project source and restart both Intelligence servers. See KB484738 for more information. 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. x. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. Allows the user to. " If you try to edit these MicroStrategy Connector cubes, you may be. Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. x may observe that after a period of time from the initial publishing of the cube, the size of the cubes as reported by the Cube monitor increases, in some cases by substantial amounts. In MicroStrategy, you can also use connection mapping to control the data that users have access to when they run reports. 39. Build a cube of customer data that’s relevant to all employees and publish it. Since an Intelligent Cube is structured similarly to a Relational Database the method of retrieving data from the Intelligent Cube, Cube Subsetting Instructions, is very similar to. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. Users may need to delete several certain rows of data from an intelligence cube, but it is not possible to do so for a cube created by data import on MicroStrategy Web 10. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. The MicroStrategy analytics platform is consistently rated as the best in enterprise analytics and is used by many of the world’s most admired. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. KB442630: CSI optimization for improving the in-memory query execution for many. Using Database Write-back Functionality to Enable Decision-Making. Before MicroStrategy 10. The Intelligence Server generates a query based on the requested information and the received definition. In Developer, log into a project. x -10. Appendixes The MicroStrategy Intelligence Server 9. Run the Report and check the SQL View. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". Die Erstellung eines Intelligent Cube ähnelt der Erstellung eines Berichts. The main purpose of this service is to generate PDF outputs from the information contained inside a dossier or report. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. The total number of Intelligent Cubes for a project that are stored in Intelligence Server memory is compared to the limit you define. Select the Intelligent Cubes tab. Administer cluster. Main features of mstrio-py allows to access MicroStrategy data: Connect to your MicroStrategy environment using Connection class (see code_snippets) Note: to log into Library and use mstrio-py user needs to have UseLibrary privilege. 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’. 1 and 10. Published: Apr 6, 2017. For example, analysts can export interactive dashboards and reports to PDF format, allowing executives to access and review critical information without needing direct access to the BI platform. MicroStrategy World 2014: Scaling MicroStrategy at eBay - Download as a PDF. Total Cubes This section displays the total count of cubes by status. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. bat format. The. In the New Intelligent Cube dialog box, select the MDX Sources tab. Save the Report and close. From the File menu, select New, and then select Intelligent Cube. A user logged in to a MicroStrategy Intelligence Server. Intelligent Cubes act as the layer between the data warehouse and MicroStrategy reports that analyze and display. The Cube API supports DDA cubes and MDX cubes, in addition to Intelligent cubes. Cache Lookup Cleanup Frequency (Sec) The Cache lookup cleanup frequency (sec) setting determines how frequently the CacheLkUp. View reports against Intelligent Cubes in MicroStrategy OLAP Services have the ability to add filtering qualifications into Cube Subsetting Instructions, including security filter qualifications. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. Click All Objects View. 4. 1 and 10. Replace a slice of data in an Intelligent cube using a single incremental cube refresh step. Description: Intelligent Cube design and utilization; how to build cubes. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data. 1 and 10. Use the drop-down under the filter summary section to switch the server nodes. The Analytics Server creates and manages Intelligent Cubes, a multi-dimensional cache structure that speeds up access to frequently used data. An Intelligent Cube is an In-Memory data structure which holds information from a source in a readily accessible format for quick access. Definition. To effectively create a HyperIntelligence dataset, your data must have attributes with either one-to-one relationships or many-to-one relationships. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 10. 4. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. x and newer. In a clustered environment, each node in a cluster must share its result caches and intelligent cubes with the other nodes, so all clustered machines have the latest cache information. The Intelligent Cube Monitor provides information about published Intelligent Cubes, as well as Intelligent Cube usage statistics. With OLAP Services features, your report designers can create Intelligent Cube reports. In MicroStrategy Tutorial Project, create an In-Memory Intelligent Cube by importing the following Database Tables. 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 . Report Versioning (19) Ratings. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Department Architecture consists of a single server node for MicroStrategy Intelligence Server, Web, Mobile, Collaboration, and Identity. x. Intelligent Cubes erstellen. Refresh. An Intelligent Cube has been created in a project. The maximum cube size is set by the "Maximum cube size allowed for download" field (in MicroStrategy Developer, in the Project Configuration dialog box, choose Intelligence Cubes > General) Users with security filters subscribing to a Visual Insight dossier built on a cubeUpdate 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. In MicroStrategy Developer, log in to a project source using administrative privileges. Localizing Intelligent Cubes in multiple languages. File subscriptions save the report or document as an Excel or PDF file to a disk location on the network. On the ODBC Sources tab, in the Source area, select the database instance that connects to the data source to report on using Freeform SQL or Query Builder. This technical note outlines an issue that occurs when running or editing Intelligent Cubes based on SAP BW Cube in MicroStrategy Developer 9. Improved cube index memory management and governing using the "Maximum % growth of an Intelligent Cube due to indexes" project configuration setting. These VLDB properties control the method by which the report data are normalized. 4. This is a known inconsistency in MicroStrategy analytical engine where it may pick different tables for fact extension against In-Memory vs Connect Live Intelligent Cubes. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. The Intelligent Cube opens in the Report Editor. Name the different export. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 4. , in search results, to enrich docs, and more. MicroStrategy online help and PDF manuals (available both online and in printed format) use standards to help you identify certain types of content. x product documentation "InMemoryAnalytics. 4. This article explains how a cube and its cache become synchronized in a clustered environment. Consider the following example based on the MicroStrategy Tutorial project. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. The Schedule dialog box opens for your dataset, showing the tables in your dataset. You can update and modify the document in Design View. You can also apply this security when users create reports that connect to an Intelligent Cube. 1, Windows 2003 and UNIX. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. MicroStrategyMicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. When trying to publish an Intelligent Cube via MicroStrategy Developer 9. Learn how to use Intelligent Cubes to optimize performance in MicroStrategy Developer, an advanced environment providing a complete range of analytical funct. The MicroStrategy Intelligence Server 9. • OLAP cubes that can be entirely based on memory. An Enhancement Request for implementing this functionality is. From the CatalogCube drop-down list, select the MDX cube to create training metrics for. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Starting in MicroStrategy 10. .