Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. Import MicroStrategy File. 2. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube, and click OK. Insert one panel stack and add dynamic text with Profit Margin. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. . Publish the cube. 3. However, importing data from a Google Drive Spreadsheet requires some additional setup. Integrity Manager can test the SQL of Intelligent Cubes even if they. 86K KB31566: MicroStrategy 9. To Schedule a Cube Refresh. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. after executing the Login task), and type the GUID of the. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Steps to import a spreadsheet from Google Drive:MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. In the Navigation pane, click , next to Datasets. Required Status to Perform Action. Web Analyst. KB224157: How to Get the Intelligent Cube Status Using MicroStrategy Web SDK. Navigate to the Engine Component with CSI Dispatcher. Choose File > New > Report. Create a new report based on the published Intelligent Cubes that are supposed to be made available to your designers. 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 status of each Intelligent Cube is listed in the. Click “All Objects View”. x Intelligent Cube status indication and workflowTo create an attribute form caching cube. Execute View Report. An enhancement Request has been reported to the MicroStrategy Technology team. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Intelligent Cubes. Answer: Intelligent Cubes can be created in microstrategy in public objects folder or in a particular user folder. Steps to Reproduce. In the left panel, click Cubes. Set the path for the cube cache file directory to . The report retrieves data from Cube B now. The default value is 256 megabytes. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. 5. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. 2. Kickstart Your Career Get. Integrity Manager can test the SQL of Intelligent Cubes even if they. Click the MicroStrategy icon, and select Create Report. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. The Modeling service must be configured correctly to use this feature. Architects can now create, edit, and publish Intelligent Cubes with the new editor in Workstation, streamlining overall creation workflows. 1. Create a new File Log and name it “CSI” (or any other name). All necessary privileges are included in the Administrator role by default. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. x-10. Create. 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. 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. A set of data is returned from the. Expand Intelligent Cubes, and then select General. KB30711: Security filter application to view reports based on Intelligent Cubes. x environments. details. 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. com. In the Navigation pane, click , next to Datasets. 1. 2. 3. Edit Intelligent Cubes from the new editor in Workstation at any time. Right mouse click the Intelligent Cube Q, select Schedule Delivery To>History List as shown below: 3. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import 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. IS_CUBE_REP_ID. You cannot create or edit a card based on an unpublished cube. 4. 1. 0. This is an identified defect in Visual Insight in MicroStrategy Web 10. To set refresh filters, or alternate data sources, select Show Advanced Options. create(auto_upload=False,. 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. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. The Modeling service must be configured correctly to use this feature. In MicroStrategy Web 9. The cube now has Year and Category on it. Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. You can also reproduce this issue in a Document. CAUSE: This is working as designed. 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. 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. Add a dataset. 4. Business users might not want MicroStrategy to build any M:M Relationship tables while publishing the Intelligent Cube In-Memory due to the following reasons: 1) It distorts the actual relationship between a tuple of 3 or more attributes related to each other through M:M relationship in Project Schema by creating individual tables and joining. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. Open the report in Grid View, Design View, or Grid and Graph view. The differences between the options. 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). Execute reports or documents that reference the object. Afterwards the cube will start executing. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. Let us assume the Intelligent Cube is published on Node B: Create an event called "Refresh Cubes" Create an event-based schedule called "Refresh Cubes"" Web Reporter" and "Report Services document" are required to run Intelligent Cube document. Defining the partition for Super Cubes. Open the. Select Empty. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. 2. To Create a Report that Accesses an Intelligent Cube. In the user interface, specify the partition attribute and the number of partition . Publish the Intelligent Cube by executing it on either of the nodes. 4. Create an Intelligent cube and add subscriptions for all 500 users to publish the cube. For example, you can choose to add or delete data from the Intelligent Cube. Login as MSTR, create an intelligent cube with attribute ‘Year’ and metric ‘Average Revenue’, and publish it as ‘Cube_Tutorial’. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. In the Object name field, type a descriptive name for the Intelligent Cube. Save the Report and close. In Web, create a new Dossier and click on New Data. From the Data menu, select Configure Intelligent Cube. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. Intelligent cube is an OLAP feature introduced in Microstrategy 9 version. x - 9. How to build and manage Intelligent Cubes. Click here to view details about the Intelligent Cube Monitor. MicroStrategy AI is here. Login Web with Administrator, Create a VI Dashboard based on this cube. Click Intelligent Cube Report. This Python 3 / MicroStrategy 10. Memory mapped files (MMF) can be used for effective RAM utilization. Deploy the ojdbc8. Common Privileges. The Report Editor opens. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. At least one MDX cube must be imported into your MicroStrategy project. The display of data is handled by the reports that access the Intelligent Cube. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. Republish the Intelligent Cube or re-create a report cache, which will be shared with MicroStrategy Technical Support; Send the requested data to MicroStrategy Technical Support; Revert the metric definition back to the original one, or remove the randomized metric from the report (Intelligent Cube configuration is not relevant in MicroStrategy 8. When an Intelligent Cube is in this status, any reports based on this cube have. In the Object name field, type a descriptive name for the Intelligent Cube. All articles. First, you open a blank document and select a report to use as the document's dataset. STEPS TO REPRODUCE. Add Project objects from the All Objects panel. Create an Intelligent Cube with attributes Year, Month and Region; 4. The New Grid dialog box opens. Cube index generation will increase cube size. Check in Developer that the stopped node is in Maintenance Mode. x. To schedule an Intelligent Cube to be updated. 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. 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. Common Privileges. Navigate to Administrator -> System monitor -> Cube monitor both nodes, and check all cube are “active, load, file” status. Right mouse click on the cube and choose Schedule 3. 4. Use OLAP Services. It retrieves report results from a schema source and stores it in memory. This privilege is part of OLAP Services. It does not tell us anything helpful and we should not use it as a point of reference. 4. This technical note describes a known issue when creating a data import cube in MicroStrategy Web 10. Complete the "sessionState" field (e. The "Email" column cannot be found in. 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). With OLAP Services features, your report designers can create Intelligent Cube reports. 2. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. This property can only be enabled through Workstation. 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. For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. Right-click your selection and select Group. ACTION:The Data Transfer Rate varies from 27 to 28 Mb/s. For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (article describes how to provide Intelligent Cube cache files to MicroStrategy for troubleshooting cases. Save the Report and close. For background. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). Create a metric that returns a transformation of last year's. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. Sharing data. Create a cube report based on the cube. 2 attributes and 1 metric). 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. 9K KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Create a report based off the cube in Step 1 that includes the description form for Category. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Select a database configured for SAP HANA. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. Importing MDX cubes is often handled by a MicroStrategy architect. 4. Click Intelligent Cube Report. 000007431. 4. The partition attribute is the attribute that is used to divide. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Publish the cube. Click Create on any page, point to New Report, and then select Blank Report, which provides a blank template to build your report on. 1 or above, to pick up the fix, enable project level setting "Data Engine Version" to 11. Easily add or change pre- and post- SQL statements. 3 - Check the Make Intelligent. Loading. Browse to and select a previously saved Intelligent Cube on which to build your report. This is the same requirement to create or run a static report in Workstation. Navigate to the folder location of the Intelligent Cube. Designing and creating documents: An overview. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. This is because with this feature enabled, the element block ID will be saved to the new cube cache. Use the drop-down under the filter summary section to switch the server nodes. 2. This Python 3 / MicroStrategy 10. In the Refresh Policy column, choose one of the following options: To define an incremental refresh report. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Data Population for Intelligent Cubes. In MicroStrategy Web 9. From the cube monitor, we could see the. Allow reports to drill outside the Intelligent Cube: Select this check box to enable drilling outside the Intelligent Cube to access the full set of data available in the data. How to configure, monitor, and manage Intelligent Cubes. You need the Use Intelligent Cube. Select the data set and click Prepare Data. MicroStrategy transforms organizations into intelligent enterprises through data-driven innovation. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Faster performance than directly querying warehouse. IS_PROJ_ID. 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. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. 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. x. ACTION:In the Navigation pane, click Monitors. 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. At this time, only one table per cube is supported. ) 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. The Intelligent Cube Options dialog box opens. This can improve the performance of. Modify the list of Report objects (use object browser). WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. HyperIntelligence for Web. Con: The copy of report data in Intelligence Server memory only applies to a single report. A report that runs against the Intelligent Cube. Users can create a Report Post SQL Statement within the Intelligent Cube that updates the value of a flag in the warehouse table. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 4. 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. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. The Intelligent Cube Editor uses the new Modeling service infrastructure. 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. 3. Shut down Intelligent Server node A with command . An Intelligent Cube is a multi-dimensional cube (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports and documents. The Save Intelligent Cube As dialog box opens. The ability to view or edit certain settings is determined by a user's privileges. Browse to an Intelligent Cube, select it, and then click OK. 2. Choose File > New > Intelligent Cube. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. Choose File > New > Intelligent Cube. You can also select an existing template (see How to Create a Report Based on an Existing Template ). Under Cube Update, click Cube Update. “Intelligent Cube (<Cube Name>) for locale. 11. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. If you are upgrading to MicroStrategy 11. To choose from the full list of template workflows, click the. 4. Click All Objects View. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. Select the Intelligent Cubes tab. In this case, the dataset is a MicroStrategy Intelligent Cube. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. PUBLISH INTELLIGENT CUBE "Year Revenue Cube" IN FOLDER "profilesAdministratorMy Reports" FOR PROJECT "MicroStrategy Tutorial"; TRIGGER EVENT "Run Reports";Create an Intelligent cube with Month and Revenue. Create a Report 'R3' with 'Country' attribute. Check it in the cube monitor and we can see its column Database Connection is not empty. 4. You can also select an existing template on which to build your new report. 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). Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. By default, there is a system hierarchy on the cube. 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. Open the cube report in Design View. Edit the cube from step 1 and add the Category attribute. 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. The file location in project configuration is . We use MicroStrategy Tutorial objects in the following steps. 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. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. This can be done by selecting Run Report in the toolbar. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. 3. It is especially useful when data. 4. Intelligent cubes & Level Metrics. 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 . Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. Make sure the service is properly configured and running before using the Intelligent Cube Editor. Prerequisites. 2 release, the driver file is called odbc8. 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. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). 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. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide . The Modeling service must be configured correctly to use this feature. Run the report in Grid View. Right-click the dataset, and choose Schedule. Purpose of the registry key. 4 the connection mapping of the u… Number of Views 1. Click OK to save the Intelligent Cube and return to the Report Editor. 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. MicroStrategy Developer 9. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. You can edit project-level cache and Intelligent Cube settings. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. 4. 0 MicroStrategy releases. Drill within Intelligent Cube:. More than one cube can be used in a single dashboard. Navigate to the folder location of the 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. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. The following procedure will make cube data accessible to view reports. com Format: A MicroStrategy Online. 3. • You need the Publish Intelligent Cube (Developer) and/or Web Publish Intelligent Cube (Web) privileges. Click OK. To view an existing cube, you must have the following minimal privileges: Use analytics. and select the Project-Name. 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. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. This determines the approach to existing data at refresh. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. 1. 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. 1 to see the results as shown. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. 1. In the Tutorial project create a cube with the Year attribute. 4. It's basically just a report, and can even start it's life off as a report. Select an MDX cube. Ensure that the email addresses can be displayed properly. Select the refresh policy.