In just one week, MicroStrategy Professional Services, will conduct a thorough examination of your Business Intelligence implementation, providing you with actionable recommendations on these five key areas to improve overall performance. For the steps to define an incremental refresh report, refer to: Subset report or view report caching can improve dossier performance in almost 70% of all cases. Slice and dice features are awesome. It is local to the node and is reset every time the cube is unloaded/loaded. The Performance Analysis folder has several reports and two folders, each with its own related area of analysis: •. MicroStrategy's support for parameterized queries can improve performance in scenarios that require the insertion of information into a database. Whenever a report executes against a data warehouse and returns a new set of data, a personal Intelligent Cube is created automatically. Datamart optimization can be used to improve performance in this situation if the database for the datamart. Intelligent Cube storage on disk mirrors report cache storage. MicroStrategy is constantly iterating, importing, and creating new features to ensure our customers are having the best experience. 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. Providing Intelligent Cube data. while (cubesEnum. MicroStrategy support connects you to the most helpful & experienced technical experts in the industry. MicroStrategy Parameterized Query feature for better performance. 1, Intelligent Cubes have a new feature to update information without republishing it. This provides improved performance when querying in-memory cubes. Navigate to the Intelligent Cube for which you want to define the incremental refresh. For example, the objects developed in a development environment can be copied to a UAT environment to test and validate the. 0 if there are multiple join paths between two or more One-to-Many relationship tables in a multi-table data import cube, rather than using the first available table join path, the analytical engine will look for the path with the least number of tables and the smallest table base on the following order/criteria: 1. Users in order to see them have to go to the object and un-hide it. 4, the Data Import functionality utilizes multiple threads to improve the cube publishing time, when performing a data import against CSV/Text files. 2 Secure Enterprise Platform, a new VLDB setting "MCE Join To Get Data Combination" has been introduced, that can help improve the document performance. x SQL engine: "Parallel Query Execution" work. Expand the Object Templates category, select General, and from the Show templates for the. Improve Report and Cube Performance Against the Data Warehouse by Using an Attribute Form Caching Cube This feature was introduced in MicroStrategy 2021 Update 5. In the previous example all the extra calculations were pushed to the intelligent cube which will improve the performance for the end users. Starting in MicroStrategy 10. " Cube B's refresh policy is set to "update existing data. Super Cubes are simply a renaming of what was previously referred to as MTDI (Multi Table Data Import) Cubes. In order to obtain those values, users must select at least one performance cycle in the Processing options window as shown in the following image: Once the test is completed, the user will get the minimum, maximum and average time of. The M8MulPrc/M8MulPrc_32 process is a database connection process spawned from the MicroStrategy Intelligence Server 9. When running an integrity test, users might want to get the execution time of the report or document. All prerequisites for using security filters with MDX Cubes should be completed before. For background. Partitions help in performance improvement of subset report executions; as a trade-off, some extra information is written in the cube, resulting in an increase in the cube size. Steps to Modify the View Date Range. println ("For project: " + cubesPerProject. Always consider to collect database statistics as the query execution plan is generated based on that. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. x, create a simple Intelligent Cube with attribute Category and metric Revenue. all_timezones)"With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single, unified Web interface. The use of text columns for attribute IDs can impair query performance in the database and, in this scenario, opens the door to inconsistent data handling. Upgrade to MicroStrategy and upgrade the metadata using the same cube files generated before. Partitioning will depend on the type of cube, MTDI (Multi-table Data Import introduced in 10. Summary. This technical article describes an optimization for In-Memory query against Intelligent Cubes to improve filter expression for better performance. •. Smart. 11 Derived Attributes for “Connect Live” cubes were always evaluated in memory. the scheduler that manages the data lake updates, the ability to initiate an on-demand cube refresh immediately after the data lake update is complete. Cube with Date Dim and Currency (as mandatory) 3. This " How to" knowledge base article explains cube advisor. Beginning with MicroStrategy 2020 Update 1, this governing setting is being retired. Kylin 4 is a major architecture upgrade version, both cube building engine and query engine use spark as calculation engine, and cube data is stored in parquet files instead of HBase. Cloud Computing. Published: Jun 7, 2017 Last updated: Jun 7, 2017In Windows choose Start > Programs > MicroStrategy Tools > Cube Advisor. Update Cube Data *. To plan for these memory requirements, see the System Administration Guide. Incremental Refresh Options, Advanced: Use these options to choose whether the incremental refresh is performed using a filter or report. Normally a cube cache stores data in memory and a subset reports based on those cubes can be quickly executed. Use mstr_ko. Plus, our specialists will share tips and tricks to help you avoid common pitfalls and troubleshoot issues that can impact performance. Video Tutorials. Historically, business intelligence (BI) teams focused on building dashboards to run on computer systems. From the performance side it is possible to do a SQL comparison between the two executions, however this was chosen against as the performance impact would be too great for the average user. The iCube creation process is very similar to Reports: Right-click | New Intelligent Cube | Then, add a Template and. It is similar to concept of standard report hitting the database with intermediate table concept of fetching required amount of data and merging it finally with necessary filters to improve. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. Under the VLDB settings for that cube, make sure that to increase the. Level. KB221859: PRIME partitioning guidelines for MicroStrategy 10 . Under the VLDB settings for that cube, make sure that to increase the. We have already. If the New Intelligent Cube dialog box does not open, from the Tools menu, select Developer Preferences. MicroStrategy will monitor the data repository and/or cube memoryOnce the cube is published, these four files are loaded in-memory on the Intelligence Server. Specific jobs will run (in parallel) on Hadoop and then be transfered back to the intelligence server (in parrallel) via TCP. To define an incremental refresh report. The cube can answer most daily questions instead of going back toThis article describes best practices to be taken when using a Teradata database in MicroStrategy. In MicroStrategy 2021, we introduce a new cube type called Attribute Form Caching cube. In 11. Example Performance Data. The following steps demonstrates how to reproduce the issue in MicroStrategy Tutorial project: Create an intelligent cube with Category, SubCategory, Item, Warranty, Call Center. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. . Create a report not based on the Intelligent Cube with Year, Quarter, and Revenue . Starting with MicroStrategy 10. Can benefit from spark new features and ecology. In addition, some other important tuning recommendations are mentioned: OS Level Optimization. To improve performance, MicroStrategy provided a way to bulk insert a large amount of data with prepared statement. 4. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. SUMMARY. For Oracle 12. When you enable these traces, be sure to enlarge the size of trace file to >20MB. This will influence the user experience. The following knowledge base article explains the process to modify the diagnostics logging for MicroStrategy components from the command line in Windows and Unix environments. In-store and online. Number. x. Now offering. In the search, when All objects option is ticked, the cube does not appear. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. To improve the cube publish performance for Oracle, we tried using different ArraySize values and found a more suitable range against the use case. 0 ODBC calls. This is helpful if the Intelligent Cube is used in an internationalized environment that supports multiple languages. For information on how parameterized queries can improve performance in MicroStrategy, see the Project Design Help. To support this configuration, you must ensure that the Intelligence Server host machine uses values greater than or equal to the resource limits described below. The MicroStrategy Intelligence Server 9. As the Architect of the company, you are responsible for creating a dataset optimized for HyperIntelligence. With Redshift Spectrum, you take advantage of a fast, cost-effective engine that minimizes data processed with dynamic partition pruning. In the Platform Analytics directory, located at C:Program Files (x86)MicroStrategyPlatform Analytics, open the conf folder. Create a new variable and assign SuperCube with two parameters inside – connection and id. You can optionally remove cells that have a value of zero. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Cube A's refresh policy is set to "add new data. MTDI cubes are the self-service in-memory solution. When a remote accesses this cube, the cube is loaded into memory of the. Further in order to enhance the performance and quality of the reports produced we can follow the. if it’s take less time then you’ll have something to do with MSTR or fine tune DB SQL with the help DBA. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. Then click "Save". Full in-memory load can even be a hinder to full deployment. Optimize Aggregation : Generates optimized views based on collected. Cyber Security and SIEM Tools. However, subset. Iterate through the enumeration to get the cubes per project and the corresponding status. jar file to i-server machine. . There are two main settings involved in cube partitioning configurations: Partition Attribute: The attribute you select to partition should be the one with the most cardinality in the cube. x). x. In MicroStrategy versions prior to MicroStrategy 2021 Update 1, the cube cache file that is saved to disk does not include an Attribute Element Index, which is generated during cube publishing to improve cube querying performance. Purpose of the registry key. The MicroStrategy Performance Analysis service delivers:. Select data population for Intelligent Cubes. This presentation helps users understand MicroStrategy's in-memory architecture. Use Index on all Key columns ( for conditions from WHERE clause,. 2. Then go to the key “Query. Select the Enable report drilling check box. println ("For project: " + cubesPerProject. Complete the "sessionState" field (e. In MicroStrategy Secure Enterprise an Intelligent Cube goes through an. Business Intelligence and Analytics. The cube can answer most daily questions instead of going back toThis article describes best practices to be taken when using a Teradata database in MicroStrategy. This name change is visible in. Starting 10. Project Overview: Analyze the performance of the MicroStrategy projects and determine which users connect to them and which products they use to connect. For a single cube publish, using 3. Open Confluent Control Center. All of the object comparisons take place before the SQL is generated as they are part of the determination in how to correctly generate the needed SQL. MicroStrategy consistently pushes updates to the Chrome Web Store when any issues are resolved. This article describes the Intelligent Cube Population options available in MicroStrategyReturn on investment (ROI) is a critical metric for any business as it measures the profitability of an investment in relation to its cost. In MicroStrategy 10. Note that the behavior is the same when searching for the cube in MicroStrategy Developer via Tools > Search for Objects: CAUSEEnable dynamic sourcing for the project and other aspects of the MicroStrategy system. Use Case 4. 0, dynamic growth algorithm for buffer size is introduced to improve the performance of buffer, and it is enabled by default. 0. Run both reports after enabling the metric levels log. Review steps below to improve bulk data load from Redshift to MicroStrategy. Cube with Date Dim and Carteras_Desc (as mandatory)We should ignore the size of the Cube in the Cube Monitor when the Status is "A,F" (Active, Filed). Its name stands for MicroStrategy Parallel Relational In-Memory Engine. Logs name for PU, Command ID, and execution Status. 5 compared to ODBC call 2. Load an updated CSV file into a DataFrame providing full path. This functionality is run in a separate process to isolate MicroStrategy Intelligence Server 9. You can learn more about Enterprise Manager in the following documentation resources:In MicroStrategy Desktop 9. All from Workstation, the resulting data can then be published to be stored in the Intelligence Server’s memory. This article narrates large cubes appear in ‘LP’ status and some other cubes not shown up in cube monitor in MicroStrategy 2021 is due to loading cube info thread being blocked by loading the large cube instance. instead of storing all data in-memory as a normal Intelligent Cube. Starting from MicroStrategy 9. Although the default memory usage limit is 500%, sometimes it can be set as low as 50%. Before you create an Intelligent Cube, search through MicroStrategy to see whether a similar Intelligent Cube already exists that can serve the same. In kylin4, sparder exists as a long-running spark application. Easily add or change pre- and post- SQL statements. If you use Enterprise Manager, dedicate a machine for the Enterprise. Cube and Cache Monitoring: Ensure that cubes and caches are being fully leveraged to improve the performance of key analytics content. You can edit project-level cache and Intelligent Cube settings. 0. x. 6. Matching and Number of Keyword Limitations. 1, Intelligent Cubes have a new feature to update information without republishing it. Solution. 0. Once the object is used in the card, right-click the object. KB36020 "New Statistics and Enterprise Manager tables designed to track new Intelligent Cube Operations in MicroStrategy 9. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. Every new MTDI cubes appears as hidden object in Microstaretgy 10. 10 where different behavior is seen in between a Live connect and In-Memory cube when filtering on warehouse null values in Dossier. With Kyvos’ Smart OLAP™, you can modify the existing cube to add, delete or reorder the entities by eliminating the need to rebuild the cube. With Redshift Spectrum, you take advantage of a fast, cost-effective engine that minimizes data processed with dynamic partition pruning. Performance with mixed selections may vary significantly due to the selections of different elements in Warehouse, such as the performance difference between Case 5 and Case 6, Case 7, and Case 8. Select the Data Partition category. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. This article explains how to use MicroStrategy Cube Advisor with MicroStrategy Intelligence Server Universal. This technical note will describe the steps to specify the partition attribute and the number of partitions in a regular Intelligent Cube and an in-memory Intelligent Cube created via Data Import. For the steps to define an incremental refresh report, refer to:Normally, when memory depletion or delayed system performance occurs, page cache can be a checkpoint. With Parameterize Query on, the query can be re-used and the data retrieving performance will be increase by 10% for IBM Db2. (In MicroStrategy Intelligence Server Universal environments in UNIX/Linux, this may require the memory contract manager setting "Memory reserved for other processes" to be increased. Refer to Product Manual for more detailed information. To achieve this, cube processing in the MicroStrategy. You can further improve query performance by reducing the amount of data scanned. Download the attached PDF for an in-depth understanding of Object Migration best practices. There is general performance degradation introduced by Sub-query. When you enable these traces, be sure to enlarge the size of trace file to >20MB. In-store and online. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. It illustrates tips and tricks, such as enabling parallel data fetch, enabling the correct number of partitions, enabling partition on the appropriate attribute, and using cubes vs. Cube 7: Improve cube response time. 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. The data get's fresher, faster, and less resources consuming for everyone. An Architect creates, publishes, and optimizes a federated data layer as the enterprise’s single version of the truth. Learn how to increase the JVM Heap size for Microsoft Internet information services to allow for better performance. This would require that you have all your attribute relationships defined correctly. You need the Use Intelligent Cube Editor privilege to create Intelligent Cubes. MicroStrategy PRIME goes far beyond by adding a complete extra layer between the data store and the data analytics layers, allowing to process orders of much higher magnitude and. This report is prompted on time and on the job type you want to analyze, and you can select the. Full control. Starting from MicroStrategy 10 – you’ll see tge optimized form of Intelligent Cube based reports SQL modified as below with better optimizations. Learn how to use Intelligent Cubes to optimize performance in MicroStrategy Developer, an advanced environment providing a complete range of. hasMoreElements ()) { //Get the intelligent cubes for one project Caches cubesPerProject = cubesEnum. Unified calculation engine for building and querying; 3. 3. Use Cube Advisor to create Intelligent Cubes: 1. Use the table below as a guide to determine whether switching to a single Intelligent Cube as dataset can improve the performance in your environment: 3. Prior to 10. Can benefit from spark new features and ecology. 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 can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. Distributed query engine，avoid single-point-of-failure; 2. yaml file and update the viewCutoffRangeInDays field to the. 0 cubes is the ability to partition cubes. Rather than returning data from the data warehouse for a single report, you can return sets of data from you data warehouse and save them directly into the Intelligence Server memory. Course Categories. Partitioning will depend on the type of cube, MTDI (Multi-table Data Import introduced in 10. The ID of the Job would be useful in order to read the job trace. Add filters for Year and Quarter through the Advanced Filter Editor by clicking on the 3-dot icon on the grid visualization and select Edit Filter. Create the metric levels log file used to track the use of dynamic sourcing. The third most common microstrategy developer skill is templates on 5. This feature is addressed in MicroStrategy 2020 Update 2 and MicroStrategy 2021. 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. The impacted index sorting are basically Integer operation, and based on information online, MicroStrategy 2021 Intelligence Server is 25+% slower than MicroStrategy 2020 Intelligence Server. Publish the Intelligent Cube by executing it on either of the nodes. In MicroStrategy Secure Enterprise an Intelligent Cube goes through an Attribute Index based optimization during the publication to produce the smallest effective size based on cardinality. The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. VLDB settings 4. Parallel query execution is disabled by default to allow you to first verify that your reports and Intelligent Cubes are executing correctly prior to any parallel. Steps to reproduce. Web Open the Settings page (right click the extension and select Options). Apply the year prompt to to view filter of the intelligent cube report and the report filter regular report. In the Navigation pane, click , next to Datasets. API Management and Testing. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. 3. This will influence the user experience. CI/CD Devops. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. 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%. The MicroStrategy Intelligence Server 9. x) or OLAP (first generation of in memory cubes, introduced in 9. In Asian languages, the minimum length is one character. This article discusses how the Data Import functionality utilizes multiple threads to improve the cube publishing time, when performing a data import against CSV/Text files Best Practices Articles (Performance Tuning Based on IBM Db2) This article describes best practices to be taken when connecting an instance of IBM Db2 in MicroStrategy. To make use of bulk insert for Snowflake, user can simply enable “Use Parameterized Queries” when creating DB Role: After bulk insert functionality is enabled, it enables reuse of SQL statements and only set new parameters. For example, you can choose to add or delete data from the Intelligent Cube. QUESTIONUpgrade to MicroStrategy 2021 Update 2 still notice the performance difference. This setting defines the amount of Intelligent Cube data that can store in Intelligence Server memory at one time for a project. These settings affect how MicroStrategy Intelligence Server manages joins, metric calculations, and query optimizations, among other options. If the data requirements for the report change, or cannot be satisfied by an available Intelligent Cube, the reports automatically access the data. In the bottom section, under Destination note the location of. CONTENT: Enable cube partitioning, the partition attribute should be the attribute with more cardinality in the cube (more cardinality means the attribute with more different elements, for example in the Tutorial project the. This attribute should have a lookup table in the SQL data warehouse. If the user account for the data warehouse has permissions to create tables, switch to the option Normalize Intelligent Cube data in the database . You can edit project-level cache and Intelligent Cube settings. 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. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. Click Modify to open the Properties dialog box: Security tab. Report runtime performance for reports accessing Intelligent Cubes is optimized because the Intelligent Cube for the report has already been loaded. Login to MicroStrategy Web, create a cube with the function of Data Import. The in-database Advanced Analytics gives you the insights you need to improve everything from database performance to your company’s inventory management. Distributed query engine，avoid single-point-of-failure; 2. Refer to Product Manual for more detailed information. Business Intelligence. The following article provides information for measuring the Intelligent Cube performance parameters for time and memory in MicroStrategy Intelligence Server 9. Normally a cube cache stores data in memory and a subset reports based on those cubes can be quickly executed. x ODBC calls have approximately 30% performance improvement than using 2. These enhancements include: Improved Data Compression: New data compression algorithms enable MicroStrategy’s In-memory cubes to store up to three times as much data as before. Required Status to Perform Action. 0 and 2019, users will notice objects referred to as "Super Cubes". To get the best performance out of your MicroStrategy/Any system, you must be familiar with the characteristics of your system and how it performs under different conditions. This copy of report data is stored in Intelligence Server memory only. Watch this video to learn more about the Expert. For the other types of output, MicroStrategy Office and MicroStrategy Web in DHTML mode, the Intelligence Server generates XML. Under Refresh type, select one of the following options. sh . 4. An Intelligent Cube is an In-Memory data structure which holds. The first step in analyzing. Maintain your competitive edge with a data-driven retail app designed to scale—from individual locations to global franchises. MicroStrategy implements a list of strategies to generate intermediate tables the choice of which can have a significant impact on query performance. Starting from Microstrategy 2020, for duplicated filter conditions, the Engine will only calculate the temporary result once and reused for the same filter conditions, so that the performance can be improved. 7, and later versions, non-distributive metrics do not return correct data, because the engine does double aggregation due to the optimization done in DE81833. All Intelligent Cube operations are listed below: 1. 11, 10. With the buffer size dynamic growth. This Knowledge Base article describes the steps to filter data for the current month in a cube report. In-store and online. Instead, Command Manager can be used to display the cube status. Dec 2017 - Present 6 years. This is particularly useful when there exist many Intelligent Cubes that have to be published but require a high amount of memory in the process so executing them, all at the same time is not feasible. After you find the microstrategy. This Technical Note describes how the project level governing limit “Maximum RAM usage (MBytes)" for Intelligent Cubes is implemented in a clustered environment. Platform Analytics captures telemetry from the MicroStrategy platform in real-time, and then it presents this data to the administrators, developers, and analysts to help them optimize the performance of their MicroStrategy system, offer personalized recommendations to their business users, improve their analytics apps, secure their data, and more. Use a cube with MicroStrategy if you're only concerned with last month’s aggregated data. Select one of the following: Drill anywhere: (the default) All drill paths in the drill map for the dataset report are shown. Subset report or view report caching can improve dossier performance in almost 70% of all cases. •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. However, after publishing,. In order to obtain those values, users must select at least one performance cycle in the Processing options window as shown in the following image: Once the test is completed, the user will get the minimum, maximum and average time of. With Parallel Hierarchy. The second most common hard skill for a microstrategy developer is bi appearing on 5. To update the newly created Super Cube, create a new script starting from repeating steps 3-7. While performing multiple queries in parallel can improve the performance of query execution in MicroStrategy, it will not provide the best performance or results in all scenarios. 9 and 10. Retail is leveling up with omnichannel analytics. x from any unexpected conditions. Create an attribute element prompt for the Year attribute. Sure, currently just exploring the mstrio. 3. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. in MSTR, go to project config, increase the project memory settings. To apply security filters to MDX Cubes, the filtering attribute in the cube must be mapped onto a project attribute. SUMMARY. Starting from MicroStrategy 9. In MicroStrategy, users can create and manage datamart tables in a different schema, database, or server from the data warehouse. Regression DefectThe MicroStrategy Internal Reference Number for the issue discussed in this technical note is KB442296 and DE91603. Cube Instance ID: The ID for the current published version of the Intelligent Cube. 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. There are two main settings involved in cube partitioning configurations: Partition Attribute: The attribute you select to partition should be the one with the most cardinality in the cube. C. MicroStrategy's support for parameterized queries can improve performance in scenarios that require the insertion of information into a database. it should be large enough to process it quickly. We cannot include custom groups, consolidations, derived metrics, prompts, or view filters in an intelligent cube. 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. Best Practices with MicroStrategy. If you used this option in 9. When running an integrity test, users might want to get the execution time of the report or document. view reports. Choose the Topic to send to MicroStrategy and click Continue. 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:. Click Modify to open the Properties dialog box: Security tab. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. The default value is 256 megabytes. PublishCube". If it is not possible to improve data consistency in the database, the Intelligent Cube report may be configured to normalize data in the Intelligence Server. Option 2: Have all your 46 million records pulled into a cube. 4. Dossiers automatically adjust to look great on any screen. g. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesFollow the steps below to delete an OLAP cube database instance from MicroStrategy Developer.