create() will create a SuperCube, upload the data to the Intelligence Server and publish it. To build an Intelligent Cube In Developer, from the File menu select New, and then Intelligent Cube. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. For a MicroStrategy environment configured to use Database level security using MSTR connection mapping, Intelligent Cubes can still be utilized. x releases, and the new Multi-table Data Import (MTDI) cubes. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. HIDDEN: if the intelligent cube is hidden or not, returned as a boolean value. Right-click on the cube and choose Edit. Open the cube report in Design View. 438832. This is the same requirement to create or run a static report in Workstation. MicroStrategy AI is here. x: Create a new Intelligent Cube with Attributes Category, Subcategory and Metric Revenue. Execute reports or documents that reference the object. Open the cube report in Design View. Publish the cube. 2. If you select Cube B, any dashboards or reports linked to Cube A before the merge may not function correctly. The Modeling service must be configured correctly to use this feature. The Browse for Folder dialog box opens. Con: The copy of report data in Intelligence Server memory only applies to a single report. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. The Modeling service must be configured correctly to use this feature. For steps to create a view filter in MicroStrategy Web, see the MicroStrategy Web Help. 0 MicroStrategy releases. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Create an Intelligent Cube, with Region, Category, Cost and Profit. ACTION:In the Navigation pane, click Monitors. 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%. Right-click an application and choose Properties. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. Follow the steps below using the MicroStrategy Tutorial project: 1. Use Intelligent Cube Editor. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. The impact is limited to MicroStrategy Developer 9. Select from the following localization options: Use project default data language (Default): Select this option to provide data only in the default language for the project. Create an attribute element prompt for the Year attribute. 2. Select a schedule from the Schedule drop-down list. Note: number of columns should be the same as in the original file. 86K KB42486: Users are unable to align the report name / title when exporting a report to an Excel file in MicroStrategy Web 9…This article discusses an issue with DELETE incremental refresh reports invalidly preventing an intelligent cube from being used for dynamic sourcing in MicroStrategy 10. To create or edit Intelligent cube reports you must at least have the following privileges: Web define Intelligent Cube Report or Defined Intelligent Cube Report. 4. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. A set of data is returned from the. Click Intelligent Cube Report. Share query results in-memory across multiple dossiers and. Create a report based off the cube in Step 1 that includes the description form for Category. Integer ID of the Intelligent Cube report that was published, if any. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. Right-click your selection and select Group. Full Refresh. Prerequisites for using Cube Advisor. It retrieves report results from a schema source and stores it in memory. Number of Views 1. Quickly integrating data into MicroStrategy as part of a proof-of-concept. This can be done by selecting Run Report in the toolbar. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Web object search—this enables the user to see the “User Manager” button on the Intelligence Server Administration page. To publish your cube, see the In-Memory Analytics Help. Select the. Quickly integrating data into MicroStrategy as part of a proof-of-concept. Created cube with lastname and any other attribute. This chapter provides information on how to deploy and configure MicroStrategy Web and Web Universal on Windows and Linux platforms with various Web and application servers. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;Job ID for the action on the Intelligent Cube. Refer to the tech note below for more information: KB32502 - Support for transformation metrics for Dynamic Sourcing in MicroStrategy OLAP ServicesIn MicroStrategy Web click Create -> Add External Data -> File from disk; Select the Excel file saved in Documents; Prepare data (Note: Change the data type of “AttributeID” to text) Right click the first attribute "AttributeID" and select "Map to Project Attribute" Search for “AttributeID” in the search bar and hit enter. The Intelligent Cube opens in the Report Editor. First, you open a blank document and select a report to use as the document's dataset. To create or edit Intelligent cube reports you must at least have the following privileges: Web define Intelligent Cube Report or Defined Intelligent Cube Report. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . “Intelligent Cube (<Cube Name>) for locale. IS_PROJ_ID. This Python 3 / MicroStrategy 10. In MicroStrategy Developer create an Intelligent Cube with any attributes and metrics. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. In MicroStrategy Web, log in to a project. From the. To unpublish an Intelligent Cube. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. For information on using Cube Advisor to support dynamic sourcing, see Using Cube Advisor to support dynamic sourcing. They should have the “A, L, F” status (Active, Loaded, Filed). Add a grid with the attribute Customer. In MicroStrategy Web 9. create(auto_publish=False). Faster performance than directly querying warehouse. 9 and 10. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. Create a new Dossier. Click Close, then "Finish" on the "prepare data" view and save the cube. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. Create a new variable and assign SuperCube with two parameters inside – connection and id. 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. Navigate to the Intelligent Cube you want to refresh. Add Project objects from the All Objects panel. Modify the list of Report objects (use object browser). From these results it can be determined that the Month attribute is not being used within any of the view Reports, Documents, Dossiers that reference this Intelligent Cube. 1. 4. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. 4. In this case, the dataset is a MicroStrategy Intelligent Cube. Restoring cube files. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. 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. Complete the "sessionState" field (e. Browse to and select a previously saved Intelligent Cube on which to build your report. 8. 4. The Intelligent Cube Monitor is displayed. 3. Check in Developer that the stopped node is in Maintenance Mode. Select other schedule options as required, and click OK. MicroStrategy Web is a browser-based client interface that enables IT to satisfy the diverse analytics needs of every enterprise user—consumers, analysts, data scientists, developers, and administrators—without the burden of distributing and maintaining multiple software packages. For: "Import data from file or database before using in a Visual Insight analysis", which makes the source an Intelligent Cube, a Web Professional license is required. Click OK. Steps to import a spreadsheet from Google Drive: MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. Both properties are located in the Query Optimizations folder in the VLDB property editor. 0, the only way to create an intelligent cube (also known as an ROLAP cube or an OLAP cube) was from a report (which is a single table dataset). KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. To Create a Report from Scratch. This is the same requirement to create or run a static report in Workstation. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. "In MicroStrategy 10. x. The Modeling service must be configured correctly to use this feature. Select Build a Query and click Next. 2. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Look for existing Intelligent Cubes: Before you create an Intelligent Cube, search through MicroStrategy to see whether a similar Intelligent Cube already exists that can serve the same purpose as the Intelligent Cube that you. Select the data set and click Prepare Data. 4 the connection mapping of the u… Number of Views 1. An Intelligent Cube is a multi-dimensional cube (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports and documents. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. How to Import Data from a SAP HANA Database Into MicroStrategy Web. 2. Create a Report 'R3' with 'Country' attribute. KB39447: How to Trigger an Event Using the MicroStrategy Web SDK 9. Publish the cube. Use Intelligent Cube Editor. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. Con: The copy of report data in Intelligence Server memory only applies to a single report. Navigate to the Engine Component with CSI Dispatcher. x as Administrator; create a simple Intelligent Cube called Q, and publish it. In Project B, create and run a new Intelligent Cube. Check the location of the new cube cache and notice that it is saved in the default location, i. KB30711: Security filter application to view reports based on Intelligent Cubes. 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. 4. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Add a dataset. 2. First, you open a blank document and select a report to use as the document's dataset. 2. After refreshing an Intelligent Cube that had columns added to it, the newly created attributes do not show up in the document's Dataset Objects pane in MicroStrategy Web 9. This is because with this feature enabled, the element block ID will be saved to the new cube cache. Click OK. Create a cube report based on the cube. A possible cause of this issue is that the folder that stores the Intelligent Cube files on the node where the Intelligent Cube is published is not shared with the name 'ClusterCube' on the MicroStrategy Intelligence Server machine(s). How to build and manage Intelligent Cubes. 63K. The Subscription Editor opens. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT. Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. Click Create on any page, point to New Report, and select Blank Report. You can also reproduce this issue in a Document. You can also select an existing template on which to build your new report. The steps below show you how to create an Intelligent Cube based on an MDX cube. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user. 1 or MicroStrategy Web 9. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. x - 10. 38K. ACTION:The Data Transfer Rate varies from 27 to 28 Mb/s. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide. Memory mapped files (MMF) can be used for effective RAM utilization. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. Navigate to the folder location of the Intelligent Cube. Create an MDX Cube ReportThe option to point a grid to an Intelligent Cube appears disabled, while other options such as "Convert Grid to Intelligent Cube" appear available. 66K. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. To define an incremental refresh report. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. From the Data menu, select Add Dataset. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. In MicroStrategy Web 10. Make sure the service is properly configured and running before using the Intelligent Cube Editor. x checks for 'Execute' access to the managed column object being used in the metric when adding it to the report, which is not required for regular non-mnanaged metrics. In MicroStrategy 9. Integer ID of the project where the Intelligent Cube is stored. It is especially useful when data. To Create a Report that Accesses an Intelligent Cube. 2. MicroStrategy Developer 9. This Python 3 / MicroStrategy 10. 4 the connection mapping of the user account which published the cube are created and database connections are listed in the Intelligent Cube Monitor in Developer. The Schedule dialog box opens for your dataset, showing the tables in your dataset. This is the same requirement to create or run a static report in Workstation. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). Sharing data. Click a catalog. This knowledge base article describe steps to re-point an existing report which is based on Cube A previously to another Cube B. To schedule updates for the Intelligent Cube. Ensure that the email addresses can be displayed properly. Refresh Intelligent Cubes manually. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Normalize Intelligent Cube data in the. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. Import MicroStrategy File. To create an Intelligent Cube based on an MDX cube Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Web publish Intelligent Cube. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Refer to the following tech note, KB37431 for a list of Licenses and privileges required for different actions related to Visual Insight in MicroStrategy Web 9. Create an Intelligent Cube with attributes Year, Month and Region; 4. When Drilling on a report created from an Intelligent Cube gives the Last Update Date of 1899 in MicroStrategy Web 9. Navigate to the folder location of the Intelligent Cube. If you've already got a report that you want to create an Intelligent Cube out of, you simply go to. Create an Intelligent cube and add subscriptions for all 500 users to publish the cube. Create a report services document or Visual Insight Analysis. Run a dossier based on the cube. Choose File > New > Intelligent Cube. Personal Intelligent Cubes are linked to a single report: Pro: The report can use OLAP Services to analyze report data and is always updated with the latest version of the personal Intelligent Cube. Easily add or change pre- and post- SQL statements. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. Type a name for the derived element, and click OK. 1Currently it is not possible to create a cube refresh subscription in Command Manager. The main thing to keep in mind is that the A,F size is the I-servers best guess as to what the size in-memory will be once it is loadedConsider the following example based on the MicroStrategy Tutorial project. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. Open the. 4. Log into ProjectA in MicroStrategy Web. Open the Workstation window. It's basically just a report, and can even start it's life off as a report. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent Cube is repeated for every row. These privileges are part of OLAP Services. Run the Report and check the SQL View. ACTION:The procedure below provides steps to create a subscription to schedule the publication of an Intelligent Cube. It also. The Select Dataset dialog box opens. Create an Intelligent Cube, with Region, Category, Cost and Profit. It is very simple to create an intelligent cube, it is same like. Browse to an Intelligent Cube, select it, and then click OK. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Click Create and choose Add External Data. 11. After the Intelligent Cube has finished republishing, the Cube. Open Command Manager and type the following commands to. Steps to Reproduce. 3. In your Datasets panel, hover over the name of your dataset. For example, an Intelligent Cube includes Year and Quarter. x. Select the data set and click Prepare Data. Create and publish Intelligent cube called “Cube2” on node B. 4. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). Reports/Documents not created from Intelligent Cube but meet dynamic sourcing requirements: Additional "Use OLAP services" and "Use Dynamic Sourcing" are required for a user to hit an Intelligent Cube, besides the privileges. In MicroStrategy 9. txt file. KB224157: How to Get the Intelligent Cube Status Using MicroStrategy Web SDK. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. MicroStrategy Web also uses the history list from Intelligence Server. These VLDB properties control the method by which the report data are normalized. Refer to the following tech note, KB37431 for a list of Licenses and privileges required for different actions related to Visual Insight in MicroStrategy Web 9. 4. 2. 7. Browse to and select a. For the example scenario, log in to the MicroStrategy Tutorial project. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. Navigate to the Intelligent Cube you want to refresh. 3. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. Log in to the project in which you want to create a report. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. Export to MicroStrategy File. 0 and earlier releases, Outer Join setting for Metrics does not work when there are more than 1 visualizations containing same attributes, metrics, filters but different metric outer join settings when using Live Intelligent Cube as dataset. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. 2 in Web, navigate to the report in edit mode, right click “customer” and insert metric Count as shown below: 3. The report opens with all of the objects of the Intelligent. The following steps can be used to reproduce the issue in the MicroStrategy Tutorial project: 1. The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. Visit the data visualization and data dashboard galleries for inspiration. The report opens with all of the objects of the Intelligent. Browse to an Intelligent Cube, select it, and then click OK. Cube A must be selected here to maintain its attribute IDs after the merge. In Desktop, create and publish an intelligent cube with one attribute and one metric. When an Intelligent Cube is in this status, any reports based on this cube have. All articles. 4. 2. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. Right-click the Intelligent Cube, select "Schedule Delivery To" and choose "Refresh Cube". x Intelligent Cube status indication and workflow To create an attribute form caching cube. x. 0. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. To schedule an Intelligent Cube to be updated. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. The following diagram depicts the role of the intelligent cube. Configure and start the Intelligence Server using the metadata backup. The Browse for Folder dialog box opens. Right-click the dataset, and choose Schedule. To set refresh filters, or alternate data sources, select Show Advanced Options. Create a Visual Insight dashboard and add the above cube as the dataset: 3. Log into the server and go to the Intelligent Cube monitor (Administration > System Monitors > Caches > Intelligent Cubes). We use MicroStrategy Tutorial objects in the following steps. Login Web with Administrator, Create a VI Dashboard based on this cube. 2. For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. 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. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. Insert one panel stack and add dynamic text with Profit Margin. Right-click an Intelligent Cube and select Delete. Choose File > New > Report. Select the refresh policy. Browse to and select a previously saved Intelligent Cube on which to build your report. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. 6 and below, this feature was only available when re-pointing an existing report from one OLAP cube to another OLAP cube or re-pointing the report from one MTDI cube to another OLAP cube. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent Cube is repeated for every row. Intelligent cubes & Level Metrics. On the Home screen, select My Subscription. Common Privileges. 4. Execute View Report. Select data population for Intelligent Cubes. The Intelligent Cube Options dialog box opens. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. Right mouse click on the cube and choose Schedule 3. Delete the cube cache from cube monitor. Required Status to Perform Action. To Create an Intelligent Cube Using Freeform SQL or Query Builder. Create a new File Log and name it “CSI” (or any other name). Supports derived metric creation. 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. Navigate to the Intelligent Cube for which you want to define the incremental refresh. This can be seen in the screenshot below. CAUSE: Starting in MicroStrategy 9. 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‘. Add the report as the dataset for the Dashboard by. When a user imports an Excel file in. Importing MDX cubes is often handled by a MicroStrategy architect. Execute reports or documents that reference the object. x-10. 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. 4. Assuming that ProjectA and ProjectB are in the same metadata, create a Database Instance to connect to an OLAP data source. The following procedure will make cube data accessible to view reports. The Report Editor opens with all of the objects of the Intelligent Cube. x, users will notice that this is not possible due to the mouse. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. This must be done by the DBA and MicroStrategy Technical Support will not assist with this. This can improve the performance of. The group is created as a derived element and displayed on the report. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Log in to the project in which you want to create a report. Enter a name for your new schedule into the. Drill within Intelligent Cube:. 1 or above, to pick up the fix, enable project level setting "Data Engine Version" to 11. Login as MSTR, create an intelligent cube with attribute ‘Year’ and metric ‘Average Revenue’, and publish it as ‘Cube_Tutorial’. 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. x, create a simple Intelligent Cube with attribute Category and metric Revenue. This is a known issue classified as a defect with MicroStrategy Web 9. Designing and creating documents: An overview. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9.