This Technical Note shows examples of how each refresh type option of an Incremental Refresh report works. However, OLAP Services provides MOLAP and ROLAP analysis on the same report, which offers many distinct benefits, summarized below: Using OLAP Services, you can get fast response times for reports that use data directly from in-memory Intelligent Cubes, instead of from the data warehouse. 2. These reports allow data to be returned from the data. 4. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. Create a New Dossier. KB442449: Dossier Performance: Connect Live performance considerations. Also, verify that the /<path_to_the_location>/core. x SYMPTOM: After creating an Intelligent Cube from freeform SQL, reports cannot use this cube as a source via Dynamic Sourcing. 0: Balance MicroStrategy Server threadsDescription The . conf and add the following lines. log without functional impact. This template includes the following tasks: Creates a new metadata. In MicroStrategy Analytics Enterprise Web 10 onewards, users can now simultaneously import two or more tables from one or more supported data sources, this feature is called Multi-Table Data Import (MTDI) which has been renamed as Super Cubes in MSTR 2019. Create a filter that qualifies on Quarter and set Quarter = Q2 2011 (or any quarter available). • IS_CUBE_REP_STATS (statistics for actions performed on Intelligent Cubes; available in MicroStrategy 9. Limitations¶ Updating Datasets that were not created using the MicroStrategy REST API is not possible. 4. 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. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. STEPS TOP REPRODUCE: 1. x - 10. 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. Mclean, Virginia. 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. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Click Select. Save the Report and close. In the MicroStrategy Tutorial Warehouse tables, import data from the table LU_CATEGORY to create an intelligent cube in MicroStrategy Web 10. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. A metric in the Intelligent Cube reports fact data based on an attribute related to one in the security filter: The user's security filter prevents any data from being returned. This is a known issue with Data Import functionality in version 10. The Full Refresh option is the default. Create a report on this intelligent cube with the month attribute and the count of day metric. For example, an Intelligent Cube that must be updated with data for a month or region qualifies for an incremental refresh. This will set the Deactivate Intelligent Cube action to be triggered by the event created in Step 2. Dossiers automatically adjust to look great on any screen. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. For example, an Intelligent Cube that contains data for the top 200 stores by Profit must be re-calculated every time it is updated, and thus must use the Full Refresh option. In other words, the new column will NOT get mapped automatically in the existing Intelligent Cube. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Intelligent Cubes. “1:M relationship in the project but M:M relationship as per data in Intelligent Cube” pertaining to Platform Analytics project appears in DSSErrors. This article notes how support for transformation metrics in Dynamic Sourcing works. IS_PROJ_ID. In Enterprise Manager 10. 1. microstrategy. 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. 0. The related section is located in. Hover over a cube, and select the “Schedule” link to bring up a list of existing subscriptions for that cube. IS_CUBE_INST_ID. However, users may notice that there is nowhere to specify notifications through the scheduled refresh interface in MicroStrategy Web. A schedule is defined in Python code. Along with. These reports allow data to be returned from the data warehouse, stored in Intelligence Server memory, and then shared among multiple reports. Publish the cube. The default value is 256 megabytes. Whether the report is an Intelligent Cube (see Limiting the Size and Number of Intelligent Cubes). x, Report Service Document appears to show Null/Empty value for Row Count metric when using Live Connect Intelligent Cube. In an Intelligent Cube report, only the "Data Population for Intelligent Cubes" will be visible; in standard reports, it will be "Data Population for Reports. MicroStrategy AI is here. Type of action against the Intelligent Cube: • Enable partitioning in OLAP cubes To enable cube partitioning in OLAP cubes, follow the steps in the olap_partition video. To change these behaviors, see: Publishing Intelligent Cubes Without Loading Them into Intelligence Server Memory Loading Intelligent Cubes when Intelligence Server Starts If. Run both. This KB answers a question regarding memory limitations for In-Memory data import for MicroStrategy 10. Complex metrics here refer to metrics which are defined using multiple. In MicroStrategy Integrity Manager 10. The limitations of Microstrategy are not worth. 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. Create a second report with the year and quarter attributes and the revenue metric. . Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. Click Select. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. 4. Cube Advisor opens. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. Create a report off the Intelligent Cube in step 1 with Year and Month in the rows and Revenue in the columns. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The Modeling service must be configured correctly to use this feature. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. 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. Along with. PRIME stands for Parallel Relational In-Memory Engine, and it engulfs two types of in-memory cubes: OLAP cubes, or the traditional Intelligent Cubes that have existed since 9. It will remain available, but the setting will not be enforced if set below the default value of 100000. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. An Intelligent Cube is. x environment . 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. It stores the non-normalized table into the MicroStrategy. 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. You can control users' access to data with security filters. Right-click the Intelligent Cube, and select Define Incremental Refresh Report. The Intelligent Cube Options dialog box opens. The view filter cannot filter out other elements as shown below:Data Modeling. III. Choose Databases. Make sure you review the following prerequisites before you create an Intelligent Cube in MicroStrategy. This can improve the performance of. Pro: The Intelligent Cube remains valid and processing time against the data warehouse is minimal. Senior Lead, Application Support. The Intelligent Cube opens in the Report Editor. This is the same requirement to create or run a static report in Workstation. KB35540: How to publish Intelligent Cubes sequentially using MicroStrategy Command Manager version 10. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. KB30696: Overview of security filter application to view reports based on Intelligent Cubes in MicroStrategy OLAP Services . A value of 0 means that cache, History List messages, and Intelligent Cubes are backed up immediately after they are created. 3. x may observe that after a period of time from the initial publishing of the cube, the size of the cubes as reported by the Cube monitor increases, in some cases by substantial amounts. Navigate to and select the report or Intelligent Cube to use as the dataset, then click OK. 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. In MicroStrategy 10. Data modeling is the structuring of an organization's data assets into an applicable logical model. However, OLAP Services provides MOLAP and ROLAP analysis on the same report, which offers many distinct benefits, summarized below: Using OLAP Services, you can get fast response times for reports that use data directly from in-memory Intelligent Cubes, instead of from the data warehouse. File subscriptions save the report or document as an Excel or. Job ID for the action on the Intelligent Cube. x or 10. To view an Intelligent Cube stored in your History List. Choose File > New > Intelligent Cube. Ability to load Intelligent Cubes into memory on all nodes of the cluster upon publication. For a detailed explanation of the Cube Status values, see KB31566: MicroStrategy 9. Node 1. 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. In MicroStrategy 10. Instead, the Intelligent Cube can be restored directly, and the view reports executed against it. Using any other database should not have any implications, given that TPT is only applicable to Teradata. Create Cube2 with the Region attribute and the metric created in step 1. Starting in MicroStrategy 10. Personal Intelligent Cubes: A personal Intelligent Cube is the Intelligent Cube functionality available in all pre-9. By default, joins on unrelated attributes across datasets differ between documents and dashboards: Documents follow a Project level setting. 5 GB, the Data Transfer from Datasource(s) time is 77. 2. Use this option under the following conditions: If the data in the Intelligent Cube is outdated. The Maximum RAM usage (Mbytes) memory limit can be defined per project. KB440617: Considerations for using security filters when sharing data import cubes in MicroStrategy. 1 and later) • MSI_STATS_LOG (not used in MicroStrategy version 9. Create a dossier and add subset R from Existing Dataset. MicroStrategy Intelligence Cubes enables you to create Intelligent Cubes, which operate within Intelligent Server. Open the. The default file location for Intelligent Cubes is defined in the Project Configuration as '. Integer ID of the Intelligent Cube report that was published, if any. Strong semantic layer to define all the business rules and tightly coupled. Intelligent Cubes are multi-dimensional cubes (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data among multiple reports. In MicroStrategy Developer, log in to a project source with administrative privileges. Updating Intelligent Cubes without re-processing: Incremental Refresh. It remains available, but is not enforced if it is less than the default value of 100000. These reports can analyze the MDX cube data, while also taking advantage of OLAP Services analysis features such as derived elements. From the Data menu, select Configure Intelligent Cube. The REST API enables you to create MicroStrategy intelligent cubes from 3rd party applications. Report Design - Best Practices: Report filter should be more restrictive than the Cube filter. Answer: Go with dossier. Web Open the Settings page (right click the extension and select Options). This case is built with the Microstrategy Tutorial project and using the latest version of Microstrategy Web. In Developer, from the File menu select New, and then Intelligent Cube. 4 GB or higher. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. Aggregate Awareness: Most of the data warehouses provide aggregated layer of fact tables. ACTION This. GUID of the Intelligent Cube instance in memory. All necessary privileges are included in the Administrator role by default. 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. HyperAndroid Go to the Account tab. 3. 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. The Modeling service must be configured correctly to use this feature. 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. Known limitations in MicroStrategy 2021 Update 9: Derived element creation inside the report is not yet available in Workstation. 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. Create Cube1 with the Region attribute and the metric created in step 1. Öffnen Sie das Workstation-Fenster. Intelligent Cube storage on disk mirrors report cache storage. Can. The Intelligent Cube must not be re-processed based on a metric. Choose your environment, project, and Intelligent Cube as your dataset type. 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. This import bridge imports MicroStrategy logical tables as Dimensions. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. To do so, you can take advantage of URL API. STEPS TO REPRODUCE 1. 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. 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. OR, to convert an existing filter into a security filter, click Import. Click here to view details about the Intelligent Cube Monitor. Live-connect is not supported, so datasets for HyperIntelligence must be in-memory cubes. x as the MicroStrategy environment is applying the System Prompt 'User Login' at the time of Intelligent Cube publication. Right-click the dataset, and choose Schedule. IS_CUBE_ACT_ID. To change the intelligent cube status, right-click the Cube in the Cube Monitor, and select one of the actions. Designing and creating documents: An overview. metrics in the intelligent cube or in the MicroStrategy schema and application objects. Use the Intelligent Cube created with freeform SQL and manually point reports to this cube as a source, not using. (Does it sound like multisourcing for all the users without admin help?)Increasing the 'Maximum RAM for Working Set cache' setting will increase the possible limit amount of RAM that can be used by the Microstrategy Intelligence Server. The user then updates the cube. 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’. x - 10. The intelligent cube monitor on both the nodes looks the same as what is seen in step 7. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. Export data frames from RStudio to MicroStrategy in-memory cubes. 1 and 10. 4. 10 example shows how you can: Generate Auth Token and create an Intelligent Cube containing data. 0 MicroStrategy releases. 0 MicroStrategy releases. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. BACKGROUND: When configuring a MicroStrategy Intelligence Server cluster, special configuration must be made in order for the Intelligence Server cluster nodes to be able to access report and document caches, intelligent cubes, history list messages, and session recovery files that were created on other nodes of the cluster. First, you open a blank document and select a report to use as the document's dataset. 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. Create a Report 'R3' with 'Country' attribute. Both properties are located in the Query Optimizations folder in the VLDB property editor. 56K. This is the most popular MicroStrategy Interview Question asked in an interview. In addition, multiple logical tables can represent the same physical table. Consider the following example based on the MicroStrategy Tutorial project. If the Intelligent Cube must be re-processed based on a metric. 2. Explain the process of creating intelligent cubes in MicroStrategy? Public folder or a specific user folder can be. Used Project documentation feature: Documented all MicroStrategy objects like reports, prompts, filters and metrics for user reference. Because Intelligent Cubes must be loaded into memory to be used in reports, they can use a great. In MicroStrategy Web 10, during Data Import, users are able to choose "Connect Live" data sources, which is also known as "Direct Data Access" function, as shown below:. 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. 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. If desired, user can create a dashboard immediately from the imported data. These VLDB properties control the method by which the report data are normalized. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Job ID for the action on the Intelligent Cube. When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. In versions prior to MicroStrategy Intelligence Server 9. 0. When a remote accesses this cube, the cube is loaded into memory of the. The visualization data changes when the Data Access mode of an Intelligent Cube is changed from In-Memory to Live mode. The initial size of the Intelligent Cube is 11G and can grow to a maximum of 32G while the Maximum % growth of the Intelligent Cube is 50%. 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%. Go to the Report -> Data->Intelligent Cube Options->Point grid to. For example, you can create a card based on an Intelligent, in-memory MTDI, or an in-memory MDX/SAP cube. In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. Modify or remove the view filter to attempt to return data for the report. 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. x releases, and the new Multi-table Data Import (MTDI) cubes. In a MicroStrategy Intelligence Server clustered environment, it is observed that dynamic sourcing does work against Intelligent Cubes available on a remote node, after updating the schema. 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. This data can be used to create a dataset or to modify an existing dataset in a Data Import cube. HyperAndroid Go to the Account tab. 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. Number of Views 523. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. . x and newer. In this case, 50GB is spent for the Intelligence Server cube cache and 100GB RAM OS cache for the cube. It is shared by all processes running on the machine, including the operating system. Check it in the cube monitor and we can see its column Database Connection is not empty. Then it generates a report. 4 the connection mapping of the u… Number of Views 1. Create an intelligent cube with the month attribute, the region attribute, and the count of day metric from the first step. Refer to the following sections for a list of features that can and cannot be used with. com. The. For reports and Intelligent Cubes that do not use MultiSource Option or database gateway support to access multiple data sources, all queries are processed sequentially. Our analysts compare MicroStrategy against Looker based on a 400+ point analysis, reviews & crowdsourced data from our software selection platform. Dossier Datasets do not include all the Security Filter attributes, and one of the Datasets are Connect Live Data Import Dataset, it may have security concerns. x. This document discusses a specific case regarding how security filters are applied when there are complex metrics in the Intelligent Cube definition. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. You can use. json and has the yyyymmdd suffix automatically set every day, resulting in one log file per day. Advanced category, select the Balance MicroStrategy Server threads check box. Defining the partition for Super Cubes. Recorded at World 2021. Type of action against the Intelligent Cube: •However, Intelligent cube publishing performance may be affected with the agent enabled. Security filters apply to all reports, however, and there is no guarantee that every Intelligent Cube will include security filtering attributes. The **_objects folder with a size of 277G. 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. A user logs out of a MicroStrategy Project by scheduler. All necessary privileges are included in the Administrator role by default. It is shared by all processes running on the machine, including the operating system. Create Schema Objects. Select an Environment from the upper-left drop-down. Changes in MicroStrategy 2020 Starting in MicroStrategy 2020, unused cube indexes are swapped to disk instead of being dumped from memory. x, the user can compare the SQL generated for both Intelligent Cubes and Data marts. This is set to 32,000 by default. x. To access the MicroStrategy Installation Wizard. 3. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent. Create Cube B which contains all objects in the report and publish it . 0. The keys are both related to the Index Governing feature, which will help control the cube size increase in memory. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. 4. The updates to the Intelligent Cube must be according to attributes only. From the Data menu, select Configure Intelligent Cube. 8. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. All cubes respect the governing setting. x. Intelligent Cubes must be stored in Intelligence Server memory for reports to access their data. 2. Browse to the filter you want to convert and click Open. Upgrade to those versions to take advantage of the fix. The first is to enable report caching at the project level. To create an Intelligent Cube based on MDX data in Developer, open the File menu, select New, and select Intelligent Cube. , 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. To Create a Report that Accesses an Intelligent Cube. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Alternatively, you cannot create a card based on a live-connect MDX/SAP cube. 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. 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. Dynamic Refresh Inserts new rows from new data, and removes non-overlapping. Add ORDER_DETAIL (this tables comes with MicroStrategy Tutorial WH) and click Prepare Data. Die Abschnitte „Editor“ und „Filter“ sind standardmäßig gestapelt. You can add data for your Intelligent cube by including objects such as attributes, metrics, filters, and so on, as report objects or report filters. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. 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. Intelligent. What happens during the two timestamps for MicroStrategy Intelligent Cube 9. 3. There's a reason we're at the top of the list. Developed reports for MicroStrategy Web users. Providing Intelligent Cube data. Edit SQL Transactions in Reports. Answer: Go with dossier. Right-click an Intelligent Cube and select Delete. Report is not able to use an Intelligent Cube created with freeform SQL using Dynamic Sourcing in MicroStrategy 9. IS_CUBE_ACT_ID. The Modeling service must be configured correctly to use this feature. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. Add Year Id and Quarter. See full list on community. Browse to and select a previously saved Intelligent Cube on which to build your report. 9 and 10. Locate and run the Setup. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. Use Cube Advisor to create Intelligent Cubes: 1. 4. Create the MIN (CurrentDateTime ()) metric. Built by MicroStrategy, a worldwide leader in enterprise analytics and mobility, the. By default, this is set to 32,000. 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. Edit Intelligent Cubes from the new editor in Workstation at any time. Reports that connect to Intelligent Cubes adhere to many of the same standards of data access security as the rest of your MicroStrategy project. The New Grid dialog box opens. Cube Limitations. MicroStrategy Professional Services for high performance. 4. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. x If the Administrator wants to create a user that is only allowed to create an Intelligent Cube from a grid report in MicroStrategy Developer 10. 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. Navigate to the Intelligent Cube for which you want to define the incremental refresh. MicroStrategy recommends using the binary name (%e), process ID (%p), hostname (%h), and timestamp (%t) for the core file name, as shown below. STEPS TO REPRODUCE: 1) Add external dataset. Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. Limiting the Maximum Report Size. You must belong to the System Administrators group to use this feature. Its contents are timestamped messages with status, method of refresh, request source, request content, updated request content.