Login MicroStrategy Developer 10. x. A page with report creation options is displayed. Select other schedule options as required, and click OK. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. Starting in MicroStrategy 10. e. 8. Click the MicroStrategy icon, and select Create Report. g. Use the drop-down under the filter summary section to switch the server nodes. Select the data sources to be refreshed. This can be seen in the screenshot below. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. Create a new Dossier. 3. MicroStrategy Web also uses the history list from Intelligence Server. This VLDB property has the following options:. Check the status of the cubes in Developer. Number of Views 1. Run the report, notice that the filter does not work, all. Intelligent Cubes. To view an existing cube, you must have the following minimal privileges: Use analytics. 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. Browse to and select a. The Intelligent Cube Options dialog box opens. To make the Intelligent Cube available for creating reports, publish the Intelligent Cube by choosing Run Report in the toolbar. Right-click the Intelligent Cube, select "Schedule Delivery To" and choose "Refresh Cube". Creating Intelligent Cubes is as easy as creating reports. Documentation on the REST API is at developer. 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. 4 the connection mapping of the u… Number of Views 1. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal Intelligent. This is the same requirement to create or run a static report in Workstation. Some uses for this data include: •. The cube now has Year and Category on it. 3. It's basically just a report, and can even start it's life off as a 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. Check in Developer that the stopped node is in Maintenance Mode. 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. CAUSE: This is working as designed. 1. Users can create a Report Post SQL Statement within the Intelligent Cube that updates the value of a flag in the warehouse table. The month ID for 2004 Jan is like 200401. The Intelligent Cube Options dialog box opens. Navigate to the Intelligent Cube you want to refresh. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Supports derived metric creation. “Intelligent Cube (<Cube Name>) for locale. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. Open MicroStrategy Developer. Answer: When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. The search directly uses the attribute form from the attribute definition, instead of form from the intelligent cube. Section 5: Load Intelligent Cube files into the Intelligence Server. If you've already got a report that you want to create an Intelligent Cube out of, you simply go to. Intelligent Cubes. 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. Intelligent Cube IC2 contains attributes 'Country' and 'Region' Create a report services document with the above 2 Intelligent Cubes as datasets. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 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. Right-click an Intelligent Cube and select Delete. STEPS TO REPRODUCE 1. ACTION:The procedure below provides steps to create a subscription to schedule the publication of an Intelligent Cube. 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). 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 Schema Objects. The Intelligent Cube Monitor is displayed. At least one MDX cube must be imported into your MicroStrategy project. It involves only fetching a portion of the data that the user wants, instead of storing all data in-memory as a normal Intelligent Cube. Execute reports or documents that reference the object. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. Create a report based off the cube in Step 1 that includes the description form for Category. Documentation on the REST API is at developer. com Format: A MicroStrategy Online. 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. The Subscription Editor opens. To subscribe a report or document to a cube refresh. Configure and start the Intelligence Server using the metadata backup. All necessary privileges are included in the Administrator role by default. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. Workaround 2: Create a non-Kerberos authenticated database login. To view an existing cube, you must have the following minimal privileges: Use analytics. In Desktop, create and publish an intelligent cube with one attribute and one metric. Both types of subscriptions when targeting intelligent cubes will submit the same SQL statements to the database. Go to MicroStrategy Web 10. Click OK. Choose Databases. A report that runs against the Intelligent Cube. 3. This article describes how to update information in an Intelligent Cube without having to do a full republishUsing Web, create an Intelligent Cube with Add External Data> Databases > Select Tables option and add 1 table Order_Detail using a "Live" connection. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. 4. First, you open a blank document and select a report to use as the document's dataset. This group also inherits all of the privileges assigned to the Web Reporter group. At least one MDX cube must be imported into your MicroStrategy project. Integrity Manager can test the SQL of Intelligent Cubes even if they. 38K. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). It also. STEPS TO REPRODUCE Use Data Import to bring in an Excel file containing a few columns (i. Call this 'Base Report'. In MicroStrategy Web, click "Access External Data"; In the "Connect to Your Data" window, click the "Manage Your Datasets" link in left-bottom corner, as shown below: In Data Storage window, right mouse click the cube and choose "Schedule", a sub context menu displays all the existing schedule. 2. CAUSE: The report on which the action is being performed is a "Standard" report, only OLAP reports can be pointed to Intelligent Cubes. MicroStrategy Developer 9. Add a dataset. Add Year Id and Quarter. HyperIntelligence for Web was first. 86K KB31566: MicroStrategy 9. 1 clicking on the Intelligent Cube does not publish the cube but instead creates an analysis from the cube. You can use a report or Intelligent Cube. Run the Report and check the SQL View. Right-click the cube, and select Schedule. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. 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. Expand Intelligent Cubes, and then select General. It is very simple to create an intelligent cube, it is same like. 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. Integer ID of the Intelligent Cube report that was published, if any. 1, Data Import allows users to maintain intelligent cubes from external Excel files. x - 10. Click Create on any page, point to New Report, and select Blank Report. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Watch the Product team review how to configure and manage advanced properties of Intelligent Cubes. The CREATE and INSERT support VLDB property defines whether MicroStrategy can perform CREATE and INSERT statements against the database for a database instance. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. Import MicroStrategy File. The ability to view or edit certain settings is determined by a user's privileges. Add Project objects from the All Objects panel. Other metadata database platforms:Login Developer with Administrator, create a cube and publish it. Create a report with the year and quarter attributes and the profit metric. x-10. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. Related Topics. Hover the schedule need to be modified,. From the File menu, select Create Test. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. See Importing MDX cubes in the MDX Cube Reporting Help for more information. The Incremental Refresh Options dialog box opens. 7. To do so, you can take advantage of URL API. Republish the same cube, and a new cube instance is generated. The Subscribe to Cube /Cache Update dialog box opens. The New Grid dialog box opens. For example, an Intelligent Cube includes Year and Quarter. Open the. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. 4. All Intelligent Cube operations are listed below: 1. We use MicroStrategy Tutorial objects in the following steps. 2. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. (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. 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. 2. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. 0 MicroStrategy releases. This procedure assumes that the Linux machines are called UNIX1 and UNIX2. 1. Remove the prompt from the Base Report and save it as Intelligent Cube. STEPS TO REPRODUCE. Personal Intelligent Cubes are linked to a single report: Pro: The report can use OLAP Services to analyze report data and is always updated with the latest version of the personal Intelligent Cube. We should ignore the size of the Cube in the Cube Monitor when the Status is "A,F" (Active, Filed). First, you open a blank document and select a report to use as the document's dataset. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Republish the. Description MicroStrategy 10 introduced a new option on the Intelligent Cube called Data Partition. It retrieves report results from a schema source and stores it in memory. 9K KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Add a grid with the attribute Customer. In MicroStrategy Developer, log in to a project source with administrative privileges. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. 3. Number of Views 1. Open the cube report in Design View. Select the Intelligent Cubes tab. Number of Views 2. PRIME stands for Parallel Relational In-Memory Engine, and it engulfs two types of in-memory cubes: OLAP cubes, or the traditional Intelligent Cubes that have existed since 9. Select Build a Query and click Next. Create. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. Create and publish Intelligent cube called “Cube2” on node B. In MicroStrategy 11. For steps to create a view filter in MicroStrategy Web, see the MicroStrategy Web Help. Web publish Intelligent Cube. Currently, project duplication does not involve Intelligent Cube File Directory. 3. 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. To Create a Report Using Both Report Objects from a MicroStrategy Project and MDX Cube Data. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. x - 9. Publish the cube. Start > All Programs > MicroStrategy Products > Integrity Manager. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Navigate to the Intelligent Cube for which you want to define the incremental refresh. details. The Dashboard can be executed successfully. When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Right-click the cube, and select Schedule. 2. Choose File > New > Intelligent Cube. This privilege is part of OLAP Services. 4 using an Excel file and the Connection mapping database connections of the user account which published the cube are listed when checking the Intelligent Cube monitor in Developer. To do so, you can take advantage of URL API. 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. To define an incremental refresh report. x checks for 'Execute' access to the managed column object being used in the metric when adding it to the report, which is not required for regular non-mnanaged metrics. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. 4. Run report off cube. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. To schedule updates for the Intelligent Cube. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. . You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. Select the data set and click Prepare Data. Right-click the cube, and select Schedule Data Refresh. A report accessing the Intelligent Cube includes only Year on the report. The Schedule dialog box opens for your dataset, showing the tables in your dataset. The Schedule dialog box opens for your dataset, showing the tables in your dataset. x, users will notice that this is not possible due to the mouse. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. For steps to create an Intelligent Cube based on an MDX cube, see Creating Intelligent Cubes based on MDX cubes. 2 attributes and 1 metric). The Intelligent Cube Monitor is displayed. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. This can be done by selecting Run Report in the toolbar. 2. Publish. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. From the Data menu, select Configure Intelligent Cube. Navigate to the folder location of the Intelligent Cube. Intelligent cube is an OLAP feature introduced in Microstrategy 9 version. This property can only be enabled through Workstation. This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. In MicroStrategy Web 10, during Data Import, users are able to choose "Connect Live" data sources, which is also known as "Direct Data Access" function, as shown below:. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide . Create a metric that returns a transformation of last year's. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Kickstart Your Career Get. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. From the Data menu, select Configure Intelligent Cube. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. The default value is 256 megabytes. Restoring cube files. 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. Common Privileges. For the Intelligent Cube that you want to refresh, click the subscription icon. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. Right-click an Intelligent Cube and select Delete. Open the Workstation window. Common Privileges. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Quickly integrating data into MicroStrategy as part of a proof-of-concept. With OLAP Services features, your report designers can create Intelligent Cube reports. 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. The Save Intelligent Cube As dialog box opens. From the cube monitor, we could see the old cube is it. 2) Choose "Database" and select the 3rd option to "Pick tables". Create an Intelligent Cube with attribute Region and metrics, Revenue and Revenue Forecast; Create a subset report based on the above Intelligent Cube; Insert a derived metric DM = Revenue Forecast/Revenue as seen below: Execute the report either in MicroStrategy Desktop 9. The Intelligent Cube opens in the Report Editor. Create a New Dossier. When triggering the concurrent subscriptions to publish a cube with different database connections, some of them do not publish. The Intelligent Cube Options dialog box opens. Choose File > New > Report. Importing MDX cubes is often handled by a MicroStrategy architect. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Data access security is maintained. 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. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. A document that uses the Intelligent Cube as a dataset. Delete the cube cache from cube monitor. Login as MSTR, create an intelligent cube with attribute ‘Year’ and metric ‘Average Revenue’, and publish it as ‘Cube_Tutorial’. 2. Set the path for the cube cache file directory to . Add Project objects from the All Objects panel. The report retrieves data from Cube B now. To create an Intelligent Cube based on an MDX cube Using MicroStrategy Developer, log in to a project connected to an MDX cube source. The Intelligent Cube opens in the Report Editor. Run a dossier based on the cube. You must browse to the MDX cube to use to build the Intelligent Cube. 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. When an Intelligent Cube is in this status, any reports based on this cube have. Purpose of the registry key. 2. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Common Privileges. These privileges are part of OLAP Services. Since Web distributes connections between Intelligence Servers. 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)". In the Data Source column, select the checkboxes for the tables to update. 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. In the Intelligent Cube cache monitor in Developer, notice that all cube caches for the project. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. Navigate to the folder location of the Intelligent Cube. Description What's New 2022 Releases Workstation. Login MicroStrategy Web as M20061, go to Add External Data -> Databases -> Select Tables, pick the following tables Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. If you select Cube B, any dashboards or reports linked to Cube A before the merge may not function correctly. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. 2. This provides ROLAP-type analysis without having to re-execute against the data warehouse. 0 MicroStrategy releases. The create_cube() function will return the datasetID and tableID, which can be used to update a dataset with new data. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. The Intelligent Cube opens in the Report Editor. 3. 4. Steps to Reproduce. Description. In the Object name field, type a descriptive name for the Intelligent Cube. In MicroStrategy Developer create an Intelligent Cube with any attributes and metrics. This will create the Intelligent Cube directories. Shut down Intelligent Server node A with command . In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. To Create an MDX Cube Report. The Intelligent Cube Editor uses the new Modeling service infrastructure. 4. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. Login to MicroStrategy Web, create a cube with the function of Data Import 2. Republish the Intelligent Cube or re-create a report cache, which will be shared with MicroStrategy Technical Support; Send the requested data to MicroStrategy Technical Support; Revert the metric definition back to the original one, or remove the randomized metric from the report (Intelligent Cube configuration is not relevant in MicroStrategy 8. 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‘. In MicroStrategy Developer, locate the Intelligent Cube that needs to be refreshed. Node 2. Web publish Intelligent Cube. PublishCube". x. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. HyperIntelligence for Web. A document is used to format data from multiple datasets in a single display of presentation quality. Right-click an application and choose Properties. Run a Command Manager script to delete the cube cache previously deleted in step 2. Create an Intelligent Cube, with Region, Category, Cost and Profit. Include “Qualification Prompt”. 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. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical Engine. In Web, create a new Dossier and click on New Data. Look for existing Intelligent Cubes: Before you create an Intelligent Cube, search through MicroStrategy to see whether a similar Intelligent Cube already exists that can serve the same purpose as the Intelligent Cube that you. If you just want to create the SuperCube and upload the row-level data but leave it unpublished, use SuperCube. x Intelligent Cube status indication and workflow To create an attribute form caching cube. Browse to an Intelligent Cube, select it, and then click OK. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. 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. The. x. The Modeling service must be configured correctly to use this feature. Check it in the cube monitor and we can see its column Database Connection is not empty. Easily add or change pre- and post- SQL statements. 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. 3. 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. 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. A list of data sources available in this project appear.