Select Empty. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. In the Name field, type the name of the subscription. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. jar. The Modeling service must be configured correctly to use this feature. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Publish the cube. The differences between the options. When an Intelligent Cube is published, the Intelligent. Since Web distributes connections between Intelligence Servers. Navigate to the Intelligent Cube for which you want to define the incremental refresh. /ClusterCube. 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. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. To create a report that connects to an Intelligent Cube, in MicroStrategy Developer. MicroStrategy URL Structure The following table summarizes the root URL structure used for every request to MicroStrategy Web. 4. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. ACTION: Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled MicroStrategy release. x. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. 1. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Create a cube report based on the cube. 1… Number of Views 9. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. Choose File > New > Intelligent Cube. 2. Right-click the Intelligent Cube, and select Define Incremental Refresh. 1 and 10. (Titled: "Cube broken aplysimple") No data is returned the following SQL view is seen: Report: cube broken applysimple Job: 198 Total Number of Passes: 1 Number of Intelligent Cube SQL Passes: 1 Number of Analytical Passes: 0 Intelligent Cubes Accessed:The steps below show you how to create an Intelligent Cube based on an MDX cube. Description. The Modeling service must be configured correctly to use this feature. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. e. 1. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. 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%. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. They should have the “A, L, F” status (Active, Loaded, Filed). Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. Add Project objects from the All Objects panel. 0. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. 2. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. x and create a new Dashboard. Run the Report and check the SQL View. Common Privileges. This article describes how to update information in an Intelligent Cube without having to do a full republishUsing Web, create an Intelligent Cube with Add External Data> Databases > Select Tables option and add 1 table Order_Detail using a "Live" connection. KB228850: How to migrate published intelligent cubes to a different environment in MicroStrategy Intelligence Server 9. In the left panel, click Cubes. The file location in project configuration is . create(auto_publish=False). Save the cube, and run it to publish. The partition attribute is the attribute that is used to divide. A page with report creation options is displayed. x - 10. To unpublish an Intelligent Cube. Save the Report and close. To accomplish this, the first step is to turn ON this feature by selecting "Create Intelligent Cubes by database connection" in the Project Configuration editor (screenshot below). Create Schema Objects. As shown in the screenshot above, only one cube cache can be loaded in RAM. Select the refresh policy. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Designing and creating documents: An overview. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. 2. Click the MicroStrategy icon, and select Create Report. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. 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. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. The Browse for Folder dialog box opens. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. Create Schema Objects. 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. Hover the schedule need to be modified,. It also. In the Refresh Policy column, choose. Answer: When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. 2. Node 1. . In the Navigation pane, click , next to Datasets. These VLDB properties control the method by which the report data are normalized. Right-click the Intelligent Cube, select "Schedule Delivery To" and choose "Refresh Cube". The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". Save the Report and close. Export to MicroStrategy File. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. All reports that access Intelligent Cubes allow you to drill within the data included in an Intelligent Cube. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 4. Enter a name for your new schedule into the. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. In the Tutorial project create a cube with the Year attribute. Later the user can poll for the change in the value of the flag. You cannot create or edit a card based on an unpublished cube. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. Modify the list of Report objects (use object browser). When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. Click an MDX cube source. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Click Create on any page, point to New Report, and select Blank Report. Use OLAP Services. In MicroStrategy, users can trace MicroStrategy Intelligent Cube activity via the Cube Server Trace which can be enabled through MicroStrategy Diagnositcs Configuration as seen below: The following section displays excerpt from the Cube Server trace when different actions are performed on the MicroStrategy Intelligent Cube. Create a new report based on the published Intelligent Cubes that are supposed to be made available to your designers. Create. IS_CUBE_REP_ID. From the Categories list, expand Options, and then select Data Languages. Expand Intelligent Cubes, and then select General. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Create Intelligent Cubes. This article describes the Intelligent Cube Population options available in MicroStrategy. 4. Click OK to save the Intelligent Cube and return to the Report Editor. Click here to view details about the Intelligent Cube Monitor. From the Data menu, select Configure Intelligent Cube. When you use the cube directly in the Dossier, the definition is applied to the cube directly and the MicroStrategy AE saves time since it doesn’t have to search and fetch an extra report definition. The Intelligent Cube Options dialog box opens. Create Cube A and a report based on it. Type a name for the derived element, and click OK. Execute. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. 4. 7. This VLDB property has the following options:. 3. 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. Log in to the project in which you want to create a report. 4. Report: The results of a report are used to populate the Intelligent Cube. For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. x. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. In the Refresh Policy column, choose. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. From the Data menu, select Configure Intelligent Cube. Create a report with the year and quarter attributes and the profit metric. A user with Use but not Execute permission for an Intelligent Cube can create and execute reports that use that Intelligent Cube, but cannot publish the Intelligent 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). For steps to create an Intelligent Cube report, refer to the OLAP Services Guide . You need the. 4 the connection mapping of the u… Number of Views 1. With OLAP Services features, your report designers can create Intelligent Cube reports. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Create a Data Import Live Intelligent Cube. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. The Intelligent Cube Monitor is displayed. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. Node 1. Setting Up Documents and HTML Documents: This chapter explains the setup required for the Intelligence Server to create and execute HTML documents and documents. Select Build a Query and click Next. You need the Use Intelligent Cube. x, users will notice that this is not possible due to the mouse. Description What's New 2022 Releases Workstation. When Drilling on a report created from an Intelligent Cube gives the Last Update Date of 1899 in MicroStrategy Web 9. 4. 2. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Right-click on the cube and choose Edit. Create a new File Log and name it “CSI” (or any other name). The Intelligent Cube opens in the Report Editor. The Intelligent Cube opens in the Report Editor. To review and create recommended Intelligent Cubes using Cube Advisor. Right-click the project and select Project Configuration. Prerequisites. Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. Total Cubes This section displays the total count of cubes by status. jar file to i-server machine. In the Data Source column, select the checkboxes for the tables to update. Delete the cube cache from cube monitor. In MicroStrategy 10. Open the. This provides ROLAP-type analysis without having to re-execute against the data warehouse. 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. Right-click the report and select Edit. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Start > All Programs > MicroStrategy Products > Integrity Manager. 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. With OLAP Services features, your report designers can create Intelligent Cube reports. You can use the Import Data feature in MicroStrategy Web to import data from sources such as Microsoft Excel spreadsheets, comma-separated text files, and external databases into your project. This is due to the fact that adding prompts to Intelligent Cubes is not supported. This data is stored as Intelligent Cubes. 3. To make the Intelligent Cube available for creating reports, publish the Intelligent Cube by choosing Run Report in the toolbar. If the Intelligent Cube must be re-processed based on a metric. Web create derived metrics and derived attributes: This privilege allows you to create new calculations based on other. 1 Hotfix 6, it is not possible to use the Attribute Name macro in the filename of a bursted document when the document uses an Intelligent Cube create via Data Import as a dataset as the Intelligent Cube's attributes are not in the actual project schema. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. Insert one panel stack and add dynamic text with Profit Margin. g. Create a new Dossier. At least one MDX cube must be imported into your MicroStrategy project. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. Delete one of these two cube caches from the cache monitor in Developer. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. Con: The copy of report data in Intelligence Server memory only applies to a single report. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. How to build and manage Intelligent Cubes. Login MicroStrategy Developer 10. In order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. Select the. Integrity Manager can test the SQL of Intelligent Cubes even if they. Call this 'Base Report'. Choose File > New > Report. CSI after fix:The following steps explain how to share a MicroStrategy Intelligent Cube with users between different connections: In MicroStrategy Desktop, open Project Configuration window for a project, uncheck the option "Create Intelligent Cubes by database connection" under Intelligent Cubes > General, as shown below: Restart. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. 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. 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. x Intelligent Cube status indication and workflowTo create an attribute form caching cube. Login MicroStrategy Web as M20061, go to Add External Data -> Databases -> Select Tables, pick the following tablesFollow these steps to reproduce the issue in a MicroStrategy Tutorial Project. Log into ProjectA in MicroStrategy Web. After updating an intelligent cube through incremental refresh, when running a report based off the cube, the incorrect time (12/29/99 7:00:00 PM) appears as the last update time in MicroStrategy Web 9. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. For steps to create an Intelligent Cube based on an MDX cube, see Creating Intelligent Cubes based on MDX cubes. Related Topics. 2. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. 4. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. x releases, and the new Multi-table Data Import (MTDI) cubes. When triggering the concurrent subscriptions to publish a cube with different database connections, some of them do not publish. Open MicroStrategy Developer. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. From the cube monitor, we could see the old cube is it. MicroStrategy AI is here. 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. Choose File > New > Intelligent Cube. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. The Intelligent Cube Monitor is displayed. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. In the Navigation pane, click Applications. You must belong to the System Administrators group to use this feature. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Republish the. Data Population for Intelligent Cubes. You can also select an existing template on which to build your new report. Create a Report 'R3' with 'Country' attribute. Follow the steps below using the MicroStrategy Tutorial project: 1. In MicroStrategy Desktop 9. To schedule updates for the Intelligent Cube. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. 3. Open the cube report in Design View. It is very simple to create an intelligent cube, it is same like. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). 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. Disconnect from the project source and restart both Intelligence servers. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. The Intelligent Cube Options dialog box opens. Create a report based on the Intelligent Cube. 2. By default, Intelligent Cubes created through Data Import are saved to the MicroStrategy user's "My Reports" folder. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. 4. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. x. Insert one panel stack and add dynamic text with Profit Margin. 2 release, the driver file is called odbc8. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. Create a Report 'R3' with 'Country' attribute. Browse to and select a previously saved Intelligent Cube on which to build your report. Add External Data. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. Publish the cube. x as Administrator; create a simple Intelligent Cube called Q, and publish it. The group is created as a derived element and displayed on the report. Here, we use MicroStrategy Tutorial objects to create a report: Add Category, Brand, and. We use MicroStrategy Tutorial objects in the following steps. You should see these cubes in the Intelligent Cube cache monitor in Developer. The cube now has Year and Category on it. Community & Support Search Discussions Open A Case View My CasesSince the Intelligent Cube is based off a FFSQL report, the columns in the metrics being used are managed objects. Select the refresh policy. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. To Create a Report Using Both Report Objects from a MicroStrategy Project and MDX Cube Data. Quickly integrating data into MicroStrategy as part of a proof-of-concept. All articles. Configure and start the Intelligence Server using the metadata backup. Under Refresh type, select one of the following options. Navigate to the Engine Component with CSI Dispatcher. Section 5: Load Intelligent Cube files into the Intelligence Server. Run a Command Manager script to delete the cube cache previously deleted in step 2. com. • You need the Publish Intelligent Cube (Developer) and/or Web Publish Intelligent Cube (Web) privileges. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Create a Visual Insight dashboard and add the above cube as the dataset: 3. Select the data set and click Prepare Data. 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. Under Refresh type, select one of the following options. Browse to and select a. The Report Editor opens with all of the objects of the Intelligent Cube. ACTION:In the Navigation pane, click Monitors. 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. Create a new dossier: Create a new metric M01=Case: Create a new metric. Right-click the cube, and select Schedule. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. Dynamic source hit. 3. Edit Project-Level Cache and Intelligent Cube Settings. To schedule an Intelligent Cube to be updated. 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. Node 2. Users can create a Report Post SQL Statement within the Intelligent Cube that updates the value of a flag in the warehouse table. Use the Objects section to search for the desired metrics and attributes. Create an Intelligent cube with Month and Revenue. Add DM. In MicroStrategy 11. This determines the approach to existing data at refresh. In MicroStrategy Developer, log in to a project that contains reports connected to active Intelligent Cubes. Create an attribute element prompt for the Year attribute. Web Analyst. In the Name field, type the name of the subscription. 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)". The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Normalize Intelligent Cube data in MicroStrategy Intelligence Server . The ability to view or edit certain settings is determined by a user's privileges. Execute reports or documents that reference the object. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. From the Data menu, select Configure Intelligent Cube. For information on using Cube Advisor to support dynamic sourcing, see Using Cube Advisor to support dynamic sourcing. The Save Intelligent Cube As dialog box opens. Intelligent cube is an OLAP feature introduced in Microstrategy 9 version. ICUBE_STATUS: shows the status of the intelligent cube, returned as a string value. Log into the server and go to the Intelligent Cube monitor (Administration > System Monitors > Caches > Intelligent Cubes). Right-click the cube, and select Schedule Data Refresh. Save the Cube with Connect Live Data Access Mode. In MicroStrategy Developer create an Intelligent Cube with any attributes and metrics. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. In MicroStrategy Web browse to the Cube location and click on the cube . In the Refresh Policy column, choose one of the following options: To define an incremental refresh report. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. PublishCube". Create an Intelligent Cube, with Region, Category, Cost and Profit. 4. Create a cube report based on the cube. 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. Common Privileges. Create a new File Log and name it “CSI” (or any other name). MicroStrategy transforms organizations into intelligent enterprises through data-driven innovation. 3. 1, Data Import allows users to maintain intelligent cubes from external Excel files. 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. STEPS TO REPRODUCE: 1. Navigate to the folder location of the Intelligent Cube. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. In Desktop, create and publish an intelligent cube with one attribute and one metric. Browse to an Intelligent Cube, select it, and then click OK. Add the report as the dataset for the Dashboard by. In MicroStrategy 10. 4. A list of data sources available in this project appear. This is an identified defect in Visual Insight in MicroStrategy Web 10. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database.