Typically, a long duration is seen in the Data Transfer time which indicates the time it takes to fetch data from the warehouse. 1. Prerequisites for using Cube Advisor. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. 86K KB31566: MicroStrategy 9. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Intelligent Cubes. 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)". Create a new Intelligent Cube C01 using the "ORDER_FACT" table: Add External Data > Databases > Select Tables. Choose Databases. Select Build a Query and click Next. They should have the “A, L, F” status (Active, Loaded, Filed). Open the. However, importing data from a Google Drive Spreadsheet requires some additional setup. 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. Right-click an Intelligent Cube and select Delete. Navigate to the Intelligent Cube for which you want to define the incremental refresh. 4. Multiple reports can access a single. 4. Publish the cube. It also. 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. Click OK. For the Intelligent Cube that you want to refresh, click the subscription icon. Right Mouse Click on ‘Cube_Tutorial’ to create report called ‘Report_Tutorial’. blogspot. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. After the Intelligent Cube has finished republishing, the Cube. Sharing data. For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. Execute. In MicroStrategy 11. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. x - 10. At least one MDX cube must be imported into your MicroStrategy project. and select the Project-Name. To solve this problem, we introduce a new registry key, " Respect. Starting in MicroStrategy 10. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. Some uses for this data include: •. STEPS TO REPRODUCE: 1. Add Project objects from the All Objects panel. You can also reproduce this issue in a Document. You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. To create an MDX cube report in MicroStrategy Web, you need to have Web Professional privileges, including the Web Define MDX Cube Report. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. The "Email" column cannot be found in. HIDDEN: if the intelligent cube is hidden or not, returned as a boolean value. Intelligent Cube IC2 contains attributes 'Country' and 'Region' Create a report services document with the above 2 Intelligent Cubes as datasets. STEPS TO REPRODUCE. The Intelligent Cube Monitor is displayed. All necessary privileges are included in the Administrator role by default. The Browse for Folder dialog box opens. 2) Choose "Database" and select the 3rd option to "Pick tables". 2. Web Analyst. 2. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Easily add or change pre- and post- SQL statements. 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. In MicroStrategy 9. IS_PROJ_ID. Use OLAP Services. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. com Format: A MicroStrategy Online. This is an identified defect in Visual Insight in MicroStrategy Web 10. 3. 2. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. Click Create on any folder page, point to New Report, and select MDX Cube Report. To set refresh filters, or alternate data sources, select Show Advanced Options. You can also select an existing template on which to build your new report. Right-click the project and select Project Configuration. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. By default, this is set to 32,000. Right-click the Intelligent Cube, and select Define Incremental Refresh. Republish the. Loading. Open the Workstation window. In MicroStrategy Web, open the document in Design Mode or Editable Mode. Setting Up Documents and HTML Documents: This chapter explains the setup required for the Intelligence Server to create and execute HTML documents and documents. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. 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. Visit the data visualization and data dashboard galleries for inspiration. This property can only be enabled through Workstation. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. Steps to Reproduce. 4. We match smart people to dynamic projects and technologies that truly. 4. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide. Right-click an Intelligent Cube and select Delete. In the Grid/Graph, you can use MicroStrategy Web to create a threshold to change the formatting of the revenue amounts when the profit is greater than a specified amount. 1. In MicroStrategy Developer, browse to an Intelligent Cube. Login Web with Administrator, Create a VI Dashboard based on this cube. Create Schema Objects. Web Analyst. For steps to create a view filter in MicroStrategy Web, see the MicroStrategy Web Help. To schedule an Intelligent Cube to be updated. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. This is possible because when the Intelligent Cube refresh job finishes, a record is logged in the IS_REPORT_STATS table. Export to MicroStrategy File. x as Administrator; create a simple Intelligent Cube called Q, and publish it. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube, and click OK. Publish the cube. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. Then click "Save". First, you open a blank document and select a report to use as the document's dataset. delete one relation as the following Then click "Save" to go back to the cube editor, click the "Update Dataset" button in the bottom right corner. Check the location of the new cube cache and notice that it is saved in the default location, i. Save the Intelligent Cube generated. From the. The status of each Intelligent Cube is listed in the. Create an intelligent cube with Call Center, Quarter and the derived metric 3. In MicroStrategy Web 10, during Data Import, users are able to choose "Connect Live" data sources, which is also known as "Direct Data Access" function, as shown below:. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. Browse to an Intelligent Cube, select it, and then click OK. How to build and manage Intelligent Cubes. STEPS TO REPRODUCE 1. details. Select data population for Intelligent Cubes. Delete one of these two cube caches from the cache monitor in Developer. Start > All Programs > MicroStrategy Products > Integrity Manager. Modify the list of Report objects (use object browser). Create a report with Category, Region and Year attributes, and Revenue metric in the grid, and Year prompt from Step 1 in the report filter. In your Datasets panel, hover over the. In Web, create a new Dossier and click on New Data. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Create a second report with the year and quarter attributes and the revenue metric. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. Check the status of the cubes in Developer. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. You can also modify the properties of. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). You must browse to the MDX cube to use to build the Intelligent Cube. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. An. For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. Navigate to Administrator -> System monitor -> Cube monitor both nodes, and check all cube are “active, load, file” status. STEPS TO REPRODUCE: 1. Prerequisites. 2 attributes and 1 metric). The report opens with all of the objects of the Intelligent. 3. 1, users could right click an Intelligence cube to create a URL API call that would allow users to automatically create a Visual Insight dashboard using that same cube. Edit Intelligent Cubes from the new editor in Workstation at any time. PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public Objects\Reports\Sequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a script that also requests the Command Manager console to be open through the command prompt. 1Currently it is not possible to create a cube refresh subscription in Command Manager. Create a new in-memory dataset with the create_dataset() function. First, you open a blank document and select a report to use as the document's dataset. It is possible to create an Object Manager package for an Intelligent Cube created through Data Import in Web and then import the package into a different environment in MicroStrategy 10. The file location in project configuration is . Click Select. In Developer, log into a project. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Share query results in-memory across multiple dossiers and. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. To publish an Intelligent. The following steps can be used to reproduce the issue in the MicroStrategy Tutorial project: 1. However, the metric must display in the area of subtotal, the total number of customers inserted into the data warehouse, not the sum of. 9K KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. 3 - Check the Make Intelligent. 11. Open MicroStrategy Web. In MicroStrategy 9. This command will deactivate the Intelligent Cube cache so reports from this Intelligent Cube will not be able to run while it is being re-published. Click Databases . Log in to a project connected to an MDX cube source. Web Analyst. Description What's New 2022 Releases Workstation. See Importing MDX cubes in the MDX Cube Reporting Help for more information. Create. Under Cube Update, click Cube Update. Dynamic source hit. Select Empty. Navigate to the folder location of the Intelligent Cube. The ability to view or edit certain settings is determined by a user's privileges. Integer ID of the Intelligent Cube report that was published, if any. 4. Click Intelligent Cube Report. Go to the "All Objects View" option in the top left corner. This issue has been classified as a defect by MicroStrategy. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. To schedule updates for the Intelligent Cube. On the Home screen, select My Subscription. Login to MicroStrategy Web, create a cube with the function of Data Import 2. Right-click the dataset, and choose Schedule. In the web cube editor for a data-import cube, pick a table and choose "Define Relationships" from the table drop-down menu to modify the relations, e. 4. The value of Composite Metrics displays with “--“ in Intelligent Cube based Report in MicroStrategy 9. Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. Open the. Select Intelligent Cubes > General > Intelligent Cube File directory. 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. The Save Intelligent Cube As dialog box opens. Open the Workstation window. Execute View Report. com. By default, Intelligent Cubes created through Data Import are saved to the MicroStrategy user's "My Reports" folder. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. “Intelligent Cube (<Cube Name>) for locale. x releases, and the new Multi-table Data Import (MTDI) cubes. 4 the connection mapping of the u… Number of Views 1. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. create(auto_upload=False,. From the Report Selection panel, go to the File menu > Open. 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. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. 4 the connection mapping of the u… Number of Views 1. The CREATE and INSERT support VLDB property defines whether MicroStrategy can perform CREATE and INSERT statements against the database for a database instance. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. KB485159: Enable support for Security Filter with Top and Bottom Range Attributes in Data Import Intelligent cubes and Fix the security hole in Connect Live Data Import Intelligent cubes MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). In order to set up an incremental refresh report, the user should first right click on the Intelligent Cube and select "Define Incremental Refresh Report":After each unload/reload, and running the Dossiers against the cube, the duplicate Element Block files will be dumped into the same *****_objects folder. Go to MicroStrategy Web 10. Description. Select data population for Intelligent Cubes. From the File menu, select Create Test. Browse to an Intelligent Cube, select it, and then click OK. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. Right-click your selection and select Group. A report accessing the Intelligent Cube includes only Year on the report. Use OLAP Services. 2. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. Number of Views 1. We use MicroStrategy Tutorial objects in the following steps. Click “All Objects View”. In the Intelligent Cube cache monitor in Developer, notice that all cube caches for the project. Republish the Intelligent Cube or re-create a report cache, which will be shared with MicroStrategy Technical Support; Send the requested data to MicroStrategy Technical Support; Revert the metric definition back to the original one, or remove the randomized metric from the report (Intelligent Cube configuration is not relevant in MicroStrategy 8. Select the "ORDER_FACT" table. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. When a user imports an Excel file in. In MicroStrategy Desktop 9. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Under Refresh type, select one of the following options. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. Create a new File Log and name it “CSI” (or any other name). Modify the list of Report objects (use object browser). Save the Intelligent Cube. Create a Report 'R3' with 'Country' attribute. Create a New Dossier. Total Cubes This section displays the total count of cubes by status. Check it in the cube monitor and we can see its column Database Connection is not empty. Make sure the service is properly configured and running before using the Intelligent Cube Editor. 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%. Watch the Product team review how to configure and manage advanced properties of Intelligent Cubes. 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. In MicroStrategy Web 10. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. This can improve the performance of. In MicroStrategy Developer, log in to a project source with administrative privileges. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. Select "Add External Data" and connect to an OLAP data source with the Live Connect option. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. The Browse for Folder dialog box opens. From the Categories list, expand Options, and then select Data Languages. KB224157: How to Get the Intelligent Cube Status Using MicroStrategy Web SDK. Create 500 users, 500 database logins, and 500 database connections mapping to the same data warehouse. Browse to and select a. Select an Environment from the upper-left drop-down. This can be seen in the screenshot below. Create an attribute element prompt for the. This permission is checked at design time, and when executing reports against an Intelligent Cube. Create a metric that returns a transformation of last year's. 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. 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. Select an MDX cube. Click OK to save the Intelligent Cube and return to the Report Editor. KB30711: Security filter application to view reports based on Intelligent Cubes. These prerequisites include: Enable dynamic sourcing for the project and other aspects of the MicroStrategy system. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Right-click the report and select Edit. Full Refresh. You can edit project-level cache and Intelligent Cube settings. In the Refresh Policy column, choose. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". The Create Group dialog box opens. It retrieves report results from a schema source and stores it in memory. 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. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. 0 MicroStrategy releases. Steps to import a spreadsheet from Google Drive: MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. Let us assume the Intelligent Cube is published on Node B: Create an event called "Refresh Cubes" Create an event-based schedule called "Refresh Cubes"" Web Reporter" and "Report Services document" are required to run Intelligent Cube document. In the Data Source column, select the checkboxes for the tables to update. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. x, when there are multiple fact tables available to perform the fact extension, different fact table are used by the analytical engine for the fact extension in Connect Live and In-Memory Intelligent Cube. All Intelligent Cube operations are listed below: 1. Some data that may be available to the user by directly querying a data source may not be available in the report that accessed an Intelligent Cube. MicroStrategy AI is here. From the cube monitor, we could see the. Web Analyst. 1. For the example scenario, create a report with Year, Region, and Profit Margin on the report. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. /mstrctl -s IntelligenceServer. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. 119 Share Save 45K views 9 years ago MicroStrategy Advanced Topics by MicroRooster Source: MicroRooster. You need the Use Intelligent Cube. Click Create on any page, point to New Report, and select Blank Report. The ability to view or edit certain settings is determined by a user's privileges. 0. 2 release, the driver file is called odbc8. The Intelligent Cube opens in the Report Editor. ACTION:The Data Transfer Rate varies from 27 to 28 Mb/s. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. This copy of report data is stored in Intelligence Server memory only. Expand Intelligent Cubes, and then select General. Create the metric levels log file used to. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. There is another reason that the intelligent cube is imported from a local file in the web server machine, and the Web server and the Intelligence Server do not need to be on the same machine. 1 clicking on the Intelligent Cube does not publish the cube but instead creates an analysis from the cube. Allow reports to drill outside the Intelligent Cube Select this option to enable drilling outside the Intelligent Cube to access the full set of data available in the data. 000007431. No additional resources are needed to modify the Intelligent Cube or to create a new report. Configure a Cluster with a Centralized Cache. It is very simple to create an intelligent cube, it is same like. 5. 4 the connection mapping of the u…Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. To Create a Report that Accesses an Intelligent Cube. Create a report based off the cube in Step 1 that includes the description form for Category. x. 4. Select other schedule options as required, and click OK. CAUSE: This is working as designed. In the left pane, click Intelligent Cubes. Create an attribute element prompt for the Year attribute. x clustered environment may observe that after a period of time from the initial publishing of the cube and executing reports based off it, the size of the cubes as reported by the Intelligent Cube monitor in some cases is different in one node than the other node(s). Follow the steps below using the MicroStrategy Tutorial project: 1. From the File menu, select New, and then select Intelligent Cube. 3. 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. Steps To Reproduce 1. 10, when the "Defect fixes may impact Data, SQL, MDX, CSI" is turned to "On" under Web preferences > Project Default, thresholds for derived metric cannot be properly applied if the condition is based on a cube base attribute. Save the cube, and run it to publish. Remove the prompt from the Base Report and save it as Intelligent Cube. Open the. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Prerequisites. At this point, the Month attribute can be removed from the cube to reduce the publication time and size of the Intelligent Cube within memory. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. Create a report based on above Cube and add the prompt in view filter. 2. Insert one panel stack and add dynamic text with Profit Margin. Complete the "sessionState" field (e. The Intelligent Cube opens in the Report Editor. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. 2. PublishCube". Multiple reports can access a single. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. The cube now has Year and Category on it. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. Once this privilege is enabled, the Intelligence Server Administration screen looks like the following: With only these three privileges, a user is able to access the User Manager in Web. Save the Report and close. 4. This is the same requirement to create or run a static report in Workstation. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help.