Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Log into ProjectA in MicroStrategy Web. 4. In MicroStrategy Web 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. Modify the list of Report objects (use object browser). Description MicroStrategy 10 introduced a new option on the Intelligent Cube called Data Partition. 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. To Create a Report Using Both Report Objects from a MicroStrategy Project and MDX Cube Data. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Open the. 1 clicking on the Intelligent Cube does not publish the cube but instead creates an analysis from the cube. Steps to import a spreadsheet from Google Drive: MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Watch on. 1Currently it is not possible to create a cube refresh subscription in Command Manager. com Format: A MicroStrategy Online. To Create a Report that Accesses an Intelligent Cube. Steps to reproduce. 38K. g. If you've already got a report that you want to create an Intelligent Cube out of, you simply go to. All articles. Run the Report and check the SQL View. 4. 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. This determines the approach to existing data at refresh. The default value is 256 megabytes. 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. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. 4. There is no need to further create a dashboard. The CREATE and INSERT support VLDB property defines whether MicroStrategy can perform CREATE and INSERT statements against the database for a database instance. com. . 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. 4. Login as MSTR, create an intelligent cube with attribute ‘Year’ and metric ‘Average Revenue’, and publish it as ‘Cube_Tutorial’. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. MicroStrategy Developer 9. The main thing to keep in mind is that the A,F size is the I-servers best guess as to what the size in-memory will be once it is loadedConsider the following example based on the MicroStrategy Tutorial project. By default, there is a system hierarchy on the cube. 2. Trending Articles. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Section 5: Load Intelligent Cube files into the Intelligence Server. Select the data sources to be refreshed. Click All Objects View. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. Add External Data. Answer: Intelligent Cubes can be created in microstrategy in public objects folder or in a particular user folder. Browse to an Intelligent Cube, select it, and then click OK. In MicroStrategy Developer, log in to a project that contains reports connected to active Intelligent Cubes. For the example scenario, create a report with Year, Region, and Profit Margin on the report. When Drilling on a report created from an Intelligent Cube gives the Last Update Date of 1899 in MicroStrategy Web 9. microstrategy. x-10. Open the. Create a new Dossier. Report Post SQL Statement. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. For example, you can choose to add or delete data from the Intelligent Cube. 4 the connection mapping of the u… Number of Views 1. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent. 2. Node 1. Total Cubes This section displays the total count of cubes by status. This determines the approach to existing data at refresh. 1. This is the same requirement to create or run a static report in Workstation. In the Object name field, type a descriptive name for the Intelligent Cube. Select the "ORDER_FACT" table. IS_CUBE_REP_ID. In the Name field, type the name of the subscription. Execute reports or documents that reference the object. In order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. Create a second report with the year and quarter attributes and the revenue metric. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. Select the environment and project where you want to save your. For Oracle 12. STEPS TO REPRODUCE: 1. On the Home screen, select My Subscription. Drag and drop the objects into the report grid from the Report Objects pane. From the Data menu, select Configure Intelligent Cube. After updating an intelligent cube through incremental refresh, when running a report based off the cube, the incorrect time (12/29/99 7:00:00 PM) appears as the last update time in MicroStrategy Web 9. Right-click an Intelligent Cube and select Delete. In MicroStrategy Web, log in to a project. Create a Visual Insight dashboard and add the above cube as the dataset: 3. Create an Intelligent cube with Month and Revenue. 9 and 10. In your Datasets panel, hover over the. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. Drill within Intelligent Cube:. Enter a name for your new schedule into the. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. Search for prompt answer in report based on Intelligent Cube returns no results on selected ID form in MicroStrategy Web 9. You can also create Intelligent Cubes by directly querying your data. 3. Starting in MicroStrategy 10. 1. Prerequisites for using Cube Advisor. Under Refresh type, select one of the following options. At least one MDX cube must be imported into your MicroStrategy project. Click Close, then "Finish" on the "prepare data" view and save the cube. 3. This issue has been classified as a defect by MicroStrategy. x. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. Create a new report based on the published Intelligent Cubes that are supposed to be made available to your designers. Log in to the project in which you want to create a report. Navigate to Administrator -> System monitor -> Cube monitor both nodes, and check all cube are “active, load, file” status. Run the Report and check the SQL View. Run report off cube. 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. In Developer, log into a project. Save the Report and close. Create a report services document or Visual Insight Analysis. MicroStrategy AI is here. The following procedure will make cube data accessible to view reports. The Report Editor opens with all of the objects of the Intelligent Cube. 2. In MicroStrategy 10. 1. From the File menu, select New,. Create Schema Objects. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. after executing the Login task), and type the GUID of the. It's basically just a report, and can even start it's life off as a report. The user continues to use the report that accesses the Intelligent Cube. 66K. After the Intelligent Cube has finished republishing, the Cube. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Create a Visual Insight dashboard and add the above cube as the dataset: 3. The Incremental Refresh Options dialog box opens. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. Created cube with lastname and any other attribute. In the Object name field, type a descriptive name for the Intelligent Cube. First, you open a blank document and select a report to use as the document's dataset. PUBLISH INTELLIGENT CUBE "C02" IN FOLDER "Public ObjectsReportsSequential Cube Execution" FOR PROJECT "MicroStrategy Tutorial"; The previous commands can be saved in a. If. Create a new Intelligent Cube C01 using the "ORDER_FACT" table: Add External Data > Databases > Select Tables. 1 release. To view an existing cube, you must have the following minimal privileges: Use analytics. Execute reports or documents that reference the object. 4. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. The old cube files don't have this property, so new IDs will be generated every. 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. To Schedule a Cube Refresh. STEPS TO REPRODUCE. If you just want to create the SuperCube and upload the row-level data but leave it unpublished, use SuperCube. 2. To Create a Report from Scratch. 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. If you select Cube B, any dashboards or reports linked to Cube A before the merge may not function correctly. In Desktop, create and publish an intelligent cube with one attribute and one metric. Create a user (tester) and disable the "web publish Intelligence Cube" privileges under Web Analyst. 3. Edit Intelligent Cubes from the new editor in Workstation at any time. Navigate to and select the report or Intelligent Cube to use as the dataset, then click OK. Select the Intelligent Cubes tab. To schedule updates for the Intelligent Cube. In Web, create a new Dossier and click on New Data. Select the environment and project where you want to save your Intelligent cube, select Intelligent Cube, and click OK. Intelligent Cubes. How to build and manage Intelligent Cubes. Regular Intelligent Cubes created on Developer. Open the Workstation window. Steps To Reproduce 1. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. ) 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. This permission is checked at design time, and when executing reports against an Intelligent Cube. This privilege is part of OLAP Services. The Modeling service must be configured correctly to use this feature. Open the cube report in Design View. Create Schema Objects. 4. Right mouse click the Intelligent Cube Q, select Schedule Delivery To>History List as shown below: 3. In the Navigation pane, click , next to Datasets. Select "Add External Data" and connect to an OLAP data source with the Live Connect option. The Browse for Folder dialog box opens. 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. x. This technical note describes a known issue when creating a data import cube in MicroStrategy Web 10. The ability to view or edit certain settings is determined by a user's privileges. Refer to the following tech note, KB37431 for a list of Licenses and privileges required for different actions related to Visual Insight in MicroStrategy Web 9. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Importing MDX cubes is often handled by a MicroStrategy architect. Call this 'Base Report'. ACTION:In the Navigation pane, click Monitors. Expand Intelligent Cubes, and then select General. However, importing data from a Google Drive Spreadsheet requires some additional setup. This is an identified defect in Visual Insight in MicroStrategy Web 10. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. Sharing data. 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. Choose Databases. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. In MicroStrategy 9. 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. Cube A must be selected here to maintain its attribute IDs after the merge. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. 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. 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. INTELLIGENT_CUBE_TYPE: is the type of the intelligent cube, returned as a string value. 0. This is a known issue classified as a defect with MicroStrategy Web 9. 1. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. 3. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. 0. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. Create a Report 'R3' with 'Country' attribute. Launch MicroStrategy Cube Advisor from the Start menu > Programs > MicroStrategy > Tools > Cube Advisor. Refresh Intelligent Cubes manually. The Intelligent Cube opens in the Report Editor. Execute ‘Report_Tutorial’ returns data as shown below: You can edit project-level cache and Intelligent Cube settings. 9 and 10. For example, an Intelligent Cube includes Year and Quarter. The group is created as a derived element and displayed on the report. WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. To define an incremental refresh report. 0, the only way to create an intelligent cube (also known as an ROLAP cube or an OLAP cube) was from a report (which is a single table dataset). They should have the “A, L, F” status (Active, Loaded, Filed). The Select Intelligent Cube dialog box opens. Currently, project duplication does not involve Intelligent Cube File Directory. This issue occurs if the cube that are created with less Attribute Forms as the Element prompt with the same Attribute. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). blogspot. ACTION:The procedure below provides steps to create a subscription to schedule the publication of an Intelligent Cube. To publish an Intelligent. Do not normalize Intelligent Cube data. It is very simple to create an intelligent cube, it is same like. To make the Intelligent Cube available for creating reports, publish the Intelligent Cube by choosing Run Report in the toolbar. 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, locate the Intelligent Cube that needs to be refreshed. 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. In MicroStrategy 9. 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. KB228850: How to migrate published intelligent cubes to a different environment in MicroStrategy Intelligence Server 9. Run a Command Manager script to delete the cube cache previously deleted in step 2. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. A document that uses the Intelligent Cube as a dataset. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. The New Intelligent Cube dialog box opens. Create a document with orderID and itemID attributes on the grid. The Intelligent Cube Editor uses the new Modeling service infrastructure. All Intelligent Cube operations are listed below: 1. Create a report based on the Intelligent Cube. Follow the steps below using the MicroStrategy Tutorial project: 1. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. com. 4. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. g. Make sure the service is properly configured and running before using the Intelligent Cube Editor. You need the Use Intelligent Cube. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. In the user interface, specify the partition attribute and the number of partition . Click an MDX cube source. create(auto_publish=False). Defining the partition for Super Cubes. In MicroStrategy 2020 Update 2, the size of the Intelligent Cube keeps gradually increasing even after setting the Maximum % growth of Intelligent Cube to 50%. x as Administrator; create a simple Intelligent Cube called Q, and publish it. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. The report opens with all of the objects of the Intelligent. 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. Click a catalog. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. Publish the cube. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Description. We can create a report and point the report to a cube or right click. The following diagram depicts the role of the intelligent cube. 0. The Intelligent Cube Options dialog box opens. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. Connection mapping can then be used to map the desired MicroStrategy users to this database login. Export to MicroStrategy File. In MicroStrategy Developer, log in to a project source with administrative privileges. x. If you are upgrading to MicroStrategy 11. Integer ID of the project where the Intelligent Cube is stored. Visit the data visualization and data dashboard galleries for inspiration. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. In order to set up an incremental refresh report, the user should first right click on the Intelligent Cube and select "Define Incremental Refresh Report":After each unload/reload, and running the Dossiers against the cube, the duplicate Element Block files will be dumped into the same *****_objects folder. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. KB39447: How to Trigger an Event Using the MicroStrategy Web SDK 9. To review and create recommended Intelligent Cubes using Cube Advisor. 1 Hotfix 6, it is not possible to use the Attribute Name macro in the filename of a bursted document when the document uses an Intelligent Cube create via Data Import as a dataset as the Intelligent Cube's attributes are not in the actual project schema. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. Community & Support Search Discussions Open A Case View My CasesThis defect is addressed in MicroStrategy 11. The Intelligent Cube Editor uses the new Modeling service infrastructure. Notice the attribute forms in the Report Objects pane. Dynamic source hit. x - 9. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. 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. Log into the three-tier project source and choose the project that was analyzed in stage 2. Start > All Programs > MicroStrategy Products > Integrity Manager. 4. x: Create a new Intelligent Cube with Attributes Category, Subcategory and Metric Revenue. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. 1. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 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. When an Intelligent Cube is published, the Intelligent. Users can create a Report Post SQL Statement within the Intelligent Cube that updates the value of a flag in the warehouse table. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. To learn more about Intelligent Cube Data Partition, please refer to KB237803. To view an existing cube, you must have the following minimal privileges: Use analytics. Create a new dossier: Create a new metric M01=Case: Create a new metric. Click Create on any folder page, point to New Report, and select Intelligent Cube 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. CubeServerDefinition, and this folder should be shared as 'ClusterCube'. Create a report based off the cube in Step 1 that includes the description form for Category. Click Create and choose Add External Data. 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. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. 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. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. This provides ROLAP-type analysis without having to re-execute against the data warehouse. Normalize Intelligent Cube data in MicroStrategy Intelligence Server . From the File menu, select New, and then select Intelligent Cube. Publish the cube. By default, Intelligent Cubes created through Data Import are saved to the MicroStrategy user's "My Reports" folder. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. 4. 2. This data is stored as Intelligent Cubes. 86K KB31566: MicroStrategy 9. In MicroStrategy 9. 4. Click Create on any folder page, point to New Report, and select MDX Cube Report. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. How to build and manage Intelligent Cubes. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. 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. The predefined MicroStrategy Web Analyst group is assigned the set of Web Analyst privileges by default. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. Create an attribute element prompt for the Year attribute. This property can only be enabled through Workstation. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Right-click the cube, and select Schedule Data Refresh. 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. Click Create on any page, point to New Report, and select Blank Report. x. PublishCube". Then click "Save". Rather than returning data from the data warehouse for a. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. 1 and 10. x. Integrity Manager can test the SQL of Intelligent Cubes even if they. IS_CUBE_INST_ID. Intelligent cube is a pre aggregated set of data stored in intelligent server memory and it will give very quick access to the data without hitting the data warehouse. From the System Manager home page, you can access the template workflows in the Templates section. 1. Set the path for the cube cache file directory to . Click Create on any folder page, point to New Report, and select Intelligent Cube Report. The differences between the options. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. 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 . 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. For steps to create a view filter in MicroStrategy Web, see the MicroStrategy Web Help. 3 - Check the Make Intelligent. The New Intelligent Cube dialog box opens. Importing MDX cubes is often handled by a MicroStrategy architect. This will create the Intelligent Cube directories. Click OK. In MicroStrategy 9. Run a dossier based on the cube. 4. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Create an Intelligent Cube, with Region, Category, Cost and Profit. Use Intelligent Cube Editor. x. STEPS TO REPRODUCE: 1. There is another reason that the intelligent cube is imported from a local file in the web server machine, and the Web server and the Intelligence Server do not need to be on the same machine. The Subscription Editor opens.