Navigate to the folder location of the Intelligent Cube. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. For example, you can choose to add or delete data from the Intelligent Cube. The ability to view or edit certain settings is determined by a user's privileges. Create 500 users, 500 database logins, and 500 database connections mapping to the same data warehouse. Starting in MicroStrategy 10. By default, Intelligent Cubes created through Data Import are saved to the MicroStrategy user's "My Reports" folder. In the Navigation pane, click , next to Datasets. Introduction: Need to create a report with a metric that calculates the number of distinct customers. Multiple reports can access a single. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. To publish your cube, see the In-Memory Analytics Help. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. jar file to i-server machine. The Create Group dialog box opens. 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. 2. 2. Check the status of the cubes in Developer. Then click "Save". Cube A must be selected here to maintain its attribute IDs after the merge. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". 8. 2) Choose "Database" and select the 3rd option to "Pick tables". In the Refresh Policy column, choose. Visualizations in the dossier that use data from the cube display. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. 4. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. 1 clicking on the Intelligent Cube does not publish the cube but instead creates an analysis from the cube. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Click Select. Open the Workstation window. In MicroStrategy Developer create an Intelligent Cube with any attributes and metrics. Web Analyst. Click OK to save the Intelligent Cube and return to the Report Editor. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. If. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Execute. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. However, users can achieve this functionality by creating a cache update subscription to refresh Intelligent Cubes. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. 3. These prerequisites include: Enable dynamic sourcing for the project and other aspects of the MicroStrategy system. WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. At this time, only one table per cube is supported. x. 1. 4. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. You can also modify the properties of. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. Cube Advisor opens. In Developer, log in to a project with a user account with administrative privileges. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create. In MicroStrategy Developer, browse to an Intelligent Cube. Create and publish Intelligent cube called “Cube2” on node B. 2. Navigate to the Intelligent Cube you want to refresh. This technical note describes a known issue when creating a data import cube in MicroStrategy Web 10. Complete the "sessionState" field (e. If you are upgrading to MicroStrategy 11. From the. In MicroStrategy Web 9. For intelligent cube imported from local file via Data Import, we do not support creating subscriptions as the path may change. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. Right mouse click on the cube and choose Schedule 3. A list of data sources available in this project appear. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. This is the same requirement to create or run a static report in Workstation. Choose File > New > Intelligent Cube. Create a Report 'R3' with 'Country' attribute. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Navigate to the Intelligent Cube you want to refresh. Choose File > New > Intelligent Cube. Publish. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. To create an MDX cube report in MicroStrategy Web, you need to have Web Professional privileges, including the Web Define MDX Cube Report. Open the cube report in Design View. 4. This is possible because when the Intelligent Cube refresh job finishes, a record is logged in the IS_REPORT_STATS table. Steps to import a spreadsheet from Google Drive: MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. Before MicroStrategy 10. Check in Developer that the stopped node is in Maintenance Mode. STEPS TO REPRODUCE Use Data Import to bring in an Excel file containing a few columns (i. and select the Project-Name. x - 10. The Intelligent Cube opens in the Report Editor. 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. x as Administrator; create a simple Intelligent Cube called Q, and publish it. To define an incremental refresh report. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. Click Create on any page, point to New Report, and select Blank Report. 9 and 10. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Select an Environment from the upper-left drop-down. 2. Check in Developer that the stopped node is in Maintenance Mode. The ability to view or edit certain settings is determined by a user's privileges. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. In Developer, log into a project. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Create. Open the. 4. Con: The copy of report data in Intelligence Server memory only applies to a single report. For the example scenario, create a report with Year, Region, and Profit Margin on the report. The "Email" column cannot be found in. 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. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. 4. Reporting on MDX Cubes. You'll need to provide a name for your cube, as well as a name for the table that will contain the data. Create an Intelligent cube and add subscriptions for all 500 users to publish the cube. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. x. In the Data Source column, select the checkboxes for the tables to update. Right mouse click the Intelligent Cube Q, select Schedule Delivery To>History List as shown below: 3. Create Cube B which contains all objects in the report and publish it . See Importing MDX cubes in the MDX Cube Reporting Help for more information. Description MicroStrategy 10 introduced a new option on the Intelligent Cube called Data Partition. 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. Drag and drop the objects into the report grid from the Report Objects pane. Navigate to the Intelligent Cube for which you want to define the incremental refresh. Delete the cube cache from cube monitor. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. Select the data sources to be refreshed. Open the cube report in Design View. For background. In certain situations users may want to configure success and failure notifications for the scheduled refreshes of Intelligent Cubes that are created through Data Import in MicroStrategy Web. The default value is 256 megabytes. 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. Navigate to the folder location of the Intelligent Cube. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. From the Data menu, select Add Dataset. 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. Check it in the cube monitor and we can see its column Database Connection is not empty. Rather than returning data from the data warehouse for a. Right-click your selection and select Group. 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 . The Modeling service must be configured correctly to use this feature. In MicroStrategy Developer, log in to a project that contains reports connected to active Intelligent Cubes. 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 general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. For the example scenario, log in to the MicroStrategy Tutorial project. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. From the Data menu, select Configure Intelligent Cube. This VLDB property has the following options:. 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. The "Refresh Cube. A couple of workarounds are available in the current document. 4. To set refresh filters, or alternate data sources, select Show Advanced Options. IS_CUBE_ACT_ID. create() will create a SuperCube, upload the data to the Intelligence Server and publish it. In MicroStrategy Web 9. Create. Login as MSTR, create an intelligent cube with attribute ‘Year’ and metric ‘Average Revenue’, and publish it as ‘Cube_Tutorial’. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. From the File menu, select Create Test. Select a database configured for SAP HANA. 4. In the Object name field, type a descriptive name for the Intelligent Cube. Edit Intelligent Cubes from the new editor in Workstation at any time. The report opens with all of the objects of the Intelligent. Create Intelligent Cubes. 2. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. x releases, and the new Multi-table Data Import (MTDI) cubes. Click OK. 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 view an existing cube, you must have the following minimal privileges: Use analytics. 1 product only with documents using view filter qualifications. 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. Include “Qualification Prompt”. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. In MicroStrategy Web 10. For the Intelligent Cube that you want to refresh, click the subscription icon. The CREATE and INSERT support VLDB property defines whether MicroStrategy can perform CREATE and INSERT statements against the database for a database instance. Check the status of the cubes in Developer. 4. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Select the Intelligent Cubes tab. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. Click an MDX cube source. Make sure the service is properly configured and running before using the Intelligent Cube Editor. 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. For example, an Intelligent Cube includes Year and Quarter. 1 or MicroStrategy Web 9. 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). Intelligent Cube IC2 contains attributes 'Country' and 'Region' Create a report services document with the above 2 Intelligent Cubes as datasets. Regular Intelligent Cubes created on Developer. The Modeling service must be configured correctly to use this feature. When a user imports an Excel file in. If you select Cube B, any dashboards or reports linked to Cube A before the merge may not function correctly. If you are upgrading to MicroStrategy 11. 5. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. 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. jar. Do not normalize Intelligent Cube data. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 4. x Intelligent Cube status indication and workflowTo create an attribute form caching cube. Login to MicroStrategy Web, create a cube with the function of Data Import 2. Right-click the project and select Project Configuration. On the Freeform Sources tab, select one of the following options: To. In MicroStrategy Developer, log in to a project source with administrative privileges. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. From these results it can be determined that the Month attribute is not being used within any of the view Reports, Documents, Dossiers that reference this Intelligent Cube. Quickly integrating data into MicroStrategy as part of a proof-of-concept. Both properties are located in the Query Optimizations folder in the VLDB property editor. Trending Articles. However, the metric must display in the area of subtotal, the total number of customers inserted into the data warehouse, not the sum of. Execute reports or documents that reference the object. The file location in project configuration is . At least one MDX cube must be imported into your MicroStrategy project. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. 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. Integer ID of the Intelligent Cube report that was published, if any. Now, templates for existing Intelligent Cubes must be created and placed into the report templates folder in order to allow Intelligent Cube Report Designer to select the Intelligent Cube on which they would like to build a report. Faster performance than directly querying warehouse. Click Intelligent Cube Report. Create a report services document or Visual Insight Analysis. The create_cube() function will return the datasetID and tableID, which can be used to update a dataset with new data. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. There is another reason that the intelligent cube is imported from a local file in the web server machine, and the Web server and the Intelligence Server do not need to be on the same machine. 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. Then click "Save". Click the MicroStrategy icon, and select Create Report. They should have the “A, L, F” status (Active, Loaded, Filed). KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. Integer ID of the project where the Intelligent Cube is stored. x, create a simple Intelligent Cube with attribute Category and metric Revenue. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. 4 the connection mapping of the u… Number of Views 1. Note that the cube has a neutral data language. Right-click your selection and select Group. To choose from the full list of template workflows, click the. Normalize Intelligent Cube data in the. The Subscription Editor opens. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Click Close, then "Finish" on the "prepare data" view and save the cube. 4. 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. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 4. Navigate to the Engine Component with CSI Dispatcher. 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). MicroStrategy Web and Mobile deployed in a JSP server like Tomcat. All reports that access Intelligent Cubes allow you to drill within the data included in an Intelligent Cube. The Create Group dialog box opens. KB30711: Security filter application to view reports based on Intelligent Cubes. Right-click the dataset, and choose Schedule. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". Select the data set and click Prepare Data. The Intelligent Cube Options dialog box opens. Navigate to the Intelligent Cube for which you want to define the incremental refresh. Some uses for this data include: •. 7. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. The Browse for Folder dialog box opens. PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public ObjectsReportsSequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a. An. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. The Save Intelligent Cube As dialog box opens. This article describes the Intelligent Cube Population options available in MicroStrategy. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. 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. They should have the “A, L, F” status (Active, Loaded, Filed). In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. Sharing data. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. 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. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. This knowledge base article describe steps to re-point an existing report which is based on Cube A previously to another Cube B. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Designing and creating documents: An overview. The cube now has Year and Category on it. e. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. You should see these cubes in the Intelligent Cube cache monitor in Developer. Create an attribute element prompt for the Year attribute. This property can only be enabled through Workstation. Steps to Reproduce. Launch MicroStrategy Cube Advisor from the Start menu > Programs > MicroStrategy > Tools > Cube Advisor. You cannot create or edit a card based on an unpublished cube. In the Tutorial project create a cube with the Year attribute. x. Right-click the cube, and select Schedule. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Create an Intelligent Cube, with Region, Category, Cost and Profit. 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. Click All Objects View. 2 in Web, navigate to the report in edit mode, right click “customer” and insert metric Count as shown below: 3. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. A report accessing the Intelligent Cube includes only Year on the report. The Intelligent Cube Monitor is displayed. The Select Intelligent Cube dialog box opens. In your Datasets panel, hover over the name of your dataset. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. x-10. 2. 3. 2. GUID: is the GUID of the intelligent cube, returned as a string. Select an existing schedule or create a custom one. Login to MicroStrategy Web, create a cube with the function of Data Import 2. Run both reports after enabling the metric levels log. x releases, and the new Multi-table Data Import (MTDI) cubes. In the left panel, click Cubes. How to configure, monitor, and manage Intelligent Cubes. 3. This privilege is part of OLAP Services. x checks for 'Execute' access to the managed column object being used in the metric when adding it to the report, which is not required for regular non-mnanaged metrics. The Select Dataset dialog box opens. Number of Views 3. KB228850: How to migrate published intelligent cubes to a different environment in MicroStrategy Intelligence Server 9. The default value is 256 megabytes. 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. com. The value of Composite Metrics displays with “--“ in Intelligent Cube based Report in MicroStrategy 9. For steps to use an existing template to. Steps To Reproduce 1. 2. 0. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Section 5: Load Intelligent Cube files into the Intelligence Server. 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. 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. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. Defining the partition for Super Cubes. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. CAUSE: The report on which the action is being performed is a "Standard" report, only OLAP reports can be pointed to Intelligent Cubes. Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. When an Intelligent Cube is published, the Intelligent. Right-click an Intelligent Cube and select Delete. Select "Add External Data" and connect to an OLAP data source with the Live Connect option. Data Population for Intelligent Cubes. This can be done by selecting Run Report in the toolbar. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. The predefined MicroStrategy Web Analyst group is assigned the set of Web Analyst privileges by default.