Add External Data. KB39447: How to Trigger an Event Using the MicroStrategy Web SDK 9. 3. 1. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. Open MicroStrategy Web. PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public Objects\Reports\Sequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a script that also requests the Command Manager console to be open through the command prompt. The Intelligent Cube opens in the Report Editor. For steps to create an Intelligent Cube based on an MDX cube, see Creating Intelligent Cubes based on MDX cubes. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. For prior releases, either a cube was loaded, residing completely in RAM, or unloaded. Easily add or change pre- and post- SQL statements. 4. Create a report based on the Intelligent Cube. From the cube monitor, we could see the. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. 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)". STEPS TO REPRODUCE. We can create a report and point the report to a cube or right click. Designing and creating documents: An overview. However, importing data from a Google Drive Spreadsheet requires some additional setup. 2. 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. The following steps can be used to reproduce the issue in the MicroStrategy Tutorial project: 1. From the Report Selection panel, go to the File menu > Open. Visit the data visualization and data dashboard galleries for inspiration. More than one cube can be used in a single dashboard. Create. This can improve the performance of. Create 500 users, 500 database logins, and 500 database connections mapping to the same data warehouse. 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. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. From the Data menu, select Add Dataset. To view an existing cube, you must have the following minimal privileges: Use analytics. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Select the. Other metadata database platforms:Login Developer with Administrator, create a cube and publish it. This permission is checked at design time, and when executing reports against an Intelligent Cube. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT * Web publish Intelligent Cube: publish an Intelligent Cube to Intelligence Server: WEBEXECUTECUBEREPORT * Web save derived elements: save stand-alone derived elements, separate from the report: WEBSAVEDERIVEDMETRICS In MicroStrategy Web, log in to a project. 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 MDX cube. You need the Use Intelligent Cube. 4. Click Select. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. Select Empty. 86K KB31566: MicroStrategy 9. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 2) Choose "Database" and select the 3rd option to "Pick tables". From the Data menu, select Configure Intelligent Cube. This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. x - 10. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. x. Intelligent Cubes. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. x. This copy of report data is stored in Intelligence Server memory only. Both properties are located in the Query Optimizations folder in the VLDB property editor. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. Import MicroStrategy File. x. If you are upgrading to MicroStrategy 11. Click the “Add history list subscription” link near the bottom of the screen to open the. 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. and select the Project-Name. Go to the "All Objects View" option in the top left corner. Currently, project duplication does not involve Intelligent Cube File Directory. When an Intelligent Cube is published, the Intelligent. We use MicroStrategy Tutorial objects in the following steps. This provides ROLAP-type analysis without having to re-execute against the data warehouse. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. At least one MDX cube must be imported into your MicroStrategy project. Create 3 aggregate from base metrics as follows:In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. The dataset is a set of data that can be displayed on the document. No additional resources are needed to modify the Intelligent Cube or to create a new report. Steps to import a spreadsheet from Google Drive: MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. Run a dossier based on the cube. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. Click Create on any page, point to New Report, and select Blank Report. To schedule updates for the Intelligent Cube. If you select any Intelligent Cube reports, make sure that the Intelligent Cube the reports are based on has been published before you perform the integrity test. Open the. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. Execute ‘Report_Tutorial’ returns data as shown below: You can edit project-level cache and Intelligent Cube settings. x. Sharing data. Import MicroStrategy File. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. Select data population for Intelligent Cubes. 4. Web publish Intelligent Cube. In Desktop, create and publish an intelligent cube with one attribute and one metric. Click OK to save the Intelligent Cube and return to the Report Editor. Save the Cube with Connect Live Data Access Mode. microstrategy. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). In the left pane, click Intelligent Cubes. Start > All Programs > MicroStrategy Products > Integrity Manager. x releases, and the new Multi-table Data Import (MTDI) cubes. x Intelligent Cube status indication and workflowTo create an attribute form caching cube. 2. Create an Intelligent Cube, with Region, Category, Cost and Profit. Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. 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. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide . 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‘. These prerequisites include: Enable dynamic sourcing for the project and other aspects of the MicroStrategy system. Execute reports or documents that reference the object. Create an intelligent cube with Call Center, Quarter and the derived metric 3. To build an Intelligent Cube In Developer, from the File menu select New, and then Intelligent Cube. Make sure the service is properly configured and running before using the Intelligent Cube Editor. The file location in project configuration is . xThe following scenario describes how to create a distinct count subtotal from base report: 1 Create a report A with only “year” in row and ”category” in column; add customer in report object window only. Create an Intelligent cube with Month and Revenue. jar. 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. Expand Intelligent Cubes, and then select General. Users can create a Report Post SQL Statement within the Intelligent Cube that updates the value of a flag in the warehouse table. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". 2. In MicroStrategy Web, open the document in Design Mode or Editable Mode. Edit the cube from step 1 and add the Category attribute. Republish the. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). The user continues to use the report that accesses the Intelligent Cube. Open the. 2. In the Navigation pane, click Applications. Create a report services document or Visual Insight Analysis. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. Some uses for this data include: •. On the Home screen, select My Subscription. Browse to and select a previously saved Intelligent Cube on which to build your report. Click “All Objects View”. To Create an Intelligent Cube Using Freeform SQL or Query Builder. In the Refresh Policy column, choose one of the following options: To define an incremental refresh report. 4. Create Intelligent Cubes. The Incremental Refresh Options dialog box opens. 2 attributes and 1 metric). Use OLAP Services. 3. However, users can achieve this functionality by creating a cache update subscription to refresh Intelligent Cubes. To Create an Intelligent Cube Using Freeform SQL or Query Builder. Normalize Intelligent Cube data in MicroStrategy Intelligence Server . It retrieves report results from a schema source and stores it in memory. Follow the steps below to reproduce the issue in Tutorial project in MicroStrategy 9. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 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. They are. Choose File > New > Report. Create an attribute element prompt of Month, and use above filter in "Use a filter to reduce the number of elements", as below picture shown: 3. Right-click the cube, and select Schedule Data Refresh. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. 3 - Check the Make Intelligent. Data Population for Intelligent Cubes. To publish an Intelligent. To Schedule a Cube Refresh. In the Data Source column, select the checkboxes for the tables to update. g. Right mouse click on the cube and choose Schedule 3. Select the data set and click Prepare Data. 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 Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. Publish the Intelligent Cube by executing it on either of the nodes. If you just want to create the SuperCube and upload the row-level data but leave it unpublished, use SuperCube. Notice the attribute forms in the Report Objects pane. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. Select "Add External Data" and connect to an OLAP data source with the Live Connect option. Run report off cube. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. Browse to an Intelligent Cube, select it, and then click OK. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. Click All Objects View. Add a dataset. When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Configure a Cluster with a Centralized Cache. Click an MDX cube source. This determines the approach to existing data at refresh. All articles. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. 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. 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. The differences between the options. This must be done by the DBA and MicroStrategy Technical Support will not assist with this. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. 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. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. Save the Intelligent Cube. Republish the same cube, and a new cube instance is generated. Save the Report and close. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. 4. Some uses for this data include: •. A report accessing the Intelligent Cube includes only Year on the report. 4. g. You'll need to provide a name for your cube, as well as a name for the table that will contain the data. 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. From these results it can be determined that the Month attribute is not being used within any of the view Reports, Documents, Dossiers that reference this Intelligent Cube. Choose File > New > Intelligent Cube. x - 10. Add Project objects from the All Objects panel. Common Privileges. To Create a Report Using Both Report Objects from a MicroStrategy Project and MDX Cube Data. It does not tell us anything helpful and we should not use it as a point of reference. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". You must browse to the MDX cube to use to build the Intelligent Cube. If you select any Intelligent Cube reports, make sure that the Intelligent Cube the reports are based on has been published before you perform the integrity test. All necessary privileges are included in the Administrator role by default. The partition attribute is the attribute that is used to divide. 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. 11. Cube A must be selected here to maintain its attribute IDs after the merge. In the New Intelligent Cube dialog box, select the MDX Sources tab. By default, this is set to 32,000. Faster performance than directly querying warehouse. HIDDEN: if the intelligent cube is hidden or not, returned as a boolean value. Create a Visual Insight dashboard and add the above cube as the dataset: 3. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. This can be done by selecting Run Report in the toolbar. 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. You should see these cubes in the Intelligent Cube cache monitor in Developer. Open the cube report in Design View. Check in Developer that the stopped node is in Maintenance Mode. Under Refresh type, select one of the following options. All reports that access Intelligent Cubes allow you to drill within the data included in an Intelligent Cube. For background. In the Data Source column, select the checkboxes for the tables to update. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. x-10. 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. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. 1. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. For steps to use an existing template to. 3. Use the Objects section to search for the desired metrics and attributes. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. “Intelligent Cube (<Cube Name>) for locale. STEPS TO REPRODUCE. 2. In MicroStrategy Developer, log in to a project source with administrative privileges. MicroStrategy Developer 9. Multiple reports can access a single. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. 4. Add the report as the dataset for the Dashboard by. A set of data is returned from the. blogspot. Publish the cube. 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. Create Schema Objects. Click a catalog. 438832. Starting in MicroStrategy 10. Published: 4월 6, 2017. 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. x. In the Object name field, type a descriptive name for the Intelligent Cube. Right-click the dataset, and choose Schedule. 2. Select the environment and project where you want to save your. This VLDB property has the following options:. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. In the left panel, click Cubes. Steps To Reproduce 1. Open Command Manager and type the following commands to. Now, create an hierarchy prompt but before saving , save/overwrite them on top of “Qualification Prompt” that is being used in the Cube – ensure, the hierarchy objects exists within cube. For steps to use an existing template to. We match smart people to dynamic projects and technologies that truly. 3. Select a database configured for SAP HANA. Do not normalize Intelligent Cube data. Modify the list of Report objects (use object browser). This determines the approach to existing data at refresh. Modify the list of Report objects (use object browser). The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published 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. The Intelligent Cube Editor uses the new Modeling service infrastructure. Under Refresh type, select one of the following options. Right-click an Intelligent Cube and select Delete. 0. The default value is 256 megabytes. In the grid display of the report, right-click the attribute for which you want to create or modify derived elements, and click Derived Elements . 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. Open the. From the File menu, select New,. Prerequisites. e. The group is created as a derived element and displayed on the report. Under Cube Update, click Cube Update. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Log into ProjectA in MicroStrategy Web. Required Status to Perform Action. 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. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. You can also select an existing template on which to build your new report. (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. 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. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. In MicroStrategy Web 9. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. Normalize Intelligent Cube data in the. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. First, you open a blank document and select a report to use as the document's dataset. Select the refresh policy. For steps, see the Upgrade Guide. How to Import Data from a SAP HANA Database Into MicroStrategy Web. 1. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. It also. HyperIntelligence for Web was first. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube, and click OK. Add Project objects from the All Objects panel. This is because with this feature enabled, the element block ID will be saved to the new cube cache. Delete one of these two cube caches from the cache monitor in Developer. The Intelligent Cube Editor uses the new Modeling service infrastructure. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. 2. Setting Up Documents and HTML Documents: This chapter explains the setup required for the Intelligence Server to create and execute HTML documents and documents. This is the same requirement to create or run a static report in Workstation. “Intelligent Cube (<Cube Name>) for locale. Add Year Id and Quarter. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create. 1. The Schedule dialog box opens for your dataset, showing the tables in your dataset. The view filter cannot filter out other elements as shown below:Use Cube Advisor to create Intelligent Cubes: 1. In MicroStrategy 10. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. Republish the same cube, and a new cube instance is generated. Create Schema Objects. Create the metric levels log file used to. Type a name for the derived element, and click OK. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. All necessary privileges are included in the Administrator role by default. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. Right-click the dataset, and choose Schedule. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. 0. The Save Intelligent Cube As dialog box opens. Log in to the project in which you want to create a report. If you want to create an empty SuperCube, use SuperCube. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Browse to an Intelligent Cube, select it, and then click OK. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. Ensure that the email addresses can be displayed properly. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. Create a new report based on the published Intelligent Cubes that are supposed to be made available to your designers. Publish the cube. Drill within Intelligent Cube:. From the Categories list, expand Options, and then select Data Languages. In the Intelligent Cube cache monitor in Developer, notice that all cube caches for the project. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). Modify the list of Report objects (use object browser). 86K KB31566: MicroStrategy 9.