blogspot. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. and select the Project-Name. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Select an existing schedule or create a custom one. MicroStrategy Web is a browser-based client interface that enables IT to satisfy the diverse analytics needs of every enterprise user—consumers, analysts, data scientists, developers, and administrators—without the burden of distributing and maintaining multiple software packages. Create a Data Import Live Intelligent Cube. 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. 2. KB485159: Enable support for Security Filter with Top and Bottom Range Attributes in Data Import Intelligent cubes and Fix the security hole in Connect Live Data Import Intelligent cubes MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). 4. 6. Navigate to the Intelligent Cube for which you want to define the incremental refresh. Visit the data visualization and data dashboard galleries for inspiration. com Format: A MicroStrategy Online. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Prerequisites. Select the data sources to be refreshed. 4. The ability to view or edit certain settings is determined by a user's privileges. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. Check in Developer that the stopped node is in Maintenance Mode. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Right-click the dataset, and choose Schedule. 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. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. Update Cube Data *. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. Community & Support Search Discussions Open A Case View My CasesThis defect is addressed in MicroStrategy 11. /mstrctl -s IntelligenceServer. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. 2. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. Publish the cube. 4. Web Analyst. Permanent Table: When the queries for a report or Intelligent Cube are performed in parallel, any intermediate tables are created. Log in to the project in which you want to create a report. All articles. Launch MicroStrategy Cube Advisor from the Start menu > Programs > MicroStrategy > Tools > Cube Advisor. Open the report in Grid View, Design View, or Grid and Graph view. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. The default value is 256 megabytes. 38K. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. From the File menu, select Create Test. 2. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. Create an Intelligent cube and add subscriptions for all 500 users to publish the cube. Create Intelligent Cubes. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. In the Name field, type the name of the subscription. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. Create a new Intelligent Cube C01 using the "ORDER_FACT" table: Add External Data > Databases > Select Tables. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. Open the. 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. Save as an In-Memory dataset. Right-click your selection and select Group. In MicroStrategy Web, edit the Cube where users want to enable partitioning. CAUSE: This is working as designed. Create Schema Objects. The CREATE and INSERT support VLDB property defines whether MicroStrategy can perform CREATE and INSERT statements against the database for a database instance. Select other schedule options as required, and click OK. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Expand Intelligent Cubes, and then select General. The differences between the options. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. The Incremental Refresh Options dialog box opens. Cube Advisor opens. 1. com. 1Currently it is not possible to create a cube refresh subscription in Command Manager. 1. In your Datasets panel, hover over the name of your dataset. Select the data sources to be refreshed. 1 product only with documents using view filter qualifications. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. By default, there is a system hierarchy on the cube. Run the report, notice that the filter does not work, all. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. In the Grid/Graph, you can use MicroStrategy Web to create a threshold to change the formatting of the revenue amounts when the profit is greater than a specified amount. Browse to an Intelligent Cube, select it, and then click OK. It is especially useful when data. 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. Republish the. In the Data Source column, select the checkboxes for the tables to update. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. To learn more about Intelligent Cube Data Partition, please refer to KB237803. If the Intelligent Cube must be re-processed based on a metric. There is no need to further create a dashboard. In MicroStrategy Developer, locate the Intelligent Cube that needs to be refreshed. 2. Select a database configured for SAP HANA. Click Intelligent Cube Report. 4. 4. It also. This group also inherits all of the privileges assigned to the Web Reporter group. Right-click the report and select Edit. A report that runs against the Intelligent Cube. Introduction: Need to create a report with a metric that calculates the number of distinct customers. For example, you can choose to add or delete data from the Intelligent Cube. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. Insert one panel stack and add dynamic text with Profit Margin. It retrieves report results from a schema source and stores it in memory. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. 2. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. 9K KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Right mouse click on the cube and choose Schedule 3. The Subscribe to Cube /Cache Update dialog box opens. Create a metric that returns a transformation of last year's. Execute reports or documents that reference the object. To publish an Intelligent. The Report Editor opens. The Intelligent Cube Editor uses the new Modeling service infrastructure. 4. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. A possible cause of this issue is that the folder that stores the Intelligent Cube files on the node where the Intelligent Cube is published is not shared with the name 'ClusterCube' on the MicroStrategy Intelligence Server machine(s). Open the Workstation window. 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. Intelligent Cubes. MicroStrategy Web is a browser-based client interface that enables IT to satisfy the diverse analytics needs of every enterprise user—consumers, analysts, data scientists, developers, and administrators—without the burden of distributing and maintaining multiple software packages. Select the "ORDER_FACT" table. 3. This provides ROLAP-type analysis without having to re-execute against the data warehouse. Drag and drop the objects into the report grid from the Report Objects pane. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. This Python 3 / MicroStrategy 10. In MicroStrategy Web 9. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. 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. Setting Up Documents and HTML Documents: This chapter explains the setup required for the Intelligence Server to create and execute HTML documents and documents. Follow the steps below to reproduce the issue in Tutorial project in MicroStrategy 9. There is another reason that the intelligent cube is imported from a local file in the web server machine, and the Web server and the Intelligence Server do not need to be on the same machine. Steps to Reproduce. 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. By default, the report template used is the same as the Intelligent Cube's template. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. 11. 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. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent. Add the report as the dataset for the Dashboard by. This VLDB property has the following options:. This data is stored as Intelligent Cubes. How to Import Data from a SAP HANA Database Into MicroStrategy Web. Browse to and select a. 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. CSI after fix:The following steps explain how to share a MicroStrategy Intelligent Cube with users between different connections: In MicroStrategy Desktop, open Project Configuration window for a project, uncheck the option "Create Intelligent Cubes by database connection" under Intelligent Cubes > General, as shown below: Restart. Click Create on any page, point to New Report, and select Blank Report. Published: 4월 6, 2017. 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. 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. x-10. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. From the Data menu, select Add Dataset. Select the refresh policy. Execute. Browse to an Intelligent Cube, select it, and then click OK. Section 5: Load Intelligent Cube files into the Intelligence Server. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. You must browse to the MDX cube to use to build the Intelligent Cube. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). Intelligent Cubes. 3. 1 release. Trending Articles. Description What's New 2022 Releases Workstation. 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. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 1. Create a new File Log and name it “CSI” (or any other name). Although the default memory usage limit is 500%, sometimes it can be set as low as 50%. 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. 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 . For information on using Cube Advisor to support dynamic sourcing, see Using Cube Advisor to support dynamic sourcing. 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). Designing and creating documents: An overview. The Intelligent Cube Monitor is displayed. We should ignore the size of the Cube in the Cube Monitor when the Status is "A,F" (Active, Filed). You must belong to the System Administrators group to use this feature. Run the report in Grid View. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Log in to the project in which you want to create a report. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. To do so, you can take advantage of URL API. 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. Data Population for Intelligent Cubes. This privilege is part of OLAP Services. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Web modify the list of report objects (use object browser --all objects) Web Professional. Then click "Save". The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. 4. Report Post SQL Statement. 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. Open the. 4. Create a Visual Insight dashboard and add the above cube as the dataset: 3. 66K. In the Navigation pane, click , next to Datasets. 1 to see the results as shown. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. To schedule updates for the Intelligent Cube. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. Create Schema Objects. 4. 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. The Full Refresh option is the default. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT. Click OK. x, users will notice that this is not possible due to the mouse. By default, Intelligent Cubes created through Data Import are saved to the MicroStrategy user's "My Reports" folder. In Developer, log in to a project with a user account with administrative privileges. Create an Intelligent Cube with attributes Year, Month and Region; 4. 3. Click Select. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Designing and creating documents: An overview. Typically, a long duration is seen in the Data Transfer time which indicates the time it takes to fetch data from the warehouse. 4. 4. 10 or earlier, outer join to Lookup table in a dashboard/dossier report based on Intelligent Cube with joint element list filter will not work, and incorrect CSI will be generated when both attributes used in the filter are present in visualization. The Modeling service must be configured correctly to use this feature. Select "Add External Data" and connect to an OLAP data source with the Live Connect option. From the Data menu, select Configure Intelligent Cube. Defining the partition for Super Cubes. Share query results in-memory across multiple dossiers and. 2. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". This is a known issue classified as a defect with MicroStrategy Web 9. Select an Environment from the upper-left drop-down. 2. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Select Intelligent Cubes > General > Intelligent Cube File directory. At this time, only one table per cube is supported. Web Analyst. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Some uses for this data include: •. In MicroStrategy 2020 Update 2, the size of the Intelligent Cube keeps gradually increasing even after setting the Maximum % growth of Intelligent Cube to 50%. On the Home screen, select My Subscription. The Select Intelligent Cube dialog box opens. This property can only be enabled through Workstation. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Workaround 2: Create a non-Kerberos authenticated database login. You can also select an existing template (see How to Create a Report Based on an Existing Template ). All necessary privileges are included in the Administrator role by default. The Select Dataset dialog box opens. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. This is possible because when the Intelligent Cube refresh job finishes, a record is logged in the IS_REPORT_STATS table. This " How to" knowledge base article explains cube advisor. For the example scenario, log in to the MicroStrategy Tutorial project. 4. Create a cube report based on the cube. In the user interface, specify the partition attribute and the number of partition . On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. How to configure, monitor, and manage Intelligent Cubes. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. If you are upgrading to MicroStrategy 11. 2 in Web, navigate to the report in edit mode, right click “customer” and insert metric Count as shown below: 3. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". Use Intelligent Cube Editor. Click Databases . In MicroStrategy 9. Check in Developer that the stopped node is in Maintenance Mode. 0 MicroStrategy releases. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. In the left pane, click Intelligent Cubes. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. 3. 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. 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. Run the Report and check the SQL View. This is the same requirement to create or run a static report in Workstation. 38K. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user. Create a report services document or Visual Insight Analysis. In Project B, create and run a new Intelligent Cube. The Report Editor opens with all of the objects of the Intelligent Cube. The Intelligent Cube Monitor is displayed. 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. To Create a Report Using Both Report Objects from a MicroStrategy Project and MDX Cube Data. 4. To Create an Intelligent Cube Using Freeform SQL or Query Builder Using MicroStrategy Developer, log in to a project connected to an MDX cube source. 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. 1. In MicroStrategy Web, open the document in Design Mode or Editable Mode. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. 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. This issue has been classified as a defect by MicroStrategy. However, importing data from a Google Drive Spreadsheet requires some additional setup. Report: The results of a report are used to populate the Intelligent Cube. Click the MicroStrategy icon, and select Create Report. Create Cube A and a report based on it. This can be done by selecting Run Report in the toolbar. For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (article describes how to provide Intelligent Cube cache files to MicroStrategy for troubleshooting cases. Create a dossier and add subset R from Existing Dataset. Documentation on the REST API is at developer. Normalize Intelligent Cube data in the. In MicroStrategy Web 9. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. x as Administrator; create a simple Intelligent Cube called Q, and publish it. g. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. Assuming that ProjectA and ProjectB are in the same metadata, create a Database Instance to connect to an OLAP data source. When an Intelligent Cube is published, the Intelligent. The Intelligent Cube opens in the Report Editor. Importing MDX cubes is often handled by a MicroStrategy architect. 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. Open the. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. You can use a report or Intelligent Cube. Click All Objects View. Create a new report based on the published Intelligent Cubes that are supposed to be made available to your designers. We use MicroStrategy Tutorial objects in the following steps. The following steps can be used to reproduce the issue in the MicroStrategy Tutorial project: 1. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. In the web cube editor for a data-import cube, pick a table and choose "Define Relationships" from the table drop-down menu to modify the relations, e. Set the path for the cube cache file directory to . The Create Group dialog box opens. 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. Save the Report and close. Navigate to the Intelligent Cube you want to refresh. The steps below show you how to create an Intelligent Cube based on an MDX cube. Search for prompt answer in report based on Intelligent Cube returns no results on selected ID form in MicroStrategy Web 9. 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. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. The report opens with all of the objects of the Intelligent. Node 1. Delete one of these two cube caches from the cache monitor in Developer. Create. This is the same requirement to create or run a static report in Workstation. Create a New Dossier. x, create a simple Intelligent Cube with attribute Category and metric Revenue. You can also select an existing template on which to build your new report. 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. 2. 2. Integer ID of the project where the Intelligent Cube is stored. after executing the Login task), and type the GUID of the. In MicroStrategy 10. PublishCube". Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. The New Grid dialog box opens. x: Create a new Intelligent Cube with Attributes Category, Subcategory and Metric Revenue. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Click All Objects View. The Save Intelligent Cube As dialog box opens. This will create the Intelligent Cube directories. Delete the cube cache from cube monitor. Insert one panel stack and add dynamic text with Profit Margin. Before MicroStrategy 10. Drill within Intelligent Cube:. x. The Schedule dialog box opens for your dataset, showing the tables in your dataset. 1. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports.