x - 10. The dataset is a set of data that can be displayed on the document. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. The. x and newer. Intelligent Cubes must be stored in Intelligence Server memory for reports to access their data. Intelligent Cubes. Designing and creating documents: An overview. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for the memory available on Intelligence Server machine. In certain situations users may want to configure success and failure notifications for the scheduled refreshes of Intelligent Cubes that are created through Data Import in MicroStrategy Web. Maintaining data access security. 3. Intelligent Cubes are multidimensional cubes (sets of data) that exist on the MicroStrategy Intelligence Server memory and can be shared among different users. To review and create recommended Intelligent Cubes using Cube Advisor. The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Providing Intelligent Cube data. For example, you have three projects and you set their Maximum RAM usage (Mbytes) limits to 1 GB, 1 GB, and 2 GB. iCubes, however, has some limitations and thereby needs to be used judiciously based on the need. Starting in MicroStrategy 10. 2. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. MicroStrategy tests on at least one of the CPU chipsets within a set of binary-compatible CPU architectures for purposes of certifying and supporting operating systems with MicroStrategy products. Number of Views 1. Designing and creating documents: An overview. com. In MicroStrategy Analytics Enterprise Web 10 onewards, users can now simultaneously import two or more tables from one or more supported data sources, this feature is called Multi-Table Data Import (MTDI) which has been renamed as Super Cubes in MSTR 2019. 2. Create the MIN (CurrentDateTime ()) metric. 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. 9 and 10. The ability to view or edit certain settings is determined by a user's privileges. Slice and dice features are awesome. This is controlled by the Python script. Technically this will result is different queries on the database, due to the fact that each calculation level is different. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. When you first click on "Add External Data" and a list of connectivity options come up, there is now a small icon at the top left, that allows you to filter the connections for those that support Live Connect. The Intelligent Cube refresh settings change the way the Intelligent Cube is updated when you re-execute it manually, or when it is published on a schedule, as described in Publishing Intelligent Cubes using a schedule. IS_CUBE_ACT_ID. For detailed information about mobile subscriptions and MicroStrategy Mobile, see the MicroStrategy Mobile Administration Help. x - 10. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. If desired, user can create a dashboard immediately from the imported data. Maintaining data access security. To do so, you can take advantage of URL API. Solution This issue has been addressed in MicroStrategy 2021. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. This can. The prompt is applied on top of an attribute that is part of the cube and shows correct behavior when used by normal reports, hitting the warehouse or an Intelligent Cubes by means of dynamic sourcing. 1. First, you open a blank document and select a report to use as the document's dataset. Moreover, you may generate among the various reports of many users. x using Command Manager. The Object Intelligent Cube the Microstrategy don't represent correctly this cubes and It save in-memory. Providing Intelligent Cube data. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. Cube Advisor opens. 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. Described as “Caches on Steroids”, it’s basically the ability to pre-cache data that can then be queried. Most likely several, different fact tables are uses for each query. 4. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. To do this, edit the report in developer and go to the Report -> Data->Intelligent Cube Options->Point grid to Intelligent Cube and choose the new target cube: Create Cube A and a report based on it. 06K KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. An Intelligent Cube publication takes significantly long to complete publication (several hours). We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. For an overview and steps to add a dataset to a dossier, see Adding and removing datasets from a dossier. Create an Intelligent Cube with attributes Year, Month and Region; 4. It will remain available, but the setting will not. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. “1:M relationship in the project but M:M relationship as per data in Intelligent Cube” pertaining to Platform Analytics project appears in DSSErrors. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). This applies for example to Cubes created via MicroStrategy Web client. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. Intelligent Cube update subscriptions retrieve the most recent information for an Intelligent Cube from the data warehouse and then publish that Intelligent Cube. zip file, with the. The Intelligent Cube must be published before this report can execute. Share query results in-memory across multiple dossiers and reports. The Maximum RAM usage (Mbytes) memory limit can be defined per project. x If the Administrator wants to create a user that is only allowed to create an Intelligent Cube from a grid report in MicroStrategy Developer 10. E. The Security Filter Editor opens. Select the Security Filters tab. . 3. Log on to the machine where you are installing one or more MicroStrategy products. 3. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. You can remove the system hierarchy and add your own attributes into the template and include specific attribute forms for caching. Drill up, down, and sideways to get a 360-view of. Recorded at World 2021. You must belong to the System Administrators group to use this feature. To enable or disable dynamic sourcing for an Intelligent Cube. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. You can use. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect Live. It manages high performance interactions involving terabytes of data and tens of thousands of users by leveraging in-memory intelligent cubes, caching, load balancing, resource prioritization, and connection pooling. The display of data is handled by the reports that access the Intelligent Cube. x This is a new feature introduced in MicroStrategy version 9. View reports against Intelligent Cubes in MicroStrategy OLAP Services have the ability to add filtering qualifications into Cube Subsetting Instructions, including security filter qualifications. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. In MicroStrategy 10. Die Abschnitte „Editor“ und „Filter“ sind standardmäßig gestapelt. 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. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. They can save you time and make your Intelligent Cubes more effective for your reporting environment: Define your business query: Before you can determine what objects to place on an Intelligent. Intelligent Cubes can be based on MicroStrategy data or imported data. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. The Incremental Refresh Options dialog box opens. On the left side of the page, click Logs and then Export Logs to save the file. Run sudo vi /etc/sysctl. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. x. You can also view Intelligent Cube information for a specific Intelligent Cube, by double-clicking that Intelligent Cube in the Intelligent Cube Monitor. This issue has been classified as a defect by MicroStrategy. KB222608: In a clustered environment in MicroStrategy 9. The objects in the source cubes will control how the security filter will be applied. The data used for this example is. This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Integer ID of the project where the Intelligent Cube is stored. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. • IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes; available in MicroStrategy 9. Select the Allow reports to drill outside the Intelligent Cube check box. The following diagram depicts the role of the intelligent cube. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). In versions prior to MicroStrategy Intelligence Server 9. 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. Run the Report and check the SQL View. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. Choose File > New > Intelligent Cube. In the Drilling area, clear the Use default settings check box. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. While this can improve performance of these reports. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Easily add or change pre- and post- SQL statements. You can control users' access to data with security filters. When an Intelligent Cube is in this status, any reports based on this cube have. The interface has changed a bit. The default value is 256 megabytes. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. Check the status of the cubes in Developer. A metric in the Intelligent Cube reports fact data based on an attribute related to one in the security filter: The user's security filter prevents any data from being returned. 2, it is possible to load an Intelligent Cube into memory on all the nodes of the cluster, after the Intelligent Cube finishes publication on one node. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). The Intelligent Cube “xxx” for locale <German (Germany)>has not been published. Pros and Cons. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. If a new column is added to the data import data source and the cube is republished, there is no effect. With MicroStrategy HyperIntelligence, organizations can inject Zero-Click Intelligence about customers, products, people, and more directly into websites or web applications. x and newer. MicroStrategy Intelligence Cube. CAUSE. With the release of MicroStrategy HyperIntelligence for Office in 2019 Update 2, MicroStrategy has identified a few known limitations with the product on both the browser version of Outlook and the desktop version. 3. Dynamic Sourcing is a new feature of MicroStrategy 9 OLAP Services that automatically checks a report request, and sources data from a MicroStrategy Intelligent Cube wherever possible. You may share the Intelligent Cube as a single copy in memory. 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. You can use Integrity Manager to perform a before and after test to identify which reports actually connect to a suggested Intelligent Cube and also to test data integrity. A workaround is available in the current document. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. These VLDB properties control the method by which the report data are normalized. Most likely several, different fact tables are uses for each query. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). 2. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. NOTE: There is an inherent limit specific to importing Excel files due to using an internal Java component to extract the data from Excel files. To build an Intelligent Cube. 5. Create a Report 'R3' with 'Country' attribute. To customize your filename, please refer to the man page of core(5). Intelligent Cubes are a more aggressive form of caching and allow multiple reports to be stored in the Cube (which is effectively a large cached report stored in memory on the. 0 MicroStrategy releases. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). A filtered attribute element list prompt appears empty when used inside a report mapped directly to an Intelligent Cube. The Schedule dialog box opens for your dataset, showing the tables in your dataset. In MicroStrategy 9. Scenario you prefer iCube and Cache : I Cube is preferred when we have large amount. For more information about Dynamic Sourcing and its limitations, refer to the following TechNote:. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. From the Data menu, select Configure Intelligent Cube. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). This data is to apply the calculations. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. The underlying cause comes from a miscalculated governing setting which incorrectly prevents new Data Import Intelligent Cubes. 4. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. Create an intelligent cube report with Year and three derived metrics and enable "Aggregate from base" as shown below: Insert view filter "Year in list (2009)". What happens during the two timestamps for MicroStrategy Intelligent Cube 9. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. Constant Value: 220 (0x000000dc)When enabling the option to "Fetch data slices in parallel from the warehouse" from the Intelligent Cube Options > Data Partitions menu, TPT is required to be disabled on the database side when using Teradata as a Warehouse. This folder needs to be shared as 'ClusterCube'. The Cubes are modeled with a built-for-purpose modeling thus requiring additional schema work instead of directly leveraging the already-built schema model MicroStrategy Cube Advisor recommends and automatically creates an optimal set of in-memory cubes based on usage patterns for different users accessing the BI system. Navigate to and select the report or Intelligent Cube to use as the dataset, then click OK. Drag and drop the objects into the report grid from the Report Objects pane. Moreover, you can return a data. Create Cube B which contains all objects in the report and publish it . With OLAP Services features, your report designers can create Intelligent Cube reports. If you have multiple projects that are hosted from the same Intelligence Server, each project may store Intelligent Cube data up to its memory limit. The Intelligent Cube is opened in the Report Editor. Intelligent Cube IC1 contains attribute 'Region' and metric 'Cost'. Alternatively, you cannot create a card based on a live-connect MDX/SAP 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%. 2. This defect is addressed in MicroStrategy 11. This Knowledge base article describes limitations in using security filters and intelligence cubes. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. In MicroStrategy Desktop 9. 143; asked Oct 2, 2014 at 14:58. • Manage a team of 9 Technical Support Engineers who provide advice, solutions, and. Because the filters are applied to the master data in the Intelligent. location_path: is the folder where the intelligent cube. The following table summarizes the test results of some test scenarios against Oracle 19c. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Refer to the following MicroStrategy Knowledge Base. If the indexes are needed again,. Job ID for the action on the Intelligent Cube. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. x. Since an Intelligent Cube is structured similarly to a Relational Database the method of retrieving data from the Intelligent Cube, Cube Subsetting Instructions, is very similar to. Enable core dumping. If the Intelligent Cube must be re-processed based on a metric. The related section is located in. When using an Intelligent Cube, you already have an in memory dataset. Browse to the filter you want to convert and click Open. In the left panel, click Cubes. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. Dossiers automatically adjust to look great on any screen. 0. Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference. This knowledge base article assumes that the user has a month attribute whose format is YYYYMM as shown below and s/he wants to delete more than 12 months’. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Intelligent Cubes. 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. Use Case 4. Choose File > New > Intelligent Cube. By default, there is a system hierarchy on the cube. Click View Logs, to display the share icon in the upper-left. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. This article describes a known limitation where users are unable to republish a data import intelligent cube for dashboards or dossiers that were created in MicroStrategy Analytics Desktop with an In-Memory data set and a DSNless connection after being imported into MicroStrategy Web 10. with MicroStrategy ONE Building Prompts to Enable User Input Improving Performance with Intelligent Cubes Preparing Complex Data for Enhanced Storytelling Creating Workflows for Efficient Storytelling Designing Documents Building Enterprise Mobile Applications. Introduction. In addition, multiple logical tables can represent the same physical table. exe file. Under Refresh type, select one of the following options. IS_PROJ_ID. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. Create a Data Import Live Intelligent Cube. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. From the Data menu, select Configure Intelligent Cube. Choose your environment, project, and Intelligent Cube as your dataset type. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Users of Intelligent Cubes in MicroStrategy 9. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. mstr file is actually a . . For example, an Intelligent Cube that contains data for the top 200 stores by. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. HyperAndroid Go to the Account tab. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. Node 1. This is the same requirement to create or run a static report in Workstation. Use Cube Advisor to create Intelligent Cubes: 1. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. 4. x. Once activated, the user loads the cube in memory. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. 6 and higher. Modeling is creating information that describes another set of data. This is helpful in querying curated data easily with cubes versus directly executing against the data warehouse. Intelligent Cubes. MicroStrategy HyperIntelligence is the next step in the future of data analytics. Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. When I am creating my microstrategy cube connection to this Postgres Database, I am unable to see this Materialized View. By profiling the Intelligent Cube publication (as per KB30699 - How to measure the Intelligent Cube performance parameters for time and memory in the MicroStrategy Intelligence Server 9. x. 2) Choose "Database" and select the 3rd option to "Pick tables". Type of action against the Intelligent Cube: •However, Intelligent cube publishing performance may be affected with the agent enabled. In a MicroStrategy Intelligence Server clustered environment, it is observed that dynamic sourcing does work against Intelligent Cubes available on a remote node, after updating the schema. The New Intelligent Cube dialog box opens. By default, MicroStrategy Command Manager handles cube publication synchronously (i. 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. Provides the last cube row count. x Enterprise Manager, running the out-of-the-box report "Intelligent Cube Usage Statistics". This allows for more power and control over data for MicroStrategy. Dossier Datasets do not include all the Security Filter attributes, and one of the Datasets are Connect Live Data Import Dataset, it may have security concerns. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. x) • MSI_STATS_PROP (properties table that MicroStrategy Intelligence Server uses to initialize statistics logging) • IS_SESSION_STATS (server session statistics)In MicroStrategy Developer, select the Empty Attribute Form Caching Intelligent Cube template when creating a new Intelligent cube. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. "The following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. This template includes the following tasks: Creates a new metadata. Dynamic Refresh: The Intelligent Cube's filter is. To view this field, the Intelligent Cube must be published at least once. * MicroStrategy does have support for dynamic sourcing with MDX sources. What BO customers are interested in knowing 3A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. In the Data Source column, select the checkboxes for the tables to update. The Security Filter Editor opens. To Create an Intelligent Cube Using Freeform SQL or Query Builder. x? To answer this question, the "Query Engine finish time" is marked when the warehouse query step for generating the Intelligent Cube finishes. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Mclean, Virginia. 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. This means you can manually change the suffix to . KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy 9. 4. This is due to the fact that adding prompts to Intelligent Cubes is not supported. Right-click an Intelligent Cube and select Delete. Report: The results of a report are used to populate the Intelligent Cube. These reports allow data to be returned from the data. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. More specifically, the amount of RAM the machine has available when the intelligent cube gets created during In-Memory Data Import. for a script with several commands, one of which being a cube publication command, the. Creating an Intelligent cube is similar to creating a report. This KB answers a question regarding memory limitations for In-Memory data import for MicroStrategy 10. The Intelligent Cube opens in the Report Editor. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. Click the “Add history list subscription” link near the bottom of the screen to open the. However, if the. OR, to convert an existing filter into a security filter, click Import. Open the. The **_objects folder with a size of 277G. x restart, irrespective of if the Intelligent cube belongs to that node or to a remote node in the cluster. This data can be used to create a dataset or to modify an existing dataset in a Data Import cube. If the New Intelligent Cube dialog box does not open, from the Tools menu, select Developer Preferences. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 5 GB. The Intelligent Cube Monitor is displayed. It will remain available, but the setting will not be enforced if set below the default value of 100000. Both properties are located in the Query Optimizations folder in the VLDB property editor. Article Reference Number:The memory used by Intelligence Server is limited by the machine's virtual memory. 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:. 19K KB483298: Important Note on Upgrading Enterprise Manager Statistics and Warehouse from 10. You can add data for your Intelligent cube by including objects such as attributes, metrics, filters, and so on, as report objects or report filters. Since Intelligent Cubes function simply as. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. Data in Intelligent cubes can be either marked as available for time zone conversion when running objects against it or set within a specific time zone. IS_CUBE_REP_ID. An Intelligent Cube has been created in a project. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. When a machine runs out of virtual memory, processes on the machine are no longer able.