1 and 10. An Intelligent Cube has been created in a project. Vn (with metric Mn from source cube Cn). Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Configure metric aggregations, null handling, indexing, and more. Interested in learning more about Platform Analytics or new MicroStrategy features? Visit the Learning Center on Community! Or feel free to visit our Documentation pages for product information. 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. Navigate to the folder location of the Intelligent Cube. Notice that "Project" and "Intelligent Cubes" results are blank: CAUSE: This is a known issue in MicroStrategy 10. Navigate to the folder location of the Intelligent Cube. In MicroStrategy Developer, browse to an Intelligent Cube. x Intelligent Cubes depends on the attribute(s) in the security filter being on the template of the Intelligent Cube. To do so, you can take advantage of URL API. Object Migration Best Practices. This property can only be enabled through Workstation. With OLAP Services end users can add or remove report objects, add derived metrics and modify the filter -- all with speed-of-thought response time against Intelligent Cubes. This returns results much faster than querying the data warehouse. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Interested in learning more about Platform Analytics or new MicroStrategy features? Visit the Learning Center on Community! Or feel free to visit our Documentation pages for product information. You can edit project-level cache and Intelligent Cube settings. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Defining the partition for Super Cubes. Reporting on Intelligent Cubes also allows you to use all of the OLAP Services features, including derived elements, which allow you to group attribute elements in a report on. To improve the performance, MicroStrategy Intelligence Server can be configured to use shared memory resources. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. 1 and 10. 1 or above, to pick up the fix, enable project level setting "Data Engine Version" to 11. 4. Results 1 - 20 of 100 What are the feature flag options and what do they accomplish in MicroStrategy Web 10. Run the Report and check the SQL View. KB486140 | Knowledge Article | 23 Views | Jul 27, 2023. Currently, project duplication does not involve Intelligent Cube File Directory. 0. The Intelligent Cube Options dialog box opens. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Using Database Write-back Functionality to Enable Decision-Making. Main features of mstrio-py allows to access MicroStrategy data: Connect to your MicroStrategy environment using Connection class (see code_snippets) Note: to log into Library and use mstrio-py user needs to have UseLibrary privilege. All necessary privileges are included in the Administrator role by default. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. By default this is set to 256 megabytes. Due to data privacy considerations, MicroStrategy doesAs the new default monitoring tool for the MicroStrategy platform, Platform Analytics has a slightly different attribute structure to Enterprise Manager. KB30713: Data outside a user's security filter are indirectly available through set qualifications used in Intelligent Cubes in MicroStrategy OLAP Services; KB30714: Handling of security filters with multiple qualifications applied to Intelligent Cube view reports in MicroStrategy OLAP Services; Article Reference Number: KB99998 In the Navigation pane, click Monitors. Localizing Intelligent Cubes in multiple languages. CSI after fix:What is a cube in Microstrategy? Intelligent Cubes: A shared Intelligent Cube (called 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. Limit data to specific values: Filters 4. 11. 1 and 10. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as. In MicroStrategy Developer, locate the Intelligent Cube that needs to be refreshed. We empower you with the skills to get the most out of your analytics investment. 4, MSTR file is an available export format for individual Visual Insight dashboards from MicroStrategy Web and MicroStrategy Desktop. This data can be used to create a. Exporting a document or report to PDF, plain text, Excel spreadsheet, or XML . In the Data Source column, select the checkboxes for the tables to update. In MicroStrategy Developer, log in to a project source with administrative privileges. Drag and drop the objects into the report grid from the Report Objects pane. In MicroStrategy Web 9. 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. Hear from Jeff Stitzel, Business Intelligence Architect at eBay, as he discusses big data migrations, intelligent cube use cases, and cube optimization techniques with MicroStrategy. However, Intelligent cube publishing performance may be affected with the agent enabled. Publish the specified Intelligent Cube to the Intelligence Server, so that it can be used by reports. Intelligent Cube data can also be stored in secondary storage, such as a hard disk, on the machine hosting Intelligence Server. To schedule an Intelligent Cube to be updated. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. Save the workflow in . Business users might not want MicroStrategy to build any M:M Relationship tables while publishing the Intelligent Cube In-Memory due to the following reasons: 1) It distorts the actual relationship between a tuple of 3 or more attributes related to each other through M:M relationship in Project Schema by creating individual tables and joining. The Intelligence Server brings the live-connect intelligent cube definition from the metadata and analyzes the information requested from that definition. To create an Intelligent Cube using the Freeform SQL Editor, select Use Freeform. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. Reproduce Steps Definingderivedelementfunctionalityandformatting 156 Interactionwithotherreportingfeatures 169 6. 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 view the following information in the Intelligent Cube Monitor: Cube Report Name: The name of the Intelligent Cube. The New Grid dialog box opens. In versions prior to MicroStrategy Intelligence Server 9. Intelligent cubes are generated automatically when a new report is run against the data warehouse. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded. For more information, see. In addition to creating reports directly, you can use the Freeform SQL Editor or Query Builder Editor to create an Intelligent Cube. 4. Main Features. INTELLIGENT_CUBE_MAX_RAM: The maximum size in memory of all Intelligent. x. To Create an Intelligent Cube Using Freeform SQL or Query Builder. Choose File > New > Intelligent Cube. Drilling is allowed within an Intelligent Cube for quick-response MOLAP analysis. In addition to creating reports. The. x clustered environments. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. You can also apply this security when users create reports that connect to an Intelligent Cube. The History List folder is displayed, with a list of dossiers, documents, reports, and Intelligent Cubes that have been added to the History List. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. An Enhancement Request for implementing this functionality is. You can control users' access to data with security filters. To display PDF bookmarks with the correct font, the language pack must be installed on the viewer's machine. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. 4. Create a report based off the cube in Step 1 that includes the description form for Category. From the CatalogCube drop-down list, select the MDX cube to create training metrics for. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Reports include Freeform SQL reports, Query Builder reports, MDX cube reports, and reports that access Intelligent Cubes. mstr file is too large. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. Starting in MicroStrategy 10. Once an Intelligent Cube is stored in Intelligence Server memory, multiple reports can be created to view and analyze the set of published data. Select or clear the Load Intelligent cubes on startup check box to enable or disable loading Intelligent Cubes when Intelligence Server starts. 4. In MicroStrategy Developer, log in to a project source using administrative privileges. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. • Reports can consist of documents with customized HTML format. Export to PDF filter summaries include the full attribute and metric. On the ODBC Sources tab, in the Source area, select the database instance that connects to the data source to report on using Freeform SQL or Query Builder. The Full Refresh option is the default. For more details on enabling the setting, refer to Change Data Engine Version. 6. There is a distributed database for the MicroStrategy metadata and. Every time that a user does something in MicroStrategy, like. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. This technical document covers a known issue affecting MicroStrategy Secure Analytics Enterprise 10. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Using OLAP Services, you can perform the same multidimensional analysis whether you use MicroStrategy Developer, Office, or Web. From the ‘Federated Analytics’ product category, deploy the following products to relevant users and connect them to. Select the Data Partition category. Comparing OLAP and MTDI cubes. in MicroStrategyIntelligence ServerCube<Server_Definition_Name>. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. About this book. In MicroStrategy Developer, log in to a project source with administrative privileges. Share query results in-memory across multiple dossiers and reports. 0, to pick up the feature, enable project level setting "Data Engine Version" to 11. Select to move project-related objects, administration objects, or merge entire projects together. 0 MicroStrategy releases. The ability to view or edit certain settings is determined by a user's privileges. MicroStrategy 9. •. A user logged in to a MicroStrategy Intelligence Server. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. KB19654: How to obtain the Report Execution. 1 and 10. In terms of intelligent Cube indexes, there are mainly two types: True Level Index, All Level Index (also known as Main. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. In the left pane, click All Settings. Expand Intelligent Cubes, and then select General. This data can then be shared as a single in-memory copy, among many different reports created by multiple users. Same datasets available for MicroStrategy and TableauCan also be leverage in other analytic applications like SAS and RNo 2 billion row limit. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. x. x releases, and the new Multi-table Data Import (MTDI) cubes. 1) Right click the intelligent cube and select Properties -> Security . For instance, let’s say you have an Intelligent Cube with 2 million rows and 10 attributes and 5KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Select an Environment from the upper-left drop-down. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. 2015-06-04 MicroStrategy Product Manuals 2015-02-01 MicroStrategy Product Manuals The OLAP Services Guide covers information on MicroStrategy OLAP. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. The following project governing settings are being retired beginning with MicroStrategy 2020 Update 1. A report accessing the Intelligent Cube includes only Year on the report. An Intelligent Cube is a set of data that can be shared as a single in-memory copy among many. The Intelligent Cube Monitor is displayed. To publish an Intelligent Cube, see. You can update and modify the document in Design View. 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. Right-click an Intelligent Cube and select Delete. Right-click an application and choose Properties. However, you cannot create a card based on a live-connect MDX/SAP cube. 4. The Intelligent Cube “xxx” for locale <German (Germany)>has not been published. x-2021 Update 1 in a clustered Intelligence servers environment, the following message is seen. Save the Report and close. This issue was reviewed by our Technology team for feasibility and will not be scoped for a code fix in any upcoming MicroStrategy release. The Intelligent Cube must be published before this report can execute. KB440822. Publish the cube. OLAP cubes make it easy to answer additional questions that will drive strategy with near-instant analysis of large amounts of data. The Intelligent Cube opens in the Report Editor. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. MicroStrategy Intelligence Server . " If you try to edit these MicroStrategy Connector cubes, you may be asked to log into the Library server. 1 and 10. Afterwards the cube will start executing. From the Data menu, select Configure Intelligent Cube. This has been fixed in. This section contains the following information: Managing Intelligent Cubes: Intelligent Cube Monitor Governing Intelligent Cube Memory Usage, Loading, and Storage The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. Publish the Cube, and create the following Dossier:. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. "The cube can be either an Intelligent Cube or a DDA(Direct Data Access)/MDX-based Live Connect cube. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a. In Developer, log in to a project with a user account with administrative privileges. x CAUSE: The user is missing the "Administer Subscriptions" privilege under "Administration" in. MicroStrategy Intelligent Cubes Eliminate the Need to Maintain a Proprietary Cube Environment and Redundant Hardware and Databases In order to provide BI functionality, many vendors use proprietary cubes, which require additional hardware storage 7 4%: Breakdown of TCO for IT Infrastructure workloads over a five-year period. With OLAP Services features, your report designers can create Intelligent Cube reports. Administer Caches. The "Refresh Cube Subscription Editor" allows for a "Name", "Schedule", and "Delivery Notification" to be set. You can add data for your Intelligent. Published: 4월 6, 2017. Learning Resources. " If you try to edit these MicroStrategy Connector cubes, you may be. However, Intelligent cube publishing performance may be affected with the agent enabled. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. This article also provides a workaround to avoid this behavior. Indicates a user exported a view report or a cube-based document or a cube-based dossier to PDF and hits the cube cache. MicroStrategy Intelligent Cube Technology allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Defining Intelligent Cube refresh settings. blogspot. In MicroStrategy Developer or Web, log in to a project that contains reports connected to active Intelligent Cubes. You can find this setting in the Intelligent Cube editor > Data > Configure Intelligent Cube > Data Partition. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. and background information on Intelligent Cubes is in the MicroStrategy In-memory Analytics Help. For detailed information about Intelligent Cubes, see the In-memory Analytics Help. com Format: A MicroStrategy Online Training Video blog. LIST PROPERTIES FOR INTELLIGENT CUBE CACHE (NAME "<intelligent_cube_name>" | GUID <instance_guid>) FOR PROJECT "<project_name>"; An enhancement request has been raised to have the ability to use “cube as trigger”. The Intelligent Cube Options dialog box opens. Intelligent Cubes are part of the OLAP Services add-on to Intelligence Server. 5 GB, the Data Transfer from Datasource(s) time is 77. 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. bat format. 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. Sie können Daten für Ihren Intelligent Cube hinzufügen, indem Sie Objekte wie Attribute, Metriken, Filter usw. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. Together with the Reports API, this API is often referred to as the JSON Data API. Creating an Intelligent cube is similar to creating a report. • MicroStrategy Intelligence Server (IS) allows threads with different priority and may be based on cost and other application factors. metrics in the intelligent cube or in the MicroStrategy schema and application objects. You must belong to the System Administrators group to use this feature. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. 1, Windows 2003 and UNIX. pdf", Dynamic Sourcing -> Best practices for supporting dynamic sourcing -> Dynamic Sourcing for Incrementally refreshed Intelligent Cubes On the toolbar, choose Data > Configure Intelligent Cube. This can be seen in the screenshot below. The New Intelligent Cube dialog box opens. g. * Details on 2 possible causes for connectivity issues preventing the publication of Platform Analytics Intelligent Cubes. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Click the “Add history list subscription” link near the bottom of the screen to open the. When using the default array size of 60,000 (60KB) and publishing an Intelligent cube with a cube size of 1. In HTML View and PDF View, a dashboard is displayed as a static document. Intelligent Cubes. 4. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. 4. In MicroStrategy Developer, log in to a project source with administrative privileges. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. 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. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. For more information on how to integrate with Oracle OLAP cubes contact MicroStrategy Consulting. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. 0. An Intelligent Cube is a. The following table summarizes the test results of some test scenarios against Oracle 19c. For example, the attributes Year and Region and the metrics Cost and Revenue are included in the Intelligent Cube shown in the image above. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. From the Data menu, point to Intelligent Cube Options, and select Convert to Intelligent Cube. The objects in the source cubes will control how the security filter will be applied. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. This image shows a cube with three dimensions (though really, the number of dimensions that can be contained within a cube are limitless): products, customers (by country) and posting date (year). 3 - Check the Make Intelligent. MicroStrategy Developer, Web, and Office users can slice and dice data in reports within Intelligent Cubes without having to re-execute SQL against the data warehouse. 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. Privilege. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. The Query Engine runs the SQL required to refresh the data in the Intelligent Cube. The procedure below provides the steps to manually publish an Intelligent Cube. When using Intelligent cubes, there is an option available to support connection mapping with the use of cubes. KB441285: Optimization for the Intelligent Cube Data Structure at the time of publication. This command will list the table information only when the intelligent cube is a super cube. In the Navigation pane, click Applications. Both products' features range. 56K. x. Information to use MicroStrategy OLAP Services features, including Intelligent Cubes, derived metrics, derived elements, dynamic aggregation, view filters, and dynamic sourcing. Go to the "All Objects View" option in the top left corner. Intelligent Cubes can be partitioned,. 3. Slice and dice features are awesome. This privilege is part of OLAP. Right-click the report and select Edit. To plan for. You create Intelligent Cubes and publish them as a shared data source for the users to build reports from. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. 1. Create Cube1 with the Region attribute and the metric created in step 1. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. File subscriptions save the report or document as an Excel or PDF file to a disk location on the network. Users don’t have to mention the cube to which they want to connect. 4. This enables the development of datasets via data importing, instead of creating and modifying each new dataset from scratch. Intelligent Cubes allow multiple reports to retrieve data from a single shared in-memory set of data. Beginning in MicroStrategy 10. Number of Views 1. KB30711 : Security filter application to view reports based on Intelligent Cubes missing the security filter attribute in MicroStrategy OLAP ServicesKB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. Add data from existing reports, documents, and Intelligent Cubes. Published: Jun 29, 2018;Data Population for Intelligent Cubes. 438832. x, the user can compare the SQL generated for both Intelligent Cubes and Data marts. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. 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. x This is a new feature introduced in MicroStrategy version 9. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. 4,. For example, analysts can export interactive dashboards and reports to PDF format, allowing executives to access and review critical information without needing direct access to the BI platform. It accesses and joins data. Publish, unpublish, delete, and update Intelligent Cubes. Select the data set and click Prepare Data. Drilling can also be enabled outside of an Intelligent Cube for full ROLAP analysis. xUse the same attribute in filter in Intelligent Cube and incremental refresh filter. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. To support this configuration, you must ensure that the Intelligence Server host machine uses values greater than or equal to the resource limits described below. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Click here to view details about the Intelligent Cube Monitor. Within the set. In the left panel, click Cubes. Rather than returning data from the data warehouse for a single. When a remote accesses this cube, the cube is loaded into memory of the. 11 on Unix/Linux Number of Views 2. Right-click an Intelligent Cube and select Delete. It is a very popular BI tool since it allows organizations to analyze their data in-depth and make better decisions. 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. Name the different export. For example, an Intelligent Cube includes Year and Quarter. Intelligent Cubes are part of the OLAP Services feature in Intelligence Server. INTELLIGENT_CUBE_MAX_NO: The maximum number of Intelligent Cubes allowed in the project, returned as an integer. In MicroStrategy, you can also use connection mapping to control the data that users have access to when they run reports. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. When the subscription has been configured, click. Publishing an Intelligent Cube retrieves data from the data warehouse and stores this data as an Intelligent Cube in Intelligence Server memory. Environment connection is lost when using Kerberos and creating an Intelligent Cube in MicroStrategy Workstation. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. Easily add or change pre- and post- SQL statements. 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. MicroStrategy Intelligence Server . This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Expand the Object Templates category, select General, and. Recorded at World 2021. Choose one of the following options: Full Refresh: This is the default. Refer to the following MicroStrategy Knowledge base document for general remarks on security filter application to Intelligent Cubes where not all of the security attributes are found. 8 and up? KB439821 | Knowledge Article | 2670. To enable. 3. idx file is cleaned up. Select an Environment from the upper-left drop-down. 39. x releases, and the new Multi-table Data Import (MTDI) cubes. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. 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. Email subscriptions deliver a report or document to one or more email addresses. Administering MicroStrategy: Managing the Intelligence Platform Securing user privileges and data access Monitoring and tracking the analytics system. 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‘. ¶. Cube Advisor opens. Intelligent Cubes can be based on MicroStrategy data or imported data. 41. Publish the cube. Learning Resources. DerivedMetrics 182 Creatingaderivedmetric 184 Editingderivedmetrics 203 In MicroStrategy 9. AboutMicroStrategyOLAPServices 6 OLAPServicesfeatures 7 ThebenefitsofusingOLAPServices 11 PrivilegesrequiredforDeveloperandWebusers 12 Reporttypes. Defining the partition for Super Cubes. The Intelligent Cube refresh settings are recommended if the data in the Intelligent Cube must be updated for only one. Publish to PDF (22) Ratings. To build an Intelligent Cube. View the report in either Grid View or Grid and Graph View. Features: MicroStrategy and Tableau are two unique tools that offer incredible features. Navigate to and run the Intelligent Cube report. To Create a Report that Accesses an Intelligent Cube. . Right mouse click on the cube and choose Schedule 3. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 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. This article explains how a cube and its cache become synchronized in a clustered environment. Con: The copy of report data in Intelligence Server memory only applies to a single report. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. You can therefore use a dashboard as a starting point for a document, to add data and a structure to the document. 4. If the Intelligent Cube must be re-processed based on a metric. Select data population for Intelligent Cubes. Expand Intelligent Cubes, and then select General. The following diagram depicts the role of the intelligent cube. In this case, the dataset is a MicroStrategy Intelligent Cube. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. Right-click an Intelligent Cube and select Delete. Click All Objects View. The personal Intelligent Cube is similar to the report cache; however, it acts as a layer between the report cache and the report itself. x. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source.