Upload Dashboard. 4. 2. 000007431. Currently, project duplication does not involve Intelligent Cube File Directory. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. Click the MicroStrategy icon at the upper left of any page and select History List. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. 6. Refresh Intelligent Cubes manually. 9 and 10. To publish an Intelligent Cube, see. Create Schema Objects. Description What's New 2022 Releases Workstation. Intelligent Cubes. Refer to the following tech note, KB37431 for a list of Licenses and privileges required for different actions related to Visual Insight in MicroStrategy Web 9. The display of data is handled by the reports that access the Intelligent Cube. 1. They are. Make sure the service is properly configured and running before using the Intelligent Cube Editor. Easily add or change pre- and post- SQL statements. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. In MicroStrategy 10. Deploy the ojdbc8. Do not normalize Intelligent Cube data. With OLAP Services features, your report designers can create Intelligent Cube reports. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. Check in Developer that the stopped node is in Maintenance Mode. Right-click the cube, and select Schedule Data Refresh. 3. Purpose of the registry key. Browse to and select a previously saved Intelligent Cube on which to build your report. The Intelligent Cube Monitor is displayed. Integer ID of the project where the Intelligent Cube is stored. 3. Load an updated CSV file into a DataFrame providing full path. 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. If you are upgrading to MicroStrategy 11. create() will create a SuperCube, upload the data to the Intelligence Server and publish it. For Oracle 12. 4. This technical note describes a known issue when creating a data import cube in MicroStrategy Web 10. 4. Create a report with the year and quarter attributes and the profit metric. 1. Create a new in-memory dataset with the create_dataset() function. ACTION:In the Navigation pane, click Monitors. 3. A set of data is returned from the. Export to MicroStrategy File. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. In MicroStrategy Web 9. For steps, see the Upgrade Guide. Create Schema Objects. Choose File > New > Report. Right-click an Intelligent Cube and select Delete. 0. 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. 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. In MicroStrategy Developer, edit the Intelligent Cube where u sers want to enable partitioning. The ability to view or edit certain settings is determined by a user's privileges. From the Data menu, select Configure Intelligent Cube. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. x. Web Analyst. Create a Report 'R3' with 'Country' attribute. delete one relation as the following Then click "Save" to go back to the cube editor, click the "Update Dataset" button in the bottom right corner. In the Navigation pane, click , next to Datasets. Designing and creating documents: An overview. The Browse for Folder dialog box opens. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 1. Use the Objects section to search for the desired metrics and attributes. Modify the list of Report objects (use object browser). The Schedule dialog box opens for your dataset, showing the tables in your dataset. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. Click Intelligent Cube Report. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. 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. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). The report opens with all of the objects of the Intelligent. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. Navigate to the folder location of the Intelligent Cube. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Type a name for the derived element, and click OK. Go to Data -> Configure Intelligent Cube -> General and set both "Make Intelligent Cube available for Dynamic Sourcing" and "Allow Dynamic Sourcing even if Outer Join properties are not set" to ‘Enabled‘. x, users will notice that this is not possible due to the mouse. Run report off cube. To solve this problem, we introduce a new registry key, " Respect. jar file to i-server machine. Select an Environment from the upper-left drop-down. Insert one panel stack and add dynamic text with Profit Margin. It does not tell us anything helpful and we should not use it as a point of reference. x. Normalize Intelligent Cube data in MicroStrategy Intelligence Server . Steps to Reproduce. In the Refresh Policy column, choose. 1, Data Import allows users to maintain intelligent cubes from external Excel files. 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). Add a dataset. 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. Create Cube A and a report based on it. 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. After the Intelligent Cube has finished republishing, the Cube reports will contain the updated. Easily add or change pre- and post- SQL statements. Trending Articles. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. From the cube monitor, we could see the. Use Intelligent Cube Editor. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Number of Views 1. In MicroStrategy Web 9. For the Intelligent Cube that you want to refresh, click the subscription icon. Open the. This is possible because when the Intelligent Cube refresh job finishes, a record is logged in the IS_REPORT_STATS table. Save the Report and close. For information on using Cube Advisor to support dynamic sourcing, see Using Cube Advisor to support dynamic sourcing. At this point, the Month attribute can be removed from the cube to reduce the publication time and size of the Intelligent Cube within memory. 4. The Intelligent Cube Editor uses the new Modeling service infrastructure. PublishCube". MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal Intelligent. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. e. You can also select an existing template on which to build your new report. This is the same requirement to create or run a static report in Workstation. Click the MicroStrategy icon, and select Create Report. Create a Data Import Live Intelligent Cube. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create a report in MicroStrategy Web. Browse to and select a. Check the location of the new cube cache and notice that it is saved in the default location, i. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . The Subscription Editor opens. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The Subscribe to Cube /Cache Update dialog box opens. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. You must belong to the System Administrators group to use this feature. Before MicroStrategy 10. 4. To Create a Report Using Both Report Objects from a MicroStrategy Project and MDX Cube Data. By default, there is a system hierarchy on the cube. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. 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. A solution/code fix for this issue is not available in current releases but is being reviewed for a future MicroStrategy. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. The Report Editor opens. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. The search directly uses the attribute form from the attribute definition, instead of form from the intelligent cube. The Dashboard can be executed successfully. HyperIntelligence for Web. To Schedule a Cube Refresh. 3. At this time, only one table per cube is supported. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. Created cube with lastname and any other attribute. Quickly integrating data into MicroStrategy as part of a proof-of-concept. In the Data Source column, select the checkboxes for the tables to update. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. x as Administrator; create a simple Intelligent Cube called Q, and publish it. Delete one of these two cube caches from the cache monitor in Developer. The Modeling service must be configured correctly to use this feature. For steps to use an existing template to. 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. In the Data Source column, select the checkboxes for the tables to update. Select a schedule from the Schedule drop-down list. Click Select. /ClusterCube. This provides ROLAP-type analysis without having to re-execute against the data warehouse. 0 MicroStrategy releases. create(auto_upload=False,. 2. 2. Create a metric that returns a transformation of last year's. KB228850: How to migrate published intelligent cubes to a different environment in MicroStrategy Intelligence Server 9. The Intelligent Cube Options dialog box opens. You must belong to the System Administrators group to use this feature. Right-click an application and choose Properties. MicroStrategy Developer 9. All necessary privileges are included in the Administrator role by default. In MicroStrategy Web, open the document in Design Mode or Editable Mode. This determines the approach to existing data at refresh. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. Browse to an Intelligent Cube, select it, and then click OK. From the File menu, select New, and then select Intelligent Cube. The current version of MicroStrategy Tutorial is designed using the MicroStrategy URL API with JSP framework, therefore MicroStrategy ASP is not supported for the redesigned Tutorial project. 1. Include “Qualification Prompt”. Common Privileges. 3. 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. Republish the same cube, and a new cube instance is generated. Prerequisites. To set refresh filters, or alternate data sources, select Show Advanced Options. They should have the “A, L, F” status (Active, Loaded, Filed). 2. 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. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. Call this 'Base Report'. The Modeling service must be configured correctly to use this feature. Click OK. From the System Manager home page, you can access the template workflows in the Templates section. 4. Save the cube, and run it to publish. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. In MicroStrategy 10. 1 and 10. 1. 3. To accomplish this, the first step is to turn ON this feature by selecting "Create Intelligent Cubes by database connection" in the Project Configuration editor (screenshot below). Regular Intelligent Cubes created on Developer. 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. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. 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. 1 to see the results as shown. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. Log in to the project in which you want to create a report. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. x-10. 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. Full Refresh. Right-click the dataset, and choose Schedule. The Select Intelligent Cube dialog box opens. com. This will influence the user experience. and select the Project-Name. In MicroStrategy Web browse to the Cube location and click on the cube . For more details on enabling the setting. The Full Refresh option is the default. To view an existing cube, you must have the following minimal privileges: Use analytics. 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. Description. 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. Right Mouse Click on ‘Cube_Tutorial’ to create report called ‘Report_Tutorial’. Cube index generation will increase cube size. Contact the MicroStrategy Technical Support for an update on this enhancement request. Log into the server and go to the Intelligent Cube monitor (Administration > System Monitors > Caches > Intelligent Cubes). Execute. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. To Create an MDX Cube Report. If you select Cube B, any dashboards or reports linked to Cube A before the merge may not function correctly. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Disconnect from the project source and restart both Intelligence servers. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. In MicroStrategy Web, click "Access External Data"; In the "Connect to Your Data" window, click the "Manage Your Datasets" link in left-bottom corner, as shown below: In Data Storage window, right mouse click the cube and choose "Schedule", a sub context menu displays all the existing schedule. KB224157: How to Get the Intelligent Cube Status Using MicroStrategy Web SDK. The cube now has Year and Category on it. 3. In MicroStrategy Web 10, during Data Import, users are able to choose "Connect Live" data sources, which is also known as "Direct Data Access" function, as shown below:. Use OLAP Services. The group is created as a derived element and displayed on the report. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. As shown in the screenshot above, only one cube cache can be loaded in RAM. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Open the cube report in Design View. 3 - Check the Make Intelligent. Go to the "All Objects View" option in the top left corner. ACTION:The procedure below provides steps to create a subscription to schedule the publication of an Intelligent Cube. A report accessing the Intelligent Cube includes only Year on the report. For steps to create an Intelligent Cube based on an MDX cube, see Creating Intelligent Cubes based on MDX cubes. To choose from the full list of template workflows, click the. The New Intelligent Cube dialog box opens. In the Object name field, type a descriptive name for the Intelligent Cube. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). These VLDB properties control the method by which the report data are normalized. txt file. 11. 4. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. This can be done by selecting Run Report in the toolbar. In MicroStrategy 9. 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. Save the Intelligent Cube. In the Object name field, type a descriptive name for the Intelligent Cube. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. To review and create recommended Intelligent Cubes using Cube Advisor. From the cube monitor, we could see the old cube is it. x and create a new Dashboard. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. Add External Data. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Navigate to and select the report or Intelligent Cube to use as the dataset, then click OK. 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. Section 5: Load Intelligent Cube files into the Intelligence Server. Workaround 2: Create a non-Kerberos authenticated database login. Follow the steps below using the MicroStrategy Tutorial project: 1. 3. /mstrctl -s IntelligenceServer. Notice the attribute forms in the Report Objects pane. Kickstart Your Career Get. PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public ObjectsReportsSequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a. 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. PublishCube". For the example scenario, log in to the MicroStrategy Tutorial project. In a clustered MicroStrategy Intelligence Server Universal compounded by two nodes Node A and Node B, a cube test cube is published on Node A and its status can be seen in Administration >> System Monitors >> Caches >> Intelligent Cubes:To view an Intelligent Cube stored in your History List. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. The report retrieves data from Cube B now. Select the refresh policy. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. 0. • You need the Publish Intelligent Cube (Developer) and/or Web Publish Intelligent Cube (Web) privileges. 8. You can also reproduce this issue in a Document. In your Datasets panel, hover over the. Intelligent Cubes. The default value is 256 megabytes. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. From the Report Selection panel, go to the File menu > Open. Edit Intelligent Cubes from the new editor in Workstation at any time. To Create a Report Using Both Report Objects from a MicroStrategy Project and MDX Cube Data. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. Right-click an Intelligent Cube and select Delete. Remove the prompt from the Base Report and save it as Intelligent Cube. after executing the Login task), and type the GUID of the. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent. com. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide. This article describes how to update information in an Intelligent Cube without having to do a full republishUsing Web, create an Intelligent Cube with Add External Data> Databases > Select Tables option and add 1 table Order_Detail using a "Live" connection. You can also modify the properties of. It also. Click OK. To unpublish an Intelligent Cube. Publish. 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. 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%. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. g. Visit the data visualization and data dashboard galleries for inspiration. 2. x. 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. 2. The group is created as a derived element and displayed on the report. We can create a report and point the report to a cube or right click. For steps to use an existing template to. Go to Data -> Configure Intelligent Cube -> General and set both "Make Intelligent Cube available for Dynamic Sourcing" and "Allow Dynamic Sourcing even if Outer Join properties are not set" to ‘Enabled‘. This Python 3 / MicroStrategy 10. Select the environment and project where you want to save your. Required Status to Perform Action. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Data access security is maintained. The Intelligent Cube Options dialog box opens. 0. Ensure that the email addresses can be displayed properly. This property can only be enabled through Workstation. Right mouse click the Intelligent Cube Q, select Schedule Delivery To>History List as shown below: 3. We use MicroStrategy Tutorial objects in the following steps. This copy of report data is stored in Intelligence Server memory only. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Enter a name for your new schedule into the. Assuming that ProjectA and ProjectB are in the same metadata, create a Database Instance to connect to an OLAP data source. STEPS TO REPRODUCE Use Data Import to bring in an Excel file containing a few columns (i. Click Create on any page, point to New Report, and select Blank Report. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. Open the Workstation window. Select other schedule options as required, and click OK. 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. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". The New Intelligent Cube dialog box opens. By default SuperCube. Run a dossier based on the cube. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. A page with report creation options is displayed. Select the. 1 or MicroStrategy Web 9. This VLDB property has the following options:. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. The "Email" column cannot be found in. Make sure the service is properly configured and running before using the Intelligent Cube Editor. This can improve the performance of. KB39447: How to Trigger an Event Using the MicroStrategy Web SDK 9. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. Right-click on the cube and choose Edit. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Expand Intelligent Cubes, and then select General. Create a report with Category, Region and Year attributes, and Revenue metric in the grid, and Year prompt from Step 1 in the report filter. From the File menu, select Create Test. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. From the Data menu, select Configure Intelligent Cube. x a new concept is introduced called Intelligent Cubes. Common Privileges. How to build and manage Intelligent Cubes. "In MicroStrategy 10.