Currently, project duplication does not involve Intelligent Cube File Directory. The Cube API supports DDA cubes and MDX cubes, in addition to Intelligent cubes. Create a Report 'R3' with 'Country' attribute. 1 and 10. Backup frequency (minutes): controls the frequency (in minutes) at which cache, History List messages, and Intelligent Cubes are backed up to disk. 0. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Exporting a document or report to PDF, plain text, Excel spreadsheet, or XML . 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 . Choose Data > Configure Intelligent Cube. You can also apply this security when users create reports that connect to an Intelligent Cube. From the ‘Federated Analytics’ product category, deploy the following products to relevant users and connect them to. Published: Nov 19, 2018; Last updated: Nov 18, 2022;MicroStrategy version 9. Administering MicroStrategy: Managing the Intelligence Platform User privileges and data access Monitoring and tracking the analytics system Administering MicroStrategy Mobile. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. MicroStrategy online help and PDF manuals (available both online and in printed format) use standards to help you identify certain types of content. Introduction to MicroStrategy BI Architecture . The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. This property can only be enabled through Workstation. Select other schedule options as required, and click OK. MicroStrategy will continue to investigate and post updates as soon as they are. In MicroStrategy Developer, log in to a project source with administrative privileges. . In this case, the dataset is a MicroStrategy Intelligent Cube. The Schedule dialog box opens for your dataset, showing the tables in your dataset. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. From the ‘Federated Analytics’ product category, deploy the following products to relevant users and connect them to. WORKAROUND: Two possible workarounds which may be feasible, depending on the situation are:Select Intelligent Cubes > General > Intelligent Cube File directory. The Intelligent Cube refresh settings are recommended if the data in the. Afterwards the cube will start executing. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. . The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. The Report Editor opens with all of the objects of the Intelligent Cube. Published: Jun 29, 2018;Data Population for Intelligent Cubes. Drilling is allowed within an Intelligent Cube for quick-response MOLAP analysis. Push-Down Derived Attributes for Live Connection Cubes In MicroStrategy 10. 1. Intelligent Cubes. 4. This technical note provides a detailed explanation on how Intelligent Cube index generation works in MicroStrategy 9. It depends on the cube. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. Administering MicroStrategy: Managing the Intelligence Platform Securing user privileges and data access Monitoring and tracking the analytics system. In MicroStrategy Tutorial Project, create an In-Memory Intelligent Cube by importing the following Database Tables. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded. Introduction to advanced analytics 3. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server memory reduces response time for reports using them. Rather than returning data from the data warehouse for a single. 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. The Training Metric Wizard contains the following steps to guide you through the creation of a training metric: Select Type of Analysis. 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. In the left pane, click Intelligent Cubes. The Full Refresh option is the default. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. 1 and 10. The. MicroStrategy Web allows you to merge two or more Intelligent Cubes. What is HyperIntelligence? In 2019, MicroStrategy invented a new solution for a conventional problem in the analytics industry. Starting in MicroStrategy 10. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 1, Windows 2003 and UNIX. 1 and 10. Click here to view details about the Intelligent Cube Monitor. The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. Expand Intelligent Cubes, and then select General. A dataset is a MicroStrategy report that is used on a document and all of the report's elements–attributes, custom groups, consolidations, and metrics. 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. The Intelligent Cube Options dialog box opens. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Go to the "All Objects View" option in the top left corner. 3 - Check the Make Intelligent. Main Features. Click All Objects View. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. In HTML View and PDF View, a dashboard is displayed as a static document. Sharing data. Analyzing SQL and For detailed information about Intelligent Cubes, see the In-memory Analytics Guide. 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. This will work as a regular SQL comparison. This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. • Reports can consist of documents with customized HTML format. For detailed information about Intelligent Cubes, see the In-memory Analytics Help. The default value is 256 megabytes. To enable or disable dynamic sourcing for an Intelligent Cube. 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 the Data Source column, select the checkboxes for the tables to update. In MicroStrategy 2020, the password can be found in the Default_Accounts. With this release, architects can design or edit Intelligent Cubes directly from Workstation: Architects can design and create Intelligent Cubes to combine. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. To improve the performance, MicroStrategy Intelligence Server can be configured to use shared memory resources. 4. This article explains why the Intelligence Cubes are not published via subscriptions to both nodes of a cluster in MicroStrategy 2019 and later versions. Intelligence Server Statistics . x clustered environments. MicroStrategy reference numbers for this technical note are KB442285 and DE101600. Publish the cube. Users with different security filters can use the same Intelligent Cube data. About this book. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). x, with the Intelligence Server running on Linux, the. If the Intelligent Cube must be re-processed based on a metric. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. com Format: A MicroStrategy Online Training Video blog. KB440822. Click Select. 39. If the welcome page is shown, review the information and click Next. The New Grid dialog box opens. PRIME stands for Parallel Relational In-Memory Engine, and it engulfs two types of in-memory cubes: OLAP cubes, or the traditional Intelligent Cubes that have existed since 9. 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. 3. The New Grid dialog box opens. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. The cube instance is located from the Intelligent Cube Manager, when a subset report, or a standard report that uses dynamic caching, is executed. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Turn on/off the Parallel Execution on project level or report level: Query Optimization > Parallel Query Execution. Navigate to and run the Intelligent Cube report. Creating Intelligent Cubes The Freeform SQL Editor and the Query Builder Editor provide alternative methods to create reports in MicroStrategy. To Create an Intelligent Cube Using Freeform SQL or Query Builder. 4. In Developer, log into a project. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. * Details on 2 possible causes for connectivity issues preventing the publication of Platform Analytics Intelligent Cubes. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. This property can only be enabled through Workstation. xA report that runs against the Intelligent Cube. mstr file is too large. Good Understanding of Intelligent cubes and Data mart design. 4. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". These restrictions are applied automatically when creating prompts. MicroStrategy Intelligent Cube Technology allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Email subscriptions deliver a report or document to one or more email addresses. Drilling can also be enabled outside of an Intelligent Cube for full ROLAP analysis. While still exposed, the settings will not take effect if. Object Migration Best Practices. g. 4 to MSTR 2019 U2. The Intelligent Cube Editor opens. 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. Number of Views 391. The Intelligent Cube Options dialog box opens. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. 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. Con: The copy of report data in Intelligence Server memory only applies to a single report. 4. As of MicroStrategy Secure Enterprise 10. • Meta data that is very scalable and can reach beyond 1TB. 24: Update Intelligent Cube. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. In MicroStrategy 10. Set Intelligent Cubes to Publish and Trigger initial Object Migration. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. 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. Click OK. 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. Select the data set and click Prepare Data. x. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. Query Generation. 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. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. Easily add or change pre- and post- SQL statements. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. This technical note outlines an issue that occurs when running or editing Intelligent Cubes based on SAP BW Cube in MicroStrategy Developer 9. For more details on enabling the setting. x product documentation "InMemoryAnalytics. Intelligent Cubes provide the fast response time and analytic calculations that are often associated with MOLAP cubes. 2. 1 or above, to pick up the fix, enable project level setting "Data Engine Version" to 11. Report Data Manipulation 5. Right-click an Intelligent Cube and select Delete. txt file. 1 and 10. Improved cube index memory management and governing using the "Maximum % growth of an Intelligent Cube due to indexes" project configuration setting. Users don’t have to mention the cube to which they want to connect. KB485226: Intelligent Cube size increases irrespective of the "Maximum % growth of Intelligent cube to 50%" governing setting. e. Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. Ab MicroStrategy 2021 Update 5 können Sie Intelligent Cubes erstellen. For more details on enabling the setting, refer to Change Data Engine Version. You must belong to the System Administrators group to use this feature. 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. The display of data is handled by the reports that access the Intelligent Cube. This property can only be enabled through Workstation. 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. In MicroStrategy Web 9. x product documentation "InMemoryAnalytics. For detailed information about Intelligent Cubes. All necessary privileges are included in the Administrator role by default. Publish the specified Intelligent Cube to the Intelligence Server, so that it can be used by reports. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. 8 and up? KB439821 | Knowledge Article | 2670. Attributes in the security filter are related to attributes in the Intelligent Cube: No data is returned, to maintain data access security. The Intelligent Cube opens in the Report Editor. 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. Right-click an application and choose Properties. 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. . "Maintaining data access security. Intelligent Cubes: MicroStrategy’s Intelligent Cubes are pre-aggregated, in-memory data structures that enhance the performance of queries. This is because with this feature enabled, the element block ID will be saved to the new cube cache. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. •. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Administer database connections. Add data from existing reports, documents, and Intelligent Cubes. To that end, we’ve designed a program of continuous training and certification for every role in your Intelligent Enterprise. 4. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. x. For more information on security filters, see the System Administration Guide. Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. 0. In the New Intelligent Cube dialog box, select the MDX Sources tab. 9 The MicroStrategy REST API has been unified and expanded to include the following REST API families: Authentication API; Browsing API; Cubes API; Datasets API; Datasource Management API; Dossiers and Documents API; Emails API; Library API;. Intelligent Cubes are multidimensional cubes (sets of data) that exist in the MicroStrategy Intelligence Server memory and can be shared among different users. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. Refer to the following MicroStrategy Knowledge base document for general remarks on security filter application to Intelligent Cubes where not all of the security attributes are found. Create Cube1 with the Region attribute and the metric created in step 1. 2. For more information on cache encryption, review the following article: KB31094: New feature in MicroStrategy Intelligence Server 9. 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. Localizing Intelligent Cubes in multiple languages. Depending on location set at the project level, one or none of the Intelligence server nodes will be able. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. This article explains how a cube and its cache become synchronized in a clustered environment. x - 10. Action This issue is fixed in MicroStrategy 11. In versions prior to MicroStrategy Intelligence Server 9. " If you try to edit these MicroStrategy Connector cubes, you may be asked to log into the Library server. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. Vn (with metric Mn from source cube Cn). The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. To create a report that connects to an Intelligent Cube, in MicroStrategy Developer. To enable or disable dynamic sourcing for an Intelligent Cube. When an Intelligent Cube is defined to support a language, data is available for the Intelligent Cube in that language. An Intelligent Cube is an In-Memory data structure which. To do so, you can take advantage of URL API. The Subscription Editor opens. As of MicroStrategy Secure Enterprise 10. With MicroStrategy OLAP Services, transformation metrics used in standard reports can resolve against Intelligent Cubes under the following conditions: A metric with the same formula and transformation exists in the Intelligent Cube. 4. This can improve the performance of. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. In MicroStrategy Web, you can. Due to data privacy considerations, MicroStrategy doesAs the new default monitoring tool for the MicroStrategy platform, Platform Analytics has a slightly different attribute structure to Enterprise Manager. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. From the Data menu, select Configure Intelligent Cube. Beginning in MicroStrategy 10. The Intelligent Cube Monitor is displayed. 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. If you are upgrading to MicroStrategy 11. Browse to and select a previously saved Intelligent Cube on which to build your report. Browse to the folder location to store Intelligent Cubes, and then click OK. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. 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. Click here to view details about the Intelligent Cube Monitor. Intelligent Cube storage on disk mirrors report cache storage. MicroStrategy Developer, Web, and Office users can slice and dice data in reports within Intelligent Cubes without having to re-execute SQL against the data warehouse. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. MicroStrategy World 2014: Scaling MicroStrategy at eBay - Download as a PDF. 4. Cube and Cache Metric Names. Right-click an Intelligent Cube and select Delete. 4. Privilege. The **_objects folder with a size of 277G. Although this technique improves document performance, the amount of time required to publish an Intelligent Cube increases as it grows in size. Select an Environment from the upper-left drop-down. In MicroStrategy 9. x releases, and the new Multi-table Data Import (MTDI) cubes. 3 - Check the Make Intelligent Cubes. For example, an Intelligent Cube includes Year and Quarter. KB30711 : Security filter application to view reports based on Intelligent Cubes missing the security filter attribute in MicroStrategy OLAP ServicesKB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. To enable. 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. 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. Description MicroStrategy 10 introduced a new option on the Intelligent Cube called Data Partition. Select the Data Partition category. With OLAP Services features, your report designers can create Intelligent Cube reports. Drag and drop the objects into the report grid from the Report Objects pane. By the same token, our platform is also the source of valuable data. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. Con: The copy of report data in Intelligence Server memory only applies to a single report. For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. 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. 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. Export to PDF filter summaries include the full attribute and metric. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. •PDF. 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. 1 and 10. Right-click the project and select Project Configuration. Navigate to the Data Refresh category. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. pdf", Dynamic Sourcing -> Best practices for supporting dynamic. Intelligent Cubes are part of the OLAP Services feature in Intelligence Server. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. This image shows a cube with three dimensions (though really, the number of dimensions that can be contained within a cube are limitless): products, customers (by country) and posting date (year). Required Status to Perform Action. Expand Intelligent Cubes, and then select General. 4. Have full control over result, element, and object caches in a project. This issue was reviewed by our Technology team for feasibility and will not be scoped for a code fix in any upcoming MicroStrategy release. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. The reports created from the shared sets of data are. If you are upgrading to MicroStrategy 11. The old cube files don't have this property, so new IDs will be generated every. 11+, derived attributes are evaluated at the source when all the required columns come from the same table- which is the case for most users. 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. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. In the Navigation pane, click Monitors. Sharing data. 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. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. the project configuration: ACTION . 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. 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). You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. MicroStrategy Intelligence Server . 0 MicroStrategy releases. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Create a report based off the cube in Step 1 that includes the description form for Category. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 0. It accesses and joins data. 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. 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. " If you try to edit these MicroStrategy Connector cubes, you may be. Share query results in-memory across multiple dossiers and reports. 4. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. Number of Views 1. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. 0: Balance MicroStrategy Server threadsReporting on an Intelligent Cube provides quick access to data, as the data has been pre-aggregated. There is a distributed database for the MicroStrategy metadata and. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Due to the architecture of the MicroStrategy platform, if a customer chooses to utilize caching and intelligence cube capabilities, then application data files that are at-rest are backed up on MicroStrategy-managed Intelligence Servers for a minimum period of five days. 1 release. x a new concept is introduced called Intelligent Cubes. • • • To • •. Total Cubes This section displays the total count of cubes by status. Upgrade to those versions to take advantage of the fix. Beginning with MicroStrategy Secure Enterprise 10. For detailed information about Intelligent Cubes, see the In-memory Analytics Help.