2. Republish the. From the File menu, select Create Test. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. The cube now has Year and Category on it. MicroStrategy Web and Mobile deployed in a JSP server like Tomcat. g. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. 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. Create a new File Log and name it “CSI” (or any other name). 0. Add Project objects from the All Objects panel. Steps to Reproduce. This issue has been classified as a defect by MicroStrategy. Login MicroStrategy Developer 10. Create a new Intelligent Cube C01 using the "ORDER_FACT" table: Add External Data > Databases > Select Tables. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. To learn more about Intelligent Cube Data Partition, please refer to KB237803. Create a user (tester) and disable the "web publish Intelligence Cube" privileges under Web Analyst. Run a dossier based on the cube. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. x as Administrator; create a simple Intelligent Cube called Q, and publish it. blogspot. Make sure the service is properly configured and running before using the Intelligent Cube Editor. For more details on enabling the setting. 3. 11. KB228850: How to migrate published intelligent cubes to a different environment in MicroStrategy Intelligence Server 9. Publish the cube. Check the status of the cubes in Developer. Prerequisites. You can use the ACL Editor in -MicroStrategy Web to assign the following permission groups to users, for each Intelligent Cube: Group. Use Intelligent Cube Editor. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. 4. They should have the “A, L, F” status (Active, Loaded, Filed). Save the Report and close. x. 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. To Schedule a Cube Refresh. This property can only be enabled through Workstation. To do so, you can take advantage of URL API. A report accessing the Intelligent Cube includes only Year on the report. Select an MDX cube. In the Object name field, type a descriptive name for the Intelligent Cube. Save as an In-Memory dataset. Expand Intelligent Cubes, and then select General. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. These privileges are part of OLAP Services. The view filter cannot filter out other elements as shown below:Use Cube Advisor to create Intelligent Cubes: 1. WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. The Select Intelligent Cube dialog box opens. Open Command Manager and type the following commands to. Included are steps to enable dynamic sourcing for the project, create the metric levels log, and run the Cube Advisor Tool. x. Open the. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. Required Status to Perform Action. Login Web with Administrator, Create a VI Dashboard based on this cube. 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. The Intelligent Cube Monitor is displayed. 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. 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. Number of Views 1. First, you open a blank document and select a report to use as the document's dataset. 3 - Check the Make Intelligent. 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. Now, create an hierarchy prompt but before saving , save/overwrite them on top of “Qualification Prompt” that is being used in the Cube – ensure, the hierarchy objects exists within cube. In MicroStrategy Developer, edit the Intelligent Cube where u sers want to enable partitioning. Right-click an Intelligent Cube and select Delete. In the Navigation pane, click Applications. Common Privileges. 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 and publish Intelligent cube called “Cube2” on node B. After the Intelligent Cube has finished republishing, the Cube reports will contain the updated. Login to MicroStrategy Web, create a cube with the function of Data Import 2. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. This " How to" knowledge base article explains cube advisor. 4. 1 or above, to pick up the fix, enable project level setting "Data Engine Version" to 11. This data is stored as Intelligent Cubes. x: Create a new Intelligent Cube with Attributes Category, Subcategory and Metric Revenue. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. Browse to an Intelligent Cube, select it, and then click OK. Browse to and select a previously saved Intelligent Cube on which to build your report. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. The New Intelligent Cube dialog box opens. Export to MicroStrategy File. 9 and 10. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. HyperIntelligence for Web was first. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 7. Some uses for this data include: •. Number of Views 2. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. 4. x - 9. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. Create Cube A and a report based on it. Share query results in-memory across multiple dossiers and. 8. The CREATE and INSERT support VLDB property defines whether MicroStrategy can perform CREATE and INSERT statements against the database for a database instance. 1. By default, this is set to 32,000. Some uses for this data include: •. You cannot create or edit a card based on an unpublished cube. Navigate to the Engine Component with CSI Dispatcher. 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. The Intelligent Cube opens in the Report Editor. The New Intelligent Cube dialog box opens. Modify the list of Report objects (use object browser). Click an MDX cube source. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. Right-click on the cube and choose Edit. For example, an Intelligent Cube includes Year and Quarter. If you are upgrading to MicroStrategy 11. Modify the list of Report objects (use object browser). To Create an MDX Cube Report. In the Object name field, type a descriptive name for the Intelligent Cube. 2. Run the Report and check the SQL View. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 4. Create a new dossier: Create a new metric M01=Case: Create a new metric. Reporting on MDX Cubes. 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. 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%. However, users can achieve this functionality by creating a cache update subscription to refresh Intelligent Cubes. At this time, only one table per cube is supported. In the Data Source column, select the checkboxes for the tables to update. 1. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. Watch on. To unpublish an Intelligent Cube. To Schedule a Cube Refresh. STEPS TO REPRODUCE: 1. The group is created as a derived element and displayed on the report. Select the refresh policy. x. This must be done by the DBA and MicroStrategy Technical Support will not assist with this. The display of data is handled by the reports that access the Intelligent Cube. Edit Intelligent Cubes from the new editor in Workstation at any time. In Developer, log in to a project with a user account with administrative privileges. Answer: When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. For example, if a user has an Intelligent Cube that contains weekly sales data, the user may want this Intelligent Cube to be updated at the end of every week with the sales data for that week. 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. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. We use MicroStrategy Tutorial objects in the following steps. Right-click the cube, and select Schedule. 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. Open MicroStrategy Developer. 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. Run the report in Grid View. Data access security is maintained. Execute. x Intelligent Cube status indication and workflow To create an attribute form caching cube. The Create Group dialog box opens. * 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. IS_PROJ_ID. "In MicroStrategy 10. Right-click the cube, and select Schedule Data Refresh. First, you open a blank document and select a report to use as the document's dataset. The steps below show you how to create an Intelligent Cube based on an MDX cube. Right-click the project and select Project Configuration. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). Permanent Table: When the queries for a report or Intelligent Cube are performed in parallel, any intermediate tables are created. Click OK to save the Intelligent Cube and return to the Report Editor. Here, we use MicroStrategy Tutorial objects to create a report: Add Category, Brand, and. The report retrieves data from Cube B now. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). Complex metrics here refer to metrics which are defined using multiple. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". 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. 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). Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. Drag and drop the objects into the report grid from the Report Objects pane. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. 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. e. jar. 2) Choose "Database" and select the 3rd option to "Pick tables". 2. Run report off cube. Type a name for the derived element, and click OK. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. This permission is checked at design time, and when executing reports against an Intelligent Cube. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. 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. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. com. x. Open the. Select the data sources to be refreshed. 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. Visualizations in the dossier that use data from the cube display. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. How to Import Data from a SAP HANA Database Into MicroStrategy Web. 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. 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. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. To set refresh filters, or alternate data sources, select Show Advanced Options. In the Tutorial project create a cube with the Year attribute. To do so, you can take advantage of URL API. IS_CUBE_INST_ID. With OLAP Services features, your report designers can create Intelligent Cube reports. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. The file location in project configuration is . Select data population for Intelligent Cubes. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;Job ID for the action on the Intelligent Cube. Create a report services document or Visual Insight Analysis. In MicroStrategy 11. In the Refresh Policy column, choose one of the following options: To define an incremental refresh report. The Subscribe to Cube /Cache Update dialog box opens. Click the MicroStrategy icon, and select Create Report. Designing and creating documents: An overview. This article describes the Intelligent Cube Population options available in MicroStrategy. Save the Report and close. 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. 1 or MicroStrategy Web 9. 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. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. From the File menu, select Create Test. A set of data is returned from the. Create a report based off the cube in Step 1 that includes the description form for Category. Importing MDX cubes is often handled by a MicroStrategy architect. In MicroStrategy Developer, log in to a project source with administrative privileges. 4. It does not tell us anything helpful and we should not use it as a point of reference. Open the cube report in Design View. Execute reports or documents that reference the object. The following procedure will make cube data accessible to view reports. Select Empty. In Developer, log into a project. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. Click Close, then "Finish" on the "prepare data" view and save the cube. The Schedule dialog box opens for your dataset, showing the tables in your dataset. From the File menu, select New, and then select Intelligent Cube. 3. Later the user can poll for the change in the value of the flag. In MicroStrategy Desktop 9. On the Freeform Sources tab, select one of the following options: To. 2. The month ID for 2004 Jan is like 200401. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. An. Introduction: Need to create a report with a metric that calculates the number of distinct customers. Insert one panel stack and add dynamic text with Profit Margin. It retrieves report results from a schema source and stores it in memory. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. Create Cube B which contains all objects in the report and publish it . 000007431. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Cube Advisor opens. Node 2. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Related Topics. Under Cube Update, click Cube Update. Drill within Intelligent Cube:. Import MicroStrategy File. You can also create Intelligent Cubes by directly querying your data. 1. 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). This determines the approach to existing data at refresh. 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. By default, there is a system hierarchy on the cube. 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. The Intelligent Cube Monitor is displayed. 1 and 10. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. In Project B, create and run a new Intelligent Cube. You can modify the derived element using the Derived Elements Editor (see Using the Derived Elements Editor ). Connection mapping can then be used to map the desired MicroStrategy users to this database login. By default, Intelligent Cubes created through Data Import are saved to the MicroStrategy user's "My Reports" folder. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. 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. 4 using an Excel file and the Connection mapping database connections of the user account which published the cube are listed when checking the Intelligent Cube monitor in Developer. For example, you can restrict some users to only create reports based on an Intelligent Cube, but not re-execute the Intelligent Cube. Dynamic source hit. Other metadata database platforms:Login Developer with Administrator, create a cube and publish it. For steps to create a view filter in MicroStrategy Web, see the MicroStrategy Web Help. Node 1. 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. Number of Views 1. 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. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . Create Intelligent Cube report with derived metric and derived element as shown below: Create a document with this cube report as dataset. Description. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. “Intelligent Cube (<Cube Name>) for locale. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. Shut down Intelligent Server node A with command . 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. If you want to create an empty SuperCube, use SuperCube. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. HIDDEN: if the intelligent cube is hidden or not, returned as a boolean value. 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. Click Intelligent Cube Report. x. In MicroStrategy 10. ) 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. 4. Publish the cube. Start > All Programs > MicroStrategy Products > Integrity Manager. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. The Modeling service must be configured correctly to use this feature. Remove the prompt from the Base Report and save it as Intelligent Cube. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. Save the Cube with Connect Live Data Access Mode. Documentation on the REST API is at developer. Click here to view details about the Intelligent Cube Monitor. Click a catalog. For a MicroStrategy environment configured to use Database level security using MSTR connection mapping, Intelligent Cubes can still be utilized. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. In Web, create a new Dossier and click on New Data. Create Schema Objects. In MicroStrategy 10. Intelligent cube is an OLAP feature introduced in Microstrategy 9 version. x-10. All articles. MicroStrategy Web also uses the history list from Intelligence Server. Common Privileges. Follow the steps below using the MicroStrategy Tutorial project: 1. Once this privilege is enabled, the Intelligence Server Administration screen looks like the following: With only these three privileges, a user is able to access the User Manager in Web. 2. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. Create a standalone Derived metric DM : Create a new Intelligent Cube C01: Add the Quarter, Country, and Region attributes. This technical note describes a known issue when creating a data import cube in MicroStrategy Web 10. Select the data sources to be refreshed. 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. Create a document with orderID and itemID attributes on the grid. 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‘. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. 4 the connection mapping of the u… Number of Views 1. As shown in the screenshot above, only one cube cache can be loaded in RAM. Use the Objects section to search for the desired metrics and attributes. How to configure, monitor, and manage Intelligent Cubes. Run the report, notice that the filter does not work, all. You can also create an Intelligent Cube that contains data from an MDX cube integrated into MicroStrategy from an MDX source such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . 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. 1, Data Import allows users to maintain intelligent cubes from external Excel files. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. 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). 4. 38K. In MicroStrategy Developer, locate the Intelligent Cube that needs to be refreshed. 4. WORKAROUND: If possible, create a report from the Intelligent Cube, then create the Visual Insight. Defining the partition for Super Cubes. Export to MicroStrategy File. IS_CUBE_ACT_ID. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent Cube is repeated for every row. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. You can also select an existing template (see How to Create a Report Based on an Existing Template ). This is the same requirement to create or run a static report in Workstation. Choose File > New > Report. Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. To schedule updates for the Intelligent Cube. Publish the cube. In MicroStrategy OLAP Services, Transformation metrics used in standard reports can resolve against Intelligent Cubes only when the same Transformation metric exists in the Intelligent Cube. The Select Intelligent Cube dialog box opens. 4. create() will create a SuperCube, upload the data to the Intelligence Server and publish it. Upload Dashboard. 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. From the Data menu, select Configure Intelligent Cube. Search for prompt answer in report based on Intelligent Cube returns no results on selected ID form in MicroStrategy Web 9. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets". 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. Intelligent cubes & Level Metrics. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. 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. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. Click OK. x. With OLAP Services features, your report designers can create Intelligent Cube reports. /mstrctl -s IntelligenceServer. 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. Check it in the cube monitor and we can see its column Database Connection is not empty. To Create an Intelligent Cube Using Freeform SQL or Query Builder.