Documentation on the REST API is at developer. Once the workflow is open in System Manager, you can select each process in the workflow to review the task that it performs for the workflow. Created cube with lastname and any other attribute. 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. To define an incremental refresh report. For intelligent cube imported from local file via Data Import, we do not support creating subscriptions as the path may change. Click OK. This is due to the fact that adding prompts to Intelligent Cubes is not supported. Web Analyst. To Create an Intelligent Cube Using Freeform SQL or Query Builder. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. Export to MicroStrategy File. This determines the approach to existing data at refresh. Navigate to the Intelligent Cube you want to refresh. An enhancement Request has been reported to the MicroStrategy Technology team. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. 1. In this case, the dataset is a MicroStrategy Intelligent Cube. In the Refresh Policy column, choose one of the following options: To define an incremental refresh report. 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. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. Start > All Programs > MicroStrategy Products > Integrity Manager. You must belong to the System Administrators group to use this feature. Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. 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. x. 1 and 10. 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. Follow the steps below to reproduce the issue in Tutorial project in MicroStrategy 9. 1. Use OLAP Services. Run the Report and check the SQL View. This permission is checked at design time, and when executing reports against an Intelligent Cube. 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. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. 7. Connection mapping can then be used to map the desired MicroStrategy users to this database login. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. In MicroStrategy 10. You must belong to the System Administrators group to use this feature. To view an existing cube, you must have the following minimal privileges: Use analytics. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. 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. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. Create. Drag and drop the objects into the report grid from the Report Objects pane. Currently, project duplication does not involve Intelligent Cube File Directory. 2. In the Navigation pane, click , next to Datasets. In the Name field, type the name of the subscription. Open MicroStrategy Developer. Expand Intelligent Cubes, and then select General. Use Intelligent Cube Editor. When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. The Subscribe to Cube /Cache Update dialog box opens. Check in Developer that the stopped node is in Maintenance Mode. To do so, you can take advantage of URL API. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 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). In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. Save the cube, and run it to publish. Execute ‘Report_Tutorial’ returns data as shown below: You can edit project-level cache and Intelligent Cube settings. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. If you want to create an empty SuperCube, use SuperCube. 66K. This Python 3 / MicroStrategy 10. The following steps can be used to reproduce the issue in the MicroStrategy Tutorial project: 1. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. 1, Data Import allows users to maintain intelligent cubes from external Excel files. . It's basically just a report, and can even start it's life off as a report. 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). This will create the Intelligent Cube directories. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. 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. Click an MDX cube source. Steps to reproduce. Browse to and select a previously saved Intelligent Cube on which to build your report. Create an Intelligent Cube, with Region, Category, Cost and Profit. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Delete one of these two cube caches from the cache monitor in Developer. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Click the MicroStrategy icon at the upper left of any page and select History List. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. Defining the partition for Super Cubes. Easily add or change pre- and post- SQL statements. 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, with Region, Category, Cost and Profit. This is the same requirement to create or run a static report in Workstation. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 2 release, the driver file is called odbc8. Right mouse click on the cube and choose Schedule 3. Quickly integrating data into MicroStrategy as part of a proof-of-concept. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Designing and creating documents: An overview. However, in MicroStrategy Web 10, this 'Link' property is no longer available for Intelligence cubes2. Execute. From the Data menu, select Configure Intelligent Cube. This is a known issue classified as a defect with MicroStrategy Web 9. 000007431. Both properties are located in the Query Optimizations folder in the VLDB property editor. • You need the Publish Intelligent Cube (Developer) and/or Web Publish Intelligent Cube (Web) privileges. Create Schema Objects. 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 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. Publish the cube. 3. 4 the connection mapping of the u… Number of Views 1. 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. Navigate to the Intelligent Cube for which you want to define the incremental refresh. 4 the connection mapping of the u… Number of Views 1. From the File menu, select Create Test. You should see these cubes in the Intelligent Cube cache monitor in Developer. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. At least one MDX cube must be imported into your MicroStrategy project. With OLAP Services features, your report designers can create Intelligent Cube reports. 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. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. 4. com Format: A MicroStrategy Online. Browse to and select a. Prerequisites for using Cube Advisor. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. This " How to" knowledge base article explains cube advisor. 9 and 10. This determines the approach to existing data at refresh. As shown in the screenshot above, only one cube cache can be loaded in RAM. Create an Intelligent Cube with "Customer", and add the attribute form "Email" into the cube. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. From the File menu, select Create Test. "In MicroStrategy 10. Click OK. This permission is checked at design time, and when executing reports against an Intelligent Cube. The partition attribute is the attribute that is used to divide. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. It retrieves report results from a schema source and stores it in memory. Add Project objects from the All Objects panel. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 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. See Importing MDX cubes in the MDX Cube Reporting Help for more information. Navigate to Administrator -> System monitor -> Cube monitor both nodes, and check all cube are “active, load, file” status. From the cube monitor, we could see the old cube is it. Open Command Manager and type the following commands to. Description. 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. 4. Right-click the cube, and select Schedule. Importing MDX cubes is often handled by a MicroStrategy architect. To Create a Report that Accesses an Intelligent Cube. To Create a Report from Scratch. Click Select. All articles. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;Job ID for the action on the Intelligent Cube. Intelligent Cubes. The group is created as a derived element and displayed on the report. 4. 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. Click the “Add history list subscription” link near the bottom of the screen to open the. This technical note describes a known issue when creating a data import cube in MicroStrategy Web 10. Open the. How to build and manage Intelligent Cubes. All necessary privileges are included in the Administrator role by default. DESC forms are in bold as they are displayed by default in the report, as shown below:In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 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. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). 4. 4. Republish 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. Login to MicroStrategy Web, create a cube with the function of Data Import 2. Go to the "All Objects View" option in the top left corner. x environments. In MicroStrategy Web browse to the Cube location and click on the cube . To Schedule a Cube Refresh. Publish the cube. In MicroStrategy 9. x. 3. Choose File > New > Intelligent Cube. Memory mapped files (MMF) can be used for effective RAM utilization. Save the Intelligent Cube. A list of data sources available in this project appear. x and create a new Dashboard. With OLAP Services features, your report designers can create Intelligent Cube reports. Create an intelligent cube with Call Center, Quarter and the derived metric 3. Right-click an application and choose Properties. Required Status to Perform Action. 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. (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. 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. For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. Starting in MicroStrategy 10. In MicroStrategy Developer, browse to an Intelligent Cube. From the Data menu, select Configure Intelligent Cube. To Create a Report Using Both Report Objects from a MicroStrategy Project and MDX Cube Data. Introduction: Need to create a report with a metric that calculates the number of distinct customers. Browse to an Intelligent Cube, select it, and then click OK. x. Delete the cube cache from cube monitor. Publish. The report retrieves data from Cube B now. The display of data is handled by the reports that access the Intelligent Cube. This property can only be enabled through Workstation. To Create an MDX Cube Report. The ability to view or edit certain settings is determined by a user's privileges. 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. The Schedule dialog box opens for your dataset, showing the tables in your dataset. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Add a grid with the attribute Customer. Intelligent cube is an OLAP feature introduced in Microstrategy 9 version. Export to MicroStrategy File. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. Shut down Intelligent Server node A with command . Click Create on any page, point to New Report, and select Blank Report. 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. To do so, you can take advantage of URL API. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. 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. Execute. 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. Later the user can poll for the change in the value of the flag. 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 9. The ability to view or edit certain settings is determined by a user's privileges. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. x - 10. Under Cube Update, click Cube Update. All reports that access Intelligent Cubes allow you to drill within the data included in an Intelligent Cube. The Intelligent Cube Options dialog box opens. Notice the attribute forms in the Report Objects pane. 1. Right-click the project and select Project Configuration. Node 1. 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. Select a database configured for SAP HANA. 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. 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. 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. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. Regular Intelligent Cubes created on Developer. To view an existing cube, you must have the following minimal privileges: Use analytics. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. 3. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). 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 name change is visible in MicroStrategy Workstation and MicroStrategy Web. The Browse for Folder dialog box opens. In MicroStrategy Developer, edit the Intelligent Cube where u sers want to enable partitioning. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. 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‘. A user with Use but not Execute permission for an Intelligent Cube can create and execute reports that use that Intelligent Cube, but cannot publish the Intelligent Cube. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. From the cube monitor, we could see the. 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. To solve this problem, we introduce a new registry key, " Respect. The ability to view or edit certain settings is determined by a user's privileges. 0 MicroStrategy releases. 4. Expand Intelligent Cubes, and then select General. Choose File > New > Report. Click Create on any folder page, point to New Report, and select MDX Cube Report. From the. Right-click an Intelligent Cube and select Delete. 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%. You need the. The Modeling service must be configured correctly to use this feature. Share query results in-memory across multiple dossiers and reports. In Developer, log into a project. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. 4. The New Intelligent Cube dialog box opens. Start > All Programs > MicroStrategy Products > Integrity Manager. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. Upload Dashboard. In MicroStrategy Web, open the document in Design Mode or Editable Mode. Log into the three-tier project source and choose the project that was analyzed in stage 2. Create 500 users, 500 database logins, and 500 database connections mapping to the same data warehouse. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. ICUBE_STATUS: shows the status of the intelligent cube, returned as a string value. This is the same requirement to create or run a static report in Workstation. 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. Add a dataset. From the File menu, select New, and then select Intelligent Cube. 2. Open the. Integer ID of the project where the Intelligent Cube is stored. 4. The New Grid dialog box opens. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. The old cube files don't have this property, so new IDs will be generated every. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. 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. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. For more details on enabling the setting. Select the Intelligent Cubes tab. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical Engine. Login MicroStrategy Developer 10. Complex metrics here refer to metrics which are defined using multiple. After the Intelligent Cube has finished republishing, the Cube reports will contain the updated. Create a report based on the Intelligent Cube. Log into the server and go to the Intelligent Cube monitor (Administration > System Monitors > Caches > Intelligent Cubes). We match smart people to dynamic projects and technologies that truly. For steps to use an existing template to. In Developer, log in to a project with a user account with administrative privileges. Right-click the cube, and select Schedule Data Refresh. This data is stored as Intelligent Cubes. In MicroStrategy Developer create an Intelligent Cube with any attributes and metrics. HyperIntelligence for Web. 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. MicroStrategy URL Structure The following table summarizes the root URL structure used for every request to MicroStrategy Web. Since Web distributes connections between Intelligence Servers. 4. Add a grid to the document with the objects 'Region' and. Here, we use MicroStrategy Tutorial objects to create a report: Add Category, Brand, and. This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. g. 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. 2. Publish the Intelligent Cube by executing it on either of the nodes. Select data population for Intelligent Cubes. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. The impact is limited to MicroStrategy Developer 9. To schedule updates for the Intelligent Cube. Restoring cube files. ACTION:In the Navigation pane, click Monitors. In your Datasets panel, hover over the name of your dataset. From the Categories list, expand Options, and then select Data Languages. 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. Follow the steps below using the MicroStrategy Tutorial project: 1. 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). Select a schedule from the Schedule drop-down list. Open the Workstation window. For steps, see the Upgrade Guide. Easily add or change pre- and post- SQL statements. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. It is especially useful when data. Make sure the service is properly configured and running before using the Intelligent Cube Editor. No additional resources are needed to modify the Intelligent Cube or to create a new report.