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. Multiple reports can access a single. Log into ProjectA in MicroStrategy Web. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. jar file to i-server machine. The Intelligent Cube Options dialog box opens. MicroStrategy Developer 9. This is the same requirement to create or run a static report in Workstation. 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. In the Intelligent Cube cache monitor in Developer, notice that all cube caches for the project. 3. In the left pane, click Intelligent Cubes. There is no need to further create a dashboard. x - 9. Normalize Intelligent Cube data in the. Some uses for this data include: •. The search directly uses the attribute form from the attribute definition, instead of form from the intelligent cube. Create a Visual Insight dashboard and add the above cube as the dataset: 3. PublishCube". 2. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. Memory mapped files (MMF) can be used for effective RAM utilization. 1. Node 2. 2 attributes and 1 metric). This is the same requirement to create or run a static report in Workstation. Create and publish Intelligent cube called “Cube2” on node B. Complex metrics here refer to metrics which are defined using multiple. Create an Intelligent cube with Month and Revenue. This determines the approach to existing data at refresh. 0, you have the option to use Data Import to create an in-memory dataset (sometimes referred to as an super cube) containing data from multiple tables. The dataset is a set of data that can be displayed on the document. Save the Report and close. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. A document is used to format data from multiple datasets in a single display of presentation quality. 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). The report opens with all of the objects of the Intelligent. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. /ClusterCube. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. You can also create Intelligent Cubes by directly querying your data. In MicroStrategy Desktop 9. x. To Create a Report that Accesses an Intelligent Cube. 0. This permission is checked at design time, and when executing reports against an Intelligent Cube. 2. Steps To Reproduce 1. Created cube with lastname and any other attribute. 4. Delete one of these two cube caches from the cache monitor in Developer. 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. 2. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. Select the refresh policy. In MicroStrategy 10. On the Home screen, select My Subscription. Here, we use MicroStrategy Tutorial objects to create a report: Add Category, Brand, and. To set refresh filters, or alternate data sources, select Show Advanced Options. access the MicroStrategy Web Administrator page and assign Project defaults: WEBADMIN: Privileges marked with * are included only if you have OLAP Services installed as part of the Intelligence Server. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. For the Intelligent Cube that you want to refresh, click the subscription icon. Common Privileges. The Select Dataset dialog box opens. Create Schema Objects. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. In your Datasets panel, hover over the. If the Intelligent Cube must be re-processed based on a metric. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. The Report Editor opens with all of the objects of the Intelligent Cube. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. More than one cube can be used in a single dashboard. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. In MicroStrategy 9. 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. Configure a Cluster with a Centralized Cache. 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. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. To create an MDX cube report in MicroStrategy Web, you need to have Web Professional privileges, including the Web Define MDX Cube Report. Make sure the service is properly configured and running before using the Intelligent Cube Editor. 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. Sharing data. Run a dossier based on the cube. Easily add or change pre- and post- SQL statements. x. From the File menu, select Create Test. Start > All Programs > MicroStrategy Products > Integrity Manager. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. 2. You can also reproduce this issue in a Document. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. x, create a simple Intelligent Cube with attribute Category and metric Revenue. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. When an Intelligent Cube is in this status, any reports based on this cube have. In the Navigation pane, click , next to Datasets. To set refresh filters, or alternate data sources, select Show Advanced Options. Description. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. 2. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. Section 5: Load Intelligent Cube files into the Intelligence Server. 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. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. Log into the three-tier project source and choose the project that was analyzed in stage 2. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). In MicroStrategy Developer, right-click on the intelligent cube and select Edit. How to build and manage Intelligent Cubes. These VLDB properties control the method by which the report data are normalized. The Modeling service must be configured correctly to use this feature. HyperIntelligence for Web was first. First, you open a blank document and select a report to use as the document's dataset. x - 10. Run the Report and check the SQL View. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Reporting on MDX Cubes. Refresh Intelligent Cubes manually. Required Status to Perform Action. The Modeling service must be configured correctly to use this feature. 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 report retrieves data from Cube B now. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. Data Population for Intelligent Cubes. 1. 1 or MicroStrategy Web 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. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. Select Intelligent Cubes > General > Intelligent Cube File directory. Add the report as the dataset for the Dashboard by. Steps to Reproduce. Creating Intelligent Cubes is as easy as creating reports. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. This must be done by the DBA and MicroStrategy Technical Support will not assist with this. Select the refresh policy. For example, you can choose to add or delete data from the Intelligent Cube. 4. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. By default, there is a system hierarchy on the cube. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. In MicroStrategy 10. Choose File > New > Intelligent Cube. Intelligent cubes & Level Metrics. Navigate to the folder location of the Intelligent Cube. Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. If you just want to create the SuperCube and upload the row-level data but leave it unpublished, use SuperCube. com. 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. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. For the Intelligent Cube that you want to refresh, click the subscription icon. Save as an In-Memory dataset. This can be seen in the screenshot below. Create 3 aggregate from base metrics as follows:In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. This is an identified defect in Visual Insight in MicroStrategy Web 10. For Oracle 12. Prerequisites for using Cube Advisor. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. Node 2. Create an Intelligent cube and add subscriptions for all 500 users to publish the cube. The New Grid dialog box opens. 4. “Intelligent Cube (<Cube Name>) for locale. Right-click an Intelligent Cube and select Delete. Steps to reproduce. Select the data sources to be refreshed. Click an MDX cube source. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. The New Intelligent Cube dialog box opens. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Save the Cube with Connect Live Data Access Mode. Republish the same cube, and a new cube instance is generated. The month ID for 2004 Jan is like 200401. Create an attribute element prompt for the Year attribute. Type a name for the derived element, and click OK. Typically, a long duration is seen in the Data Transfer time which indicates the time it takes to fetch data from the warehouse. To review and create recommended Intelligent Cubes using Cube Advisor. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. It does not tell us anything helpful and we should not use it as a point of reference. g. This data is stored as Intelligent Cubes. 4. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. The Intelligent Cube Options dialog box opens. A report that runs against the Intelligent Cube. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. Designing and creating documents: An overview. Click OK to save the Intelligent Cube and return to the Report Editor. 4. If you want to create an empty SuperCube, use SuperCube. This " How to" knowledge base article explains cube advisor. g. Log in to the project in which you want to create a report. Make sure the service is properly configured and running before using the Intelligent Cube Editor. Currently, project duplication does not involve Intelligent Cube File Directory. Save the Intelligent Cube. The Full Refresh option is the default. Publish the cube. For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. Common Privileges. 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. Click All Objects View. At least one MDX cube must be imported into your MicroStrategy project. The. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. 1 release. CAUSE: This is working as designed. x releases, and the new Multi-table Data Import (MTDI) cubes. 4. 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. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. Click Close, then "Finish" on the "prepare data" view and save the cube. An. PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public ObjectsReportsSequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a. You must belong to the System Administrators group to use this feature. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. ) As long as each node is using the same server definition, the setting of the cache and history list locations in the Intelligence Server configuration only needs to be done once; however, the creation of the shared folders will need to be done on each node. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. 3. The ability to view or edit certain settings is determined by a user's privileges. KB224157: How to Get the Intelligent Cube Status Using MicroStrategy Web SDK. An enhancement Request has been reported to the MicroStrategy Technology team. 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. The month ID for 2004 Jan is like 200401. Prerequisites. For example, if a user has an Intelligent Cube that contains weekly sales data, the user may want this Intelligent Cube to be updated at the end of every week with the sales data for that week. Designing and creating documents: An overview. However, the metric must display in the area of subtotal, the total number of customers inserted into the data warehouse, not the sum of. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. Execute reports or documents that reference the object. How to build and manage Intelligent Cubes. From the Categories list, expand Options, and then select Data Languages. x releases, and the new Multi-table Data Import (MTDI) cubes. Create a new dossier: Create a new metric M01=Case: Create a new metric. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. This is possible because when the Intelligent Cube refresh job finishes, a record is logged in the IS_REPORT_STATS table. Navigate to the folder location of the Intelligent Cube. This knowledge base article describe steps to re-point an existing report which is based on Cube A previously to another Cube B. Select a database configured for SAP HANA. Choose File > New > Intelligent Cube. However, importing data from a Google Drive Spreadsheet requires some additional setup. This will create the Intelligent Cube directories. The Intelligent Cube Options dialog box opens. 2. If you select any Intelligent Cube reports, make sure that the Intelligent Cube the reports are based on has been published before you perform the integrity test. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . This article describes the Intelligent Cube Population options available in MicroStrategy. Faster performance than directly querying warehouse. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. For the example scenario, log in to the MicroStrategy Tutorial project. Importing MDX cubes is often handled by a MicroStrategy architect. In MicroStrategy 11. From the. Under Refresh type, select one of the following options. Click a catalog. Choose File > New > Intelligent Cube. Web object search—this enables the user to see the “User Manager” button on the Intelligence Server Administration page. Start > All Programs > MicroStrategy Products > Integrity Manager. 86K KB31566: MicroStrategy 9. 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. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. x - 10. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. create(auto_upload=False,. Click Databases . The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. The Intelligent Cube Monitor is displayed. 2. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical Engine. Common Privileges. 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. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. 9K KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. 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. To Schedule a Cube Refresh. Upload Dashboard. Node 1. In the Name field, type the name of the subscription. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Click the MicroStrategy icon at the upper left of any page and select History List. Con: The copy of report data in Intelligence Server memory only applies to a single report. 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. 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. This data is stored as Intelligent Cubes. Hover the schedule need to be modified,. 4. Check the status of the cubes in Developer. Note that the cube has a neutral data language. The Create Group dialog box opens. Documentation on the REST API is at developer. Click the “Add history list subscription” link near the bottom of the screen to open the. 1… Number of Views 9. 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. Create a new variable and assign SuperCube with two parameters inside – connection and id. 1 product only with documents using view filter qualifications. Intelligent Cubes in MicroStrategy - A Tutorial MicroStrategyBlog 413 subscribers Subscribe 21K views 11 years ago A quick tutorial on how to create and. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. Web Analyst. 3. Right-click the Intelligent Cube, select "Schedule Delivery To" and choose "Refresh Cube". To define an incremental refresh report. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. ACTION:The procedure below provides steps to create a subscription to schedule the publication of an Intelligent Cube. 3. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. The Intelligent Cube Options dialog box opens. You can also select an existing template on which to build your new report. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. You must browse to the MDX cube to use to build the Intelligent Cube. 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%. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. The Browse for Folder dialog box opens. First, you open a blank document and select a report to use as the document's dataset. Right-click your selection and select Group. Contact the MicroStrategy Technical Support for an update on this enhancement request. 1. 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. HIDDEN: if the intelligent cube is hidden or not, returned as a boolean value. For information on using Cube Advisor to support dynamic sourcing, see Using Cube Advisor to support dynamic sourcing. STEPS TO REPRODUCE: 1. x-10. after executing the Login task), and type the GUID of the. In MicroStrategy Web, log in to a project. Number of Views 1. Edit Intelligent Cubes from the new editor in Workstation at any time. Publish the cube. x. Update Cube Data *. Create an Intelligent Cube, with Region, Category, Cost and Profit. See Importing MDX cubes in the MDX Cube Reporting Help for more information. A list of data sources available in this project appear. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. g. 4. Select the "ORDER_FACT" table. Answer: When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. Add Year Id and Quarter. 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). You can also select an existing template (see How to Create a Report Based on an Existing Template ). Open the cube report in Design View. 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. Type a name for the derived element, and click OK. Login MicroStrategy Web as M20061, go to Add External Data -> Databases -> Select Tables, pick the following tables Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. 2. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Watch the Product team review how to configure and manage advanced properties of Intelligent Cubes. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. 3. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. The "Email" column cannot be found in. Run both reports after enabling the metric levels log. Description What's New 2022 Releases Workstation. Select an MDX cube. 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. They should have the “A, L, F” status (Active, Loaded, Filed). Check it in the cube monitor and we can see its column Database Connection is not empty. x. The Save Intelligent Cube As dialog box opens. Right-click the cube, and select Schedule Data Refresh. 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. The Select Intelligent Cube dialog box opens. After refreshing an Intelligent Cube that had columns added to it, the newly created attributes do not show up in the document's Dataset Objects pane in MicroStrategy Web 9. The Intelligent Cube Editor uses the new Modeling service infrastructure. You can also modify the properties of. In the Data Source column, select the checkboxes for the tables to update. Run the report, notice that the filter does not work, all. This group also inherits all of the privileges assigned to the Web Reporter group. Answer: Intelligent Cubes can be created in microstrategy in public objects folder or in a particular user folder. 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. Select data population for Intelligent Cubes. 1 clicking on the Intelligent Cube does not publish the cube but instead creates an analysis from the cube. 4. Launch MicroStrategy Cube Advisor from the Start menu > Programs > MicroStrategy > Tools > Cube Advisor. To schedule updates for the Intelligent Cube. The steps below show you how to create an Intelligent Cube based on an MDX cube. 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‘. When an Intelligent Cube is published, the Intelligent. All articles. 9 and 10. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. Import MicroStrategy File. Supports derived metric creation. 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.