The Intelligent Cube Monitor is displayed. 6 and below, this feature was only available when re-pointing an existing report from one OLAP cube to another OLAP cube or re-pointing the report from one MTDI cube to another OLAP cube. MicroStrategy Analytics cubes are easy to create and deploy. This is the same requirement to create or run a static report in Workstation. 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. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. MicroStrategy Web: Web Server. Intelligent Cubes are multidimensional cubes (sets of data) that exist on the MicroStrategy Intelligence Server memory and can be shared among different users. Create an Intelligent Cube with attributes Year, Month and Region; 4. When using an Intelligent Cube, you already have an in memory dataset. The interface has changed a bit. The Modeling service must be configured correctly to use this feature. If you are upgrading to MicroStrategy 11. Cube and Cache Metric Names. Required Status to Perform Action. Select the data set and click Prepare Data. More specifically, the amount of RAM the machine has available when the intelligent cube gets created during In-Memory Data Import. You can create and analyze new reports in real time. The data in Intelligent Cubes can be accessed by different Microstrategy objects like Reports and Documents. To Create a Report that Accesses an Intelligent Cube. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. To use an attribute form. These reports allow data to be returned from the data. Implicit degradation occurs when the Intelligent cube report level is not compatible with the fact level of any metric being used in the Intelligent Cube (Fact Editor > Tools > Show Fact Entry Level) so a cross join between the fact table and the report level attribute is needed resulting in a fact extension and disabling Dynamic Sourcing for that specific Intelligent. All MicroStrategy security settings are respected when interacting with MicroStrategy. 1. This is a known issue with Data Import functionality in version 10. Cube Advisor opens. The data used for this example is. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. 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. In addition, multiple logical tables can represent the same physical table. This issue has been classified as a defect by MicroStrategy. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. Select the schedule you had created in step 2 and in the Intelligent Cubes field, select the desired Intelligent Cube as seen below: 6. 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. This Python 3 / MicroStrategy 10. Expand the Object Templates category, select General, and from the. The New Grid dialog box opens. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server memory. Along with. When an Intelligent Cube is in this status, any reports based on this cube have. 3. IS_PROJ_ID. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. However, the cube monitor doesn’t show partition related information. Designing and creating documents: An overview. 17. This can be seen in the screenshot below. GUID of the Intelligent Cube instance in memory. Web Open the Settings page (right click the extension and select Options). GUID of the Intelligent Cube instance in memory. This is helpful in querying curated data easily with cubes versus directly executing against the data warehouse. conf and add the following lines. Starting with MicroStrategy Intelligence Server 9. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. Run both. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. There's a reason we're at the top of the list. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. 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. You can use. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. Save the Report and close. Intelligent Cubes can be based on MicroStrategy data or imported data. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. 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. Run a dossier based on the cube. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Number of Views 1. x. If desired, user can create a dashboard immediately from the imported data. If the indexes are needed again, they are reloaded into memory from disk, instead of being regenerated. Click the MicroStrategy icon at the upper left of any page and select History List. In MicroStrategy Web, open the document in Design Mode or Editable Mode. IS_PROJ_ID. WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. x. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. . For more information on security filters, see the System Administration Guide. x. 4 the connection mapping of the u… Number of Views 1. Expand the Object Templates category, select General, and. 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. 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. STEPS TO REPRODUCE 1. x. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. Users cannot trigger or schedule cube republishing. Locate and run the Setup. These VLDB properties control the method by which the report data are normalized. Enable parallel query execution for all reports that support it: MicroStrategy attempts to execute multiple queries in parallel for all MicroStrategy reports and Intelligent. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Using Database Write-back Functionality to Enable Decision-Making. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Intelligence Server Statistics . This is the most popular MicroStrategy Interview Question asked in an interview. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. In MicroStrategy Desktop 9. 6 and below, this feature was only available when re-pointing an existing report from one OLAP cube to another OLAP cube or re-pointing the report from one MTDI cube to another OLAP cube. Defining Intelligent Cube refresh settings. Since Intelligent Cubes function simply as. By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. Create a Data Import Live Intelligent Cube. The underlying cause comes from a miscalculated governing setting which incorrectly prevents new Data Import Intelligent Cubes. x where duplicate cube instances are created when a cube with a neutral locale gets updated with a multilingual attribute. The following procedure describes how to prevent a user from being able to re-publish selective cubes (i. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. Browse to and select a previously saved Intelligent Cube on which to build your report. You must belong to the System Administrators group to use this feature. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. The . Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. Senior Lead, Application Support. Choose one of the following options: Full Refresh: This is the default. Integer ID of the Intelligent Cube report that was published, if any. Intelligence Server Statistics Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. Choose Databases. zip and use 7Zip, or similar tools, to unzip it. To access the MicroStrategy Installation Wizard. 0 votes. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. 0. x environment . 3. By default, MicroStrategy Command Manager handles cube publication synchronously (i. 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. The MicroStrategy Intelligence Server is a highly scalable, self-tuning analytic server. 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. 0. 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. Answer: Go with dossier. Published: 4월 6, 2017. To view this field, the Intelligent Cube must be published at least once. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. The following diagram depicts the role of the intelligent cube. 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. The. Intelligent Cube storage on disk mirrors report cache storage. Navigate to the Intelligent Cube for which you want to define the incremental refresh. Number of Views 8. 2. Changes in MicroStrategy 2020 Starting in MicroStrategy 2020, unused cube indexes are swapped to disk instead of being dumped from memory. Republish the same cube, and a new cube instance is generated. For detailed information about mobile subscriptions and MicroStrategy Mobile, see the MicroStrategy Mobile Administration Help. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. Share query results in-memory across multiple dossiers and. 3. If the Intelligent Cube must be re-processed based on a metric. 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. , Cube Filter: Year between 2006 and 2010; Report Filter: Year in (2007, 2008) Report filter should at least filter on all attributes and attribute forms. x - 10. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent 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. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Moreover, you can return a data. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. 15K. 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. 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. Creating an Intelligent cube is similar to creating a report. This template includes the following tasks: Creates a new metadata. If the Intelligent Cube must be re-processed based on a metric. xKB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. Intelligent Cube file directory: Specifies the file location in which Intelligent Cubes are stored when you select to save an Intelligent Cube to secondary storage. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. The Full Refresh option is the default. Published: Apr 6, 2017. Open the. Solution This issue has been addressed in MicroStrategy 2021. 3. mstr suffix. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. 4. Intelligent Cubes. 0 MicroStrategy releases. All necessary privileges are included in the Administrator role by default. It is recommended that the Excel file size should not exceed 1GB. 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. MicroStrategy Analytics cubes are easy to create and deploy. Go to the Report -> Data->Intelligent Cube Options->Point grid to. 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. Moreover, you may generate among the various reports of many users. Choose your preferred method to share the logs. 4. They should have the “A, L, F” status (Active, Loaded, Filed). OR, to convert an existing filter into a security filter, click Import. You can control users' access to data with security filters. The Intelligence Server checks to see if there is an existing cache for the same Report. 5 GB . In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. KB31352: How does Intelligent Cube caching work in a clustered MicroStrategy 9. The. For example, an Intelligent Cube includes the. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. From the Data menu, select Configure Intelligent Cube. reg file on UNIX/Linux operating systems. Create Schema Objects. MicroStrategy Professional Services has identified five primary levers customers can use to get dramatically faster performance:. For example, Create a report with an attribute with only one attribute form. Cube Limitations. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. HyperAndroid Go to the Account tab. In other words, the cube "loaded" status (before shutdown) will be retained on each node even after MicroStrategy Intelligence Server 9. Maintaining data access security. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. Intelligent Cube update subscriptions retrieve the most recent information for an Intelligent Cube from the data warehouse and then publish that Intelligent Cube. The Security Filter Editor opens. 3. This means any report you create will have caching enabled by default. To build an Intelligent Cube. The following table summarizes the test results of some test scenarios against Oracle 19c. This will reduce the memory usage from 150GB to 100GB. When running MicroStrategy Intelligence Server 9. Dynamic Refresh: The Intelligent Cube's filter is. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. IS_CUBE_ACT_ID. Number of Views 1. 2) Choose "Database" and select the 3rd option to "Pick tables". Rather than returning data from the data warehouse for a. x and newer. This import bridge imports MicroStrategy logical tables as Dimensions. 3 - Check the Make Intelligent. Save the Cube with Connect Live Data Access Mode. Strong semantic layer to define all the business rules and tightly coupled. KB30711 : Security filter application to view reports based on Intelligent Cubes missing the security filter attribute in MicroStrategy OLAP ServicesSTEPS TO REPRODUCE. In the Refresh Policy column, choose one of the following options:Memory Contract Manager (MCM) is designed to protect Intelligence Server in cases where a memory request would cause the system to approach a state of memory depletion. The requests are granted or denied according to user-configured limits on the amount of. Discover MicroStrategy 2021 >This is a known issue in MicroStrategy. 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. Measures the time duration an operation executed against cubes. Reports include Freeform SQL reports, Query Builder reports, MDX cube reports, and reports that access Intelligent Cubes. 3. For a new column to be added to an existing Intelligent Cube, users need to edit an existing Intelligent Cube and map the new column manually, as. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Add Year Id and Quarter. This. Then it generates a report. Our analysts compare MicroStrategy against Looker based on a 400+ point analysis, reviews & crowdsourced data from our software selection platform. The status of each Intelligent Cube is listed in the. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. Right-click an Intelligent Cube and select Delete. 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. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the PRIME. x If the Administrator wants to create a user that is. This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. The Intelligent Cube Monitor is displayed. 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. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. The **_objects folder with a size of 277G. Click All Objects View. 11. This Knowledge base article describes limitations in using security filters and intelligence cubes. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). Like cache update subscriptions, Intelligent Cube. If the New Intelligent Cube dialog box does not open, from the Tools menu, select Developer Preferences. com. If the Intelligent Cube must be re-processed based on a metric. This table is not populated unless at least one of the Advanced Statistics Collection Options are selected in the Statistics category of the Project Configuration Editor. In reality, an . Check the status of the cubes in Developer. CubeServerDefinition', where ServerDefinition is a name to reference the folder containing the caches. Click the “Add history list subscription” link near the bottom of the screen to open the. Article Reference Number:The memory used by Intelligence Server is limited by the machine's virtual memory. 1 and later) • MSI_STATS_LOG (not used in MicroStrategy version 9. 3. Explain the process of creating intelligent cubes in MicroStrategy? Public folder or a specific user folder can be. Developed reports for MicroStrategy Web users. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. 06K KB33244: Are there any limits imposed on Intelligent Cube size in MicroStrategy 9. Execute the report and view the SQL:MicroStrategy enables users to pull subsets of data, which could be up to hundreds of Gigabytes, from a Big Data source into an in-memory cube, and build reports/dossiers from the cube. Click View Logs, to display the share icon in the upper-left. Publish the Intelligent Cube by executing it on either of the nodes. An example of this behavior for a relatively small cube is shown in the screen shots below:The MicroStrategy SDK allows you to customize several MicroStrategy products and extend and integrate the MicroStrategy business intelligence functionality into other applications. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. You may share the Intelligent Cube as a single copy in memory. 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. Specify a name and location for the new security filter and click Save. E. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. x and newer. With OLAP Services features, your report designers can create Intelligent Cube reports. For more information on Intelligent Cube sizes, refer to the following MicroStrategy Knowledge Base technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. 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. In the grid display of the report, press the CTRL key and select multiple attribute elements within the same attribute. The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Platform Analytics and to address issues encountered during the statistics logging and data load. 2 – The data is being pushed to MicroStrategy Intelligent. A workaround is available in the current document. Navigate to the folder location of the Intelligent Cube. From the Data menu, select Configure Intelligent Cube. In the New Intelligent Cube dialog box, select the MDX Sources tab. The ability to view or edit certain settings is determined by a user's privileges. In the Data Source column, select the checkboxes for the tables to update. x. By default, this is set to 32,000. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. This import bridge imports MicroStrategy logical tables as Dimensions. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Open the. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. 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. MicroStrategy AI is here. As part of generating an Intelligent Cube MicroStrategy uses a normalized data structure similar to a Relational Database with a series of Fact and Lookup tables. When using MicroStrategy and Teradata, the best approach is to. OLAP (In-Memory, Intelligent Cube) MTDI (In-Memory) MTDI (Live Connect) Data Retrieval. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. Records statistics related to Intelligent Cube manipulations. The related section is located in. STG_IS_CUBE_REP_STATS. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. IS_CUBE_REP_ID. In order to set up an incremental refresh report, the user should first right click on the Intelligent Cube and select "Define Incremental Refresh Report":The peak memory for publishing an Intelligent cube is much larger in Winodws than Linux if the data contains ASCII characters. Once activated, the user loads the cube in memory. 4. The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. Create a Report 'R3' with 'Country' attribute. 2. exe file. Create an Intelligent Cube with this attribute and publish. x Intelligent Cube status indication and workflow . MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. Stop the Intelligence Server service of one node of the cluster (in this example, node 2 called “sup-w-006660”). Email subscriptions deliver a report or document to one or more email addresses. x. Its name stands for MicroStrategy Parallel Relational In-Memory Engine. 0+, you have the ability to see how long it takes each visualization to execute, what query is being sent to the DataWarehouse, or what request is being done to an In-Memory intelligent cube. x as the MicroStrategy environment is applying the System Prompt 'User Login' at the time of Intelligent Cube publication. Die Abschnitte „Editor“ und „Filter“ sind standardmäßig gestapelt. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. 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. 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. Cube Advisor opens. 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. The Intelligent Cube must be published before this report can execute. The Select Dataset dialog box opens. By default, the report template used is the same as the Intelligent Cube's template. 0: Balance MicroStrategy Server threadsDescription The . Share query results in-memory across multiple dossiers and reports. Integer ID of the Intelligent Cube report that was published, if any. To enable or disable dynamic sourcing for an Intelligent Cube. 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‘. To Create a Report that Accesses an Intelligent Cube.