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. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. Full Refresh. Click OK to save the Intelligent Cube and return to the Report Editor. 11. Designing and creating documents: An overview. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. Check it in the cube monitor and we can see its column Database Connection is not empty. Select the environment and project where you want to save your. Check the location of the new cube cache and notice that it is saved in the default location, i. Select other schedule options as required, and click OK. In the Tutorial project create a cube with the Year attribute. The Intelligent Cube Monitor is displayed. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. Web Analyst. In the web cube editor for a data-import cube, pick a table and choose "Define Relationships" from the table drop-down menu to modify the relations, e. Run a dossier based on the cube. Login to MicroStrategy Web, create a cube with the function of Data Import 2. 2. All reports that access Intelligent Cubes allow you to drill within the data included in an Intelligent Cube. The Intelligent Cube Options dialog box opens. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. 4. In your Datasets panel, hover over the name of your dataset. 4. This property can only be enabled through Workstation. Navigate to the Intelligent Cube you want to refresh. The status of each Intelligent Cube is listed in the. In the Object name field, type a descriptive name for the Intelligent Cube. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide . This can be seen in the screenshot below. Import MicroStrategy File. Open MicroStrategy Web. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. Edit Intelligent Cubes from the new editor in Workstation at any time. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. details. 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). To Schedule a Cube Refresh. Watch on. 3. Stop the. The Modeling service must be configured correctly to use this feature. 4. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. 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. 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. Faster performance than directly querying warehouse. You cannot create or edit a card based on an unpublished cube. 2. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. /ClusterCube. Right-click an Intelligent Cube and select Delete. In MicroStrategy Web 9. WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. Add Year Id and Quarter. Click Close, then "Finish" on the "prepare data" view and save the cube. The Intelligent Cube Monitor is displayed. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. x. Create 500 users, 500 database logins, and 500 database connections mapping to the same data warehouse. All necessary privileges are included in the Administrator role by default. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. In MicroStrategy Web, open the document in Design Mode or Editable Mode. 4 the connection mapping of the user account which published the cube are created and database connections are listed in the Intelligent Cube Monitor in Developer. This is the same requirement to create or run a static report in Workstation. The Dashboard can be executed successfully. Intelligent Cubes in MicroStrategy - A Tutorial MicroStrategyBlog 413 subscribers Subscribe 21K views 11 years ago A quick tutorial on how to create and. Start > All Programs > MicroStrategy Products > Integrity Manager. From the MicroStrategy Web Home page navigate to the Intelligent Cube (Cube A) you want to merge data into. . Add a dataset. Publish the cube. However, importing data from a Google Drive Spreadsheet requires some additional setup. Use OLAP Services. Login to MicroStrategy Web, create a cube with the function of Data Import 2. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. When an Intelligent Cube is published, the Intelligent. Supports derived metric creation. • You need the Publish Intelligent Cube (Developer) and/or Web Publish Intelligent Cube (Web) privileges. 3. Dynamic source hit. CAUSE: The report on which the action is being performed is a "Standard" report, only OLAP reports can be pointed to Intelligent Cubes. From the Report Selection panel, go to the File menu > Open. The predefined MicroStrategy Web Analyst group is assigned the set of Web Analyst privileges by default. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. 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. However, in MicroStrategy Web 10, this 'Link' property is no longer available for Intelligence cubes2. This data is stored as Intelligent Cubes. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. com Format: A MicroStrategy Online. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. The month ID for 2004 Jan is like 200401. Remove the prompt from the Base Report and save it as Intelligent Cube. The Subscribe to Cube /Cache Update dialog box opens. 2. This is the same requirement to create or run a static report in Workstation. However, users can achieve this functionality by creating a cache update subscription to refresh Intelligent Cubes. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . 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. Use OLAP Services. Complete the "sessionState" field (e. 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. x. 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. Then click "Save". Open the. To publish an Intelligent Cube, see. To define an incremental refresh report. 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. CAUSE: This is working as designed. 1 product only with documents using view filter qualifications. In MicroStrategy Web 9. The Select Dataset dialog box opens. Create a new dossier: Create a new metric M01=Case: Create a new metric. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. The differences between the options. In Desktop, create and publish an intelligent cube with one attribute and one metric. You need the Use Intelligent Cube. 1 or above, to pick up the fix, enable project level setting "Data Engine Version" to 11. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Con: The copy of report data in Intelligence Server memory only applies to a single report. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL. In the Object name field, type a descriptive name for the Intelligent Cube. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. “Intelligent Cube (<Cube Name>) for locale. The create_cube() function will return the datasetID and tableID, which can be used to update a dataset with new data. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). 4. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. Steps to reproduce. This is the same requirement to create or run a static report in Workstation. x releases, and the new Multi-table Data Import (MTDI) cubes. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;Job ID for the action on the Intelligent Cube. The Subscription Editor opens. The Browse for Folder dialog box opens. Save the Intelligent Cube generated. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. txt file. 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)". In MicroStrategy Developer, log in to a project source with administrative privileges. 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. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. Here, we use MicroStrategy Tutorial objects to create a report: Add Category, Brand, and. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. At least one MDX cube must be imported into your MicroStrategy project. Create a document with orderID and itemID attributes on the grid. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Web publish Intelligent Cube. In MicroStrategy Web 9. The Intelligent Cube Editor uses the new Modeling service infrastructure. Create a new variable and assign SuperCube with two parameters inside – connection and id. Publish. 2. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. Browse to and select a. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. Choose Databases. Sharing data. x - 10. 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. Create an intelligent cube with Call Center, Quarter and the derived metric 3. Then click "Save". When Drilling on a report created from an Intelligent Cube gives the Last Update Date of 1899 in MicroStrategy Web 9. To Create a Report that Accesses an 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. Execute View Report. Open the report in Grid View, Design View, or Grid and Graph view. The Incremental Refresh Options dialog box opens. Open the Workstation window. 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. In MicroStrategy Web 10. 9 and 10. To view an existing cube, you must have the following minimal privileges: Use analytics. Browse to an Intelligent Cube, select it, and then click OK. The Modeling service must be configured correctly to use this feature. In MicroStrategy 9. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. 2. For: "Import data from file or database before using in a Visual Insight analysis", which makes the source an Intelligent Cube, a Web Professional license is required. It involves only fetching a portion of the data that the user wants, instead of storing all data in-memory as a normal Intelligent Cube. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. To create a report that connects to an Intelligent Cube, in MicroStrategy Developer. 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. 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. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Typically, a long duration is seen in the Data Transfer time which indicates the time it takes to fetch data from the warehouse. From the Data menu, select Configure Intelligent Cube. Create Schema Objects. To choose from the full list of template workflows, click the. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. 2. (Titled: "Cube broken aplysimple") No data is returned the following SQL view is seen: Report: cube broken applysimple Job: 198 Total Number of Passes: 1 Number of Intelligent Cube SQL Passes: 1 Number of Analytical Passes: 0 Intelligent Cubes Accessed:The steps below show you how to create an Intelligent Cube based on an MDX cube. Load an updated CSV file into a DataFrame providing full path. The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. The report opens with all of the objects of the Intelligent. Visualizations in the dossier that use data from the cube display. Create and publish Intelligent cube called “Cube2” on node B. Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. In MicroStrategy Developer create an Intelligent Cube with any attributes and metrics. To Create an Intelligent Cube Using Freeform SQL or Query Builder. Drag and drop the objects into the report grid from the Report Objects pane. Description. Select data population for Intelligent Cubes. Make sure the service is properly configured and running before using the Intelligent Cube Editor. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Designing and creating documents: An overview. Steps to import a spreadsheet from Google Drive:MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. 1, Data Import allows users to maintain intelligent cubes from external Excel files. 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. Run the report in Grid View. Do not normalize Intelligent Cube data. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. This is set to 32,000 by default. The Create Group dialog box opens. Click “All Objects View”. 1 or MicroStrategy Web 9. 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. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. Right-click your selection and select Group. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. This permission is checked at design time, and when executing reports against an Intelligent Cube. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Log into ProjectA in MicroStrategy Web. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. Check the status of the cubes in Developer. The Modeling service must be configured correctly to use this feature. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. 63K. Open the. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. For the example scenario, log in to the MicroStrategy Tutorial project. 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. You need the. Right-click your selection and select Group. 2. Upload Dashboard. Select Empty. create() will create a SuperCube, upload the data to the Intelligence Server and publish it. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Publish the Intelligent Cube by executing it on either of the nodes. In MicroStrategy 10. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. Use Intelligent Cube Editor. At least one MDX cube must be imported into your MicroStrategy project. g. Open Command Manager and type the following commands to. x-10. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. This is an identified defect in Visual Insight in MicroStrategy Web 10. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. Execute. e. On the ODBC Sources tab, in the Source area, select the database instance that connects to the data source to report on using Freeform SQL or Query Builder. An. 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. Create an Intelligent Cube with "Customer", and add the attribute form "Email" into the cube. x and create a new Dashboard. 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. 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. Select an Environment from the upper-left drop-down. Navigate to the Engine Component with CSI Dispatcher. 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. Edit Intelligent Cubes from the new editor in Workstation at any time. In MicroStrategy 11. This permission is checked at design time, and when executing reports against an Intelligent Cube. To build an Intelligent Cube In Developer, from the File menu select New, and then Intelligent Cube. KB30711: Security filter application to view reports based on Intelligent Cubes. 38K. We match smart people to dynamic projects and technologies that truly. From the File menu, select New,. Make sure the service is properly configured and running before using the Intelligent Cube Editor. 4. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create. Create Schema Objects. 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. Call this 'Base Report'. x. This property can only be enabled through Workstation. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. 2. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". How to configure, monitor, and manage Intelligent Cubes. Right mouse click on the cube and choose Schedule 3. 3. 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. These privileges are part of OLAP Services. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. Ensure that the email addresses can be displayed properly. IS_CUBE_ACT_ID. The file location in project configuration is . The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. For intelligent cube imported from local file via Data Import, we do not support creating subscriptions as the path may change. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. 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. Restoring cube files. ACTION:In the Navigation pane, click Monitors. Create a cube report based on the cube. Log in to a project connected to an MDX cube source. 4. The view filter cannot filter out other elements as shown below:Use Cube Advisor to create Intelligent Cubes: 1. It is very simple to create an intelligent cube, it is same like. 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. And create one Cube based report called “cube report 2”. Run both reports after enabling the metric levels log. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 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. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. 1. Save the Cube with Connect Live Data Access Mode. For steps to create a view filter in MicroStrategy Web, see the MicroStrategy Web Help. For example, you can choose to add or delete data from the Intelligent Cube. The month ID for 2004 Jan is like 200401. 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). after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". To set refresh filters, or alternate data sources, select Show Advanced Options. ICUBE_STATUS: shows the status of the intelligent cube, returned as a string value. Select a schedule from the Schedule drop-down list. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Publish the cube. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. In the left panel, click Cubes. How to Import Data from a SAP HANA Database Into MicroStrategy Web. From the File menu, select New, and then select Intelligent Cube. Log in to the project in which you want to create a report. Expand Intelligent Cubes, and then select General. 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. Common Privileges. The user continues to use the report that accesses the Intelligent Cube. 4. Save as an In-Memory dataset. Open the Workstation window. To publish an Intelligent. . Shut down Intelligent Server node A with command . 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. You can also reproduce this issue in a Document. Navigate to the Intelligent Cube for which you want to define the incremental refresh. Drag and drop the objects into the report grid from the Report Objects pane. If you select Cube B, any dashboards or reports linked to Cube A before the merge may not function correctly. 1. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Watch the Product team review how to configure and manage advanced properties of Intelligent Cubes. Right-click the cube, and select Schedule Data Refresh. 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 allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. To Create a Report that Accesses an Intelligent Cube. 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.