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. The Save Intelligent Cube As dialog box opens. Note: number of columns should be the same as in the original file. Save as an In-Memory dataset. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. jar. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. This knowledge base article describe steps to re-point an existing report which is based on Cube A previously to another Cube B. Con: The copy of report data in Intelligence Server memory only applies to a single report. 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%. Open the cube report in Design View. Stop the. 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. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. In MicroStrategy 9. Log in to the project in which you want to create a report. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. Open MicroStrategy Developer. Report Post SQL Statement. MicroStrategy transforms organizations into intelligent enterprises through data-driven innovation. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 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. Currently, project duplication does not involve Intelligent Cube File Directory. For a MicroStrategy environment configured to use Database level security using MSTR connection mapping, Intelligent Cubes can still be utilized. The Schedule dialog box opens for your dataset, showing the tables in your dataset. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. In MicroStrategy Web 10. 3. Steps To Reproduce 1. And create one Cube based report called “cube report 2”. Select the data sources to be refreshed. Type a name for the derived element, and click OK. All reports that access Intelligent Cubes allow you to drill within the data included in an Intelligent Cube. Create the metric levels log file used to. 2. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. Check the status of the cubes in Developer. 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. STEPS TO REPRODUCE: 1. 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‘. 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. From the cube monitor, we could see the. The "Refresh Cube. To create or edit Intelligent cube reports you must at least have the following privileges: Web define Intelligent Cube Report or Defined Intelligent Cube Report. To set refresh filters, or alternate data sources, select Show Advanced Options. 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. Create an Intelligent Cube, with Region, Category, Cost and Profit. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Complete the "sessionState" field (e. To learn more about Intelligent Cube Data Partition, please refer to KB237803. ACTION:The procedure below provides steps to create a subscription to schedule the publication of an Intelligent Cube. Node 2. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. Make sure the service is properly configured and running before using the Intelligent Cube Editor. 4. From the Data menu, select Add Dataset. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. (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. Introduction: Need to create a report with a metric that calculates the number of distinct customers. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Login MicroStrategy Web as M20061, go to Add External Data -> Databases -> Select Tables, pick the following tablesFollow these steps to reproduce the issue in a MicroStrategy Tutorial Project. The ability to view or edit certain settings is determined by a user's privileges. For more information on importing MDX cubes into MicroStrategy, see Importing MDX cubes. Right-click an Intelligent Cube and select Delete. Drill within Intelligent Cube:. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. By default, there is a system hierarchy on the cube. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. For steps to use an existing template to. For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. 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. When an Intelligent Cube is in this status, any reports based on this cube have. 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. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. Cube A must be selected here to maintain its attribute IDs after the merge. The predefined MicroStrategy Web Analyst group is assigned the set of Web Analyst privileges by default. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. Browse to and select a previously saved Intelligent Cube on which to build your report. This issue has been classified as a defect by MicroStrategy. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. The status of each Intelligent Cube is listed in the. 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. x. com. Importing MDX cubes is often handled by a MicroStrategy architect. To Schedule a Cube Refresh. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. Click Create and choose Add External Data. 2. For Oracle 12. From the MicroStrategy Web Home page navigate to the Intelligent Cube (Cube A) you want to merge data into. microstrategy. The file location in project configuration is . Choose File > New > Report. 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. To unpublish an Intelligent Cube. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Insert one panel stack and add dynamic text with Profit Margin. 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 10. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. If you want to create an empty SuperCube, use SuperCube. At least one MDX cube must be imported into your MicroStrategy project. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. STEPS TO REPRODUCE Use Data Import to bring in an Excel file containing a few columns (i. 000007431. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. Run the Report and check the SQL View. Navigate to the Engine Component with CSI Dispatcher. 4. 86K KB31566: MicroStrategy 9. 9K KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. To subscribe a report or document to a cube refresh. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. This VLDB property has the following options:. This will create the Intelligent Cube directories. However, the metric must display in the area of subtotal, the total number of customers inserted into the data warehouse, not the sum of. 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:. 0 MicroStrategy releases. At this time, only one table per cube is supported. 38K. Total Cubes This section displays the total count of cubes by status. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent. Create. Share query results in-memory across multiple dossiers and. Publish the cube. Check in Developer that the stopped node is in Maintenance Mode. Modify the list of Report objects (use object browser). This permission is checked at design time, and when executing reports against an 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. This is an identified defect in Visual Insight in MicroStrategy Web 10. x. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. MicroStrategy Web and Mobile deployed in a JSP server like Tomcat. Steps to Reproduce. Create a standalone Derived metric DM : Create a new Intelligent Cube C01: Add the Quarter, Country, and Region attributes. x - 10. 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. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. Afterwards the cube will start executing. 2. Click Select. You can also select an existing template on which to build your new report. While the report cache is disabled at the report level and there is no cache or Intelligent Cube exist for the dataset to hit, "In Memory" appears under the dataset name listed in Visual Insight editor with MicroStrategy Web 10. Description What's New 2022 Releases Workstation. 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. KB30711: Security filter application to view reports based on Intelligent Cubes. MicroStrategy Developer 9. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. To schedule updates for the Intelligent Cube. With OLAP Services features, your report designers can create Intelligent Cube reports. Publish the cube. To make the Intelligent Cube available for creating reports, publish the Intelligent Cube by choosing Run Report in the toolbar. 1… Number of Views 9. In the Refresh Policy column, choose. 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)". Under Cube Update, click Cube Update. 6. 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. In MicroStrategy Developer, browse to an Intelligent Cube. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. Documentation on the REST API is at developer. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Node 2. 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. Open MicroStrategy Web. A document that uses the Intelligent Cube as a dataset. An. From the File menu, select New,. Create a document with orderID and itemID attributes on the grid. 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. You cannot create or edit a card based on an unpublished cube. Data access security is maintained. KB228850: How to migrate published intelligent cubes to a different environment in MicroStrategy Intelligence Server 9. How to Import Data from a SAP HANA Database Into MicroStrategy Web. Select data population for Intelligent Cubes. The Intelligent Cube Monitor is displayed. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). Right-click the cube, and select Schedule. 7. In MicroStrategy Developer, log in to a project source with administrative privileges. /ClusterCube. 11. 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. x Intelligent Cube status indication and workflow To create an attribute form caching cube. 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. Right-click the dataset, and choose Schedule. Follow the steps below using the MicroStrategy Tutorial project: 1. Import MicroStrategy File. STEPS TO REPRODUCE. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. 2. The differences between the options. Before MicroStrategy 10. Create a user (tester) and disable the "web publish Intelligence Cube" privileges under Web Analyst. For steps to create an Intelligent Cube based on an MDX cube, see Creating Intelligent Cubes based on MDX cubes. 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. 1. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). . Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Select the "ORDER_FACT" table. STEPS TO REPRODUCE. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. If you just want to create the SuperCube and upload the row-level data but leave it unpublished, use SuperCube. Create a report services document or Visual Insight Analysis. The Browse for Folder dialog box opens. Execute ‘Report_Tutorial’ returns data as shown below: You can edit project-level cache and Intelligent Cube settings. x. By default, there is a system hierarchy on the cube. CAUSE: The report on which the action is being performed is a "Standard" report, only OLAP reports can be pointed to Intelligent Cubes. This property can only be enabled through Workstation. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Save the Intelligent Cube. Open the Workstation window. 8. The New Intelligent Cube dialog box opens. 2. You can use a report or Intelligent Cube. Click the “Add history list subscription” link near the bottom of the screen to open the. 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). The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Right-click your selection and select Group. The Schedule dialog box opens for your dataset, showing the tables in your dataset. and select the Project-Name. 4. Use the drop-down under the filter summary section to switch the server nodes. 1, Data Import allows users to maintain intelligent cubes from external Excel files. Right mouse click on the cube and choose Schedule 3. 4 the connection mapping of the u… Number of Views 1. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. Log into the server and go to the Intelligent Cube monitor (Administration > System Monitors > Caches > Intelligent Cubes). 1 clicking on the Intelligent Cube does not publish the cube but instead creates an analysis from the 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. Save the Report and close. On MicroStrategy's business intelligence platform, you have two unique methods to implement Intelligent Cube Technology: Personal Intelligent Cubes: A personal Intelligent. 4. Drag and drop the objects into the report grid from the Report Objects pane. Answer: Intelligent Cubes can be created in microstrategy in public objects folder or in a particular user folder. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT * Web publish Intelligent Cube: publish an Intelligent Cube to Intelligence Server: WEBEXECUTECUBEREPORT * Web save derived elements: save stand-alone derived elements, separate from the report: WEBSAVEDERIVEDMETRICS In MicroStrategy Web, log in to a project. Web publish Intelligent Cube. Then click "Save". Navigate to the folder location of the Intelligent Cube. Node 1. IS_CUBE_INST_ID. Under Refresh type, select one of the following options. Web create derived metrics and derived attributes: This privilege allows you to create new calculations based on other. The month ID for 2004 Jan is like 200401. Kickstart Your Career Get. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Expand Intelligent Cubes, and then select General. 1 product only with documents using view filter qualifications. Steps to activate CSI Log in Windows: Open the MicroStrategy Diagnostics and Performance Logging Tool. The Modeling service must be configured correctly to use this feature. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. In MicroStrategy 9. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. Sharing data. Create Schema Objects. 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. All articles. In the grid display of the report, right-click the attribute for which you want to create or modify derived elements, and click Derived Elements . On the ODBC Sources tab, in the Source area, select the database instance that connects to the data source to report on using Freeform SQL or Query Builder. In the Tutorial project create a cube with the Year attribute. Click a catalog. After the Intelligent Cube has finished republishing, the Cube. 1 to see the results as shown. To schedule an Intelligent Cube to be updated. Log in to a project connected to an MDX cube source. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Select Intelligent Cubes > General > Intelligent Cube File directory. Trending Articles. With OLAP Services features, your report designers can create Intelligent Cube reports. PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public Objects\Reports\Sequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a script that also requests the Command Manager console to be open through the command prompt. 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 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. HyperIntelligence for Web. 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. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. The Schedule dialog box opens for your dataset, showing the tables in your dataset. 4. 4. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. 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. This is the same requirement to create or run a static report in Workstation. Edit Project-Level Cache and Intelligent Cube Settings. Select the environment and project where you want to save your. Save the Cube with Connect Live Data Access Mode. Intelligent cube is an OLAP feature introduced in Microstrategy 9 version. This can affect performance of your Intelligence Server as well as the ability to publish the. This determines the approach to existing data at refresh. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. After the Intelligent Cube has finished republishing, the Cube reports will contain the updated. 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. x-10. To view an existing cube, you must have the following minimal privileges: Use analytics. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. The Modeling service must be configured correctly to use this feature. Web modify the list of report objects (use object browser --all objects) Web Professional. after executing the Login task), and type the GUID of the. Web publish Intelligent Cube. Web Analyst. Common Privileges. 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. Export to MicroStrategy File. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. Once you have reviewed the information, select the check boxes for the Intelligent Cubes to create using Cube Advisor, and then click Create Cube Design. The Browse for Folder dialog box opens. . Add a grid with the attribute Customer. Navigate to the Intelligent Cube for which you want to define the incremental refresh. When a user imports an Excel file in. g. create(auto_upload=False,. 86K KB31566: MicroStrategy 9. Right-click the cube, and select Schedule. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide . 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. Publish the cube. Steps to reproduce. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube, and click OK. Workaround 2: Create a non-Kerberos authenticated database login. Log into ProjectA in MicroStrategy Web. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. To create an MDX cube report in MicroStrategy Web, you need to have Web Professional privileges, including the Web Define MDX Cube Report. Open the. Browse to and select a previously saved Intelligent Cube on which to build your report. x. Cube index generation will increase cube size. Regular Intelligent Cubes created on Developer. Contact the MicroStrategy Technical Support for an update on this enhancement request. MicroStrategy Tutorial is used in this example. MicroStrategy AI is here. 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. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. 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. Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. 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. Right-click your selection and select Group. On the Freeform Sources tab, select one of the following options: To. 4. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Create an attribute element prompt for the. Some uses for this data include: •.