Restoring cube files. STEPS TO REPRODUCE 1. 3 - Check the Make Intelligent. ACTION:In the Navigation pane, click Monitors. Create the metric levels log file used to. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select 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. Edit Project-Level Cache and Intelligent Cube Settings. The Save Intelligent Cube As dialog box opens. If you are upgrading to MicroStrategy 11. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. Create. Right mouse click on the cube and choose Schedule 3. 9 and 10. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. To unpublish an Intelligent Cube. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. delete one relation as the following Then click "Save" to go back to the cube editor, click the "Update Dataset" button in the bottom right corner. Create an Intelligent Cube, with Region, Category, Cost and Profit. In the Navigation pane, click Applications. Navigate to the Intelligent Cube for which you want to define the incremental refresh. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. In the Tutorial project create a cube with the Year attribute. Select an Environment from the upper-left drop-down. Open MicroStrategy Web. Right mouse click on the cube and choose Schedule 3. Importing MDX cubes is often handled by a MicroStrategy architect. To view an existing cube, you must have the following minimal privileges: Use analytics. • You need the Publish Intelligent Cube (Developer) and/or Web Publish Intelligent Cube (Web) privileges. “Intelligent Cube (<Cube Name>) for locale. Check in Developer that the stopped node is in Maintenance Mode. Some uses for this data include: •. This is the same requirement to create or run a static report in Workstation. Create Cube A and a report based on it. A list of data sources available in this project appear. Browse to an Intelligent Cube, select it, and then click OK. Under Refresh type, select one of the following options. Choose File > New > Report. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. The impact is limited to MicroStrategy Developer 9. Unable to create Derived Elements in a Report Services document with a dataset that is not based on an Intelligent Cube in MicroStrategy Developer 9. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. ACTION:The Data Transfer Rate varies from 27 to 28 Mb/s. Connection mapping can then be used to map the desired MicroStrategy users to this database login. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Architects can now create, edit, and publish Intelligent Cubes with the new editor in Workstation, streamlining overall creation workflows. 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. The Intelligent Cube opens in the Report Editor. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. Reports/Documents not created from Intelligent Cube but meet dynamic sourcing requirements: Additional "Use OLAP services" and "Use Dynamic Sourcing" are required for a user to hit an Intelligent Cube, besides the privileges. In the Object name field, type a descriptive name for the Intelligent Cube. From the Report Selection panel, go to the File menu > Open. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. 2) Choose "Database" and select the 3rd option to "Pick tables". The Create Group dialog box opens. If you are upgrading to MicroStrategy 11. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. The Intelligent Cube opens in the Report Editor. Run both reports after enabling the metric levels log. Enter a name for your new schedule into the. Creating Intelligent Cubes is as easy as creating reports. If you've already got a report that you want to create an Intelligent Cube out of, you simply go to. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. Open the report in Grid View, Design View, or Grid and Graph view. From the Data menu, select Configure Intelligent Cube. Integrity Manager can test the SQL of Intelligent Cubes even if they. after executing the Login task), and type the GUID of the. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Check the status of the cubes in Developer. Follow the steps below using the MicroStrategy Tutorial project: 1. Create Intelligent Cubes. All Intelligent Cube operations are listed below: 1. 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. Open the. When an Intelligent Cube is published, the Intelligent. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. Add Project objects from the All Objects panel. In MicroStrategy Developer create an Intelligent Cube with any attributes and metrics. 4. To Create a Report from Scratch. The Intelligent Cube Editor uses the new Modeling service infrastructure. When Drilling on a report created from an Intelligent Cube gives the Last Update Date of 1899 in MicroStrategy Web 9. 0 MicroStrategy releases. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Create a user (tester) and disable the "web publish Intelligence Cube" privileges under Web Analyst. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. Sharing data. The current version of MicroStrategy Tutorial is designed using the MicroStrategy URL API with JSP framework, therefore MicroStrategy ASP is not supported for the redesigned Tutorial project. In Web, create a new Dossier and click on New Data. This is a known issue classified as a defect with MicroStrategy Web 9. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. In the Name field, type the name of the subscription. Call this 'Base Report'. Select a schedule from the Schedule drop-down list. If you just want to create the SuperCube and upload the row-level data but leave it unpublished, use SuperCube. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. The Intelligent Cube Editor uses the new Modeling service infrastructure. Data access security is maintained. From the Data menu, select Configure Intelligent Cube. Later the user can poll for the change in the value of the flag. From these results it can be determined that the Month attribute is not being used within any of the view Reports, Documents, Dossiers that reference this Intelligent Cube. Click OK. The Intelligent Cube Editor uses the new Modeling service infrastructure. 2. Navigate to the folder location of the Intelligent Cube. Click Create on any page, point to New Report, and select Blank Report. This privilege is part of OLAP Services. You can also modify the properties of. For more details on enabling the setting. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. 3. 1. If you select any Intelligent Cube reports, make sure that the Intelligent Cube the reports are based on has been published before you perform the integrity test. 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. 2 attributes and 1 metric). 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. In Developer, log into a project. In MicroStrategy Web browse to the Cube location and click on the cube . By default, this is set to 32,000. 2. 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. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal Intelligent. e. This data is stored as Intelligent Cubes. You must browse to the MDX cube to use to build the Intelligent Cube. STEPS TO REPRODUCE. Publish the cube. To Create an MDX Cube Report. Create 500 users, 500 database logins, and 500 database connections mapping to the same data warehouse. Run the Report and check the SQL View. The Report Editor opens with all of the objects of the Intelligent Cube. The Incremental Refresh Options dialog box opens. 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. 7. Users may need to delete several certain rows of data from an intelligence cube, but it is not possible to do so for a cube created by data import on MicroStrategy Web 10. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. 4. 1. GUID of the Intelligent Cube instance in memory. For the Intelligent Cube that you want to refresh, click the subscription icon. This is the same requirement to create or run a static report in Workstation. Currently, project duplication does not involve Intelligent Cube File Directory. 4 the connection mapping of the u… Number of Views 1. 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. 2. Click Create on any page, point to New Report, and then select Blank Report, which provides a blank template to build your report on. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. x: Create a new Intelligent Cube with Attributes Category, Subcategory and Metric Revenue. No additional resources are needed to modify the Intelligent Cube or to create a new report. jar. 2. The "Refresh Cube. microstrategy. Afterwards the cube will start executing. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. At least one MDX cube must be imported into your MicroStrategy project. 4. The display of data is handled by the reports that access the Intelligent Cube. A couple of workarounds are available in the current document. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. 4 the connection mapping of the user account which published the cube are created and database connections are listed in the Intelligent Cube Monitor in Developer. In the user interface, specify the partition attribute and the number of partition . This determines the approach to existing data at refresh. Select the refresh policy. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. You need the Use Intelligent Cube. Description. From the File menu, select New, and then select Intelligent Cube. WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. PUBLISH INTELLIGENT CUBE "Year Revenue Cube" IN FOLDER "profilesAdministratorMy Reports" FOR PROJECT "MicroStrategy Tutorial"; TRIGGER EVENT "Run Reports";Create an Intelligent cube with Month and Revenue. Before MicroStrategy 10. The Report Editor opens. /ClusterCube. Save the Cube with Connect Live Data Access Mode. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. x. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. Select "Add External Data" and connect to an OLAP data source with the Live Connect option. The Create Group dialog box opens. Configure and start the Intelligence Server using the metadata backup. How to build and manage Intelligent Cubes. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. x-10. Browse to and select a previously saved Intelligent Cube on which to build your report. PublishCube". This data is stored as Intelligent Cubes. To create an Intelligent Cube based on an MDX cube Using MicroStrategy Developer, log in to a project connected to an MDX cube source. PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public ObjectsReportsSequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a. In the Data Source column, select the checkboxes for the tables to update. Select data population for Intelligent Cubes. In MicroStrategy Developer, log in to a project source with administrative privileges. . To Create a Report Using Both Report Objects from a MicroStrategy Project and MDX Cube Data. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Right Mouse Click on ‘Cube_Tutorial’ to create report called ‘Report_Tutorial’. To make the Intelligent Cube available for creating reports, publish the Intelligent Cube by choosing Run Report in the toolbar. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. Navigate to the Engine Component with CSI Dispatcher. Common Privileges. The Intelligent Cube Options dialog box opens. Create and publish Intelligent cube called “Cube2” on node B. In the Name field, type the name of the subscription. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. 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. 1. ) As long as each node is using the same server definition, the setting of the cache and history list locations in the Intelligence Server configuration only needs to be done once; however, the creation of the shared folders will need to be done on each node. The predefined MicroStrategy Web Analyst group is assigned the set of Web Analyst privileges by default. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. 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. 1. Add Year Id and Quarter. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms. In this case, the dataset is a MicroStrategy Intelligent Cube. It does not tell us anything helpful and we should not use it as a point of reference. To do so, you can take advantage of URL API. Navigate to the Intelligent Cube you want to refresh. Intelligent Cubes. 4. Create a new variable and assign SuperCube with two parameters inside – connection and id. Click the MicroStrategy icon at the upper left of any page and select History List. 2. Open the Workstation window. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. . e. 000007431. In the Data Source column, select the checkboxes for the tables to update. STEPS TO REPRODUCE 1. This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. MicroStrategy AI is here. Navigate to the Intelligent Cube for which you want to define the incremental refresh. Start > All Programs > MicroStrategy Products > Integrity Manager. For background. The Save Intelligent Cube As dialog box opens. Stop the. The Browse for Folder dialog box opens. KB228850: How to migrate published intelligent cubes to a different environment in MicroStrategy Intelligence Server 9. 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. Save the cube, and run it to publish. In the left pane, click Intelligent Cubes. Create a second report with the year and quarter attributes and the revenue metric. In MicroStrategy 9. x. However, users can achieve this functionality by creating a cache update subscription to refresh Intelligent Cubes. Add a grid with the attribute Customer. The Intelligent Cube Options dialog box opens. Publish. 2 release, the driver file is called odbc8. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. Open MicroStrategy Developer. 4. An Intelligent Cube is a multi-dimensional cube (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports and documents. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. The Intelligent Cube Options dialog box opens. Navigate to the Engine Component with CSI Dispatcher. Node 1. 0. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Click Intelligent Cube Report. Workaround 2: Create a non-Kerberos authenticated database login. An enhancement Request has been reported to the MicroStrategy Technology team. Web Analyst. Drag and drop the objects into the report grid from the Report Objects pane. Make sure the service is properly configured and running before using the Intelligent Cube Editor. jar file to i-server machine. 3. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. By default, Intelligent Cubes created through Data Import are saved to the MicroStrategy user's "My Reports" folder. However, importing data from a Google Drive Spreadsheet requires some additional setup. g. Publish the cube. On the Freeform Sources tab, select one of the following options: To. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". Create Schema Objects. Steps to reproduce. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. This chapter provides information on how to deploy and configure MicroStrategy Web and Web Universal on Windows and Linux platforms with various Web and application servers. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. To schedule an Intelligent Cube to be updated. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. 86K KB31566: MicroStrategy 9. This property can only be enabled through Workstation. When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. In certain situations users may want to configure success and failure notifications for the scheduled refreshes of Intelligent Cubes that are created through Data Import in MicroStrategy Web. Permanent Table: When the queries for a report or Intelligent Cube are performed in parallel, any intermediate tables are created. The Intelligent Cube Monitor is displayed. 4. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". 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. 4. 4. This determines the approach to existing data at refresh. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. By default SuperCube. Right-click the dataset, and choose Schedule. 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. Choose File > New > Intelligent Cube. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). The report opens with all of the objects of the Intelligent. This property can only be enabled through Workstation. Web publish Intelligent Cube. To do so, you can take advantage of URL API. Supports derived metric creation. Con: The copy of report data in Intelligence Server memory only applies to a single report. create(auto_upload=False,. Update Cube Data *. To view an existing cube, you must have the following minimal privileges: Use analytics. Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. To choose from the full list of template workflows, click the. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. The Subscribe to Cube /Cache Update dialog box opens. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. Web modify the list of report objects (use object browser --all objects) Web Professional. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many different reports created by multiple users. When an Intelligent Cube is in this status, any reports based on this cube have. Configure a Cluster with a Centralized Cache. Use Intelligent Cube Editor. Choose File > New > Intelligent Cube. 11. Some data that may be available to the user by directly querying a data source may not be available in the report that accessed an Intelligent Cube. 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. Log into the three-tier project source and choose the project that was analyzed in stage 2. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. Create Intelligent Cubes. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Trending Articles. 3. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. IS_CUBE_ACT_ID. 4. 4. Log into the server and go to the Intelligent Cube monitor (Administration > System Monitors > Caches > 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. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. Modify the list of Report objects (use object browser). CAUSE: The report on which the action is being performed is a "Standard" report, only OLAP reports can be pointed to Intelligent Cubes. Number of Views 1. Create a Visual Insight dashboard and add the above cube as the dataset: 3. Open the Workstation window. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. MicroStrategy Developer 9. 2. Edit Intelligent Cubes from the new editor in Workstation at any time. Create a Report 'R3' with 'Country' attribute. Setting Up Documents and HTML Documents: This chapter explains the setup required for the Intelligence Server to create and execute HTML documents and documents. 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. 2. PublishCube". Required Status to Perform Action. This must be done by the DBA and MicroStrategy Technical Support will not assist with this. To review and create recommended Intelligent Cubes using Cube Advisor.