KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. 4. WORKAROUND: As workaround, add or edit View Filter conditions in MicroStrategy Developer or after running the Intelligence Cube Report in. 3 - Check the Make Intelligent. If the Intelligent Cube must be re-processed based on a metric. It is shared by all processes running on the machine, including the operating system. the project configuration: ACTION . Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. 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. x environment . Cube Limitations. x to 11. When user imports data into MicroStrategy Analytics Desktop , the data is saved as Intelligent Cube. The maximum number of Intelligent Cubes that can be loaded onto Intelligence Server for this project. Published: 4월 6, 2017. 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 Create on any folder page, point to New Report, and select Intelligent Cube Report. To Create a Report that Accesses an Intelligent Cube. 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. To change these behaviors, see: Publishing Intelligent Cubes Without Loading Them into Intelligence Server Memory Loading Intelligent Cubes when Intelligence Server Starts If. You are a financial analyst and want to build a grid to analyze each region’s performance across different set of products, like home equity loans and certificates of deposit, all in the same view. Edit Intelligent Cubes from the new editor in Workstation at any time. Job ID for the action on the Intelligent Cube. Along with. Integer ID of the project where the Intelligent Cube is stored. The first is to enable report caching at the project level. The updates to the Intelligent Cube must be according to attributes only. STEPS TO REPRODUCE 1. In MicroStrategy Web, open the document in Design Mode or Editable Mode. MicroStrategy - Data Cloud (Widget) - Online Training Video by MicroRooster. 2 – The data is being pushed to MicroStrategy Intelligent. Whether the report is an Intelligent Cube (see Limiting the Size and Number of Intelligent Cubes). Rather than returning data from the data warehouse for a. 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. All MicroStrategy security settings are respected when interacting with MicroStrategy. 3. The following table lists a comparison between Online Analytical Processing (OLAP) and Multi-Table Data Import (MTDI) cubes. IS_CUBE_INST_ID. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Specify a name and location for the new security filter and click Save. In addition, multiple logical tables can represent the same physical table. IS_CUBE_REP_ID. SYMPTOMS: After duplication of a project in Developer that has a user-defined Intelligent Cube cache location, Intelligent Cubes created within the new project are not saved to the location specified in Intelligent Cube File Directory in Project Configuration. On the left side of the page, click Logs and then Export Logs to save the file. 1 – Python program gets and processes the data from a Data Source. 1. You must belong to the System Administrators group to use this feature. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. Consolidate multiple MicroStrategy cubes into a single Kyvos data model without limitations on the data size or the number of dimensions that the model can hold. Strong semantic layer to define all the business rules and tightly coupled. Cube and Cache Metric Names. Pros and Cons. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. On the toolbar, choose Data > Configure Intelligent Cube. Report: The results of a report are used to populate the Intelligent Cube. 0. 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. 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. 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. To schedule updates for an Intelligent Cube, first click the “Data Import” button to bring up the list of existing Data Import Cubes. File subscriptions save the report or document as an Excel or. For example, you can create a card based on an Intelligent cube, super cube, or an in-memory MDX/SAP cube. These VLDB properties control the method by which the report data are normalized. My complaint is that a lot of the new stuff just works in the "import data into an intelligent cube" model and not the good old metadata. The New Grid dialog box opens. This can be seen in the screenshot below. The Incremental Refresh Options dialog box opens. Users of Intelligent Cubes in MicroStrategy 9. The user then updates the cube. HyperAndroid Go to the Account tab. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. The "LP" status of an Intelligent Cube in the Cube Monitor in MicroStrategy Developer stands for "Load Pending". This will work as a regular SQL comparison In order to incorporate this comparison, the SQL/MDX option should be selected in the Processing Options window:Total number of columns: The number of columns of data that the Intelligent Cube contains. In MicroStrategy Developer, right-click on the project and select Project. Choose your preferred method to share the logs. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. MicroStrategy 9 introduced a game changing feature in Intelligent Cubes. Both properties are located in the Query Optimizations folder in the VLDB property editor. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. Proper security filtering in view reports based on MicroStrategy OLAP Services 10. Pros and Cons. There are several disadvantages: Redundancy on this table affects several processes later on: for example, the transfer over the network and the amount. In MicroStrategy Developer, log in to a project source with administrative privileges. A workaround is available in the current document. Integer ID of the project where the Intelligent Cube is stored. You can create and analyze new reports in real time. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. 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. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. x in maintenance mode, it is recommended for users to enable the setting Cluster Synch Check Duplicate Cubes through the Windows registry or through the MSIReg. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. If the Intelligent Cube must be re-processed based on a metric. Download the files from the MicroStrategy download site. Check the status of the cubes in Developer. Email subscriptions deliver a report or document to one or more email addresses. x and 10. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. To add an existing report or Intelligent Cube as a dataset. If you are upgrading to MicroStrategy 11. Create an attribute element prompt for the. x. Architects can design and create Intelligent Cubes to combine attributes, metrics, and filters. This is the same requirement to create or run a static report in Workstation. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. Moreover, you can return a data. The Intelligent Cube is opened in the Report Editor. No data is returned for the report. The default file location for Intelligent Cubes is defined in the Project Configuration as '. Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. 2. x If the Administrator wants to create a user that is. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. When using an Intelligent Cube, you already have an in memory dataset. If the indexes are needed again, they are reloaded into memory from disk, instead of being regenerated. However, if the Intelligent Cube Monitor on the other node is checked, the size of the same Intelligent Cube will be smaller. Choose your environment, project, and Intelligent Cube as your dataset type. 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. If no data is returned for a report that is connected to an Intelligent Cube, this can be caused by the following scenarios: The view filter for the report is too restrictive (see View Filters ). Related Articles. Choose Databases. In a BI platform, the logical data model is designed and built using current user requirements. There's a reason we're at the top of the list. x Enterprise Manager, running the out-of-the-box report "Intelligent Cube Usage Statistics". Data Population for Intelligent Cubes. Right-click the dataset, and choose Schedule. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. This can improve the performance of. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. Edit Project-Level Cache and Intelligent Cube Settings. 3. Node 2. Use Case 4. The ability to view or edit certain settings is determined by a user's privileges. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. Datasets API. Intelligent Cube memory usage for each node in a clustered environment. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. Die Abschnitte „Editor“ und „Filter“ sind standardmäßig gestapelt. Enable parallel query execution for all reports that support it: MicroStrategy attempts to execute multiple queries in parallel for all MicroStrategy reports and Intelligent. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. 2. By default, the report template used is the same as the Intelligent Cube's template. For more information on security filters, see the System Administration Guide. Using mstrio as a MicroStrategy Intelligence Server administration tool¶For instance, if it is determined there are 8 partitions in the cube, then the value of this VLDB setting should be 8. e. Sharing Sets of Data Among Reports: Intelligent Cubes describes the role of OLAP Services in the overall MicroStrategy architecture and how you can take advantage of Intelligent. Use the drop-down under the filter summary section to switch the server nodes. With OLAP Services features, your report designers can create Intelligent Cube reports. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. To view this field, the Intelligent Cube must be published at least once. reg file on UNIX/Linux operating systems. x - 10. Select the Allow reports to drill outside the Intelligent Cube check box. A simple metric sum (Revenue) will go to different aggregate tables depending on the attributes on the template. The New Grid dialog box opens. To use a personal Intelligent Cube, you can begin by creating reports in MicroStrategy as usual, and then analyze your reports with OLAP Services features such as view filters, derived metrics, and. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Create and publish Intelligent cube called “Cube” and “Cube3” on node A. 2. Users with different security filters can use the same Intelligent Cube data. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. x and 10. 5. Senior Lead, Application Support. Toolbar Provides the most commonly used tools, including Save,SaveAs, Publish, and allows you to set the cube Refresh Type:. Click the MicroStrategy icon at the upper left of any page and select History List. This issue has been classified as a defect by MicroStrategy. x and newer. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. From the Data menu, select Configure Intelligent Cube. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Create an intelligent cube with the month attribute, the region attribute, and the count of day metric from the first step. The prompt is applied on top of an attribute that is part of the cube and shows correct behavior when used by normal reports, hitting the warehouse or an Intelligent Cubes by means of dynamic sourcing. x This is a new feature introduced in MicroStrategy version 9. x. 2. 3. metrics in the intelligent cube or in the MicroStrategy schema and application objects. KB442449: Dossier Performance: Connect Live performance considerations. The Security Filter Editor opens. The Intelligent Cube Monitor is displayed. Open the Workstation window. In other words, the cube "loaded" status (before shutdown) will be retained on each node even after MicroStrategy Intelligence Server 9. To enable or disable dynamic sourcing for an Intelligent Cube. Under Refresh type, select one of the following options. The interface has changed a bit. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for. STEPS TO REPRODUCE: 1) Add external dataset. Drill up, down, and sideways to get a 360-view of. It manages high performance interactions involving terabytes of data and tens of thousands of users by leveraging in-memory intelligent cubes, caching, load balancing, resource prioritization, and connection pooling. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. x Intelligent Cube status indication and workflow . Required Status to Perform Action. These VLDB properties control the method by which the report data are normalized. 4. Answer: Go with dossier. Cube Limitations. To review and create recommended Intelligent Cubes using Cube Advisor. Intelligent. You cannot create a card based on a live-connect MDX/SAP cube. In reality, an . 4. 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. Why MicroStrategy Why MicroStrategy; Customer StoriesHyperIntelligence is a new addition to MicroStrategy Workstation that allows analysts to inject analytics and intelligence directly into every user's experience. 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. For an overview and steps to add a dataset to a dossier, see Adding and removing datasets from a dossier. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. In MicroStrategy Integrity Manager 10. Published: Apr 6, 2017. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. . In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Case A: Security Filter attribute is related to attributes placed on the grid. cube; oracle12c; cubes; microstrategy; Jorgechu. @Luba Levin (Support Liaison) (Customer) You still do have the ability to define a dataset as "Live Connect" in MicroStrategy 2020. From the Data menu, select Add Dataset. Slice and dice features are awesome. Consider the following example based on the MicroStrategy Tutorial project. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. Browse to the filter you want to convert and click Open. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. The Intelligent Cube Options dialog box opens. A SQL like query which is generated by SQL Engine and run against MicroStrategy In-Memory Intelligent Cubes to retrieve data. MicroStrategy PRIME uses MicroStrategy Web Data Import Tool to build In-Memory Cubes that will be used by the PRIME. Intelligent Cubes. 4 GB or higher. If the data in the Intelligent Cube is outdated. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Create the MIN (CurrentDateTime ()) metric. Intelligent Cubes are multi-dimensional cubes on a BI platform, having two unique methods to implement. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. 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. Check it in the cube monitor and we can see its column Database Connection is not empty. The . Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. 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. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent Cube is repeated for every row. The **_objects folder with a size of 277G. 6 and higher. The. 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. A report instance is the version of the report results that Intelligence Server holds in memory for cache and working set results. The dataset is a set of data that can be displayed on the document. Data in Intelligent cubes can be either marked as available for time zone conversion when running objects against it or set within a specific time zone. KB442264 : In-Memory query against Intelligent Cube incorrectly does a cross join instead of joining through available tables using which the attributes could be joined. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. • Manage a team of 9 Technical Support Engineers who provide advice, solutions, and. This can cause your intelligent cube or report execution time to grow, however the end user performance will be improved. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. 5 GB, the Data Transfer from Datasource(s) time is 77. xA warning message is displayed for any mismatch in data between the report and the Intelligent Cube you want to link the report to. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. You must belong to the System Administrators group to use this feature. 0 has a dedicated section to memory used for Intelligent Cubes. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. This. MicroStrategy recommends using the binary name (%e), process ID (%p), hostname (%h), and timestamp (%t) for the core file name, as shown below. location_path: is the folder where the intelligent cube. MicroStrategy PRIME is a new feature added in MicroStrategy 10 Secure Enterprise Platform, which represents the evolution of the OLAP Intelligent Cubes. Intelligent Cubes are a more aggressive form of caching and allow multiple reports to be stored in the Cube (which is effectively a large cached report stored in memory on the. Click Select. Slice and dice features are awesome. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Total Cubes This section displays the total count of cubes by status. Contact the MicroStrategy Technical Support for an update on this enhancement request. This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. x where duplicate cube instances are created when a cube with a neutral locale gets updated with a multilingual attribute. From the Categories list, expand Options, and then select General. Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference. Intelligent Cube storage on disk mirrors report cache storage. Number of Views 1. To enable or disable dynamic sourcing for an Intelligent Cube. Add Year Id and Quarter. Documentation on the REST API is at developer. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. Article Reference Number:The memory used by Intelligence Server is limited by the machine's virtual memory. ACTION:In MicroStrategy Intelligence Server, how does the project configuration setting "Load Intelligent Cubes on startup" work in a clustered environment?To Create an Intelligent Cube Using Freeform SQL or Query Builder. With OLAP Services features, your report designers can create Intelligent Cube reports. Intelligent Cubes is a new OLAP Services feature in MicroStrategy 9. Navigate to and run the Intelligent Cube report. MicroStrategy 2021 Update 3 fixes two workflows related to Security Filter used in Data Import Intelligent cube (aka Super Cube). Defining Memory Limits for Intelligent CubesThis article discusses an issue with DELETE incremental refresh reports invalidly preventing an intelligent cube from being used for dynamic sourcing in MicroStrategy 10. The first column provides the Intelligent Cube name, and the second column provides the full path to the Command Manager script files used to publish the. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. x and newer. It involves only fetching a portion of the data that the user wants, instead of storing all data in-memory as a normal Intelligent Cube. Direct Cubes Over View Reports It's always recommended that you use the intelligent cubes directly in your dossier- avoid using view reports. For more details on enabling the setting, refer to Change Data Engine VersionCertify a super cube¶ Use SuperCube. Create a second report with the year and quarter attributes and the revenue metric. 4. 3 - Check the Make Intelligent Cubes. By default, joins on unrelated attributes across datasets differ between documents and dashboards: Documents follow a Project level setting. To customize your filename, please refer to the man page of core(5). Log file The log file, located in <path>/mstr_cube_trigger/log is called mstr_cube_trigger_log_<yyyymmdd>. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. for a script with several commands, one of which being a cube publication command, the. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes, which is part of OLAP. If the Intelligent Cube must be re-processed based on a metric. The New Intelligent Cube dialog box opens. Counts the number of sessions from the table IS_CUBE_ACTION_FACT. Pros and Cons. MicroStrategy logical tables do not necessarily represent physical tables. It is especially useful when data. What are the minimum privileges that a user needs to create an Intelligent Cube in MicroStrategy Developer 10. Cube Advisor opens. Documentation on the REST API is at developer. 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. When you run reports in MicroStrategy, they collect the warehouse data. By default, joins on unrelated attributes across datasets differ between documents and dashboards: Documents follow a Project level setting. 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. 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. An Intelligent Cube is. 4. 0. A document that uses the Intelligent Cube as a dataset. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. You can control users' access to data with security filters. Import “QTR_CATEGORY_SLS” and “LU_QUARTER” Table from the Tutorial warehouse. Dossiers automatically adjust to look great on any screen. 9 and 10. The. The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. Save the Report and close. Solution This issue has been addressed in MicroStrategy 2021. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Since Intelligent Cubes function simply as. Expand the Object Templates category, select General, and from the Show templates for the. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. Job ID for the action on the Intelligent Cube. Publish the Intelligent Cube by executing it on either of the nodes. In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Provides the last cube row count. 2. Right-click an Intelligent Cube and select Delete. IS_CUBE_ACT_ID. Steps To Reproduce 1. x. 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%. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. 4. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. The change journal logs now process the type, version, and name for databases configured in an environment. This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. An Intelligent Cube is a. ACTION: A fix for this issue is included in MicroStrategy 10. Select the Security Filters tab. An in-memory version of report data that can be manipulated by the MicroStrategy Analytical. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. Within the Microstrategy platform, the logic to match user requests with the proper intelligent cube is automatically handled. Use Cube Advisor to create Intelligent Cubes: 1. The intelligent cube monitor on both the nodes looks the same as what is seen in step 7. Advanced category, select the Balance MicroStrategy Server threads check box. Web Open the Settings page (right click the extension and select Options). Published: Apr 6, 2017. MicroStrategy AI is here. 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. 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. NOTE: There is an inherent limit specific to importing Excel files due to using an internal Java component to extract the data from Excel files. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Click All Objects View. Also enable feature flag called "Always calculate Derived Attribute at source for Connect Live Intelligent Cubes Datasets".