Other metadata database platforms:Login Developer with Administrator, create a cube and publish it. By default, there is a system hierarchy on the cube. In MicroStrategy Developer, locate the Intelligent Cube that needs to be refreshed. 2. IS_CUBE_REP_ID. Users can create a Report Post SQL Statement within the Intelligent Cube that updates the value of a flag in the warehouse table. To Create a Report Using Both Report Objects from a MicroStrategy Project and MDX Cube Data. 4. Normalize Intelligent Cube data in MicroStrategy Intelligence Server . We should ignore the size of the Cube in the Cube Monitor when the Status is "A,F" (Active, Filed). 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. The Schedule dialog box opens for your dataset, showing the tables in your dataset. This determines the approach to existing data at refresh. For the Intelligent Cube that you want to refresh, click the subscription icon. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Modify the list of Report objects (use object browser). This is an identified defect in Visual Insight in MicroStrategy Web 10. You can also select an existing template on which to build your new report. To subscribe a report or document to a cube refresh. Intelligent cubes & Level Metrics. 1Currently it is not possible to create a cube refresh subscription in Command Manager. Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. Community & Support Search Discussions Open A Case View My CasesThis defect is addressed in MicroStrategy 11. Watch on. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. Some uses for this data include: •. Execute reports or documents that reference the object. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Select the "ORDER_FACT" table. 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. Publish the cube. Hover the schedule need to be modified,. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. ICUBE_STATUS: shows the status of the intelligent cube, returned as a string value. 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. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . You should see these cubes in the Intelligent Cube cache monitor in Developer. From the File menu, select New,. Create a Visual Insight dashboard and add the above cube as the dataset: 3. Right-click the project and select Project Configuration. This is a known issue classified as a defect with MicroStrategy Web 9. You cannot create or edit a card based on an unpublished cube. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. Check it in the cube monitor and we can see its column Database Connection is not empty. When an Intelligent Cube is in this status, any reports based on this cube have. CAUSE: The report on which the action is being performed is a "Standard" report, only OLAP reports can be pointed to Intelligent Cubes. This is possible because when the Intelligent Cube refresh job finishes, a record is logged in the IS_REPORT_STATS table. 2 in Web, navigate to the report in edit mode, right click “customer” and insert metric Count as shown below: 3. To Create an MDX Cube Report. Select the Intelligent Cubes tab. Easily add or change pre- and post- SQL statements. 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. The Report Editor opens with all of the objects of the Intelligent Cube. 3. Edit Intelligent Cubes from the new editor in Workstation at any time. Web modify the list of report objects (use object browser --all objects) Web Professional. Use OLAP Services. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. Create an Intelligent Cube with attributes Year, Month and Region; 4. Browse to and select a previously saved Intelligent Cube on which to build your report. To set refresh filters, or alternate data sources, select Show Advanced Options. In the user interface, specify the partition attribute and the number of partition . Edit Intelligent Cubes from the new editor in Workstation at any time. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Follow the steps below using the MicroStrategy Tutorial project: 1. Refer to the tech note below for more information: KB32502 - Support for transformation metrics for Dynamic Sourcing in MicroStrategy OLAP ServicesIn MicroStrategy Web click Create -> Add External Data -> File from disk; Select the Excel file saved in Documents; Prepare data (Note: Change the data type of “AttributeID” to text) Right click the first attribute "AttributeID" and select "Map to Project Attribute" Search for “AttributeID” in the search bar and hit enter. 4. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. 2. 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. 3. Workaround 2: Create a non-Kerberos authenticated database login. The dataset is a set of data that can be displayed on the document. 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. 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. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. First, you open a blank document and select a report to use as the document's dataset. Right-click an application and choose Properties. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. It's basically just a report, and can even start it's life off as a report. 1 clicking on the Intelligent Cube does not publish the cube but instead creates an analysis from the cube. These privileges are part of OLAP Services. A report accessing the Intelligent Cube includes only Year on the report. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. Add the report as the dataset for the Dashboard by. Execute. Ensure that the email addresses can be displayed properly. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. Report: The results of a report are used to populate the Intelligent Cube. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. Click an MDX cube source. A document is used to format data from multiple datasets in a single display of presentation quality. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. 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. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. Here, we use MicroStrategy Tutorial objects to create a report: Add Category, Brand, and. At least one MDX cube must be imported into your MicroStrategy project. With OLAP Services features, your report designers can create Intelligent Cube reports. 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. You can also modify the properties of. 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. This knowledge base article describe steps to re-point an existing report which is based on Cube A previously to another Cube B. Common Privileges. Browse to and select a previously saved Intelligent Cube on which to build your report. Create Schema Objects. x. Upload Dashboard. 1. The differences between the options. Under Cube Update, click Cube Update. This property can only be enabled through Workstation. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. STEPS TO REPRODUCE: 1) Add external dataset. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;Job ID for the action on the Intelligent Cube. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. All Intelligent Cube operations are listed below: 1. Right-click the cube, and select Schedule. 3. Choose File > New > Intelligent Cube. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. This data is stored as Intelligent Cubes. Click OK to save the Intelligent Cube and return to the Report Editor. x-10. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. The Create Group dialog box opens. If you select Cube B, any dashboards or reports linked to Cube A before the merge may not function correctly. Select the data set and click Prepare Data. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). 4. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. Click “All Objects View”. This Python 3 / MicroStrategy 10. 4 the connection mapping of the u…Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. From the File menu, select Create Test. In your Datasets panel, hover over the name of your dataset. x. The Intelligent Cube Editor uses the new Modeling service infrastructure. Remove the prompt from the Base Report and save it as Intelligent Cube. 4. The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. Create a report with the year and quarter attributes and the profit metric. 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. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. You need the. 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. Run the Report and check the SQL View. Browse to an Intelligent Cube, select it, and then click OK. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. Integrity Manager can test the SQL of Intelligent Cubes even if they. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". after executing the Login task), and type the GUID of the. All articles. As shown in the screenshot above, only one cube cache can be loaded in RAM. The steps below show you how to create an Intelligent Cube based on an MDX cube. Designing and creating documents: An overview. 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). HIDDEN: if the intelligent cube is hidden or not, returned as a boolean value. Create Schema Objects. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. To view an existing cube, you must have the following minimal privileges: Use analytics. 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. Select an existing schedule or create a custom one. Setting Up Documents and HTML Documents: This chapter explains the setup required for the Intelligence Server to create and execute HTML documents and documents. 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. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Add Project objects from the All Objects panel. Right-click the report and select Edit. Right-click the cube, and select Schedule Data Refresh. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. Check it in the cube monitor and we can see its column Database Connection is not empty. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 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. Login as MSTR, create an intelligent cube with attribute ‘Year’ and metric ‘Average Revenue’, and publish it as ‘Cube_Tutorial’. x-10. For the example scenario, create a report with Year, Region, and Profit Margin on the report. To schedule an Intelligent Cube to be updated. It retrieves report results from a schema source and stores it in memory. Insert one panel stack and add dynamic text with Profit Margin. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. Type a name for the derived element, and click OK. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. In the Object name field, type a descriptive name for the Intelligent Cube. Republish the. Right-click on the cube and choose Edit. Select data population for Intelligent Cubes. Number of Views 1. MicroStrategy Web and Mobile deployed in a JSP server like Tomcat. 4. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. 9K KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. 4. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. 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. This can be seen in the screenshot below. Steps to Reproduce. 3. Create a Data Import Live Intelligent Cube. In the Refresh Policy column, choose. STEPS TO REPRODUCE Use Data Import to bring in an Excel file containing a few columns (i. For more details on enabling the setting, refer to Change Data Engine Version. 4. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. It is especially useful when data. This will create the Intelligent Cube directories. The Subscription Editor opens. The predefined MicroStrategy Web Analyst group is assigned the set of Web Analyst privileges by default. Export to MicroStrategy File. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. From the Data menu, select Configure Intelligent Cube. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. details. Modify the list of Report objects (use object browser). When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. 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. Number of Views 2. Login Web with Administrator, Create a VI Dashboard based on this cube. In MicroStrategy Web 9. Create a new File Log and name it “CSI” (or any other name). Integrity Manager can test the SQL of Intelligent Cubes even if they. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Create a report off the Cube with Category, and Region attributes and Revenue metric on. You can also create Intelligent Cubes by directly querying your data. KB228850: How to migrate published intelligent cubes to a different environment in MicroStrategy Intelligence Server 9. To Create a Report from Scratch. A couple of workarounds are available in the current document. You can also select an existing template on which to build your new report. 2. 5. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. 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. In the Refresh Policy column, choose. Now, templates for existing Intelligent Cubes must be created and placed into the report templates folder in order to allow Intelligent Cube Report Designer to select the Intelligent Cube on which they would like to build a report. 1… Number of Views 9. The Full Refresh option is the default. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. 3. 4. Follow the steps below to reproduce the issue in Tutorial project in MicroStrategy 9. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. In the Object name field, type a descriptive name for the Intelligent Cube. IS_PROJ_ID. Load an updated CSV file into a DataFrame providing full path. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. Create a standalone Derived metric DM : Create a new Intelligent Cube C01: Add the Quarter, Country, and Region attributes. From the Data menu, select Add Dataset. Navigate to the Engine Component with CSI Dispatcher. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. Faster performance than directly querying warehouse. x, users will notice that this is not possible due to the mouse. Publish the cube. To view an existing cube, you must have the following minimal privileges: Use analytics. Right-click the cube, and select Schedule. On the Home screen, select My Subscription. By default SuperCube. Select Empty. Include “Qualification Prompt”. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. Create an MDX Cube ReportThe option to point a grid to an Intelligent Cube appears disabled, while other options such as "Convert Grid to Intelligent Cube" appear available. ) 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. 7. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. To review and create recommended Intelligent Cubes using Cube Advisor. Create a new Dossier. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL. The Save Intelligent Cube As dialog box opens. Select the. In Project B, create and run a new Intelligent Cube. 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. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public ObjectsReportsSequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a. 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. 11. Click Intelligent Cube Report. Memory mapped files (MMF) can be used for effective RAM utilization. This article describes the Intelligent Cube Population options available in MicroStrategy. How to Import Data from a SAP HANA Database Into MicroStrategy Web. 2. Right-click an Intelligent Cube and select Delete. Right-click the dataset, and choose Schedule. The Intelligent Cube Monitor is displayed. It does not tell us anything helpful and we should not use it as a point of reference. In the left panel, click Cubes. 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. Drill within Intelligent Cube:. Create a cube report based on the cube. 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. Run the report, notice that the filter does not work, all. 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. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. 0. Open the. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. Create an Intelligent cube and add subscriptions for all 500 users to publish the cube. The Intelligent Cube Options dialog box opens. 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. 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. GUID: is the GUID of the intelligent cube, returned as a string. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. microstrategy. We match smart people to dynamic projects and technologies that truly. To create an MDX cube report in MicroStrategy Web, you need to have Web Professional privileges, including the Web Define MDX Cube Report. Create Schema Objects. The Select Intelligent Cube dialog box opens. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. 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. Publish the cube. 4. 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. Log into the server and go to the Intelligent Cube monitor (Administration > System Monitors > Caches > Intelligent Cubes). Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. Intelligent Cubes. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. 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. This Python 3 / MicroStrategy 10. 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 Web browse to the Cube location and click on the cube . Navigate to the Intelligent Cube you want to refresh. 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. However, importing data from a Google Drive Spreadsheet requires some additional setup. This VLDB property has the following options:. To learn more about Intelligent Cube Data Partition, please refer to KB237803. In MicroStrategy 9. From the cube monitor, we could see the. Create a new variable and assign SuperCube with two parameters inside – connection and id. The Subscribe to Cube /Cache Update dialog box opens. Full Refresh. Con: The copy of report data in Intelligence Server memory only applies to a single report. The Dashboard can be executed successfully. Drag and drop the objects into the report grid from the Report Objects pane. From the. Right-click the Intelligent Cube, and select Define Incremental Refresh. Documentation on the REST API is at developer. You must belong to the System Administrators group to use this feature. For steps to create an Intelligent Cube based on an MDX cube, see Creating Intelligent Cubes based on MDX cubes.