In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. Choose File > New > Intelligent Cube. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. In the Refresh Policy column, choose. 2. 4. Right Mouse Click on ‘Cube_Tutorial’ to create report called ‘Report_Tutorial’. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. Select the data set and click Prepare Data. You should see these cubes in the Intelligent Cube cache monitor in Developer. From the cube monitor, we could see the. 2 release, the driver file is called odbc8. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. Right-click an Intelligent Cube and select Delete. Quickly integrating data into MicroStrategy as part of a proof-of-concept. Navigate to the Intelligent Cube you want to refresh. x and create a new Dashboard. 66K. Run a dossier based on the cube. Con: The copy of report data in Intelligence Server memory only applies to a single report. How to build and manage Intelligent Cubes. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. The dataset is a set of data that can be displayed on the document. The Report Editor opens with all of the objects of the Intelligent Cube. 1 product only with documents using view filter qualifications. The Intelligent Cube opens in the Report Editor. In MicroStrategy Web browse to the Cube location and click on the cube . Dynamic source hit. Select the refresh policy. Select Empty. It retrieves report results from a schema source and stores it in memory. Creating Intelligent Cubes is as easy as creating reports. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. For steps to use an existing template to. This issue has been classified as a defect by MicroStrategy. The Save Intelligent Cube As dialog box opens. 4. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. Navigate to the folder location of the Intelligent Cube. IS_CUBE_INST_ID. Then click "Save". x. Check the location of the new cube cache and notice that it is saved in the default location, i. 0 MicroStrategy releases. 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. The Schedule dialog box opens for your dataset, showing the tables in your dataset. The following diagram depicts the role of the intelligent cube. The default value is 256 megabytes. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Select the "ORDER_FACT" table. 86K KB42486: Users are unable to align the report name / title when exporting a report to an Excel file in MicroStrategy Web 9…This article discusses an issue with DELETE incremental refresh reports invalidly preventing an intelligent cube from being used for dynamic sourcing in MicroStrategy 10. Navigate to the Intelligent Cube for which you want to define the incremental refresh. 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. In MicroStrategy 10. ACTION: Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled MicroStrategy release. x. Select an existing schedule or create a custom one. 2. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. In the Navigation pane, click , next to Datasets. We use MicroStrategy Tutorial objects in the following steps. 86K KB31566: MicroStrategy 9. Select the data set and click Prepare Data. KB224157: How to Get the Intelligent Cube Status Using MicroStrategy Web SDK. Create Schema Objects. How to Import Data from a SAP HANA Database Into MicroStrategy Web. 4. 2. Create a metric that returns a transformation of last year's. This is set to 32,000 by default. All necessary privileges are included in the Administrator role by default. 4. Insert one panel stack and add dynamic text with Profit Margin. 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. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. 3. Open the cube report in Design View. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. g. 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. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. Add a grid to the document with the objects 'Region' and. For the example scenario, create a report with Year, Region, and Profit Margin on the report. The Intelligent Cube Options dialog box opens. “Intelligent Cube (<Cube Name>) for locale. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. The differences between the options. Edit Project-Level Cache and Intelligent Cube Settings. To create a card, ensure we are connected to an upgraded version of the metadata or upgrade your metadata to 2019 or above. Check it in the cube monitor and we can see its column Database Connection is not empty. In your Datasets panel, hover over the name of your dataset. See Importing MDX cubes in the MDX Cube Reporting Help for more information. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Open the. Right mouse click the Intelligent Cube Q, select Schedule Delivery To>History List as shown below: 3. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. To review and create recommended Intelligent Cubes using Cube Advisor. Some uses for this data include: •. Kickstart Your Career Get. 1 or above, to pick up the fix, enable project level setting "Data Engine Version" to 11. Right-click the cube, and select Schedule. 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. The CREATE and INSERT support VLDB property defines whether MicroStrategy can perform CREATE and INSERT statements against the database for a database instance. Rather than returning data from the data warehouse for a. 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. An enhancement Request has been reported to the MicroStrategy Technology team. Create a new File Log and name it “CSI” (or any other name). Browse to and select a. 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:. Report: The results of a report are used to populate the Intelligent Cube. Create the metric levels log file used to. Other metadata database platforms:Login Developer with Administrator, create a cube and publish it. The Full Refresh option is the default. When a user imports an Excel file in. In MicroStrategy 9. Restoring cube files. To define an incremental refresh report. 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. This permission is checked at design time, and when executing reports against an Intelligent Cube. Number of Views 2. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. They are. Easily add or change pre- and post- SQL statements. Execute. Total Cubes This section displays the total count of cubes by status. 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 following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Stop the. STEPS TO REPRODUCE: 1. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. 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. g. 4. 4. For steps to create an Intelligent Cube based on an MDX cube, see Creating Intelligent Cubes based on MDX cubes. For the Intelligent Cube that you want to refresh, click the subscription icon. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Navigate to the Intelligent Cube you want to refresh. In the Name field, type the name of the subscription. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Create a report based on above Cube and add the prompt in view filter. To schedule updates for the Intelligent Cube. Add Project objects from the All Objects panel. 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. The impact is limited to MicroStrategy Developer 9. Open MicroStrategy Web. Start > All Programs > MicroStrategy Products > Integrity Manager. 3. x. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. STEPS TO REPRODUCE: 1) Add external dataset. The Browse for Folder dialog box opens. The Report Editor opens. You can edit project-level cache and Intelligent Cube settings. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Description What's New 2022 Releases Workstation. Open the Workstation window. 1 and 10. 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. Use Intelligent Cube Editor. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. Right-click an Intelligent Cube and select Delete. Answer: When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. 4. Steps to import a spreadsheet from Google Drive:MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. For more details on enabling the setting, refer to Change Data Engine Version. com. GUID: is the GUID of the intelligent cube, returned as a string. For steps to create a view filter in MicroStrategy Web, see the MicroStrategy Web Help. Create a cube report based on the cube. In MicroStrategy Web 9. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. The Intelligent Cube opens in the Report Editor. Full Refresh. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Complete the "sessionState" field (e. To solve this problem, we introduce a new registry key, " Respect. 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. 2 attributes and 1 metric). You'll need to provide a name for your cube, as well as a name for the table that will contain the data. Prerequisites. The Browse for Folder dialog box opens. x, users will notice that this is not possible due to the mouse. The "Email" column cannot be found in. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. Description. 4 the connection mapping of the u… Number of Views 1. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. In the left pane, click Intelligent Cubes. In MicroStrategy Developer, edit the Intelligent Cube where u sers want to enable partitioning. Check the status of the cubes in Developer. Web object search—this enables the user to see the “User Manager” button on the Intelligence Server Administration page. Integer ID of the project where the Intelligent Cube is stored. A couple of workarounds are available in the current document. Web Analyst. However, importing data from a Google Drive Spreadsheet requires some additional setup. 2. Normalize Intelligent Cube data in the Database 4. 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 object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. When Drilling on a report created from an Intelligent Cube gives the Last Update Date of 1899 in MicroStrategy Web 9. The report retrieves data from Cube B now. 8. Note that the cube has a neutral data language. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Execute reports or documents that reference the object. g. This is an identified defect in Visual Insight in MicroStrategy Web 10. Reports/Documents not created from Intelligent Cube but meet dynamic sourcing requirements: Additional "Use OLAP services" and "Use Dynamic Sourcing" are required for a user to hit an Intelligent Cube, besides the privileges. Click Create on any page, point to New Report, and select Blank Report. Supports derived metric creation. 4. 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). Publish the cube. How to configure, monitor, and manage Intelligent Cubes. In MicroStrategy 10. Later the user can poll for the change in the value of the flag. Choose File > New > Intelligent Cube. Multiple reports can access a single. The Modeling service must be configured correctly to use this feature. Click the MicroStrategy icon, and select Create Report. All articles. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. Create a dossier and add subset R from Existing Dataset. 2. Select "Add External Data" and connect to an OLAP data source with the Live Connect option. Notice the attribute forms in the Report Objects pane. From the File menu, select Create Test. Create an Intelligent Cube, with Region, Category, Cost and Profit. 2. A document is used to format data from multiple datasets in a single display of presentation quality. Navigate to the Engine Component with CSI Dispatcher. Click the “Add history list subscription” link near the bottom of the screen to open the. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. In Web, create a new Dossier and click on New Data. To set refresh filters, or alternate data sources, select Show Advanced Options. Contact the MicroStrategy Technical Support for an update on this enhancement request. Designing and creating documents: An overview. 4 the connection mapping of the u… Number of Views 1. Select the data sources to be refreshed. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. 1 to see the results as shown. The Modeling service must be configured correctly to use this feature. In the Navigation pane, click Applications. Navigate to the Intelligent Cube for which you want to define the incremental refresh. This knowledge base article describe steps to re-point an existing report which is based on Cube A previously to another Cube B. Normalize Intelligent Cube data in MicroStrategy Intelligence Server . Run both reports after enabling the metric levels log. Integrity Manager can test the SQL of Intelligent Cubes even if they. 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. 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. MicroStrategy Tutorial is used in this example. 2. A report accessing the Intelligent Cube includes only Year on the report. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. "In MicroStrategy 10. Create an Intelligent Cube, with Region, Category, Cost and Profit. 86K KB31566: MicroStrategy 9. 2. Go to the "All Objects View" option in the top left corner. STEPS TO REPRODUCE Use Data Import to bring in an Excel file containing a few columns (i. To Create a Report Using Both Report Objects from a MicroStrategy Project and MDX Cube Data. Steps to Reproduce. Create 500 users, 500 database logins, and 500 database connections mapping to the same data warehouse. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent. A set of data is returned from the. com. This is an identified defect in Visual Insight in MicroStrategy Web 10. 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. In the Navigation pane, click , next to Datasets. /ClusterCube. 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. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . The Subscribe to Cube /Cache Update dialog box opens. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. Multiple reports can access a single. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Common Privileges. 38K. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. The Intelligent Cube Editor uses the new Modeling service infrastructure. Defining the partition for Super Cubes. 2. Normalize Intelligent Cube data in the. Open the Workstation window. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. This must be done by the DBA and MicroStrategy Technical Support will not assist with this. com Format: A MicroStrategy Online. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. 3. Node 2. This can be seen in the screenshot below. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. Select a schedule from the Schedule drop-down list. 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. In MicroStrategy Developer, log in to a project source with administrative privileges. You must belong to the System Administrators group to use this feature. Configure and start the Intelligence Server using the metadata backup. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. Select Build a Query and click Next. 11. MicroStrategy AI is here. Memory mapped files (MMF) can be used for effective RAM utilization. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. 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)". 2. An. By default, this is set to 32,000. This will create the Intelligent Cube directories. 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). In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. Right-click the cube, and select Schedule Data Refresh. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 2. Create an Intelligent Cube with "Customer", and add the attribute form "Email" into the cube. Report Post SQL Statement. Create an attribute element prompt for the. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. For example, you can choose to add or delete data from the Intelligent Cube. 2 in Web, navigate to the report in edit mode, right click “customer” and insert metric Count as shown below: 3. Click Create on any page, point to New Report, and select Blank Report. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. In MicroStrategy Web, open the document in Design Mode or Editable Mode. HIDDEN: if the intelligent cube is hidden or not, returned as a boolean value. This privilege is part of OLAP Services. In Developer, log into a project. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. Use the drop-down under the filter summary section to switch the server nodes. Right-click the dataset, and choose Schedule. Publish the cube. 000007431. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. In MicroStrategy Developer create an Intelligent Cube with any attributes and metrics. 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. In the grid display of the report, right-click the attribute for which you want to create or modify derived elements, and click Derived Elements . 1. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 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. This can improve the performance of. 1, Data Import allows users to maintain intelligent cubes from external Excel files. 0. 0. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. In MicroStrategy Web 9. On the Home screen, select My Subscription. 4. after executing the Login task), and type the GUID of the. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory.