For steps to use an existing template to. MicroStrategy URL Structure The following table summarizes the root URL structure used for every request to MicroStrategy Web. To learn more about Intelligent Cube Data Partition, please refer to KB237803. Create a new variable and assign SuperCube with two parameters inside – connection and id. The differences between the options. Edit Project-Level Cache and Intelligent Cube Settings. 2) Choose "Database" and select the 3rd option to "Pick tables". On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal Intelligent. Use Intelligent Cube Editor. 4. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Right mouse click on the cube and choose Schedule 3. 1. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. In MicroStrategy 10. If you want to create an empty SuperCube, use SuperCube. Create a new Intelligent Cube C01 using the "ORDER_FACT" table: Add External Data > Databases > Select Tables. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. This is an identified defect in Visual Insight in MicroStrategy Web 10. However, importing data from a Google Drive Spreadsheet requires some additional setup. 4. 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. 9 and 10. 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. Expand Intelligent Cubes, and then select General. You can analyze a new set of reports using Cube Advisor or use the results of a previous Cube Advisor analysis: To use Cube Advisor to analyze a new set of reports, choose Tools. You need the. Right Mouse Click on ‘Cube_Tutorial’ to create report called ‘Report_Tutorial’. Select the data set and click Prepare Data. x Intelligent Cube status indication and workflow To create an attribute form caching cube. Right-click an Intelligent Cube and select Delete. The following steps can be used to reproduce the issue in the MicroStrategy Tutorial project: 1. Configure a Cluster with a Centralized Cache. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT. To solve this problem, we introduce a new registry key, " Respect. We can create a report and point the report to a cube or right click. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. Open the. You'll need to provide a name for your cube, as well as a name for the table that will contain the data. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. create() will create a SuperCube, upload the data to the Intelligence Server and publish it. 10 or earlier, outer join to Lookup table in a dashboard/dossier report based on Intelligent Cube with joint element list filter will not work, and incorrect CSI will be generated when both attributes used in the filter are present in visualization. Reporting on MDX Cubes. Log in to the project in which you want to create a report. From the cube monitor, we could see the old cube is it. In the Object name field, type a descriptive name for the Intelligent Cube. Check the location of the new cube cache and notice that it is saved in the default location, i. . To create an Intelligent Cube based on an MDX cube Using MicroStrategy Developer, log in to a project connected to an MDX cube source. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. Visualizations in the dossier that use data from the cube display. Purpose of the registry key. 1, users could right click an Intelligence cube to create a URL API call that would allow users to automatically create a Visual Insight dashboard using that same cube. The Select Intelligent Cube dialog box opens. This is an identified defect in Visual Insight in MicroStrategy Web 10. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). Select the refresh policy. 4. Log in to a project connected to an MDX cube source. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Save the Intelligent Cube. 0. They are. 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. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. From the Data menu, select Configure Intelligent Cube. Create Cube B which contains all objects in the report and publish it . The Modeling service must be configured correctly to use this feature. 2. Configure and start the Intelligence Server using the metadata backup. Add a grid to the document with the objects 'Region' and. 4. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. 38K. The report opens with all of the objects of the Intelligent. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. In the Data Source column, select the checkboxes for the tables to update. 4. Publish. To create a card, ensure we are connected to an upgraded version of the metadata or upgrade your metadata to 2019 or above. You must browse to the MDX cube to use to build the Intelligent Cube. From the File menu, select Create Test. x. 4. Common Privileges. 2. The CREATE and INSERT support VLDB property defines whether MicroStrategy can perform CREATE and INSERT statements against the database for a database instance. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). 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. 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. 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. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. Click All Objects View. 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. 3. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Add Year Id and Quarter. Some uses for this data include: •. STEPS TO REPRODUCE: 1. Execute ‘Report_Tutorial’ returns data as shown below: You can edit project-level cache and Intelligent Cube settings. Note that the cube has a neutral data language. 3. 1. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. The view filter cannot filter out other elements as shown below:Use Cube Advisor to create Intelligent Cubes: 1. The cube now has Year and Category on it. Right-click an Intelligent Cube and select Delete. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Unable to create Derived Elements in a Report Services document with a dataset that is not based on an Intelligent Cube in MicroStrategy Developer 9. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. x. Click Create on any folder page, point to New Report, and select MDX Cube Report. The Full Refresh option is the default. Create. microstrategy. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. 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. Visit the data visualization and data dashboard galleries for inspiration. Click “All Objects View”. Navigate to the Intelligent Cube you want to refresh. Choose Databases. In the Intelligent Cube cache monitor in Developer, notice that all cube caches for the project. This VLDB property has the following options:. The Report Editor opens with all of the objects of the Intelligent Cube. First, you open a blank document and select a report to use as the document's dataset. To view an existing cube, you must have the following minimal privileges: Use analytics. Open the Workstation window. In MicroStrategy Developer, log in to a project source with administrative 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. STEPS TO REPRODUCE. 2 attributes and 1 metric). To set refresh filters, or alternate data sources, select Show Advanced Options. 3. This must be done by the DBA and MicroStrategy Technical Support will not assist with this. 4. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. Create an MDX Cube ReportThe option to point a grid to an Intelligent Cube appears disabled, while other options such as "Convert Grid to Intelligent Cube" appear available. After updating an intelligent cube through incremental refresh, when running a report based off the cube, the incorrect time (12/29/99 7:00:00 PM) appears as the last update time in MicroStrategy Web 9. You can also select an existing template on which to build your new report. The Incremental Refresh Options dialog box opens. Delete the cube cache from cube monitor. 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 report based on the published Intelligent Cubes that are supposed to be made available to your designers. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Go to MicroStrategy Web 10. Later the user can poll for the change in the value of the flag. For a MicroStrategy environment configured to use Database level security using MSTR connection mapping, Intelligent Cubes can still be utilized. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. Full Refresh. 4. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. This will influence the user experience. Prerequisites for using Cube Advisor. It is especially useful when data. In the Navigation pane, click , next to Datasets. Some data that may be available to the user by directly querying a data source may not be available in the report that accessed an Intelligent Cube. 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). In MicroStrategy Developer, log in to a project source with administrative privileges. 8. Navigate to and select the report or Intelligent Cube to use as the dataset, then click OK. 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. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". 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. Create. Create an attribute element prompt for the. Select an MDX cube. In the Refresh Policy column, choose one of the following options: To define an incremental refresh report. 1. Open the. 2. 1 clicking on the Intelligent Cube does not publish the cube but instead creates an analysis from the cube. Right mouse click the Intelligent Cube Q, select Schedule Delivery To>History List as shown below: 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. Importing MDX cubes is often handled by a MicroStrategy architect. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. See Importing MDX cubes in the MDX Cube Reporting Help for more information. Creating Intelligent Cubes is as easy as creating reports. Architects can now create, edit, and publish Intelligent Cubes with the new editor in Workstation, streamlining overall creation workflows. 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. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Note: number of columns should be the same as in the original file. 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. 4. The month ID for 2004 Jan is like 200401. In MicroStrategy 9. In MicroStrategy Developer, browse to an Intelligent Cube. In MicroStrategy OLAP Services, Transformation metrics used in standard reports can resolve against Intelligent Cubes only when the same Transformation metric exists in the Intelligent Cube. In the Refresh Policy column, choose. 4. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Create Intelligent Cubes. This article describes how to update information in an Intelligent Cube without having to do a full republishUsing Web, create an Intelligent Cube with Add External Data> Databases > Select Tables option and add 1 table Order_Detail using a "Live" connection. • You need the Publish Intelligent Cube (Developer) and/or Web Publish Intelligent Cube (Web) privileges. 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. Web Analyst. The group is created as a derived element and displayed on the report. Open the Workstation window. Intelligent Cubes in MicroStrategy - A Tutorial MicroStrategyBlog 413 subscribers Subscribe 21K views 11 years ago A quick tutorial on how to create and. Starting in MicroStrategy 10. STEPS TO REPRODUCE: 1. Select the. 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. 1Currently it is not possible to create a cube refresh subscription in Command Manager. 4. Click OK. Complete the "sessionState" field (e. The steps below show you how to create an Intelligent Cube based on an MDX cube. 2. 000007431. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. Although the default memory usage limit is 500%, sometimes it can be set as low as 50%. To view an existing cube, you must have the following minimal privileges: Use analytics. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Log into the three-tier project source and choose the project that was analyzed in stage 2. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. To create a report that connects to an Intelligent Cube, in MicroStrategy Developer. Create the metric levels log file used to. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. Connection mapping can then be used to map the desired MicroStrategy users to this database login. 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. From the. 0 MicroStrategy releases. Create a dossier and add subset R from Existing Dataset. The New Intelligent Cube dialog box opens. Personal Intelligent Cubes are linked to a single report: Pro: The report can use OLAP Services to analyze report data and is always updated with the latest version of the personal Intelligent Cube. Integrity Manager can test the SQL of Intelligent Cubes even if they. Total Cubes This section displays the total count of cubes by status. Republish the same cube, and a new cube instance is generated. For intelligent cube imported from local file via Data Import, we do not support creating subscriptions as the path may change. At least one MDX cube must be imported into your MicroStrategy project. Check in Developer that the stopped node is in Maintenance Mode. Currently, project duplication does not involve Intelligent Cube File Directory. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. xThe following scenario describes how to create a distinct count subtotal from base report: 1 Create a report A with only “year” in row and ”category” in column; add customer in report object window only. Quickly integrating data into MicroStrategy as part of a proof-of-concept. Supports derived metric creation. The report retrieves data from Cube B now. Check the status of the cubes in Developer. 3. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. This article describes the Intelligent Cube Population options available in MicroStrategy. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. Notice the attribute forms in the Report Objects pane. 2. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. You can also reproduce this issue in a Document. Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. create(auto_publish=False). ACTION:The Data Transfer Rate varies from 27 to 28 Mb/s. 2. This Python 3 / MicroStrategy 10. Create a report services document or Visual Insight Analysis. Create Cube A and a report based on it. Run the Report and check the SQL View. The ability to view or edit certain settings is determined by a user's privileges. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). To Create a Report that Accesses an Intelligent Cube. 1. Update Cube Data *. The New Intelligent Cube dialog box opens. jar. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. Create a report based on the Intelligent Cube. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. Community & Support Search Discussions Open A Case View My CasesSince the Intelligent Cube is based off a FFSQL report, the columns in the metrics being used are managed objects. In MicroStrategy 10. Open the report in Grid View, Design View, or Grid and Graph view. 0. 3. x. 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. To define an incremental refresh report. 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. 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. Intelligent cubes & Level Metrics. 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. Cube A must be selected here to maintain its attribute IDs after the merge. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. To schedule updates for the Intelligent Cube. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 6. "In MicroStrategy 10. Create Schema Objects. 2. In the Data Source column, select the checkboxes for the tables to update. Import MicroStrategy File. 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. CAUSE: This is working as designed. Add the report as the dataset for the Dashboard by. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create a report in MicroStrategy Web. Open the cube report in Design View. The Intelligent Cube Options dialog box opens. The Intelligent Cube Monitor is displayed. CAUSE: The report on which the action is being performed is a "Standard" report, only OLAP reports can be pointed to Intelligent Cubes. Defining the partition for Super Cubes. 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. Right-click an application and choose Properties. The report opens with all of the objects of the Intelligent. Select data population for Intelligent Cubes. Description. Run a Command Manager script to delete the cube cache previously deleted in step 2. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. You can also create Intelligent Cubes by directly querying your data. Run report off cube. Create a standalone Derived metric DM : Create a new Intelligent Cube C01: Add the Quarter, Country, and Region attributes. Right-click the Intelligent Cube, select "Schedule Delivery To" and choose "Refresh Cube". This can affect performance of your Intelligence Server as well as the ability to publish the. A page with report creation options is displayed. Navigate to the Intelligent Cube you want to refresh. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. Login as MSTR, create an intelligent cube with attribute ‘Year’ and metric ‘Average Revenue’, and publish it as ‘Cube_Tutorial’. Refresh Intelligent Cubes manually. 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. 2. To set refresh filters, or alternate data sources, select Show Advanced Options. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". Browse to and select a previously saved Intelligent Cube on which to build your report. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT * Web publish Intelligent Cube: publish an Intelligent Cube to Intelligence Server: WEBEXECUTECUBEREPORT * Web save derived elements: save stand-alone derived elements, separate from the report: WEBSAVEDERIVEDMETRICS In MicroStrategy Web, log in to a project. From the Data menu, select Configure Intelligent Cube. A document is used to format data from multiple datasets in a single display of presentation quality. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). The Create Group dialog box opens. For Oracle 12. Navigate to the Intelligent Cube for which you want to define the incremental refresh. Start > All Programs > MicroStrategy Products > Integrity Manager. Create a metric that returns a transformation of last year's. 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. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. 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. Select the data sources to be refreshed. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. CubeServerDefinition, and this folder should be shared as 'ClusterCube'. 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). The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Designing and creating documents: An overview. 6 and below, this feature was only available when re-pointing an existing report from one OLAP cube to another OLAP cube or re-pointing the report from one MTDI cube to another OLAP cube. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. MicroStrategy AI is here. Create a cube report based on the cube. For more details on enabling the setting, refer to Change Data Engine Version. The Browse for Folder dialog box opens. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Normalize Intelligent Cube data in the Database 4. Defining the partition for Super Cubes. Intelligent Cubes. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. 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. Execute. By default SuperCube. Follow the steps below to reproduce the issue in Tutorial project in MicroStrategy 9. All necessary privileges are included in the Administrator role by default. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. The Save Intelligent Cube As dialog box opens. All necessary privileges are included in the Administrator role by default. Create 3 aggregate from base metrics as follows:In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. 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. 1, Data Import allows users to maintain intelligent cubes from external Excel files. Save the Report and close. Navigate to the folder location of the Intelligent Cube. 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. For steps to use an existing template to. 2. In Web, create a new Dossier and click on New Data. Load an updated CSV file into a DataFrame providing full path. This technical note describes a known issue when creating a data import cube in MicroStrategy Web 10. The partition attribute is the attribute that is used to divide. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. With OLAP Services features, your report designers can create Intelligent Cube reports. For background. PublishCube". Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory.