For example, you have three projects and you set their Maximum RAM usage (Mbytes) limits to 1 GB, 1 GB, and 2 GB. 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. III. 1 – Python program gets and processes the data from a Data Source. 86K KB31566: MicroStrategy 9. Then it generates a report. x and newer. 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. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. 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. The Full Refresh option is the default. By profiling the Intelligent Cube publication (as per KB30699 - How to measure the Intelligent Cube performance parameters for time and memory in the MicroStrategy Intelligence Server 9. To build an Intelligent Cube. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. Create an element prompt that selects elements of Month and the values are restricted by the filter created in step 2. 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. 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. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. For detailed information about Intelligent Cubes, see the In-memory Analytics Guide. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. In MicroStrategy Integrity Manager 10. Data modeling is the structuring of an organization's data assets into an applicable logical model. 0. A warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. The first is to enable report caching at the project level. 5 GB . In MicroStrategy 9. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. This allows better reconciliation and reusability of dashboard definitions when switching between an OLAP and super cube. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. By default, joins on unrelated attributes across datasets differ between documents and dashboards: Documents follow a Project level setting. The cube leverages both memory and a file on the disk, so data is quickly reloaded into memory when required. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Refer to Knowledge Base article on how to support connection mapping with the use of cubes: KB33830: Can Intelligent cubes be used along with connection mapping in MicroStrategy Developer. 3. 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’. WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. Enable "Create Intelligent Cubes by database connection" (need to reload the project to make it work). Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. MicroStrategy Intelligence Cube. This can be seen in the screenshot below. The Attribute Index An Intelligent Cube is an In-Memory data structure which holds information from a source in a readily accessible format for quick access. The Incremental Refresh Options dialog box opens. This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Both properties are located in the Query Optimizations folder in the VLDB property editor. Open the Workstation window. 3. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. The objects in the source cubes will control how the security filter will be applied. The default value is 256 megabytes. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. It is especially useful when data. This is the most popular MicroStrategy Interview Question asked in an interview. table_id: is the guid of a table. Choose File > New > Intelligent Cube. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. The fact that the Intelligent Cube resides on the MicroStrategy Intelligence Server memory. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. The following diagram depicts the role of the intelligent cube. Use Case 4. The **_objects folder with a size of 277G. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). This Python 3 / MicroStrategy 10. x Intelligent Cube status indication and workflow . Most likely several, different fact tables are uses for each query. . It remains available, but is not enforced if it is less than the default value of 100000. Documentation on the REST API is at developer. 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. 2. 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". x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. This article describes a known limitation where users are unable to republish a data import intelligent cube for dashboards or dossiers that were created in MicroStrategy Analytics Desktop with an In-Memory data set and a DSNless connection after being imported into MicroStrategy Web 10. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. This applies for example to Cubes created via MicroStrategy Web client. View reports based on Intelligent Cubes in MicroStrategy OLAP Services do not create report caches (unless the report is sent to the history list). x. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. Choose one of the following options: Full Refresh: This is the default. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. This is controlled by the Python script. Create an Intelligent cube with Year, Quarter, and Revenue with MicroStrategy Tutorial data. 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. microstrategy. Intelligent Cubes is a new OLAP Services feature in MicroStrategy 9. Select an Environment from the upper-left drop-down. x. Intelligent cubes allow a user to access OLAP service features on reports; a shared set of data can be shared among multiple reports. Open the. the project configuration: ACTION . x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. This import bridge imports MicroStrategy logical tables as Dimensions. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. Specify a name and location for the new security filter and click Save. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. This can cause your intelligent cube or report execution time to grow, however the end user performance will be improved. The view filter cannot filter out other elements as shown below:Data Modeling. mstr suffix. x - 10. Create Schema Objects. STEPS TO REPRODUCE 1. Creating an Intelligent cube is similar to creating a report. MicroStrategy tests on at least one of the CPU chipsets within a set of binary-compatible CPU architectures for purposes of certifying and supporting operating systems with MicroStrategy products. In MicroStrategy 10. Create an Intelligent Cube with attributes Year, Month and Region; 4. MicroStrategy logical tables do not necessarily represent physical tables. Dynamic Sourcing. The data used for this example is. However, the cube monitor doesn’t show partition related information. By default, the report template used is the same as the Intelligent Cube's template. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. Select the data set and click Prepare Data. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Most likely several, different fact tables are uses for each query. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Slice and dice features are awesome. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. 4. 0: Balance MicroStrategy Server threadsDescription The . This is due to the fact that adding prompts to Intelligent Cubes is not supported. Intelligent Cubes. When an Intelligent Cube is in this status, any reports based on this cube have. A report instance is the version of the report results that Intelligence Server holds in memory for cache and working set results. This dataset needs to contain all data in the required granularity. 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. The interface has changed a bit. 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. Export data frames from RStudio to MicroStrategy in-memory cubes. Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference. In MicroStrategy 10. If the Intelligent Cube must be re-processed based on a metric. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. Number of Views 8. Run sudo vi /etc/sysctl. 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. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. For example, an Intelligent Cube includes the. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. In MicroStrategy Web, open the document in Design Mode or Editable Mode. A user logs out of a MicroStrategy Project by scheduler. KB442449: Dossier Performance: Connect Live performance considerations. E. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. STG_IS_CUBE_REP_STATS. All MicroStrategy security settings are respected when interacting with MicroStrategy. You must belong to the System Administrators group to use this feature. The considerations and steps required to fully support dynamic sourcing are listed below: While many MicroStrategy features can be used with dynamic sourcing, some features may prevent the use of dynamic sourcing between reports and Intelligent Cubes. In MicroStrategy 10. 0, the only way to create an intelligent cube (also known as an ROLAP cube or an OLAP cube) was from a report (which is a single table dataset). This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. Developed reports for MicroStrategy Web users. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. Create a New Dossier. 4. Integer ID of the project where the Intelligent Cube is stored. By default, this is set to 32,000. Created Intelligent Cubes to solve the performance issues. When using an Intelligent Cube, you already have an in memory dataset. 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. This Python 3 / MicroStrategy 10. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. 2. Run both. Making the move from Developer to Workstation even smoother, users can now create Intelligent Cube Reports in Workstation. metrics in the intelligent cube or in the MicroStrategy schema and application objects. This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. Architects can now create, edit, and publish Intelligent Cubes with the new editor in Workstation, streamlining overall creation workflows. Choose Databases. The Intelligent Cube refresh settings are recommended if the data in the. 3. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. Intelligence Server Statistics . Built by MicroStrategy, a worldwide leader in enterprise analytics and mobility, the. The default value is 256 megabytes. Complex metrics here refer to metrics which are defined using multiple. For steps to use the Derived Elements Editor to create derived elements in MicroStrategy Web, see the MicroStrategy Web Help. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. Check in Developer that the stopped node is in Maintenance Mode. Extensively used “Apply Simple” function for creating attributes. Limited mobile capabilities compared to the latest BI tools like MicroStrategy. 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. 4. Explain the process of creating intelligent cubes in MicroStrategy? Public folder or a specific user folder can be. 2. 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. Transactions. The MicroStrategy Tutorial project uses aggregate tables by default. 0 votes. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. With MicroStrategy OLAP Services, transformation metrics used in standard reports can resolve against Intelligent Cubes under the following conditions: A metric with the same formula and transformation exists in the Intelligent Cube. The Intelligent Cube “xxx” for locale <German (Germany)>has not been published. MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). Click View Logs, to display the share icon in the upper-left. Open the. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. 4. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. Web Open the Settings page (right click the extension and select Options). * MicroStrategy does have support for dynamic sourcing with MDX sources. 2. conf and add the following lines. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. Published: 4월 6, 2017. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). The data in Intelligent Cubes can be accessed by different Microstrategy objects like Reports and Documents. For instance, let’s say you have an Intelligent Cube with 2 million rows and 10 attributes and 5 Expand Intelligent Cubes, and then select General. You cannot create a card based on a live-connect MDX/SAP cube. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. This allows for more power and control over data for MicroStrategy. 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. What happens during the two timestamps for MicroStrategy Intelligent Cube 9. MicroStrategy Professional Services has identified five primary levers customers can use to get dramatically faster performance:. 6 and higher. Expand Intelligent Cubes, and then select General. 2. A document that uses the Intelligent Cube as a dataset. To create or edit Intelligent cube reports you must at least have the following privileges: Web define Intelligent Cube Report or Defined Intelligent Cube Report. The . 4. It is recommended that the Excel file size should not exceed 1GB. MicroStrategy is the only comprehensive analytics vendor that supports big data analytics with native connectors to HDFS to access petabytes of data in real time. The **_objects folder with a size of 277G. Edit Intelligent Cubes from the new editor in Workstation at any time. Like cache update subscriptions, Intelligent Cube. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as a single in-memory copy among many different report created by multiple users. This Knowledge base article describes limitations in using security filters and intelligence cubes. Under Refresh type, select one of the following options. You cannot create a card based on a live-connect MDX/SAP cube. x Intelligent Cube status indication and workflowThere's a reason we're at the top of the list. 0 has a dedicated section to memory used for Intelligent Cubes. Required Status to Perform Action. Published: Apr 6, 2017. 4. An Intelligent Cube is. With OLAP Services features, your report designers can create Intelligent Cube reports. 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. If desired, user can create a dashboard immediately from the imported data. RMC on attribute Warranty to Create Attribute named ‘IsWarranty’ with the formula of “IsWarranty: Case(([Warranty]@[DESC]="No"), 0, 1)” as shown below:This article describes features that are not supported when using Dynamic Sourcing. Prerequisites to creating Intelligent 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. To define an incremental refresh report. Starting from MicroStrategy 9. 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. 5 GB. e. The Intelligent Cube Options dialog box opens. 9 and 10. In MicroStrategy Desktop 9. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. mstr file is actually a . Both properties are located in the Query Optimizations folder in the VLDB property editor. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. All cubes respect the governing setting. The MicroStrategy Intelligence Server 9. cube; oracle12c; cubes; microstrategy; Jorgechu. On the left side of the page, click Logs and then Export Logs to save the file. Publish the Intelligent Cube by executing it on either of the nodes. 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. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. iCubes, however, has some limitations and thereby needs to be used judiciously based on the need. In a BI platform, the logical data model is designed and built using current user requirements. In MicroStrategy Developer, right-click on the project and select Project. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Providing Intelligent Cube data. Direct Cubes Over View Reports It's always recommended that you use the intelligent cubes directly in your dossier- avoid using view reports. In MicroStrategy 10. 0. certify() to certify / decertify an existing super cube. In MicroStrategy Desktop 9. To add an existing report or Intelligent Cube as a dataset. If a new column is added to the data import data source and the cube is republished, there is no effect. Refer to MicroStrategy Product Manual 'In-memory Analytics Guide' for more details about partitioning and MicroStrategy PRIME. Note: The maximum file size that can be imported is 100 MB. . In the Drilling area, clear the Use default settings check box. For an overview and steps to add a dataset to a dossier, see Adding and removing datasets from a dossier. Intelligent Cubes. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. For more details on enabling the setting, refer to Change Data Engine VersionCertify a super cube¶ Use SuperCube. In MicroStrategy Developer, log in to a project source with administrative privileges. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. You can edit project-level cache and Intelligent Cube settings. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. Type of action against the Intelligent Cube: •In MicroStrategy 11. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. 2) Choose "Database" and select the 3rd option to "Pick tables". To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Along with. , 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. Let us assume the Intelligent Cube is published on Node B: Create an event called "Refresh Cubes" Create an event-based schedule called "Refresh Cubes" You can edit project-level cache and Intelligent Cube settings. Right-click the dataset, and choose Schedule. The dataset is a set of data that can be displayed on the document. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. Following techniques can be used to detect whether a MicroStrategy Intelligent cube has finished processing and is available for use. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. Rather than returning data from the data warehouse for a. Documents . If the indexes are needed again, they are reloaded into memory from disk, instead of being regenerated. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Log on to the machine where you are installing one or more MicroStrategy products. x a new concept is introduced called Intelligent Cubes. "The following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. MicroStrategy logical tables do not necessarily represent physical tables. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. By default, joins on unrelated attributes across datasets differ between documents and dashboards: Documents follow a Project level setting. To access the MicroStrategy Installation Wizard. x This is a new feature introduced in MicroStrategy version 9. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. In the left panel, click Cubes. xA warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. You can create Intelligent Cubes with data from an MDX data source, such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services. Click here to view details about the Intelligent Cube Monitor. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. 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. This article details the known limitations and challenges of the 2019 Update 2 HyperIntelligence for Office add-in. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. To view this field, the Intelligent Cube must be published at least once. Creating an Intelligent cube is similar to creating a report. 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. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. Create Cube1 with the Region attribute and the metric created in step 1. Create Schema Objects. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. The intelligent cube monitor on both the nodes looks the same as what is seen in step 7. The benefits from using Dynamic Sourcing are: Better performance for all kinds of reports. An enhancement Request has been reported to the MicroStrategy Technology team. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate that data. It is also more difficult or impossible for someone reporting on Intelligent Cube data to unintentionally cause re-execution against the data warehouse, preventing extra load on the data warehouse. In MicroStrategy 2020 Update 2, the size of the Intelligent Cube keeps gradually increasing even after setting the Maximum % growth of Intelligent Cube to 50%. com The Maximum RAM usage (Mbytes) memory limit can be defined per project. Check it in the cube monitor and we can see its column Database Connection is not empty. 4. Drag and drop the objects into the report grid from the Report Objects pane. You can create and analyze new reports in real time. For the steps to define an incremental refresh report, refer to:Both MicroStrategy Developer and MicroStrategy Web have the ability to incrementally fetch element rows from Intelligence Server. Provides the last cube row count. Counts the number of sessions from the table IS_CUBE_ACTION_FACT. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9.