In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Choose File > New > Intelligent Cube. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. 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. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. Open the Workstation window. 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. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. This technical document covers a known issue affecting MicroStrategy Secure Analytics Enterprise 10. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. Within the set. Push-Down Derived Attributes for Live Connection Cubes In MicroStrategy 10. In MicroStrategy Developer, locate the Intelligent Cube that needs to be refreshed. Total Cubes This section displays the total count of cubes by status. Our analytics and mobility platform transforms data into actionable insights that help people make better business decisions. . A filtered attribute element list prompt appears empty when used inside a report mapped directly to an Intelligent Cube. In MicroStrategy Developer, log in to a project source with administrative privileges. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. Published: Nov 19, 2018; Last updated: Nov 18, 2022;MicroStrategy version 9. This data can be used to create a. In MicroStrategy Web 9. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. Select the Data Partition category. Microstrategy is used to interact on Hadoop, Microsoft SQL Server Tables, and SSAS MDX Cubes. After each unload/reload, and running the Dossiers against the cube, the duplicate Element Block files will be dumped into the same *****_objects folder. Select the data set and click Prepare Data. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. Afterwards the cube will start executing. 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. In MicroStrategy Developer, log in to a project source with administrative privileges. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. The Intelligent Cube Monitor is displayed. About this book. Published: 4월 6, 2017. 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. A user logged in to a MicroStrategy Intelligence Server. smw format. 3 - Check the Make Intelligent Cubes. 4. 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. You can edit project-level cache and Intelligent Cube settings. • Optimizi ng performance with Intelligent Cubes • Determining the order of calculation • Sharing reports using export, print, or by subscribing to report deliveries 1. Defining Intelligent Cube refresh settings. The objects in the source cubes will control how the security filter will be applied. This is because with this feature enabled, the element block ID will be saved to the new cube cache. Run the Report and check the SQL View. x. A document that uses the Intelligent Cube as a dataset. Publish the cube. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. x Intelligent Cubes depends on the attribute(s) in the security filter being on the template of the Intelligent Cube. What is HyperIntelligence? In 2019, MicroStrategy invented a new solution for a conventional problem in the analytics industry. This privilege is part of OLAP. Save the Report and close. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report. 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. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. Discover MicroStrategy 2021 > Events; Customer Success; Enterprise Analytics; Retail; World 2021;By using a single Intelligent Cube to support all the security filters for a project, data access security is implemented automatically with minimal burden on Intelligence Server memory. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. Choose one of the following options: Full Refresh: This is the default. 2 billion row limit for Intelligent Cubes (240GB cube)Linear scalabilityReduce dependency Sub 5 second response time. Use MicroStrategy Developer, Office, or Web. . x product documentation "InMemoryAnalytics. 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. Chapter 8: Improving performance with intelligent cubes Chapter 9: Preparing complex data for enhanced storytelling Chapter 10: Creating workflows for efficient storytelling. Use the table below as a guide to determine whether switching to a single Intelligent Cube as dataset can improve the performance in your environment: 3. On the toolbar, choose Data > Configure Intelligent Cube. Save the Intelligent Cube. As of MicroStrategy Secure Enterprise 10. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. KB440822. 0 MicroStrategy releases. 1 and 10. While still exposed, the settings will not take effect if. Choose one of the following options: Full Refresh: This is the default. Creating Intelligent Cubes The Freeform SQL Editor and the Query Builder Editor provide alternative methods to create reports in MicroStrategy. Learning Resources. We empower you with the skills to get the most out of your analytics investment. Source: MicroRooster. The Subscription Editor opens. 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. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal. LIST PROPERTIES FOR INTELLIGENT CUBE CACHE (NAME "<intelligent_cube_name>" | GUID <instance_guid>) FOR PROJECT "<project_name>"; An enhancement request has been raised to have the ability to use “cube as trigger”. 6, the MicroStrategy PDF Exporter (also known as New Export Engine or NEE) service has been added to support exporting from. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. 3. In the Refresh Policy column, choose one of the following options:MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. txt file. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 4, MSTR file is an available export format for individual Visual Insight dashboards from MicroStrategy Web and MicroStrategy Desktop. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. x releases, and the new Multi-table Data Import (MTDI) cubes. Refer to Knowledge Base article on how to support connection mapping with the use of cubes: KB33830: Can Intelligent cubes be used along with connection mapping in MicroStrategy Developer. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. This is due to the fact that adding prompts to Intelligent Cubes is not supported. This provides ROLAP-type analysis without having to re-execute against the data warehouse. Integrity Manager can test the SQL of Intelligent Cubes even if they have not been published, but cannot test Intelligent Cube reports based on an unpublished Intelligent Cube. * Details on 2 possible causes for connectivity issues preventing the publication of Platform Analytics Intelligent Cubes. 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%. Prompts on reports that connect to Intelligent Cubes can only access data that is available within the Intelligent Cube. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. 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. Save the Report and close. 0. 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. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . x CAUSE: The user is missing the "Administer Subscriptions" privilege under "Administration" in. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. Edit Intelligent Cubes from the new editor in Workstation at any time. Browse to and select a previously saved Intelligent Cube on which to build your report. 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. Intelligent Cubes act as the layer between the data warehouse and MicroStrategy reports that analyze and display. Improved cube index memory management and governing using the "Maximum % growth of an Intelligent Cube due to indexes" project configuration setting. The display of data is handled by the reports that access the Intelligent Cube. 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. Publish to PDF (22) Ratings. For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. When an Intelligent Cube. 4. You can also apply this security when users create reports that connect to an Intelligent Cube. Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. User Review of MicroStrategy Analytics: 'Microstrategy is used as a reporting solution in my work environment. Both products' features range. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. 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. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Currently, project duplication does not involve Intelligent Cube File Directory. It depends on the cube. However, Intelligent cube publishing performance may be affected with the agent enabled. Beginning in MicroStrategy 10. These VLDB properties control the method by which the report data are normalized. If you use Enterprise Manager (EM),. 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. With OLAP Services features, your report designers can create Intelligent Cube reports. The ability to view or edit certain settings is determined by a user's privileges. Intelligent Cubes erstellen. The Intelligent Cube Monitor is displayed. 0 and later enhances the scalability and manageability of OLAP Services with the addition of sharable Intelligent Cubes. This VLDB property has the following options: Disable parallel query execution (default): All queries for MicroStrategy reports and Intelligent Cubes are processed sequentially. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Counts the number of sessions from the table IS_CUBE_ACTION_FACT. Because the filters are applied to the master data in the Intelligent. ¶. Solution:If you have a Distribution Services license, you can subscribe multiple users to an individual report or document through MicroStrategy Web (see To Create a Subscription in MicroStrategy Web). 1 and 10. 4. Multiple reports can access a single. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. MicroStrategy Education is committed to the success of every MicroStrategy practitioner, from novice analysts to the most experienced Intelligence Center architects. In HTML View and PDF View, a dashboard is displayed as a static document. To Create a Report that Accesses an Intelligent Cube. INTELLIGENT_CUBE_MAX_RAM: The maximum size in memory of all Intelligent. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. The fact that the. mstr file is too large. x. 4. 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. 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. The MicroStrategy Suite is a MicroStrategy offering that lets you evaluate MicroStrategy as a departmental solution. 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. Disabling parallel query execution by default allows you to first verify that your reports and Intelligent Cubes are executing correctly prior to any parallel query. For detailed information about Intelligent Cubes. NAME: The name of the Intelligent Cube, returned as a string. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. 3. The Intelligent Cube opens in the Report Editor. 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. There is a distributed database for the MicroStrategy metadata and. To create a report that connects to an Intelligent Cube, in MicroStrategy Developer. 4. Click OK. Click here to view details about the Intelligent Cube Monitor. 2015-06-04 MicroStrategy Product Manuals 2015-02-01 MicroStrategy Product Manuals The OLAP Services Guide covers information on MicroStrategy OLAP. In the Navigation pane, click Applications. For detailed information about Intelligent Cubes, see the In-memory Analytics Help. Click Close, then "Finish" on the "prepare data" view and save the cube. The Data Partition options are displayed. 0. Choose File > New > Intelligent Cube. Learn how to use Intelligent Cubes to optimize performance in MicroStrategy Developer, an advanced environment providing a complete range of analytical funct. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. With this release, architects can design or edit Intelligent Cubes directly from Workstation: Architects can design and create Intelligent Cubes to combine. 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. However, you cannot create a card based on a live-connect MDX/SAP cube. Click the MicroStrategy icon at the upper left of any page and select History List. This. x -10. Department Architecture consists of a single server node for MicroStrategy Intelligence Server, Web, Mobile, Collaboration, and Identity. Watch on. You can update and modify the document in Design View. e. Cube and Cache Metric Names. The MicroStrategy Intelligence Server 9. Create Intelligent Cubes. . Use MicroStrategy Developer, Office, or Web. Definition. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. The following table summarizes the test results of some test scenarios against Oracle 19c. CAUSE. xA report that runs against the Intelligent Cube. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. 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. The caching of Intelligence Cubes in MicroStrategy Analytics is a game changer. 1) Right click the intelligent cube and select Properties -> Security . 4. Rather than returning data from the data warehouse for a single. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. Navigate to the Data Refresh category. Before MicroStrategy 10. Right-click an application and choose Properties. PUBLISH INTELLIGENT CUBE ("name" IN FOLDER "folder_name" | GUID "guid") [ASYNCHRONOUS] FOR PROJECT "project_name"; where: "name" is the name of the Intelligent Cube to be published, of. The Report Editor opens with all of the objects of the Intelligent Cube. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. However, after publishing,. 4. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. KB442453: Dossier loses the font format when exported to PDF file in MicroStrategy 10. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. 56K. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Configure metric aggregations, null handling, indexing, and more. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Intelligent Cubes are part of the OLAP Services feature in Intelligence Server. KB255633. Browse to an Intelligent Cube, select it, and then click OK. This option is enabled by default. 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. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. 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. With OLAP Services features, your report designers can create Intelligent Cube reports. Description MicroStrategy 10 introduced a new option on the Intelligent Cube called Data Partition. The Intelligent Cube Monitor is displayed. Number of Views 1. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Drilling is allowed within an Intelligent Cube for quick-response MOLAP analysis. For reports and Intelligent Cubes that do not use MultiSource Option or database gateway support to access multiple data sources, all queries are processed sequentially. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. Edit the Cube2 , in the Cube editor > Data > Configure Intelligent Cube > Data Partition > Partition Attribute = Region and Number of Partitions = 12. 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. 6, users now have the option to select MSTR as the Delivery format for email and file subscriptions as shown below: MicroStrategy Intelligence Server. Publish Intelligent Cube statement. This defect is addressed in MicroStrategy 11. From the ‘Federated Analytics’ product category, deploy the following products to relevant users and connect them to. Defining the partition for Super Cubes. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. 11 on Unix/Linux Number of Views 2. Microstrategy's Visual Insight is used as a self service tool replacing Pivot tables & graph building in Excel. Add or remove nodes in a cluster, and set the default cluster membership. 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. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". Creating an Intelligent cube is similar to creating a report. 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. MicroStrategy online help and PDF manuals (available both online and in printed format) use standards to help you identify certain types of content. ; You can create multiple cache, History List, Intelligent Cube, or Mobile subscriptions at one time for a user or user group using the Subscription Wizard. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. I have I-cubes with billions of rows stored in memory. Select an Environment from the upper-left drop-down. 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. 0. The Intelligent Cube “xxx” for locale <German (Germany)>has not been published. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. In Developer, log in to a project with a user account with administrative privileges. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. 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. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. From the Data menu, select Configure Intelligent Cube. Run the Report and check the SQL View. Each user that connects to the MicroStrategy Intelligence server and/or project has a unique. Attributes in the security filter are related to attributes in the Intelligent Cube: No data is returned, to maintain data access security. This will reduce the memory usage from 150GB to 100GB. PATH: The path to the Intelligent Cube, returned as a string. •PDF. The Intelligent Cube Options dialog box opens. x clustered environments. 1 and 10. Login to MicroStrategy Web, create a cube with the function of Data Import 2. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. All reports that access Intelligent Cubes allow you to drill within the data included in an Intelligent Cube. From the Data menu, select Configure Intelligent Cube. Create an intelligent cube report with Year and three derived metrics and enable "Aggregate from base" as shown below: Insert view filter "Year in list (2009)". Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. 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. For more information on the Intelligent Cube Maximum. Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 1 and 10. This can improve the performance of. OLAP cubes make it easy to answer additional questions that will drive strategy with near-instant analysis of large amounts of data. Configure a Cluster with a Centralized Cache. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. KB441285: Optimization for the Intelligent Cube Data Structure at the time of publication. 1 and 10. A value of 0 means that cache, History List messages, and Intelligent Cubes are backed up immediately after they are created. 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. 4. As of MicroStrategy Secure Enterprise 10. Right-click the dataset, and choose Schedule. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. In addition to creating reports. The Intelligent Cube refresh settings change the way the Intelligent Cube is updated when you re-execute it manually, or when it is published on a schedule, as described in Publishing Intelligent Cubes using a schedule. The Intelligent Cube Options dialog box opens. 0 MicroStrategy releases. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). MicroStrategy Library. Die Erstellung eines Intelligent Cube ähnelt der Erstellung eines Berichts. 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. 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 Intelligent Cube Monitor provides information about published Intelligent Cubes, as well as Intelligent Cube usage statistics. 0 has a dedicated section to memory used for Intelligent Cubes. This section contains the following information: Managing Intelligent Cubes: Intelligent Cube Monitor Governing Intelligent Cube Memory Usage, Loading, and Storage The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. Multiple reports can access a single. If you are upgrading to MicroStrategy 11. 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. Click All Objects View. Publish the specified Intelligent Cube to the Intelligence Server, so that it can be used by reports. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. Report Versioning (19) Ratings. 6 and higher. •. x: Ability to encrypt cache files stored to disk. 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. Creating an Intelligent cube is similar to creating a report. In MicroStrategy Integrity Manager 10. Environment connection is lost when using Kerberos and creating an Intelligent Cube in MicroStrategy Workstation. Build a cube of customer data that’s relevant to all employees and publish it. Name the different export. Providing Intelligent Cube data. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. In MicroStrategy 9. Users don’t have to mention the cube to which they want to connect. MicroStrategy will monitor the data repository and/or cube memory requirement of the Enterprise Manager and/or Platform Analytics. For more information on how to integrate with Oracle OLAP cubes contact MicroStrategy Consulting. To enable or disable dynamic sourcing for an Intelligent Cube. 2. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Subsequently the requests made by other users can. In MicroStrategy Secure Enterprise an Intelligent Cube goes through an Attribute Index based optimization during the publication to produce the smallest effective size based on cardinality. When trying to publish an Intelligent Cube via MicroStrategy Developer 9.