Modify the list of Report objects (use object browser). microstrategy. 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. To set refresh filters, or alternate data sources, select Show Advanced Options. Select the data sources to be refreshed. Login to MicroStrategy Web, create a cube with the function of Data Import 2. MicroStrategy Web and Mobile deployed in a JSP server like Tomcat. To Create a Report from Scratch. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. 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. Open the. Share query results in-memory across multiple dossiers and reports. create(auto_publish=False). In the Navigation pane, click Applications. Drill within Intelligent Cube:. Type a name for the derived element, and click OK. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. Create Schema Objects. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube, and click OK. This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. For steps to create an Intelligent Cube based on an MDX cube, see Creating Intelligent Cubes based on MDX cubes. CAUSE: The report on which the action is being performed is a "Standard" report, only OLAP reports can be pointed to Intelligent Cubes. Select the refresh policy. After the Intelligent Cube has finished republishing, the Cube. Designing and creating documents: An overview. 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 following procedure will make cube data accessible to view reports. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. First, you open a blank document and select a report to use as the document's dataset. Create an Intelligent Cube with attributes Year, Month and Region; 4. Call this 'Base Report'. The Subscribe to Cube /Cache Update dialog box opens. From the Data menu, select Add Dataset. Right-click an Intelligent Cube and select Delete. Navigate to the Engine Component with CSI Dispatcher. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. This is due to the fact that adding prompts to Intelligent Cubes is not supported. 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. How to build and manage Intelligent Cubes. Navigate to the Intelligent Cube for which you want to define the incremental refresh. 2. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. 4. Log in to the project in which you want to create a report. com. For the example scenario, log in to the MicroStrategy Tutorial project. From the Categories list, expand Options, and then select Data Languages. This can be done by selecting Run Report in the toolbar. For more details on enabling the setting. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. 4. All necessary privileges are included in the Administrator role by default. The month ID for 2004 Jan is like 200401. Execute View Report. 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). 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. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. 9K KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Log in to a project connected to an MDX cube source. Expand Intelligent Cubes, and then select General. 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. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). Select the data set and click Prepare Data. Multiple reports can access a single. Starting in MicroStrategy 10. Community & Support Search Discussions Open A Case View My CasesThis defect is addressed in MicroStrategy 11. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. The CREATE and INSERT support VLDB property defines whether MicroStrategy can perform CREATE and INSERT statements against the database for a database instance. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. Expand Intelligent Cubes, and then select General. Kickstart Your Career Get. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. Select the data sources to be refreshed. The "Refresh Cube. 3. Note that the cube has a neutral data language. 4. 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. Click OK to save the Intelligent Cube and return to the Report Editor. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. The Browse for Folder dialog box opens. How to build and manage Intelligent Cubes. /ClusterCube. 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. Select the refresh policy. This privilege is part of OLAP Services. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical Engine. Visit the data visualization and data dashboard galleries for inspiration. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". Right-click an application and choose Properties. 4. In the user interface, specify the partition attribute and the number of partition . 4. Create an Intelligent Cube, with Region, Category, Cost and Profit. They should have the “A, L, F” status (Active, Loaded, Filed). To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. 1. Republish the same cube, and a new cube instance is generated. . Modify the list of Report objects (use object browser). Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. This Python 3 / MicroStrategy 10. g. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. The Intelligent Cube Editor uses the new Modeling service infrastructure. Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. Save the Report and close. x. The Intelligent Cube Options dialog box opens. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. Upload Dashboard. The status of each Intelligent Cube is listed in the. Expand Intelligent Cubes, and then select General. This is the same requirement to create or run a static report in Workstation. 4. PublishCube". Easily add or change pre- and post- SQL statements. jar. 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. When an Intelligent Cube is published, the Intelligent. 4. Intelligent Cubes. The impact is limited to MicroStrategy Developer 9. You should see these cubes in the Intelligent Cube cache monitor in Developer. Open MicroStrategy Developer. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Visualizations in the dossier that use data from the cube display. Create Intelligent Cubes. 1. 38K. 2. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. The value of Composite Metrics displays with “--“ in Intelligent Cube based Report in MicroStrategy 9. 2. To create a card, ensure we are connected to an upgraded version of the metadata or upgrade your metadata to 2019 or above. 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. Create a new in-memory dataset with the create_dataset() function. 0 and earlier releases, Outer Join setting for Metrics does not work when there are more than 1 visualizations containing same attributes, metrics, filters but different metric outer join settings when using Live Intelligent Cube as dataset. In MicroStrategy Web, open the document in Design Mode or Editable Mode. This determines the approach to existing data at refresh. In MicroStrategy Developer, locate the Intelligent Cube that needs to be refreshed. To define an incremental refresh report. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Web create derived metrics and derived attributes: This privilege allows you to create new calculations based on other. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. This is a known issue classified as a defect with MicroStrategy Web 9. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. MicroStrategy transforms organizations into intelligent enterprises through data-driven innovation. GUID of the Intelligent Cube instance in memory. Cube Advisor opens. 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. The month ID for 2004 Jan is like 200401. Right-click the report and select Edit. Right mouse click on the cube and choose Schedule 3. 6 and below, this feature was only available when re-pointing an existing report from one OLAP cube to another OLAP cube or re-pointing the report from one MTDI cube to another OLAP cube. 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. 86K KB42486: Users are unable to align the report name / title when exporting a report to an Excel file in MicroStrategy Web 9…This article discusses an issue with DELETE incremental refresh reports invalidly preventing an intelligent cube from being used for dynamic sourcing in MicroStrategy 10. To add an existing report or Intelligent Cube as a dataset. Open the. This is the same requirement to create or run a static report in Workstation. This can be done by selecting Run Report in the toolbar. Intelligent Cubes. By default, this is set to 32,000. IS_CUBE_ACT_ID. The Full Refresh option is the default. For a MicroStrategy environment configured to use Database level security using MSTR connection mapping, Intelligent Cubes can still be utilized. A set of data is returned from the. Click Databases . 3. Click Close, then "Finish" on the "prepare data" view and save the cube. Choose File > New > Intelligent Cube. The following steps can be used to reproduce the issue in the MicroStrategy Tutorial project: 1. 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. Rather than returning data from the data warehouse for a. To Schedule a Cube Refresh. The Save Intelligent Cube As dialog box opens. From the Data menu, select Configure Intelligent Cube. Create a second report with the year and quarter attributes and the revenue metric. Right-click the dataset, and choose Schedule. Designing and creating documents: An overview. 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. 0. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. For example, an Intelligent Cube includes Year and Quarter. 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. 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 . ACTION:In the Navigation pane, click Monitors. In the Object name field, type a descriptive name for the Intelligent Cube. Stop the. 4. In order to set up an incremental refresh report, the user should first right click on the Intelligent Cube and select "Define Incremental Refresh Report":After each unload/reload, and running the Dossiers against the cube, the duplicate Element Block files will be dumped into the same *****_objects folder. Web Analyst. A report that runs against the Intelligent Cube. Open the. In the Navigation pane, click , next to Datasets. The Create Group dialog box opens. For Oracle 12. Integrity Manager can test the SQL of Intelligent Cubes even if they. Sharing data. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. CAUSE: Starting in MicroStrategy 9. Click Create and choose Add External Data. Node 1. To view an existing cube, you must have the following minimal privileges: Use analytics. The partition attribute is the attribute that is used to divide. To unpublish an Intelligent Cube. 4. 1. See Importing MDX cubes in the MDX Cube Reporting Help for more information. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Create a new dossier: Create a new metric M01=Case: Create a new metric. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. From the System Manager home page, you can access the template workflows in the Templates section. In MicroStrategy 10. Check the status of the cubes in Developer. Some uses for this data include: •. Complete the "sessionState" field (e. 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. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. To set refresh filters, or alternate data sources, select Show Advanced Options. x. Section 5: Load Intelligent Cube files into the Intelligence Server. To Schedule a Cube Refresh. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. 2. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. To learn more about Intelligent Cube Data Partition, please refer to KB237803. Publish the cube. 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. Create an Intelligent cube with Month and Revenue. IS_CUBE_INST_ID. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. STEPS TO REPRODUCE. 2. 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. Execute reports or documents that reference the object. The report retrieves data from Cube B now. Expand Intelligent Cubes, and then select General. Browse to and select a previously saved Intelligent Cube on which to build your report. e. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. This can be seen in the screenshot below. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 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. 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. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. Defining the partition for Super Cubes. Run a dossier based on the cube. The Incremental Refresh Options dialog box opens. In the Name field, type the name of the subscription. The Modeling service must be configured correctly to use this feature. From the File menu, select Create Test. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. This determines the approach to existing data at refresh. The dataset is a set of data that can be displayed on the document. Publish the Intelligent Cube by executing it on either of the nodes. Web modify the list of report objects (use object browser --all objects) Web Professional. The predefined MicroStrategy Web Analyst group is assigned the set of Web Analyst privileges by default. 1, Data Import allows users to maintain intelligent cubes from external Excel files. 2 attributes and 1 metric). Select the refresh policy. The ability to view or edit certain settings is determined by a user's privileges. The steps below show you how to create an Intelligent Cube based on an MDX cube. The Schedule dialog box opens for your dataset, showing the tables in your dataset. x clustered environment may observe that after a period of time from the initial publishing of the cube and executing reports based off it, the size of the cubes as reported by the Intelligent Cube monitor in some cases is different in one node than the other node(s). Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. Run a Command Manager script to delete the cube cache previously deleted in step 2. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. Steps To Reproduce 1. 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. Click here to view details about the Intelligent Cube Monitor. The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. x. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT. In the Navigation pane, click , next to Datasets. Right-click the cube, and select Schedule. Create Schema Objects. Choose File > New > Intelligent Cube. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Web modify the list of report objects (use object browser --all objects) Web Professional. This property can only be enabled through Workstation. Open the. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. We can create a report and point the report to a cube or right click. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. Related Topics. Create a new File Log and name it “CSI” (or any other name). Navigate to and select the report or Intelligent Cube to use as the dataset, then click OK. Loading. x-10. 3. Save the Intelligent Cube. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. In the Data Source column, select the checkboxes for the tables to update. Creating Intelligent Cubes is as easy as creating reports. Use OLAP Services. GUID: is the GUID of the intelligent cube, returned as a string. A page with report creation options is displayed. Create a new variable and assign SuperCube with two parameters inside – connection and id. Number of Views 1. Hover the schedule need to be modified,. 2. ) 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. Go to MicroStrategy Web 10. When Drilling on a report created from an Intelligent Cube gives the Last Update Date of 1899 in MicroStrategy Web 9. Select the environment and project where you want to save your. Disconnect from the project source and restart both Intelligence servers. If you select Cube B, any dashboards or reports linked to Cube A before the merge may not function correctly. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. Log into the three-tier project source and choose the project that was analyzed in stage 2. Edit Project-Level Cache and Intelligent Cube Settings. Create an intelligent cube with Call Center, Quarter and the derived metric 3. 4. Create. By default SuperCube. Create Intelligent Cubes. 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 edit project-level cache and Intelligent Cube settings. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. Execute ‘Report_Tutorial’ returns data as shown below: You can edit project-level cache and Intelligent Cube settings. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. Other metadata database platforms:Login Developer with Administrator, create a cube and publish it. 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. Right-click the dataset, and choose Schedule. For example, you can choose to add or delete data from the Intelligent Cube. If. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. Add Project objects from the All Objects panel. Log into ProjectA in MicroStrategy Web. When an Intelligent Cube is in this status, any reports based on this cube have. 3. Create a Report 'R3' with 'Country' attribute. Answer: Intelligent Cubes can be created in microstrategy in public objects folder or in a particular user folder. All necessary privileges are included in the Administrator role by default. 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. Use OLAP Services. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. 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. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Select from the following localization options: Use project default data language (Default): Select this option to provide data only in the default language for the project. Choose Databases. If you just want to create the SuperCube and upload the row-level data but leave it unpublished, use SuperCube. Click Create on any page, point to New Report, and select Blank Report. 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. Add Project objects from the All Objects panel. Go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose Cube B. Workaround 2: Create a non-Kerberos authenticated database login. 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. 9 and 10. Choose File > New > Report.