Modify the list of Report objects (use object browser). These prerequisites include: Enable dynamic sourcing for the project and other aspects of the MicroStrategy system. Check the status of the cubes in Developer. Architects can now create, edit, and publish Intelligent Cubes with the new editor in Workstation, streamlining overall creation workflows. In MicroStrategy Desktop 9. Right-click the cube, and select Schedule. 1 clicking on the Intelligent Cube does not publish the cube but instead creates an analysis from the cube. From the System Manager home page, you can access the template workflows in the Templates section. Open MicroStrategy Developer. 4. You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. This is a known issue classified as a defect with MicroStrategy Web 9. 3. Then click "Save". This is possible because when the Intelligent Cube refresh job finishes, a record is logged in the IS_REPORT_STATS table. In an Intelligent Cube report, only the "Data Population for Intelligent Cubes" will be visible; in standard reports, it will be "Data Population for Reports. 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. The Select Intelligent Cube dialog box opens. In MicroStrategy Developer create an Intelligent Cube with any attributes and metrics. Con: The copy of report data in Intelligence Server memory only applies to a single report. 5. Navigate to the Intelligent Cube you want to refresh. This data is stored as Intelligent Cubes. On the Home screen, select My Subscription. To review and create recommended Intelligent Cubes using Cube Advisor. The Intelligent Cube Editor uses the new Modeling service infrastructure. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. 3. KB30711: Security filter application to view reports based on Intelligent Cubes. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. For the Intelligent Cube that you want to refresh, click the subscription icon. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. 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. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Sharing data. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Easily add or change pre- and post- SQL statements. 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. Introduction: Need to create a report with a metric that calculates the number of distinct customers. 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. Create Cube A and a report based on it. 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. 2 attributes and 1 metric). MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. To publish an Intelligent. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. STEPS TO REPRODUCE. To create a report that connects to an Intelligent Cube, in MicroStrategy Developer. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user. GUID of the Intelligent Cube instance in memory. Both types of subscriptions when targeting intelligent cubes will submit the same SQL statements to the database. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide. Prerequisites for using Cube Advisor. Create the metric levels log file used to. STEPS TO REPRODUCE: 1. 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. From the cube monitor, we could see the. 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. 4. The Intelligent Cube Options dialog box opens. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Browse to and select a previously saved Intelligent Cube on which to build your report. Login MicroStrategy Developer, create User M20061 with security filter defined as: Month in {20061} Create Intelligent Cube C01 with: Attribute Quarter, Month, Country, Region and Metric Cost, Region, and publish the cube. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. This can be seen in the screenshot below. 4 the connection mapping of the u…Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. Importing MDX cubes is often handled by a MicroStrategy architect. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. Steps to reproduce. Select data population for Intelligent Cubes. If you want to create an empty SuperCube, use SuperCube. Select the refresh policy. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. RMC on attribute Warranty to Create Attribute named ‘IsWarranty’ with the formula of “IsWarranty: Case(([Warranty]@[DESC]="No"), 0, 1)” as shown below:To update the newly created Super Cube, create a new script starting from repeating steps 3-7. Right-click the project and select Project Configuration. Run report off cube. Since Web distributes connections between Intelligence Servers. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. 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. Description. Click OK. Create an attribute element prompt for the Year attribute. Click Create and choose Add External Data. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. g. When an Intelligent Cube is published, the Intelligent. Select the refresh policy. Total Cubes This section displays the total count of cubes by status. Web Analyst. After refreshing an Intelligent Cube that had columns added to it, the newly created attributes do not show up in the document's Dataset Objects pane in MicroStrategy Web 9. This technical note describes a known issue when creating a data import cube in MicroStrategy Web 10. 4. A set of data is returned from the. To unpublish an Intelligent Cube. Browse to an Intelligent Cube, select it, and then click OK. The search directly uses the attribute form from the attribute definition, instead of form from the intelligent cube. 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. Intelligent Cubes. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. To Create an Intelligent Cube Using Freeform SQL or Query Builder. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . Visit the data visualization and data dashboard galleries for inspiration. 1 product only with documents using view filter qualifications. Intelligent Cubes. 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 steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. Select data population for Intelligent Cubes. To schedule updates for the Intelligent Cube. This can be done by selecting Run Report in the toolbar. To Create a Report from Scratch. Click the MicroStrategy icon, and select Create Report. Create a user (tester) and disable the "web publish Intelligence Cube" privileges under Web Analyst. By default, there is a system hierarchy on the cube. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. 2 in Web, navigate to the report in edit mode, right click “customer” and insert metric Count as shown below: 3. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Save as an In-Memory dataset. Create a report services document or Visual Insight Analysis. 4. 119 Share Save 45K views 9 years ago MicroStrategy Advanced Topics by MicroRooster Source: MicroRooster. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. Create a Data Import Live Intelligent Cube. Description What's New 2022 Releases Workstation. The following procedure will make cube data accessible to view reports. Open the Workstation window. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. 2. Execute View Report. 2. 4. By default, the report template used is the same as the Intelligent Cube's template. All articles. 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. Create a report with the year and quarter attributes and the profit metric. 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). 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 property can only be enabled through Workstation. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. This can be done by selecting Run Report in the toolbar. Add a dataset. Go to MicroStrategy Web 10. Create Schema Objects. For steps to use an existing template to. In the left pane, click Intelligent Cubes. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. 3. This is because with this feature enabled, the element block ID will be saved to the new cube cache. In the Navigation pane, click , next to Datasets. Some uses for this data include: •. 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 Developer, log into a project. 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. 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. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. Use Intelligent Cube Editor. Number of Views 1. For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. If you are upgrading to MicroStrategy 11. 4. In the Data Source column, select the checkboxes for the tables to update. Drag and drop the objects into the report grid from the Report Objects pane. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. You can also create Intelligent Cubes by directly querying your data. Log into ProjectA in MicroStrategy Web. 66K. Right-click your selection and select Group. The Schedule dialog box opens for your dataset, showing the tables in your dataset. 2. "In MicroStrategy 10. In MicroStrategy OLAP Services, Transformation metrics used in standard reports can resolve against Intelligent Cubes only when the same Transformation metric exists in the Intelligent Cube. Workaround 2: Create a non-Kerberos authenticated database login. 1, Data Import allows users to maintain intelligent cubes from external Excel files. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. e. Publish the cube. An enhancement Request has been reported to the MicroStrategy Technology team. PublishCube". 4. In the Name field, type the name of the subscription. Create a new File Log and name it “CSI” (or any other name). If you just want to create the SuperCube and upload the row-level data but leave it unpublished, use SuperCube. From the Report Selection panel, go to the File menu > Open. They should have the “A, L, F” status (Active, Loaded, Filed). 3 - Check the Make Intelligent. jar. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. When you use the cube directly in the Dossier, the definition is applied to the cube directly and the MicroStrategy AE saves time since it doesn’t have to search and fetch an extra report definition. In MicroStrategy Developer, log in to a project source with administrative privileges. 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. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. The month ID for 2004 Jan is like 200401. Right-click your selection and select Group. The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. 3. STEPS TO REPRODUCE: 1. 2. Assuming that ProjectA and ProjectB are in the same metadata, create a Database Instance to connect to an OLAP data source. Select an Environment from the upper-left drop-down. 1. The Intelligent Cube Options dialog box opens. Community & Support Search Discussions Open A Case View My CasesSince the Intelligent Cube is based off a FFSQL report, the columns in the metrics being used are managed objects. e. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. Allow reports to drill outside the Intelligent Cube Select this option to enable drilling outside the Intelligent Cube to access the full set of data available in the data. This is the same requirement to create or run a static report in Workstation. 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. Integrity Manager can test the SQL of Intelligent Cubes even if they. Open the. Create Intelligent Cubes. Create a Report 'R3' with 'Country' attribute. In the Refresh Policy column, choose. Starting in MicroStrategy 10. 2. 2. Set the path for the cube cache file directory to . 38K. Create an Intelligent Cube with "Customer", and add the attribute form "Email" into the cube. To build an Intelligent Cube In Developer, from the File menu select New, and then Intelligent Cube. Click the “Add history list subscription” link near the bottom of the screen to open the. At this point, the Month attribute can be removed from the cube to reduce the publication time and size of the Intelligent Cube within memory. The group is created as a derived element and displayed on the report. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. In the Object name field, type a descriptive name for the Intelligent Cube. In MicroStrategy 10. Follow the steps below to reproduce the issue in Tutorial project in MicroStrategy 9. Browse to an Intelligent Cube, select it, and then click OK. 4. Run a Command Manager script to delete the cube cache previously deleted in step 2. In the New Intelligent Cube dialog box, select the MDX Sources tab. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Complex metrics here refer to metrics which are defined using multiple. Navigate to the Engine Component with CSI Dispatcher. The following steps can be used to reproduce the issue in the MicroStrategy Tutorial project: 1. Create a report based off the cube in Step 1 that includes the description form for Category. Create 500 users, 500 database logins, and 500 database connections mapping to the same data warehouse. For background. Create Schema Objects. Create. You'll need to provide a name for your cube, as well as a name for the table that will contain the data. x. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. Right-click on the cube and choose Edit. Permanent Table: When the queries for a report or Intelligent Cube are performed in parallel, any intermediate tables are created. 4. Both properties are located in the Query Optimizations folder in the VLDB property editor. To schedule updates for the Intelligent Cube. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. Check it in the cube monitor and we can see its column Database Connection is not empty. x. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. Open Command Manager and type the following commands to. 1… Number of Views 9. Create an Intelligent cube and add subscriptions for all 500 users to publish the cube. 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. Create a second report with the year and quarter attributes and the revenue metric. MicroStrategy Web also uses the history list from Intelligence Server. Select Build a Query and click Next. Right-click the report and select Edit. Run a dossier based on the cube. No additional resources are needed to modify the Intelligent Cube or to create a new 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. x. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. Creating Intelligent Cubes is as easy as creating reports. Select Empty. This issue has been classified as a defect by MicroStrategy. The display of data is handled by the reports that access the Intelligent Cube. By default, there is a system hierarchy on the cube. x - 10. With OLAP Services features, your report designers can create Intelligent Cube reports. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Run the report, notice that the filter does not work, all. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. Type a name for the derived element, and click OK. 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. If you've already got a report that you want to create an Intelligent Cube out of, you simply go to. At least one MDX cube must be imported into your MicroStrategy project. 4. Execute. CAUSE: The report on which the action is being performed is a "Standard" report, only OLAP reports can be pointed to Intelligent Cubes. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. STEPS TO REPRODUCE: 1. A page with report creation options is displayed. Upload Dashboard. A report that runs against the Intelligent Cube. From the File menu, select New,. 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. Prerequisites. 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. CAUSE: Starting in MicroStrategy 9. Create a new variable and assign SuperCube with two parameters inside – connection and id. This data is stored as Intelligent Cubes. Login Web with Administrator, Create a VI Dashboard based on this cube. Open the report in Grid View, Design View, or Grid and Graph view. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. Watch on. This Python 3 / MicroStrategy 10. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. Before MicroStrategy 10. For information on using Cube Advisor to support dynamic sourcing, see Using Cube Advisor to support dynamic sourcing. From the Data menu, select Configure Intelligent Cube. 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. In MicroStrategy Developer, browse to an Intelligent Cube. This permission is checked at design time, and when executing reports against an Intelligent Cube. 4. 4. The ability to view or edit certain settings is determined by a user's privileges. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. The. after executing the Login task), and type the GUID of the. To do so, you can take advantage of URL API. From the Data menu, select Configure Intelligent Cube. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. All necessary privileges are included in the Administrator role by default. x releases, and the new Multi-table Data Import (MTDI) cubes. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 2. It is very simple to create an intelligent cube, it is same like. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Shut down Intelligent Server node A with command . 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:. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. Web create derived metrics and derived attributes: This privilege allows you to create new calculations based on other. 4. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. x. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). 0, you have the option to use Data Import to create an in-memory dataset (sometimes referred to as an super cube) containing data from multiple tables. By default SuperCube. Navigate to the folder location of the Intelligent Cube. 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. 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. 3. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Create a report off the Cube with Category, and Region attributes and Revenue metric on. In the Intelligent Cube cache monitor in Developer, notice that all cube caches for the project. Related Topics. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. x a new concept is introduced called Intelligent Cubes. To Schedule a Cube Refresh. Common Privileges. Create an Intelligent Cube, with Region, Category, Cost and Profit. KB224157: How to Get the Intelligent Cube Status Using MicroStrategy Web SDK. Right-click an Intelligent Cube and select Delete. Import MicroStrategy File. In your Datasets panel, hover over the name of your dataset. Right mouse click on the cube and choose Schedule 3. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. 9K KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Deploy the ojdbc8. 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. Modify the list of Report objects (use object browser). Web publish Intelligent Cube. In the user interface, specify the partition attribute and the number of partition . The "Email" column cannot be found in. In Developer, log in to a project with a user account with administrative privileges. With OLAP Services features, your report designers can create Intelligent Cube reports. 1. At this time, only one table per cube is supported. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. This will influence the user experience. Click All Objects View. Run the Report and check the SQL View. A report accessing the Intelligent Cube includes only Year on the report. You can also select an existing template (see How to Create a Report Based on an Existing Template ). Use Intelligent Cube Editor. 1. Click Create on any page, point to New Report, and select Blank Report. Notice the attribute forms in the Report Objects pane. 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. 2. Add DM. Configure a Cluster with a Centralized Cache. From the File menu, select Create Test. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. Expand Intelligent Cubes, and then select General. 2. To define an incremental refresh report. Click Close, then "Finish" on the "prepare data" view and save the cube.