IS_CUBE_INST_ID. Select the data set and click Prepare Data. Right-click the Intelligent Cube, and select Define Incremental Refresh. In the Data Source column, select the checkboxes for the tables to update. GUID: is the GUID of the intelligent cube, returned as a string. The Modeling service must be configured correctly to use this feature. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL. This permission is checked at design time, and when executing reports against an Intelligent Cube. You can also select an existing template (see How to Create a Report Based on an Existing Template ). 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. Select the data set and click Prepare Data. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. 4. Type a name for the derived element, and click OK. Edit the cube from step 1 and add the Category attribute. For example, you can choose to add or delete data from the Intelligent Cube. 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. Run the report, notice that the filter does not work, all. Use Intelligent Cube Editor. Web publish Intelligent Cube. Right-click the Intelligent Cube, select "Schedule Delivery To" and choose "Refresh Cube". The Report Editor opens. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Choose File > New > Intelligent Cube. 2. 2. Create Cube B which contains all objects in the report and publish it . 63K. /ClusterCube. The display of data is handled by the reports that access the Intelligent Cube. Click OK to save the Intelligent Cube and return to the Report Editor. 3. To solve this problem, we introduce a new registry key, " Respect. Prerequisites. Save as an In-Memory dataset. All necessary privileges are included in the Administrator role by default. In the Navigation pane, click , next to Datasets. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. Prerequisites for using Cube Advisor. 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. 3. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. The Intelligent Cube Monitor is displayed. The Report Editor opens with all of the objects of the Intelligent Cube. Select an MDX 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. x. The view filter cannot filter out other elements as shown below:Use Cube Advisor to create Intelligent Cubes: 1. Create a new Dossier. g. 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. Republish the same cube, and a new cube instance is generated. With OLAP Services features, your report designers can create Intelligent Cube reports. 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. 3. 4 the connection mapping of the u… Number of Views 1. This determines the approach to existing data at refresh. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. By default, this is set to 32,000. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. In MicroStrategy Developer, log in to a project source with administrative privileges. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Use the drop-down under the filter summary section to switch the server nodes. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. 4. Navigate to the Intelligent Cube for which you want to define the incremental refresh. This " How to" knowledge base article explains cube advisor. From the. Create a document with orderID and itemID attributes on the grid. Currently, project duplication does not involve Intelligent Cube File Directory. Check the location of the new cube cache and notice that it is saved in the default location, i. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. The following diagram depicts the role of the intelligent cube. You need the. Web object search—this enables the user to see the “User Manager” button on the Intelligence Server Administration page. This Python 3 / MicroStrategy 10. Assuming that ProjectA and ProjectB are in the same metadata, create a Database Instance to connect to an OLAP data source. Select a database configured for SAP HANA. 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. The Create Group dialog box opens. Create a new dossier: Create a new metric M01=Case: Create a new metric. How to build and manage Intelligent Cubes. Shut down Intelligent Server node A with command . The report retrieves data from Cube B now. ACTION:The procedure below provides steps to create a subscription to schedule the publication of an Intelligent Cube. 2 attributes and 1 metric). This procedure assumes that the Linux machines are called UNIX1 and UNIX2. Create a report based off the cube in Step 1 that includes the description form for Category. Publish the cube. In MicroStrategy Web, log in to a project. Then click "Save". From the File menu, select Create Test. First, you open a blank document and select a report to use as the document's dataset. Run both reports after enabling the metric levels log. 38K. 66K. Publish. 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. PublishCube". Right-click an Intelligent Cube and select Delete. Web modify the list of report objects (use object browser --all objects) Web Professional. The Intelligent Cube opens in the Report Editor. You can also select an existing template on which to build your new report. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. 2. ACTION:The Data Transfer Rate varies from 27 to 28 Mb/s. com Format: A MicroStrategy Online. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal Intelligent. Upload Dashboard. It is especially useful when data. When triggering the concurrent subscriptions to publish a cube with different database connections, some of them do not publish. In Developer, log in to a project with a user account with administrative privileges. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Follow the steps below using the MicroStrategy Tutorial project: 1. Node 2. x. Right-click your selection and select Group. Normalize Intelligent Cube data in MicroStrategy Intelligence Server . The partition attribute is the attribute that is used to divide. In MicroStrategy Web 10. In the New Intelligent Cube dialog box, select the MDX Sources tab. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). To create an MDX cube report in MicroStrategy Web, you need to have Web Professional privileges, including the Web Define MDX Cube Report. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. 0, you have the option to use Data Import to create an in-memory dataset (sometimes referred to as an super cube) containing data from multiple tables. 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. For steps to create an Intelligent Cube based on an MDX cube, see Creating Intelligent Cubes based on MDX cubes. 3. Starting in MicroStrategy 10. Navigate to Administrator -> System monitor -> Cube monitor both nodes, and check all cube are “active, load, file” status. On the Freeform Sources tab, select one of the following options: To. Click Create and choose Add External Data. In the Intelligent Cube cache monitor in Developer, notice that all cube caches for the project. Run the Report and check the SQL View. microstrategy. Allow reports to drill outside the Intelligent Cube Select this option to enable drilling outside the Intelligent Cube to access the full set of data available in the data. However, importing data from a Google Drive Spreadsheet requires some additional setup. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. Under Cube Update, click Cube Update. Publish the cube. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. Loading. It's basically just a report, and can even start it's life off as a report. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. Later the user can poll for the change in the value of the flag. Then click "Save". In MicroStrategy Developer, browse to an Intelligent Cube. x. 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. By default, there is a system hierarchy on the cube. Check in Developer that the stopped node is in Maintenance Mode. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". To review and create recommended Intelligent Cubes using Cube Advisor. First, you open a blank document and select a report to use as the document's dataset. By default, there is a system hierarchy on the cube. Add Project objects from the All Objects panel. Click Create on any page, point to New Report, and select Blank Report. 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. From the MicroStrategy Web Home page navigate to the Intelligent Cube (Cube A) you want to merge data into. Regular Intelligent Cubes created on Developer. 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. 4. x - 10. 5. This must be done by the DBA and MicroStrategy Technical Support will not assist with this. Quickly integrating data into MicroStrategy as part of a proof-of-concept. The Incremental Refresh Options dialog box opens. Complete the "sessionState" field (e. Import MicroStrategy File. PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public ObjectsReportsSequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a. In MicroStrategy Developer, locate the Intelligent Cube that needs to be refreshed. There is no need to further create a dashboard. CAUSE: This is working as designed. The Select Dataset dialog box opens. From the cube monitor, we could see the old cube is it. Right-click the project and select Project Configuration. By default SuperCube. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. Execute reports or documents that reference the object. Common Privileges. All reports that access Intelligent Cubes allow you to drill within the data included in an Intelligent Cube. How to build and manage Intelligent Cubes. 2. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. 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. A list of data sources available in this project appear. For information on using Cube Advisor to support dynamic sourcing, see Using Cube Advisor to support dynamic sourcing. KB224157: How to Get the Intelligent Cube Status Using MicroStrategy Web SDK. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. STEPS TO REPRODUCE 1. Navigate to the Intelligent Cube you want to refresh. From the Data menu, select Add Dataset. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create. . 4. In MicroStrategy Web browse to the Cube location and click on the cube . Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Log in to the project in which you want to create a report. Create an Intelligent cube and add subscriptions for all 500 users to publish the cube. The ability to view or edit certain settings is determined by a user's privileges. To Create an Intelligent Cube Using Freeform SQL or Query Builder Using MicroStrategy Developer, log in to a project connected to an MDX cube source. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. However, in MicroStrategy Web 10, this 'Link' property is no longer available for Intelligence cubes2. Drag and drop the objects into the report grid from the Report Objects pane. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. In MicroStrategy 9. In MicroStrategy Developer, edit the Intelligent Cube where u sers want to enable partitioning. Upload Dashboard. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. Select the refresh policy. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. The New Intelligent Cube dialog box opens. Call this 'Base Report'. Right mouse click on the cube and choose Schedule 3. x - 10. 38K. Publish the Intelligent Cube by executing it on either of the nodes. 1. Create a report based off the cube in Step 1 that includes the description form for Category. 3. Start > All Programs > MicroStrategy Products > Integrity Manager. Click Intelligent Cube Report. Users can create a Report Post SQL Statement within the Intelligent Cube that updates the value of a flag in the warehouse table. 8. 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. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. . 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. 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. Report Post SQL Statement. The impact is limited to MicroStrategy Developer 9. The Subscribe to Cube /Cache Update dialog box opens. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Right-click on the cube and choose Edit. Open the. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 0 MicroStrategy releases. 4. Log into the three-tier project source and choose the project that was analyzed in stage 2. These privileges are part of OLAP Services. 1. 4. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Log in to the project in which you want to create a report. The report opens with all of the objects of the Intelligent. 2. This command will deactivate the Intelligent Cube cache so reports from this Intelligent Cube will not be able to run while it is being re-published. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Launch MicroStrategy Cube Advisor from the Start menu > Programs > MicroStrategy > Tools > Cube Advisor. 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. 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. Select the data sources to be refreshed. CubeServerDefinition, and this folder should be shared as 'ClusterCube'. 4. To Create an Intelligent Cube Using Freeform SQL or Query Builder. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. Click Select. Open the cube report in Design View. Click Close, then "Finish" on the "prepare data" view and save the cube. To publish an Intelligent. Right-click the dataset, and choose Schedule. 86K KB31566: MicroStrategy 9. In MicroStrategy Web 9. Open the Workstation window. Use Intelligent Cube Editor. 2. 4. Modify the list of Report objects (use object browser). You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). The report opens with all of the objects of the Intelligent. To define an incremental refresh report. 0. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. 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 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 cube now has Year and Category on it. A set of data is returned from the. 1, Data Import allows users to maintain intelligent cubes from external Excel files. You can also create Intelligent Cubes by directly querying your data. This copy of report data is stored in Intelligence Server memory only. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. In MicroStrategy Developer create an Intelligent Cube with any attributes and metrics. GUID of the Intelligent Cube instance in memory. x as Administrator; create a simple Intelligent Cube called Q, and publish it. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. More than one cube can be used in a single dashboard. All articles. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. 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. Run a dossier based on the cube. For instructions on configuring MDX sources, refer to the MDX Cube Reporting Guide. Select the Intelligent Cubes tab. 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. 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). This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. Some uses for this data include: •. The Subscribe to Cube /Cache Update dialog box opens. In your Datasets panel, hover over the. From the File menu, select New,. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. 4. IS_CUBE_ACT_ID. 1. Click an MDX cube source. This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. 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. 1 or MicroStrategy Web 9. If you are upgrading to MicroStrategy 11. Defining the partition for Super Cubes. STEPS TO REPRODUCE 1. This determines the approach to existing data at refresh. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. The Modeling service must be configured correctly to use this feature. x. A page with report creation options is displayed. The default value is 256 megabytes. Web publish Intelligent Cube. For more information on importing MDX cubes into MicroStrategy, see Importing MDX cubes. Why MicroStrategy Why MicroStrategy; Customer StoriesBelow is an example of a script that can be used to execute the event "Run Reports" after Intelligent Cube "Year Revenue Cube" has published. To create an Intelligent Cube based on an MDX cube Using MicroStrategy Developer, log in to a project connected to an MDX cube source. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. Open Command Manager and type the following commands to. This is the same requirement to create or run a static report in Workstation. Open the. HIDDEN: if the intelligent cube is hidden or not, returned as a boolean value. If you select Cube B, any dashboards or reports linked to Cube A before the merge may not function correctly. All Intelligent Cube operations are listed below: 1. We can create a report and point the report to a cube or right click. Open the cube report in Design View. The file location in project configuration is . All articles. g. Visualizations in the dossier that use data from the cube display. Login Web with Administrator, Create a VI Dashboard based on this cube. The Select Intelligent Cube dialog box opens. Check the status of the cubes in Developer. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. The New Grid dialog box opens. From the Data menu, select Configure Intelligent Cube. An. A possible cause of this issue is that the folder that stores the Intelligent Cube files on the node where the Intelligent Cube is published is not shared with the name 'ClusterCube' on the MicroStrategy Intelligence Server machine(s). In the 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. At least one MDX cube must be imported into your MicroStrategy project. Hover the schedule need to be modified,. Trending Articles. Quickly integrating data into MicroStrategy as part of a proof-of-concept. To set refresh filters, or alternate data sources, select Show Advanced Options. Sharing data. For more details on enabling the setting, refer to Change Data Engine Version. Edit Project-Level Cache and Intelligent Cube Settings. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". Create. Use Intelligent Cube Editor. Log into ProjectA in MicroStrategy Web. Number of Views 1. Easily add or change pre- and post- SQL statements. 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. Select the data sources to be refreshed. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Go to the "All Objects View" option in the top left corner. Click Create on any page, point to New Report, and select Blank Report. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. 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. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. The Browse for Folder dialog box opens. Faster performance than directly querying warehouse. They are. The Browse for Folder dialog box opens. When an Intelligent Cube is published, the Intelligent. Create an attribute element prompt for the Year attribute. The create_cube() function will return the datasetID and tableID, which can be used to update a dataset with new data. Refresh Intelligent Cubes manually. For Oracle 12. 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. 1, Data Import allows users to maintain intelligent cubes from external Excel files. This is because with this feature enabled, the element block ID will be saved to the new cube cache. Workaround 2: Create a non-Kerberos authenticated database login. 4. x - 9. Create 500 users, 500 database logins, and 500 database connections mapping to the same data warehouse. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. For prior releases, either a cube was loaded, residing completely in RAM, or unloaded.