Right-click your selection and select Group. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. Enter a name for your new schedule into the. Assuming that ProjectA and ProjectB are in the same metadata, create a Database Instance to connect to an OLAP data source. To view an existing cube, you must have the following minimal privileges: Use analytics. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. To choose from the full list of template workflows, click the. 2. For steps to create an Intelligent Cube based on an MDX cube, see Creating Intelligent Cubes based on MDX cubes. 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. In MicroStrategy Web 10. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. 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. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. An. Stop the. 9K KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. This privilege is part of OLAP Services. Hover the schedule need to be modified,. 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. DESC forms are in bold as they are displayed by default in the report, as shown below:In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 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. KB228850: How to migrate published intelligent cubes to a different environment in MicroStrategy Intelligence Server 9. 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 report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. 438832. 3. Click an MDX cube source. 119 Share Save 45K views 9 years ago MicroStrategy Advanced Topics by MicroRooster Source: MicroRooster. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Steps to import a spreadsheet from Google Drive: MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. After the Intelligent Cube has finished republishing, the Cube. Right-click your selection and select Group. Select a database configured for SAP HANA. How to configure, monitor, and manage Intelligent Cubes. To publish an Intelligent. Select "Add External Data" and connect to an OLAP data source with the Live Connect option. Then click "Save". The Subscription Editor opens. . To Create a Report that Accesses an Intelligent Cube. Navigate to the Intelligent Cube for which you want to define the incremental refresh. 3. In the Name field, type the name of the subscription. com. Cube Advisor opens. It is very simple to create an intelligent cube, it is same like. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Navigate to the Engine Component with CSI Dispatcher. For steps to create an Intelligent Cube report, refer to the OLAP Services Guide . 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). You must complete a few prerequisites before using Cube Advisor to recommend and create Intelligent Cubes to support a dynamic sourcing strategy. The group is created as a derived element and displayed on the report. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. In the Refresh Policy column, choose one of the following options: To define an incremental refresh report. 2. Contact the MicroStrategy Technical Support for an update on this enhancement request. Create an Intelligent cube with Month and Revenue. Publish the cube. The Browse for Folder dialog box opens. Create Cube A and a report based on it. x - 10. Watch the Product team review how to configure and manage advanced properties of Intelligent Cubes. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. The Intelligent Cube Editor uses the new Modeling service infrastructure. The search directly uses the attribute form from the attribute definition, instead of form from the intelligent cube. Select an Environment from the upper-left drop-down. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. To publish your cube, see the In-Memory Analytics Help. Check the status of the cubes in Developer. Create an attribute element prompt for the. The Intelligent Cube Monitor is displayed. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. To create a report that connects to an Intelligent Cube, in MicroStrategy Developer. All necessary privileges are included in the Administrator role by default. 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. Right-click an Intelligent Cube and select Delete. Republish the. This is the same requirement to create or run a static report in Workstation. 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. Expand Intelligent Cubes, and then select General. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. 2. 3. 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. See Importing MDX cubes in the MDX Cube Reporting Help for more information. Add DM. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. Defining the partition for Super Cubes. 2. 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. Click All Objects View. 4. This permission is checked at design time, and when executing reports against an Intelligent Cube. GUID: is the GUID of the intelligent cube, returned as a string. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. Restoring cube files. STEPS TO REPRODUCE: 1) Add external dataset. 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 a new Intelligent Cube C01 using the "ORDER_FACT" table: Add External Data > Databases > Select Tables. However, the metric must display in the area of subtotal, the total number of customers inserted into the data warehouse, not the sum of. Description. Share query results in-memory across multiple dossiers and reports. All necessary privileges are included in the Administrator role by default. The old cube files don't have this property, so new IDs will be generated every. The "Refresh Cube. With OLAP Services features, your report designers can create Intelligent Cube reports. Select other schedule options as required, and click OK. This must be done by the DBA and MicroStrategy Technical Support will not assist with this. How to Import Data from a SAP HANA Database Into MicroStrategy Web. This determines the approach to existing data at refresh. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. In the Refresh Policy column, choose. Create a cube report based on the cube. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. On the Freeform Sources tab, select one of the following options: To. after executing the Login task), and type the GUID of the. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. Login to MicroStrategy Web, create a cube with the function of Data Import 2. 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. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. x-10. Total Cubes This section displays the total count of cubes by status. To Create a Report Using Both Report Objects from a MicroStrategy Project and MDX Cube Data. The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. 2. Node 1. 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. Open the cube report in Design View. From the File menu, select New, and then select Intelligent Cube. To create an Intelligent Cube based on an MDX cube Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Multiple reports can access a single. 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. Ensure that the email addresses can be displayed properly. Common Privileges. 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‘. 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‘. Add a grid with the attribute Customer. Republish the same cube, and a new cube instance is generated. This can be seen in the screenshot below. e. 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. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 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. Common Privileges. You should see these cubes in the Intelligent Cube cache monitor in Developer. Browse to an Intelligent Cube, select it, and then click OK. For prior releases, either a cube was loaded, residing completely in RAM, or unloaded. Right-click the dataset, and choose Schedule. 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. 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 Create an Intelligent Cube Using Freeform SQL or Query Builder Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Prerequisites. 1. Designing and creating documents: An overview. Select the data sources to be refreshed. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. Click Select. Create a user (tester) and disable the "web publish Intelligence Cube" privileges under Web Analyst. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report. To unpublish an Intelligent Cube. Web modify the list of report objects (use object browser --all objects) Web Professional. Click Create on any folder page, point to New Report, and select MDX Cube Report. This VLDB property has the following options:. Login to MicroStrategy Web, create a cube with the function of Data Import 2. Use OLAP Services. 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. Data Population for Intelligent Cubes. In the Refresh Policy column, choose. Click OK. * 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. Create a new dossier: Create a new metric M01=Case: Create a new metric. This is a known issue classified as a defect with MicroStrategy Web 9. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". In MicroStrategy Web 9. 2. 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. Execute reports or documents that reference the object. Run the report in Grid View. Open the Workstation window. Open the Workstation window. 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. 3. 86K KB31566: MicroStrategy 9. Right-click an Intelligent Cube and select Delete. This is the same requirement to create or run a static report in Workstation. Click “All Objects View”. g. 7. 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. Open the cube report in Design View. Create a report based on above Cube and add the prompt in view filter. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. Save the Report and close. 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. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. From the Data menu, select Configure Intelligent Cube. Integrity Manager can test the SQL of Intelligent Cubes even if they. From the MicroStrategy Web Home page navigate to the Intelligent Cube (Cube A) you want to merge data into. From the System Manager home page, you can access the template workflows in the Templates section. Open the. To view an existing cube, you must have the following minimal privileges: Use analytics. create(auto_upload=False,. 86K KB31566: MicroStrategy 9. 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:. This name change is visible in MicroStrategy Workstation and MicroStrategy Web. Memory mapped files (MMF) can be used for effective RAM utilization. Select the data set and click Prepare Data. 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. Navigate to the Intelligent Cube for which you want to define the incremental refresh. x - 10. Here, we use MicroStrategy Tutorial objects to create a report: Add Category, Brand, and. Follow the steps below using the MicroStrategy Tutorial project: 1. Sharing data. Web Analyst. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. CubeServerDefinition, and this folder should be shared as 'ClusterCube'. To set refresh filters, or alternate data sources, select Show Advanced Options. 4. In MicroStrategy Web 9. 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. In MicroStrategy 11. 4. Click Create on any page, point to New Report, and select Blank Report. Typically, a long duration is seen in the Data Transfer time which indicates the time it takes to fetch data from the warehouse. 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. To Create an Intelligent Cube Using Freeform SQL or Query Builder. 4. xThe following scenario describes how to create a distinct count subtotal from base report: 1 Create a report A with only “year” in row and ”category” in column; add customer in report object window only. Published: 4월 6, 2017. MicroStrategy Developer 9. Expand Intelligent Cubes, and then select General. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. Create a Report 'R3' with 'Country' attribute. To Create a Report from Scratch. 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. 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. Execute reports or documents that reference the object. The ability to view or edit certain settings is determined by a user's privileges. /mstrctl -s IntelligenceServer. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Search for prompt answer in report based on Intelligent Cube returns no results on selected ID form in MicroStrategy Web 9. Expand Intelligent Cubes, and then select General. 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. For background. For the example scenario, log in to the MicroStrategy Tutorial project. Select the environment and project where you want to save your. Select data population for Intelligent Cubes. Business users might not want MicroStrategy to build any M:M Relationship tables while publishing the Intelligent Cube In-Memory due to the following reasons: 1) It distorts the actual relationship between a tuple of 3 or more attributes related to each other through M:M relationship in Project Schema by creating individual tables and joining. KB30711: Security filter application to view reports based on Intelligent Cubes. This will influence the user experience. jar file to i-server machine. 3. The default value is 256 megabytes. Create Intelligent Cubes. 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. PublishCube". This " How to" knowledge base article explains cube advisor. 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. Users can create a Report Post SQL Statement within the Intelligent Cube that updates the value of a flag in the warehouse table. This determines the approach to existing data at refresh. Create a Visual Insight dashboard and add the above cube as the dataset: 3. From the cube monitor, we could see the. 4. x a new concept is introduced called Intelligent Cubes. Check the status of the cubes in Developer. STEPS TO REPRODUCE Use Data Import to bring in an Excel file containing a few columns (i. x releases, and the new Multi-table Data Import (MTDI) cubes. 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. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. This article discusses how to publish an Intelligent Cube using the MicroStrategy Web SDK. The Browse for Folder dialog box opens. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. Save the Intelligent Cube generated. In Developer, log into a project. 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. Intelligent Cube IC2 contains attributes 'Country' and 'Region' Create a report services document with the above 2 Intelligent Cubes as datasets. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. Export to MicroStrategy File. 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. jar. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Designing and creating documents: An overview. 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. x as Administrator; create a simple Intelligent Cube called Q, and publish it. You can also select an existing template (see How to Create a Report Based on an Existing Template ). This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. 3. Right-click the project and select Project Configuration. 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. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. A report accessing the Intelligent Cube includes only Year on the report. Quickly integrating data into MicroStrategy as part of a proof-of-concept. At least one MDX cube must be imported into your MicroStrategy project. 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. 1 or MicroStrategy Web 9. Create an Intelligent Cube with attributes Year, Month and Region; 4. In MicroStrategy Developer, edit the Intelligent Cube where u sers want to enable partitioning. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. ) 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 Subscribe to Cube /Cache Update dialog box opens. And create one Cube based report called “cube report 2”. The Full Refresh option is the default. Right-click an application and choose Properties. Some uses for this data include: •. 11. The Schedule dialog box opens for your dataset, showing the tables in your dataset. The dataset is a set of data that can be displayed on the document. They should have the “A, L, F” status (Active, Loaded, Filed). Supports derived metric creation. For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. Right-click the cube, and select Schedule. This is possible because when the Intelligent Cube refresh job finishes, a record is logged in the IS_REPORT_STATS table. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. STEPS TO REPRODUCE. Publish the cube. This will create the Intelligent Cube directories. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Choose File > New > Report. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. From MicroStrategy Education, this lesson teaches you how to create an Intelligence Cube in MicroStrategy Desktop, then use that Intelligence Cube to create a report in MicroStrategy Web. Multiple reports can access a single. 1. Select the data sources to be refreshed. Integrity Manager can test the SQL of Intelligent Cubes even if they. When triggering the concurrent subscriptions to publish a cube with different database connections, some of them do not publish. x. To Create a Report that Accesses an Intelligent Cube. Open the Workstation window. HyperIntelligence for Web was first. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. Normalize Intelligent Cube data in MicroStrategy Intelligence Server . Create an Intelligent Cube with "Customer", and add the attribute form "Email" into the cube. From the Report Selection panel, go to the File menu > Open. 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. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user. * Web define Intelligent Cube report: create a report that uses an Intelligent Cube as a data source: WEBDEFINEVIEWREPORT. Right-click the cube, and select Schedule Data Refresh. Create. Open Command Manager and type the following commands to. /ClusterCube. 1 product only with documents using view filter qualifications. 1. 4. 3. Although the default memory usage limit is 500%, sometimes it can be set as low as 50%. The Create Group dialog box opens. Insert one panel stack and add dynamic text with Profit Margin. Log into ProjectA in MicroStrategy Web.