Execute reports or documents that reference the object. Click Close, then "Finish" on the "prepare data" view and save the cube. From the Data menu, select Add Dataset. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent. Configure a Cluster with a Centralized Cache. The create_cube() function will return the datasetID and tableID, which can be used to update a dataset with new data. 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. This permission is checked at design time, and when executing reports against an Intelligent Cube. “Intelligent Cube (<Cube Name>) for locale. All articles. The predefined MicroStrategy Web Analyst group is assigned the set of Web Analyst privileges by default. 2. Right-click an application and choose Properties. The Create Group dialog box opens. The Browse for Folder dialog box opens. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. You can also create Intelligent Cubes by directly querying your data. Trending Articles. Log in to a project connected to an MDX cube source. 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. For the example scenario, create a report with Year, Region, and Profit Margin on the report. The status of each Intelligent Cube is listed in the. Complex metrics here refer to metrics which are defined using multiple. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. 2 attributes and 1 metric). 2. You'll need to provide a name for your cube, as well as a name for the table that will contain the 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. Click Databases . MicroStrategy URL Structure The following table summarizes the root URL structure used for every request to MicroStrategy Web. To schedule an Intelligent Cube to be updated. • You need the Publish Intelligent Cube (Developer) and/or Web Publish Intelligent Cube (Web) privileges. When Drilling on a report created from an Intelligent Cube gives the Last Update Date of 1899 in MicroStrategy Web 9. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. 3. This issue has been classified as a defect by MicroStrategy. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. The Browse for Folder dialog box opens. Description What's New 2022 Releases Workstation. To create an Intelligent Cube based on an MDX cube Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Normalize Intelligent Cube data in the Database 4. Click OK to save the Intelligent Cube and return to the Report Editor. Created cube with lastname and any other attribute. Log into the server and go to the Intelligent Cube monitor (Administration > System Monitors > Caches > Intelligent Cubes). It's basically just a report, and can even start it's life off as a report. Normalize Intelligent Cube data in the. Create a new Dossier. Select the "ORDER_FACT" table. It does not tell us anything helpful and we should not use it as a point of reference. Create a new Intelligent Cube C01 using the "ORDER_FACT" table: Add External Data > Databases > Select Tables. Designing and creating documents: An overview. 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. If the Intelligent Cube must be re-processed based on a metric. GUID: is the GUID of the intelligent cube, returned as a string. From the cube monitor, we could see the old cube is it. Publish the cube. Create an Intelligent Cube, with Region, Category, Cost and Profit. Data access security is maintained. 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. Right-click your selection and select Group. Create. Create 3 aggregate from base metrics as follows:In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. Once the workflow is open in System Manager, you can select each process in the workflow to review the task that it performs for the workflow. You must browse to the MDX cube to use to build the Intelligent Cube. Introduction: Need to create a report with a metric that calculates the number of distinct customers. We can create a report and point the report to a cube or right click. Right mouse click on the cube and choose Schedule 3. 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. 3 - Check the Make Intelligent. 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. 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. This data is stored as Intelligent Cubes. On the ODBC Sources tab, in the Source area, select the database instance that connects to the data source to report on using Freeform SQL or Query Builder. This VLDB property has the following options:. In the Object name field, type a descriptive name for the Intelligent Cube. Execute View Report. Upload Dashboard. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. 4. 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:. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. Click the MicroStrategy icon, and select Create Report. 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. With OLAP Services features, your report designers can create Intelligent Cube reports. STEPS TO REPRODUCE: 1. 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. 11. 4. 4. In MicroStrategy Developer, browse to an Intelligent Cube. Choose File > New > Intelligent Cube. Total Cubes This section displays the total count of cubes by status. The default value is 256 megabytes. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. The Save Intelligent Cube As dialog box opens. In this case, the dataset is a MicroStrategy Intelligent Cube. Save the Report and close. Expand Intelligent Cubes, and then select General. It is especially useful when data. For steps, see the Upgrade Guide. 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). Save the Intelligent Cube. 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. x Intelligent Cube status indication and workflowTo create an attribute form caching cube. 3. Open the. Common Privileges. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. Create an Intelligent Cube, with Region, Category, Cost and Profit. To Schedule a Cube Refresh. Log in to the project in which you want to create a report. 1. It is very simple to create an intelligent cube, it is same like. Drill within Intelligent Cube:. In Desktop, create and publish an intelligent cube with one attribute and one metric. 38K. Steps to Reproduce. 11. Importing MDX cubes is often handled by a MicroStrategy architect. In MicroStrategy Web browse to the Cube location and click on the cube . Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. Web Analyst. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT. The Modeling service must be configured correctly to use this feature. In MicroStrategy 10. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 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. These VLDB properties control the method by which the report data are normalized. Required Status to Perform Action. 4. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". Select other schedule options as required, and click OK. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. Dynamic source hit. Open the. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. x-10. x-10. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create. The Intelligent Cube Editor uses the new Modeling service infrastructure. Create a report based off the cube in Step 1 that includes the description form for Category. ACTION:The Data Transfer Rate varies from 27 to 28 Mb/s. 4. 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. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. The impact is limited to MicroStrategy Developer 9. 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. You should see these cubes in the Intelligent Cube cache monitor in Developer. The Intelligent Cube Options dialog box opens. Click All Objects View. Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. This article describes the Intelligent Cube Population options available in MicroStrategy. 63K. 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. Designing and creating documents: An overview. More than one cube can be used in a single dashboard. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. However, users can achieve this functionality by creating a cache update subscription to refresh Intelligent Cubes. Use OLAP Services. Under Cube Update, click Cube Update. Navigate to the Intelligent Cube for which you want to define the incremental refresh. Right Mouse Click on ‘Cube_Tutorial’ to create report called ‘Report_Tutorial’. To build an Intelligent Cube In Developer, from the File menu select New, and then Intelligent Cube. 1. Save the Intelligent Cube generated. Create Intelligent Cubes. Use Intelligent Cube Editor. Select Build a Query and click Next. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. 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%. 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. Click the MicroStrategy icon, and select Create Report. Modify the list of Report objects (use object browser). The Modeling service must be configured correctly to use this feature. Setting Up Documents and HTML Documents: This chapter explains the setup required for the Intelligence Server to create and execute HTML documents and documents. 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. Add External Data. 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. Before MicroStrategy 10. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. Make sure the service is properly configured and running before using the Intelligent Cube Editor. To view an existing cube, you must have the following minimal privileges: Use analytics. x, users will notice that this is not possible due to the mouse. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. 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. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. On the Freeform Sources tab, select one of the following options: To. Cube A must be selected here to maintain its attribute IDs after the merge. Navigate to the Engine Component with CSI Dispatcher. Prerequisites for using Cube Advisor. Run a dossier based on the cube. 1, Data Import allows users to maintain intelligent cubes from external Excel files. 0. For instructions on configuring MDX sources, refer to the MDX Cube Reporting Guide. The Select Dataset dialog box opens. Quickly integrating data into MicroStrategy as part of a proof-of-concept. 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. The following steps can be used to reproduce the issue in the MicroStrategy Tutorial project: 1. If. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. DESC forms are in bold as they are displayed by default in the report, as shown below:In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. To do so, you can take advantage of URL API. Under Cube Update, click Cube Update. 4. And create one Cube based report called “cube report 2”. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. The report opens with all of the objects of the Intelligent. Create a new File Log and name it “CSI” (or any other name). x. 2. Create a Report 'R3' with 'Country' attribute. after executing the Login task), and type the GUID of the. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. Navigate to the folder location of the Intelligent Cube. Delete one of these two cube caches from the cache monitor in Developer. Export to MicroStrategy File. Add the report as the dataset for the Dashboard by. This provides ROLAP-type analysis without having to re-execute against the data warehouse. 119 Share Save 45K views 9 years ago MicroStrategy Advanced Topics by MicroRooster Source: MicroRooster. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. The search directly uses the attribute form from the attribute definition, instead of form from the intelligent cube. Edit Project-Level Cache and Intelligent Cube Settings. x releases, and the new Multi-table Data Import (MTDI) cubes. They are. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. This is because with this feature enabled, the element block ID will be saved to the new cube cache. STEPS TO REPRODUCE 1. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Create a Data Import Live Intelligent Cube. This is the same requirement to create or run a static report in Workstation. Insert one panel stack and add dynamic text with Profit Margin. Share query results in-memory across multiple dossiers and reports. Select the data set and click Prepare Data. In the Navigation pane, click , next to Datasets. Con: The copy of report data in Intelligence Server memory only applies to a single report. Republish the same cube, and a new cube instance is generated. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). Open the cube report in Design View. Edit the cube from step 1 and add the Category attribute. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. Visit the data visualization and data dashboard galleries for inspiration. This is set to 32,000 by default. This determines the approach to existing data at refresh. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Create an attribute element prompt for the. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. Select the environment and project where you want to save your. Common Privileges. To Schedule a Cube Refresh. Right-click the project and select Project Configuration. 2. In Web, create a new Dossier and click on New Data. 2. Drag and drop the objects into the report grid from the Report Objects pane. The following diagram depicts the role of the intelligent cube. The Report Editor opens with all of the objects of the Intelligent Cube. Execute reports or documents that reference the object. The Modeling service must be configured correctly to use this feature. Click the MicroStrategy icon at the upper left of any page and select History List. In the Navigation pane, click , next to Datasets. 4. An enhancement Request has been reported to the MicroStrategy Technology team. Create a report based off the cube in Step 1 that includes the description form for Category. Full Refresh. “Intelligent Cube (<Cube Name>) for locale. For more details on enabling the setting. All necessary privileges are included in the Administrator role by default. Regular Intelligent Cubes created on Developer. Multiple reports can access a single. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. x. Log in to the project in which you want to create a report. 4. Edit Intelligent Cubes from the new editor in Workstation at any time. Create a new variable and assign SuperCube with two parameters inside – connection and id. 4. 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. 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. Run a dossier based on the cube. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. 9 and 10. Click Create on any page, point to New Report, and select Blank Report. These privileges are part of OLAP Services. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. Ensure that the email addresses can be displayed properly. The New Intelligent Cube dialog box opens. Check in Developer that the stopped node is in Maintenance Mode. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. This is possible because when the Intelligent Cube refresh job finishes, a record is logged in the IS_REPORT_STATS table. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. 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. We use MicroStrategy Tutorial objects in the following steps. CAUSE: Starting in MicroStrategy 9. Web modify the list of report objects (use object browser --all objects) Web Professional. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. 1. This determines the approach to existing data at refresh. By default, there is a system hierarchy on the cube. 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. Although the default memory usage limit is 500%, sometimes it can be set as low as 50%. STEPS TO REPRODUCE Use Data Import to bring in an Excel file containing a few columns (i. 2. 4. 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. Open the Workstation window. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Select an existing schedule or create a custom one. create() will create a SuperCube, upload the data to the Intelligence Server and publish it. Create an Intelligent Cube with attributes Year, Month and Region; 4. However, importing data from a Google Drive Spreadsheet requires some additional setup. The Intelligent Cube opens in the Report Editor. Right-click the Intelligent Cube, select "Schedule Delivery To" and choose "Refresh Cube". Publish the cube. 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. Intelligent Cube IC2 contains attributes 'Country' and 'Region' Create a report services document with the above 2 Intelligent Cubes as datasets. See Importing MDX cubes in the MDX Cube Reporting Help for more information. Check the status of the cubes in Developer. 4. You can use an Intelligent Cube as a dataset, allowing you to use one Intelligent Cube for many different documents, while reducing access to the data warehouse. 2. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Intelligent cube is an OLAP feature introduced in Microstrategy 9 version. To subscribe a report or document to a cube refresh. 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. 0 MicroStrategy releases. 2 in Web, navigate to the report in edit mode, right click “customer” and insert metric Count as shown below: 3. Add Year Id and Quarter. Number of Views 1. How to Import Data from a SAP HANA Database Into MicroStrategy Web. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide. This is the same requirement to create or run a static report in Workstation. 0 MicroStrategy releases. Import MicroStrategy File. Note that the cube has a neutral data language. These prerequisites include: Enable dynamic sourcing for the project and other aspects of the MicroStrategy system. x - 10. From the. Create a dossier and add subset R from Existing Dataset. Navigate to the Intelligent Cube for which you want to define the incremental refresh. The month ID for 2004 Jan is like 200401. In MicroStrategy 10. Intelligent Cubes. Create a new report based on the published Intelligent Cubes that are supposed to be made available to your designers. In MicroStrategy Web 9. For steps to use an existing template to. The differences between the options. The. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. 4. This " How to" knowledge base article explains cube advisor. 2. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. 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. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. The Intelligent Cube opens in the Report Editor. Select an Environment from the upper-left drop-down. Create a report based on the Intelligent Cube. Republish the. From the File menu, select Create Test. 2. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Create a cube report based on the cube. Workaround 2: Create a non-Kerberos authenticated database login. Launch MicroStrategy Cube Advisor from the Start menu > Programs > MicroStrategy > Tools > Cube Advisor. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Select data population for Intelligent Cubes. 3. You can also select an existing template on which to build your new report. The old cube files don't have this property, so new IDs will be generated every. 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. The Intelligent Cube Monitor is displayed.