Most likely several, different fact tables are uses for each query. reg file on UNIX/Linux operating systems. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for. Reports include Freeform SQL reports, Query Builder reports, MDX cube reports, and reports that access Intelligent Cubes. UPDATE: the refresh policy is Update existing data. Select the Security Filters tab. Create Cube2 with the Region attribute and the metric created in step 1. Select the data set and click Prepare Data. Required Status to Perform Action. 88K. In the Drilling area, clear the Use default settings check box. Index: P = Processing A = Active L = Loaded D = Dirty F = Filed M = Monitoring Information Dirty When a user executes an Intelligent Cube, the initial status is P. Once an Intelligent cube is created and then published so its data is available, multiple reports can be created to connect to the Intelligent cube. x where duplicate cube instances are created when a cube with a neutral locale gets updated with a multilingual attribute. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent 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. g. Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . For example, an Intelligent Cube includes the. This. Create Cube B which contains all objects in the report and publish it . In MicroStrategy 10. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. iCubes, however, has some limitations and thereby needs to be used judiciously based on the need. The view filter cannot filter out other elements as shown below:Data Modeling. The data used for this example. 86K KB31566: MicroStrategy 9. • Manage a team of 9 Technical Support Engineers who provide advice, solutions, and. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. Defining Memory Limits for Intelligent CubesThis article discusses an issue with DELETE incremental refresh reports invalidly preventing an intelligent cube from being used for dynamic sourcing in MicroStrategy 10. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. All cubes respect the governing setting. The Security Filter Editor opens. 0 MicroStrategy releases. For example, an Intelligent Cube that contains data for the top 200 stores by Profit must be re-calculated every time it is updated, and thus must use the Full Refresh option. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. Open the Workstation window. Under Refresh type, select one of the following options. My complaint is that a lot of the new stuff just works in the "import data into an intelligent cube" model and not the good old metadata. In MicroStrategy, users can trace MicroStrategy Intelligent Cube activity via the Cube Server Trace which can be enabled through MicroStrategy Diagnositcs Configuration as seen below: The following section displays excerpt from the Cube Server trace when different actions are. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. Edit Project-Level Cache and Intelligent Cube Settings. Another way to use caching in MicroStrategy is through Intelligent Cubes. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Create a second report with the year and quarter attributes and the revenue metric. To do so, you can take advantage of URL API. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect Live. 1 and later) • MSI_STATS_LOG (not used in MicroStrategy version 9. The following list summarizes which privileges can be assigned for which user groups: Common privileges: The predefined MicroStrategy Web Reporter and Analyst user groups are assigned the set of common privileges by default. The objects in the source cubes will control how the security filter will be applied. Slice and dice features are awesome. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. 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. x, but not to publish it, the minimum privileges that the Administrator would need to. MicroStrategy Analytics cubes are easy to create and deploy. 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. The data used for this example is. 4. 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. A schedule is defined in Python code. Required Status to Perform Action. The Schedule dialog box opens for your dataset, showing the tables in your dataset. Save the Cube with Connect Live Data Access Mode. 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. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. For more information on security filters, see the System Administration Guide. It remains available, but is not enforced if it is less than the default value of 100000. Select one: To create a new security filter, click New. 2. Use Cube Advisor to create Intelligent Cubes: 1. Modify or remove the view filter to attempt to return data for the report. 1, Intelligent Cubes have a new feature to update information without republishing it. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. Create a report on this intelligent cube with the month attribute and the count of day metric. - Normalize Intelligent Cube data in the. Click the “Add history list subscription” link near the bottom of the screen to open the. 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. 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. Publish the cube. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. 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. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. The data in Intelligent Cubes can be accessed by different Microstrategy objects like Reports and Documents. Whether the report is an Intelligent Cube (see Limiting the Size and Number of Intelligent Cubes). This data can be used to create a dataset or to modify an existing dataset in a Data Import cube. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. In MicroStrategy Developer, log in to a project source with administrative privileges. The Intelligent Cube Monitor is displayed. There's a reason we're at the top of the list. The Intelligent Cube must not be re-processed based on a metric. STG_IS_CUBE_REP_STATS. MicroStrategy AI is here. 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. 3. xThis article describes the Intelligent Cube Population options available in MicroStrategyPlease also see this article for more details: Data Engine changes in MicroStrategy 2021 release Acronym used: "CSI", which stands for "Cube Subsetting Instruction". MicroStrategy 9 ships a new utility called MicroStrategy Cube Advisor to assist in the use of the Dynamic Sourcing functionality in MicroStrategy OLAP Services 9. In addition, multiple logical tables can represent the same physical table. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. Moreover, you can return a data. x Intelligent Cube status indication and workflow . Starting with the release of MicroStrategy 2020 Hotfix 2, two new registry keys are available. To Create a Report that Accesses an Intelligent Cube. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. The **_objects folder with a size of 277G. Before MicroStrategy 10. With MicroStrategy HyperIntelligence, organizations can inject Zero-Click Intelligence about customers, products, people, and more directly into websites or web applications. Intelligent Cubes is a new OLAP Services feature in MicroStrategy 9. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. e. Then it generates a report. The status of each Intelligent Cube is listed in the. 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. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. x. ACTION This. 0. Web Open the Settings page (right click the extension and select Options). 4. 1. 9 and 10. Rather than returning data from the data warehouse for a. log without functional impact. Open the. If you are upgrading to MicroStrategy 11. for a script with several commands, one of which being a cube publication command, the. xKB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. 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. This defect is addressed in MicroStrategy 11. 2. Like cache update subscriptions, Intelligent Cube. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. Open the. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. How to automatically trigger reports to execute after Intelligent Cubes are published or refreshed in MicroStrategy 9. Integer ID of the Intelligent Cube report that was published, if any. MicroStrategy recommends using the binary name (%e), process ID (%p), hostname (%h), and timestamp (%t) for the core file name, as shown below. . In MicroStrategy 10. The Intelligent Cube opens in the Report Editor. Integer ID of the Intelligent Cube report that was published, if any. The interface has changed a bit. This can be seen even when the actual total memory consumption of the Intelligent Cubes loaded for this Project is below the configured Governing Setting. If the New Intelligent Cube dialog box does not open, from the Tools menu, select Developer Preferences. Number of Views 1. IS_CUBE_ACT_ID. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. KB222608: In a clustered environment in MicroStrategy 9. GUID of the Intelligent Cube instance in memory. Import and save data from a file in a folder location. The Full Refresh option is the default. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. Answer: Go with dossier. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. 3. The Intelligent Cube Monitor is displayed. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. xPersonal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. Intelligent cubes support time zone based reporting. x This is a new feature introduced in MicroStrategy version 9. MicroStrategy logical tables do not necessarily represent physical tables. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. . When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. x - 10. Intelligent Cubes. Datasets API. Create Schema Objects. In MicroStrategy Integrity Manager 10. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. Refer to the following MicroStrategy Knowledge Base. 4. ADD: the refresh policy is Add new data. 0 MicroStrategy releases. 4. x or 10. A document that uses the Intelligent Cube as a dataset. To change the intelligent cube status, right-click the Cube in the Cube Monitor, and select one of the actions. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Select one: To create a new security filter, click New. In other words, the new column will NOT get mapped automatically in the existing Intelligent Cube. For detailed information about mobile subscriptions and MicroStrategy Mobile, see the MicroStrategy Mobile Administration Help. From the Data menu, select Add Dataset. Rather than returning data from the data warehouse for a single. For more information on the Intelligent Cube Maximum. Once an Intelligent Cube is created for an MDX cube, reports can be created based on the Intelligent Cube. Navigate to the folder location of the Intelligent Cube. Intelligent Cubes. x. 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)". It is especially useful when data. x in maintenance mode, it is recommended for users to enable the setting Cluster Synch Check Duplicate Cubes through the Windows registry or through the MSIReg. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy 9. This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. Integer ID of the project where the Intelligent Cube is stored. IS_CUBE_REP_ID. The Select Dataset dialog box opens. This can be seen in the screenshot below. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. The cube is based on a MDX datasource, specifically SAP BW. Therefore, the Cache Status is stored in the fact_latest_cube_cache and fact_action_cube_cache tables to track the latest, historical, and changing status over the life of the cube cache instance. Publish the Intelligent Cube by executing it on either of the nodes. Run the report, notice that the filter does not work, all attribute elements pop out, as below picture shown: CAUSE: This is a known issue in MicroStrategy Developer 10. An Intelligent Cube has been created in a project. ACTION:In MicroStrategy Intelligence Server, how does the project configuration setting "Load Intelligent Cubes on startup" work in a clustered environment?To Create an Intelligent Cube Using Freeform SQL or Query Builder. You can create and analyze new reports in real time. the user still needs the privilege for re-publishing Intelligent Cubes, but just need this restricted for particular cubes), while still allowing this user to perform Visual Insight analysis on the cubes information. Extensively used “Apply Simple” function for creating attributes. 5 GB, the Data Transfer from Datasource(s) time is 77. Technically this will result is different queries on the database, due to the fact that each calculation level is different. To enable or disable dynamic sourcing for an Intelligent Cube. In an Intelligent Cube report, only the "Data Population for Intelligent Cubes" will be visible; in standard reports, it will be "Data Population for Reports. By default, this is set to 32,000. The related section is located in. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. Create an intelligent cube with Category, Subcategory and Year in rows and Revenue and Cost in columns. Download the files from the MicroStrategy download site. Share query results in-memory across multiple dossiers and reports. This allows for more power and control over data for MicroStrategy. The article discusses a known situation in MicroStrategy 10. Click the MicroStrategy icon at the upper left of any page and select History List. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 4. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. x - 10. A value of 0 means that cache, History List messages, and Intelligent Cubes are backed up immediately after they are created. 1 or above, to pick up the fix, enable project level setting "Data Engine. 3. Create a report with this Intelligent Cube and execute the report --> one row with 4 element returned. The change journal logs now process the type, version, and name for databases configured in an environment. 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. 8. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. Um Cubes zu erstellen, müssen Sie über die folgenden zusätzlichen Privilegien verfügen: Verwenden Sie den Intelligent Cube Editor, um auf alle Merkmale und Funktionen zum Erstellen von Cubes zuzugreifen. Limited mobile capabilities compared to the latest BI tools like MicroStrategy. In a MicroStrategy Intelligence Server cluster environment, Intelligent cubes don’t load on remote nodes when the node which published the Intelligent cube has been shut down normally, and cube based reports can’t be run . x using Command Manager. Choose Databases. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The Intelligent Cube Options dialog box opens. By default, MicroStrategy Command Manager handles cube publication synchronously (i. MicroStrategy AE, even when the data is coming from an intelligent cube, MicroStrategy still needs to calculate the derived elements and depending on the data size and complexity sometimes these calculations can take minutes. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. The Object Intelligent Cube the Microstrategy don't represent correctly this cubes and It save in-memory. 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. You must belong to the System Administrators group to use this feature. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. This Python 3 / MicroStrategy 10. Node 2. Scalable Analytics. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). Subsequently the requests made by other users can seamlessly hit this new intelligent cube. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. For ASCII characters, non UTF-8 encoding uses two bytes to store one character, while. 3. Along with. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. The Full Refresh option is the default. Export data frames from RStudio to MicroStrategy in-memory cubes. However, a lot of the advanced functionality requires the good old metadata, and having everything cubed means you will need a shit ton of RAM very quickly. This is a known issue with Data Import functionality in version 10. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. exe file. 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’. This can improve the performance of. Cube Limitations. In MicroStrategy Developer, right-click on the project and select Project. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Documents . Save the Report and close. 2. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. 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. In the left panel, click Cubes. This dataset needs to contain all data in the required granularity. This is the same requirement to create or run a static report in Workstation. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Built by MicroStrategy, a worldwide leader in enterprise analytics and mobility, the. Slice and dice features are awesome. Select data population for Intelligent Cubes. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report. The aim of this KB is to have a look at the Live connected intelligent cubes performance considerations as it’s necessary to understand how many steps are involved in the process, of course each step consumes time, hence the more steps the more time will take a dossier to. KB442630: CSI optimization for improving the in-memory query execution for many. Most likely several, different fact tables are uses for each query. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. The. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. x - 10. In this case, the dataset is a MicroStrategy Intelligent Cube. There are several disadvantages: Redundancy on this table affects several processes later on: for example, the transfer over the network and the amount. 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. x. Replace Old data is completely replaced with new data, retrieved by executing the current Intelligent cube, using its current template and filter. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. Introduction. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. @Luba Levin (Support Liaison) (Customer) You still do have the ability to define a dataset as "Live Connect" in MicroStrategy 2020. The governor should be increased to 100GB (to ensure no cube will be swapped out) and you should flush the OS cache frequently. If the Intelligent Cube must be re-processed based on a metric. The New Intelligent Cube dialog box opens. For reports and Intelligent Cubes that do not use MultiSource Option or database gateway support to access multiple data sources, all queries are processed sequentially. 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. 143; asked Oct 2, 2014 at 14:58. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. 3. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. x a new concept is introduced called Intelligent Cubes. However, if the. MicroStrategy Analytics cubes are easy to create and deploy. To review and create recommended Intelligent Cubes using Cube Advisor. Die Abschnitte „Editor“ und „Filter“ sind standardmäßig gestapelt. Changes in MicroStrategy 2020 Starting in MicroStrategy 2020, unused cube indexes are swapped to disk instead of being dumped from memory. It is recommended that the Excel file size should not exceed 1GB. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. You can edit project-level cache and Intelligent Cube settings. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super cube. 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. Create an Intelligent Cube with this attribute and publish. Navigate to the Intelligent Cube for which you want to define the incremental refresh. MicroStrategy logical tables do not necessarily represent physical tables. If the indexes are needed again,. Intelligent Cube update subscriptions retrieve the most recent information for an Intelligent Cube from the data warehouse and then publish that Intelligent Cube. 0 votes. Required Status to Perform Action. Intelligent Cube storage on disk mirrors report cache storage. Select the Security Filters tab. x, the user can compare the SQL generated for both Intelligent Cubes and Data marts. location_path: is the folder where the intelligent cube. Moreover, you may generate among the various reports of many users. Number of Views 8. SYMPTOMS: After duplication of a project in Developer that has a user-defined Intelligent Cube cache location, Intelligent Cubes created within the new project are not saved to the location specified in Intelligent Cube File Directory in Project Configuration. 79K. Navigate to and select the report or Intelligent Cube to use as the dataset, then click OK. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. Following are the features, which make intelligent cubes useful. Intelligent Cubes are multidimensional cubes (sets of data) that exist on the MicroStrategy Intelligence Server memory and can be shared among different users. 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. HyperAndroid Go to the Account tab. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. microstrategy. This dataset needs to contain all data in the required granularity. 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. Use Case 4. What happens during the two timestamps for MicroStrategy Intelligent Cube 9. GUID of the Intelligent Cube instance in memory. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. Choose File > New > Intelligent Cube. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. In addition, multiple logical tables can represent the same physical table. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. Edit Intelligent Cubes from the new editor in Workstation at any time. For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. CAUSE. STEPS TO REPRODUCE: 1) Add external dataset. This import bridge imports MicroStrategy logical tables as Dimensions. You can control users' access to data with security filters. To change these behaviors, see: Publishing Intelligent Cubes Without Loading Them into Intelligence Server Memory Loading Intelligent Cubes when Intelligence Server Starts If. Job ID for the action on the Intelligent Cube. The display of data is handled by the reports that access the Intelligent Cube. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many different reports created by multiple users. Click View Logs, to display the share icon in the upper-left. Republish the same cube, and a new cube instance is generated. x Dynamic sourcing extends the accessibility of Intelligent Cubes by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements. Maintaining data access security. x. In MicroStrategy 10. See full list on community. MicroStrategy Tutorial is used in this example. Use the drop-down under the filter summary section to switch the server nodes. In addition, multiple logical tables can represent the same physical table. . On the left side of the page, click Logs and then Export Logs to save the file. 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. An Intelligent Cube is a.