For the Intelligent Cube that you want to refresh, click the subscription icon. The Dashboard can be executed successfully. The following steps can be used to reproduce the issue in the MicroStrategy Tutorial project: 1. At least one MDX cube must be imported into your MicroStrategy project. In Web, create a new Dossier and click on New Data. When an Intelligent Cube is published, the Intelligent. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. 4 the connection mapping of the u… Number of Views 1. Run the Report and check the SQL View. This chapter provides information on how to deploy and configure MicroStrategy Web and Web Universal on Windows and Linux platforms with various Web and application servers. Create an Intelligent cube with Month and Revenue. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Common Privileges. blogspot. 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. Create a report based on above Cube and add the prompt in view filter. 7. 4. An Intelligent Cube is a multi-dimensional cube (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports and documents. Create Intelligent Cubes. In your Datasets panel, hover over the name of your dataset. Add Year Id and Quarter. This determines the approach to existing data at refresh. The Browse for Folder dialog box opens. KB441696: Cannot Add Prompts into View Filter of Cube Based Report in MicroStrategy Web. Cube Advisor opens. This data is stored as Intelligent Cubes. If you are upgrading to MicroStrategy 11. Documentation on the REST API is at developer. 4. Number of Views 2. These VLDB properties control the method by which the report data are normalized. 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. Trending Articles. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. The Subscription Editor opens. 4. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. Supports derived metric creation. 2) Choose "Database" and select the 3rd option to "Pick tables". All necessary privileges are included in the Administrator role by default. Number of Views 3. g. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. If you want to create an empty SuperCube, use SuperCube. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;Job ID for the action on the Intelligent Cube. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. 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. In MicroStrategy Web 9. The Intelligent Cube Editor uses the new Modeling service infrastructure. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 4. Follow the steps below using the MicroStrategy Tutorial project: 1. 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. Go to the "All Objects View" option in the top left corner. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. This must be done by the DBA and MicroStrategy Technical Support will not assist with this. 438832. Run a dossier based on the cube. 2. Open the cube report in Design View. 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. Configure a Cluster with a Centralized Cache. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. The Modeling service must be configured correctly to use this feature. To make the Intelligent Cube available to be reported on, you must publish the Intelligent Cube. You can use an Intelligent Cube as a dataset, allowing you to use one Intelligent Cube for many different documents, while reducing access to the data warehouse. Importing MDX cubes is often handled by a MicroStrategy architect. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. In the user interface, specify the partition attribute and the number of partition . For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. 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. 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. Refer to the tech note below for more information: KB32502 - Support for transformation metrics for Dynamic Sourcing in MicroStrategy OLAP ServicesIn MicroStrategy Web click Create -> Add External Data -> File from disk; Select the Excel file saved in Documents; Prepare data (Note: Change the data type of “AttributeID” to text) Right click the first attribute "AttributeID" and select "Map to Project Attribute" Search for “AttributeID” in the search bar and hit enter. Sharing data. 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. Watch on. 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. From the cube monitor, we could see the old cube is it. Right-click the cube, and select Schedule Data Refresh. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. 4. 86K KB31566: MicroStrategy 9. 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. 2 release, the driver file is called odbc8. x. In the Dynamic Sourcing area, use the Make Intelligent Cubes available for. 1 or above, to pick up the fix, enable project level setting "Data Engine Version" to 11. 1. 2. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. Use Intelligent Cube Editor. 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. 10, when the "Defect fixes may impact Data, SQL, MDX, CSI" is turned to "On" under Web preferences > Project Default, thresholds for derived metric cannot be properly applied if the condition is based on a cube base attribute. Importing MDX cubes is often handled by a MicroStrategy architect. They should have the “A, L, F” status (Active, Loaded, Filed). MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. The impact is limited to MicroStrategy Developer 9. Edit Intelligent Cubes from the new editor in Workstation at any time. Check in Developer that the stopped node is in Maintenance Mode. MicroStrategy Developer 9. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. In the Intelligent Cube Editor, choose Data > Configure Intelligent Cube… In the Intelligent Cube Options dialog box, expand Options and select Data Partition. Shut down Intelligent Server node A with command . x as Administrator; create a simple Intelligent Cube called Q, and publish it. In MicroStrategy Web 9. 3 - Check the Make Intelligent. To create an Intelligent Cube based on an MDX cube Using MicroStrategy Developer, log in to a project connected to an MDX cube source. The old cube files don't have this property, so new IDs will be generated every. 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. Since Web distributes connections between Intelligence Servers. Type of action against the Intelligent Cube: •OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. 9 and 10. GUID of the Intelligent Cube instance in memory. The following procedure will make cube data accessible to view reports. Execute reports or documents that reference the object. After the Intelligent Cube has finished republishing, the Cube. 2. Save the Cube with Connect Live Data Access Mode. After saving the log destination, the File Log column should now read as "CSI" for the Engine Component. 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. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. 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. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. Use OLAP Services. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. In MicroStrategy 9. Drag and drop the objects into the report grid from the Report Objects pane. Under Refresh type, select one of the following options. 1 or MicroStrategy Web 9. after executing the Login task), and type the GUID of the Intelligent Cube into the "reportid". Load an updated CSV file into a DataFrame providing full path. When Drilling on a report created from an Intelligent Cube gives the Last Update Date of 1899 in MicroStrategy Web 9. Right-click an Intelligent Cube and select Delete. In MicroStrategy 10. The Intelligent Cube Monitor is displayed. Total Cubes This section displays the total count of cubes by status. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. 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 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. Modify the list of Report objects (use object browser). Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Use the Objects section to search for the desired metrics and attributes. 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. Create a Visual Insight dashboard and add the above cube as the dataset: 3. After you have created your Intelligent Cube, you can publish its set of data to be shared by multiple reports. Contact the MicroStrategy Technical Support for an update on this enhancement request. By default, this is set to 32,000. Start > All Programs > MicroStrategy Products > Integrity Manager. For steps to create an Intelligent Cube based on an MDX cube, see Creating Intelligent Cubes based on MDX cubes. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Navigate to the Intelligent Cube for which you want to define the incremental refresh. Right-click the report and select Edit. Common Privileges. Navigate to the Engine Component with CSI Dispatcher. Afterwards the cube will start executing. 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. If you select Cube B, any dashboards or reports linked to Cube A before the merge may not function correctly. 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. The following steps demonstrate how to reproduce the issue in MicroStrategy Tutorial: Profit Margin=(Revenue-Cost)/Revenue. Documentation on the REST API is at developer. Both properties are located in the Query Optimizations folder in the VLDB property editor. When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Designing and creating documents: An overview. To Create a Report from Scratch. Create an Intelligent Cube, with Region, Category, Cost and Profit. 2 attributes and 1 metric). Normalize Intelligent Cube data in the Database 4. Click OK to save the Intelligent Cube and return to the Report Editor. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Publish the Intelligent Cube by executing it on either of the nodes. In Developer, log in to a project with a user account with administrative privileges. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. In Project B, create and run a new Intelligent Cube. Republish the. 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. 1 product only with documents using view filter qualifications. In MicroStrategy Developer, right-click on the intelligent cube and select Edit. 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%. Description What's New 2022 Releases Workstation. Open MicroStrategy Developer. Click the MicroStrategy icon at the upper left of any page and select History List. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. To do so, you can take advantage of URL API. You must belong to the System Administrators group to use this feature. This will influence the user experience. From the MicroStrategy Web Home page navigate to the Intelligent Cube (Cube A) you want to merge data into. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. x-10. Architects can now create, edit, and publish Intelligent Cubes with the new editor in Workstation, streamlining overall creation workflows. The Incremental Refresh Options dialog box opens. This is an identified defect in Visual Insight in MicroStrategy Web 10. Enter a name for your new schedule into the. Normalize Intelligent Cube data in the. From the Data menu, select Add Dataset. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. The Modeling service must be configured correctly to use this feature. Hence, the cube memory usage will easily exceed the limit and the ReduceCubeMemory method can be invoked frequently. Navigate to the Engine Component with CSI Dispatcher. On the Home screen, select My Subscription. The status of each Intelligent Cube is listed in the. To review and create recommended Intelligent Cubes using Cube Advisor. Select the data sources to be refreshed. Log into the three-tier project source and choose the project that was analyzed in stage 2. The New Intelligent Cube dialog box opens. x, users will notice that this is not possible due to the mouse. In Desktop, create and publish an intelligent cube with one attribute and one metric. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. 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. The Intelligent Cube Editor uses the new Modeling service infrastructure. In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. details. On the Freeform Sources tab, select one of the following options: To. Include “Qualification Prompt”. Loading. x. Create a new File Log and name it “CSI” (or any other name). Intelligent Cubes. 3 - Check the Make Intelligent. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. 3. To set refresh filters, or alternate data sources, select Show Advanced Options. Multiple reports can access a single. Click OK. 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‘. Answer: When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. 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. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Users can create a Report Post SQL Statement within the Intelligent Cube that updates the value of a flag in the warehouse table. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. 3. Note that the cube has a neutral data language. If you have a MultiSource Option license, you can include MDX cube data along with data from your relational project. Select Empty. Section 5: Load Intelligent Cube files into the Intelligence Server. 86K KB31566: MicroStrategy 9. 2. This knowledge base article describe steps to re-point an existing report which is based on Cube A previously to another Cube B. 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. The Create Group dialog box opens. Click Create on any page, point to New Report, and then select Blank Report, which provides a blank template to build your report on. 0. If you are upgrading to MicroStrategy 11. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. Open Command Manager and type the following commands to. This is set to 32,000 by default. This data is stored as Intelligent Cubes. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). 2. However, importing data from a Google Drive Spreadsheet requires some additional setup. In MicroStrategy 10. You must publish an Intelligent Cube to make it available for multiple reports to access and report on its set of data. Create a report with Category, Region and Year attributes, and Revenue metric in the grid, and Year prompt from Step 1 in the report filter. This copy of report data is stored in Intelligence Server memory only. 0 new operations were introduced in order to improve Intelligent Cube life cycle and performance. In MicroStrategy Web 9. 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. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . A solution/code fix for this issue is not available in current releases but is being reviewed for a future MicroStrategy. 4. Check in Developer that the stopped node is in Maintenance Mode. On the Home screen, select My Subscription. In the Data Source column, select the checkboxes for the tables to update. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. To do so, you can take advantage of URL API. The Intelligent Cube opens in the Report Editor. The report opens with all of the objects of the Intelligent. 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. The CREATE and INSERT support VLDB property defines whether MicroStrategy can perform CREATE and INSERT statements against the database for a database instance. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. (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. This " How to" knowledge base article explains cube advisor. Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. create(auto_publish=False). and select the Project-Name. KB224157: How to Get the Intelligent Cube Status Using MicroStrategy Web SDK. Right-click the Intelligent Cube, select "Schedule Delivery To" and choose "Refresh Cube". 4. Create an attribute element prompt for the. Incremental Refresh Options, General: Use these options to define the behavior of the incremental refresh. You can analyze a new set of reports using Cube Advisor or use the results of a previous Cube Advisor analysis: To use Cube Advisor to analyze a new set of reports, choose Tools. Create a Report 'R3' with 'Country' attribute. 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. 4. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Open the Workstation window. Click Close, then "Finish" on the "prepare data" view and save the cube. How to build and manage Intelligent Cubes. Steps to Reproduce. 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. Right-click the cube, and select Schedule. e. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Upload Dashboard. Create. See Importing MDX cubes in the MDX Cube Reporting Help for more information. Create Schema Objects. 9K KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. To Create an Intelligent Cube Using Freeform SQL or Query Builder. Check the location of the new cube cache and notice that it is saved in the default location, i. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Intelligent cube is an OLAP feature introduced in Microstrategy 9 version. An enhancement Request has been reported to the MicroStrategy Technology team. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. For the example scenario, log in to the MicroStrategy Tutorial project. x, create a simple Intelligent Cube with attribute Category and metric Revenue. Right-click an application and choose Properties. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. 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. 1Currently it is not possible to create a cube refresh subscription in Command Manager. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Save as an In-Memory dataset. Intelligent Cube IC2 contains attributes 'Country' and 'Region' Create a report services document with the above 2 Intelligent Cubes as datasets. The cube now has Year and Category on it. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Steps To Reproduce 1. Con: The copy of report data in Intelligence Server memory only applies to a single report. Create a cube report based on the cube. You can use an Intelligent Cube as a dataset, allowing you to use one Intelligent Cube for many different documents, while reducing access to the data warehouse. Navigate to the Intelligent Cube you want to refresh. Check the status of the cubes in Developer. PublishCube". This KB article shows sample code to get the intelligent cube status programmatically with Web SDK. Use the drop-down under the filter summary section to switch the server nodes. Number of Views 1. 2. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. • You need the Publish Intelligent Cube (Developer) and/or Web Publish Intelligent Cube (Web) privileges. Then click "Save". Publish the cube. Before MicroStrategy 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. 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. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. 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. From the. The data used for this example is from a SQL Server 2014 version of the MicroStrategy Tutorial database. From the Data menu, select Configure Intelligent Cube. It also. com Format: A MicroStrategy Online. Click the “Add history list subscription” link near the bottom of the screen to open the. Open the Workstation window. 4. This technical note describes a known issue when creating a data import cube in MicroStrategy Web 10. The Save Intelligent Cube As dialog box opens. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Unable to create Derived Elements in a Report Services document with a dataset that is not based on an Intelligent Cube in MicroStrategy Developer 9. 4. Open the. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. To make the Intelligent Cube available for creating reports, publish the Intelligent Cube by choosing Run Report in the toolbar. Starting in MicroStrategy 10. How to Import Data from a SAP HANA Database Into MicroStrategy Web. From the Report Selection panel, go to the File menu > Open. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. This is the same requirement to create or run a static report in Workstation. In the Refresh Policy column, choose. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. PUBLISH INTELLIGENT CUBE "<cube_name>" IN FOLDER "<location_path>" FOR PROJECT "<project_name>"; 8. The ability to view or edit certain settings is determined by a user's privileges. Right-click the dataset, and choose Schedule. To Create a Report that Accesses an Intelligent Cube. 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. Right mouse click the Intelligent Cube Q, select Schedule Delivery To>History List as shown below: 3. STEPS TO REPRODUCE: 1. Click “All Objects View”. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. CubeServerDefinition, and this folder should be shared as 'ClusterCube'. Import MicroStrategy File. We should ignore the size of the Cube in the Cube Monitor when the Status is "A,F" (Active, Filed). Open the. By default, Intelligent Cubes created through Data Import are saved to the MicroStrategy user's "My Reports" folder. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. 4. Create Schema Objects. There is no need to further create a dashboard. Open the cube report in Design View. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Open the report in Grid View, Design View, or Grid and Graph view. Integrity Manager can test the SQL of Intelligent Cubes even if they. Edit Project-Level Cache and Intelligent Cube Settings. You should see these cubes in the Intelligent Cube cache monitor in Developer. 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. All Intelligent Cube operations are listed below: 1. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 1.