STEPS TO REPRODUCE: 1. 2. The group is created as a derived element and displayed on the report. Importing MDX cubes is often handled by a MicroStrategy architect. Check in Developer that the stopped node is in Maintenance Mode. Open the cube report in Design View. For the Intelligent Cube that you want to refresh, click the subscription icon. Create an Intelligent Cube with attribute Region and metrics, Revenue and Revenue Forecast; Create a subset report based on the above Intelligent Cube; Insert a derived metric DM = Revenue Forecast/Revenue as seen below: Execute the report either in MicroStrategy Desktop 9. Reporting on MDX Cubes. Report: The results of a report are used to populate the Intelligent Cube. Number of Views 1. By default, the report template used is the same as the Intelligent Cube's template. For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (article describes how to provide Intelligent Cube cache files to MicroStrategy for troubleshooting cases. 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. Web Analyst. Documentation on the REST API is at developer. Shut down Intelligent Server node A with command . For Oracle 12. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. 0. At this time, only one table per cube is supported. Execute View Report. 1. This data is stored as Intelligent Cubes. Create a report services document or Visual Insight Analysis. 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. 2. To make the Intelligent Cube available for creating reports, publish the Intelligent Cube by choosing Run Report in the toolbar. Select data population for Intelligent Cubes. Select the Intelligent Cubes tab. Notice the attribute forms in the Report Objects pane. Open the Workstation window. Web publish Intelligent Cube. 4. 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. The month ID for 2004 Jan is like 200401. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. In this case, the dataset is a MicroStrategy Intelligent Cube. The display of data is handled by the reports that access the Intelligent Cube. Open the cube report in Design View. The current version of MicroStrategy Tutorial is designed using the MicroStrategy URL API with JSP framework, therefore MicroStrategy ASP is not supported for the redesigned Tutorial project. 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%. The create_cube() function will return the datasetID and tableID, which can be used to update a dataset with new data. Create a document with orderID and itemID attributes on the grid. This group also inherits all of the privileges assigned to the Web Reporter group. Share query results in-memory across multiple dossiers and reports. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. Supports derived metric creation. An enhancement Request has been reported to the MicroStrategy Technology team. After the Intelligent Cube has finished republishing, the Cube reports will contain the updated. Execute reports or documents that reference the object. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Click the “Add history list subscription” link near the bottom of the screen to open the. Click Create on any page, point to New Report, and select Blank Report. Common Privileges. 4. create(auto_upload=False,. Designing and creating documents: An overview. When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. How to configure, monitor, and manage Intelligent Cubes. details. 4. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. To add an existing report or Intelligent Cube as a dataset. Web Analyst. 2. Start > All Programs > MicroStrategy Products > Integrity Manager. To set refresh filters, or alternate data sources, select Show Advanced Options. 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. From the Data menu, select Configure Intelligent Cube. Prerequisites for using Cube Advisor. You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. Click the “Add history list subscription” link near the bottom of the screen to open the. Click Intelligent Cube Report. At least one MDX cube must be imported into your MicroStrategy project. Intelligent Cubes in MicroStrategy - A Tutorial MicroStrategyBlog 413 subscribers Subscribe 21K views 11 years ago A quick tutorial on how to create and. Select the refresh policy. 3. The Intelligent Cube Options dialog box opens. The ability to view or edit certain settings is determined by a user's privileges. Create a Report 'R3' with 'Country' attribute. Create Cube A and a report based on it. IS_CUBE_INST_ID. 2. 2 in Web, navigate to the report in edit mode, right click “customer” and insert metric Count as shown below: 3. Open the Workstation window. The ability to view or edit certain settings is determined by a user's privileges. The first step in analyzing the performance of Intelligent Cube Publication is to look at the post-execution SQL view of the initially published Intelligent Cube and understanding the breakdown. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Right-click an application and choose Properties. Easily add or change pre- and post- SQL statements. No additional resources are needed to modify the Intelligent Cube or to create a new report. Faster performance than directly querying warehouse. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. microstrategy. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. 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). Select the refresh policy. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube, and click OK. They are. Edit Intelligent Cubes from the new editor in Workstation at any time. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT. Right-click your selection and select Group. And create one Cube based report called “cube report 2”. 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. Hover the schedule need to be modified,. This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. Now, create an hierarchy prompt but before saving , save/overwrite them on top of “Qualification Prompt” that is being used in the Cube – ensure, the hierarchy objects exists within cube. Once you have reviewed the information, select the check boxes for the Intelligent Cubes to create using Cube Advisor, and then click Create Cube Design. Create a Data Import Live Intelligent Cube. Create 3 aggregate from base metrics as follows:In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. 4. STEPS TO REPRODUCE 1. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent. Node 2. STEPS TO REPRODUCE: 1. Right-click an Intelligent Cube and select Delete. To publish an Intelligent. Note that the cube has a neutral data language. 1. 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. The Intelligent Cube Editor uses the new Modeling service infrastructure. 1. Use the drop-down under the filter summary section to switch the server nodes. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. In MicroStrategy Developer, browse to an Intelligent Cube. 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 a report based off the cube in Step 1 that includes the description form for Category. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Upload Dashboard. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. In MicroStrategy Web 10. Enter a name for your new schedule into the. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. More than one cube can be used in a single dashboard. Click OK. Create a Report 'R3' with 'Country' attribute. Intelligent cube is a pre aggregated set of data stored in intelligent server memory and it will give very quick access to the data without hitting the data warehouse. This permission is checked at design time, and when executing reports against an Intelligent Cube. STEPS TO REPRODUCE. If the Intelligent Cube must be re-processed based on a metric. For steps, see the Upgrade Guide. In MicroStrategy Developer, log in to a project source with administrative privileges. Select Build a Query and click Next. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. The Intelligent Cube Monitor is displayed. com. 4. 3. Click a catalog. 4. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. Expand Intelligent Cubes, and then select General. To Schedule a Cube Refresh. For steps to create an Intelligent Cube based on an MDX cube, see Creating Intelligent Cubes based on MDX cubes. The Subscribe to Cube /Cache Update dialog box opens. On the Freeform Sources tab, select one of the following options: To. 2. To create an Intelligent Cube based on an MDX cube Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Required Status to Perform Action. 3. Answer: When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. Create an Intelligent Cube, with Region, Category, Cost and Profit. 1Currently it is not possible to create a cube refresh subscription in Command Manager. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 4. The ability to view or edit certain settings is determined by a user's privileges. Steps to reproduce. Browse to and select a. txt file. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. STEPS TO REPRODUCE Use Data Import to bring in an Excel file containing a few columns (i. Upload Dashboard. 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. x-10. When an Intelligent Cube is published, the Intelligent. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. MicroStrategy Web and Mobile deployed in a JSP server like Tomcat. In the left panel, click Cubes. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. Expand Intelligent Cubes, and then select General. Defining the partition for Super Cubes. Create Cube B which contains all objects in the report and publish it . In MicroStrategy Developer, log in to a project that contains reports connected to active Intelligent Cubes. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Web object search—this enables the user to see the “User Manager” button on the Intelligence Server Administration page. 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. Launch MicroStrategy Cube Advisor from the Start menu > Programs > MicroStrategy > Tools > Cube Advisor. The Select Intelligent Cube dialog box opens. 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. By default, there is a system hierarchy on the cube. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. Open the. From the Data menu, select Configure Intelligent Cube. CAUSE: The report on which the action is being performed is a "Standard" report, only OLAP reports can be pointed to Intelligent Cubes. Right-click on the cube and choose Edit. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. MicroStrategy URL Structure The following table summarizes the root URL structure used for every request to MicroStrategy Web. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. To create an MDX cube report in MicroStrategy Web, you need to have Web Professional privileges, including the Web Define MDX Cube Report. In MicroStrategy Web, log in to a project. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. 1, Data Import allows users to maintain intelligent cubes from external Excel files. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Navigate to the Engine Component with CSI Dispatcher. Workaround 2: Create a non-Kerberos authenticated database login. Open the cube report in Design View. 1. 4. To do so, you can take advantage of URL API. Navigate to the Engine Component with CSI Dispatcher. Before MicroStrategy 10. 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. Right mouse click on the cube and choose Schedule 3. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 4. 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. However, importing data from a Google Drive Spreadsheet requires some additional setup. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. In MicroStrategy Web browse to the Cube location and click on the cube . In Web, create a new Dossier and click on New Data. To solve this problem, we introduce a new registry key, " Respect. 1 or MicroStrategy Web 9. 11. KB30711: Security filter application to view reports based on Intelligent Cubes. Configure and start the Intelligence Server using the metadata backup. x. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. Users can create a Report Post SQL Statement within the Intelligent Cube that updates the value of a flag in the warehouse table. The Intelligent Cube opens in the Report Editor. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Save as an In-Memory dataset. In MicroStrategy Web, edit the Cube where users want to enable partitioning. Watch the Product team review how to configure and manage advanced properties of Intelligent Cubes. Introduction: Need to create a report with a metric that calculates the number of distinct customers. You can edit project-level cache and Intelligent Cube settings. Select Empty. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. The dataset is a set of data that can be displayed on the document. To Create a Report that Accesses an Intelligent Cube. Click “All Objects View”. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). From the Report Selection panel, go to the File menu > Open. The Select Dataset dialog box opens. To schedule an Intelligent Cube to be updated. Create a user (tester) and disable the "web publish Intelligence Cube" privileges under Web Analyst. In the Refresh Policy column, choose one of the following options: To define an incremental refresh report. For intelligent cube imported from local file via Data Import, we do not support creating subscriptions as the path may change. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user. There is no need to further create a dashboard. Log in to the project in which you want to create a report. After the Intelligent Cube has finished republishing, the Cube. Choose Databases. Create an Intelligent Cube, with Region, Category, Cost and Profit. 4. x-10. RMC on attribute Warranty to Create Attribute named ‘IsWarranty’ with the formula of “IsWarranty: Case(([Warranty]@[DESC]="No"), 0, 1)” as shown below:To update the newly created Super Cube, create a new script starting from repeating steps 3-7. Browse to an Intelligent Cube, select it, and then click OK. We use MicroStrategy Tutorial objects in the following steps. Publish. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. Login to MicroStrategy Web, create a cube with the function of Data Import 2. 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‘. Call this 'Base Report'. 1, Data Import allows users to maintain intelligent cubes from external Excel files. The cube now has Year and Category on it. Log into the three-tier project source and choose the project that was analyzed in stage 2. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. The Create Group dialog box opens. All necessary privileges are included in the Administrator role by default. Choose File > New > Intelligent Cube. MicroStrategy AI is here. 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. 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. Node 1. Under Cube Update, click Cube Update. 4. Run the Report and check the SQL View. Click All Objects View. 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. In MicroStrategy Web 9. Modify the list of Report objects (use object browser). For background. 4. . Export to MicroStrategy File. 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). The Subscribe to Cube /Cache Update dialog box opens. Drag and drop the objects into the report grid from the Report Objects pane. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Total Cubes This section displays the total count of cubes by status. Easily add or change pre- and post- SQL statements. Edit the cube from step 1 and add the Category attribute. 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 dataset, and choose Schedule. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. Create a New Dossier. 2. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Add the report as the dataset for the Dashboard by. Browse to an Intelligent Cube, select it, and then click OK. Stop the. Select the "ORDER_FACT" table. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. To Create an Intelligent Cube Using Freeform SQL or Query Builder Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Click Create on any page, point to New Report, and select Blank Report. Designing and creating documents: An overview. To learn more about Intelligent Cube Data Partition, please refer to KB237803. This is the same requirement to create or run a static report in Workstation. 4 the connection mapping of the u… Number of Views 1. To view an existing cube, you must have the following minimal privileges: Use analytics. Load an updated CSV file into a DataFrame providing full path. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. You can also modify the properties of. IS_PROJ_ID. Publish the cube. While the report cache is disabled at the report level and there is no cache or Intelligent Cube exist for the dataset to hit, "In Memory" appears under the dataset name listed in Visual Insight editor with MicroStrategy Web 10. Insert one panel stack and add dynamic text with Profit Margin. 1 to see the results as shown. In MicroStrategy Web, click "Access External Data"; In the "Connect to Your Data" window, click the "Manage Your Datasets" link in left-bottom corner, as shown below: In Data Storage window, right mouse click the cube and choose "Schedule", a sub context menu displays all the existing schedule. In Project B, create and run a new Intelligent Cube. Save the Report and close. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. You can also create an Intelligent Cube that contains data from an MDX cube integrated into MicroStrategy from an MDX source such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. To publish an Intelligent Cube, see. Right Mouse Click on ‘Cube_Tutorial’ to create report called ‘Report_Tutorial’. 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. If. 0. In MicroStrategy 11. 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. This can affect performance of your Intelligence Server as well as the ability to publish the. However, users can achieve this functionality by creating a cache update subscription to refresh Intelligent Cubes. Click the MicroStrategy icon, and select Create Report. Integrity Manager can test the SQL of Intelligent Cubes even if they. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. Create a new report based on the published Intelligent Cubes that are supposed to be made available to your designers. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. In an Intelligent Cube report, only the "Data Population for Intelligent Cubes" will be visible; in standard reports, it will be "Data Population for Reports. x. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. 2. Search for prompt answer in report based on Intelligent Cube returns no results on selected ID form in MicroStrategy Web 9. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. Modify the list of Report objects (use object browser). x, users will notice that this is not possible due to the mouse. 1.