Stop MicroStrategy Intelligence Server in all cluster nodes. Windows: C:\Program Files (x86)\MicroStrategy\Intelligence Server\TLS. Perform a single project test against one project. For more details, see KB442160. "" -n "" -u -p -f. Depending on the resources available and the version installed, please set the Maximum working set RAM to a number between the following list:. The search specifies a base location in the directory tree as specified by the user in the "Search root distinguished name (DN)" field of the MicroStrategy Intelligence Server configuration. browser cache etc is all cleared even tried with re-installing library server. The default value is 256 megabytes. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. war file on a default MicroStrategy Windows installation. Change the UseUTC value to 1, as shown below: Restart the MicroStrategy Logging Client and MicroStrategy Logging Server services from Control Panel > Services for the changes to take effect. So MicroStrategy Intelligence Server has to be re-started for this setting change to take effect. x in Windows environment. Right-click on User Defined and select New. scpBACKGROUND: 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. To forecast future needs, you can plot user load against the resource consumption graphs above. Choose the individual modules to be logged. On MicroStrategy 10. Tables v9. The book starts by detailing the different. If MicroStrategy Intelligence Server Universal is running on a Unix machine, then the default location of the DSSErrors. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. KB439852: In MicroStrategy 10. Select the "exportMaxCellsPlainText" setting and modify the "Maximum" value under "Other. 7, the MicroStrategy Messaging Services services can also be registered with the operating system during installation. FrameProcessor. The goal of failover is to maximize availability of the MicroStrategy Intelligence Server. Optionally, you can change the location or name of the Keystore file clientKey. So even if the usage is for the regular Single-Byte Character Set (SBCS), it is calculated as two bytes per character so that there is a. instancename is the name of a server instance, where required. If you are configuring MicroStrategy on: Windows, go to Start > Programs > MicroStrategy Tools > Configuration Wizard. Increase the Maximum RAM Usage (MBytes) governing setting for caches for the project to something greater than the size of the report that was sent to the History List. Method to. As seen below, the MicroStrategy Library version is still 11. Speed is typically measured as user wait time or. The Intelligence server has entered MCM denial state, but recovers and then works as expected. trustToken and auth. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Efficiently manages thousands of end-user requests (jobs. By default, the mstr database. xml'. LDAP Integration with the MicroStrategy Intelligence Server: To integrate users and groups stored on an LDAP server within the MicroStrategy Intelligence Server 9. During startup the State will display as . Choose Security > Internet and/or Intranet. The ability to view or edit certain settings is determined by a user's privileges. Type in the URL box the MicroStrategy Mobile Admin page URL with the fully qualified domain name (FQDN),. 3. STEPS TO CONFIGURE: Get the path of images folder on the intelligence server machine. In the top right corner, click MSTR User and then click Preferences to access Web Preferences. Locate the web. 0. in my company we are using Microstrategy 10. Right-click an Intelligent Cube and select Delete. Disconnect. The following best practices can help ensure that users get the most accurate results from a performance test: Performance comparison tests should be run as single-project integrity tests. When considering load balancing in MicroStrategy environment, the two most critical points. Theoretically, capacity is a certain. This option must be selected for any statistics to be logged. In the Open drop-down list, type cmd and click OK. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. This video will cover how to update the MicroStrategy Intelligence Server License Key and activate installation through License Manager. All files under the conf folder are overwritten when you upgrade MicroStrategy. Governance of CPU clock speed when installing MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Narrowcast Server. The setting described below (ServerName) is NOT ONLY for the '&SERVERNAME' macro used in the history list URL. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Server Activation registers each Server Installation with MicroStrategy and locks the installation to a specific machine. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. Find MicroStrategy’s public API in Postman and make your own copy (Fork). x and 10. The MicroStrategy Intelligence Server Universal on Linux operating systems can only be registered as a service by a user running with a root or privileged account. command is one of the commands from the list below. reportID. of setting up the environment for the MicroStrategy products installed. Cube Extract a MicroStrategy cube into a R Data. exe application from the extracted zip file. . You can find this ID by running the “ps” command. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. If present, the report is fetched from memory and the reportID argument is ignored. ProjectSource. The following procedure describes how to ensure the web server, mobile server and intelligence server use images from the same folder in MicroStrategy 9. x, text in documents still default to that font. The memory used by Intelligence Server is limited by the machine's virtual memory. MicroStrategy OLAP Services allows users to analyze data by slicing and dicing, inserting new metrics and filters, and manipulating reports in-memory without executing queries against the data warehouse. With the Parameterized Query option enabled, reports containing text filters and prompts will be executed using parameter markers (?) during SQL execution. ACTION:MicroStrategy recommends that the Linux kernel setting vm. Depending on the resources available and the version installed, please set the Maximum working set RAM to a number between the following list:. You can use a linear or exponential extrapolation to plot how increase in user load will drive resource consumption. Increase the size of Maximum RAM for Working Set cache to a higher value. Click the icon in the Actions column and select Start, Stop, or Restart. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Specify subset of cube to be Crash data is automatically uploaded to microstrategy. Enter the User Name and Password for the database. To be able to connect to the Directory Server however, MicroStrategy Intelligence Server 9. 2. In MicroStrategy 11. Increase the upper limit on capacity for Aurora Serverless v2 DB instances by changing the maximum ACU value for the cluster. Right-click a connected environment and choose Properties. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. type: Puppeteer exporter. OR, to convert an existing filter into a security filter, click Import. KB6446: How to increase the heap size of the Java Virtual Machine to handle large result data objects with MicroStrategy Web 9. Two different options exist for methods to deal with environments that have different supporting database servers. Beginning in MicroStrategy 10. To increase the number of server nodes, click the 'Number of Server Instances' dropdown. Hello, We had the same problem after upgrading our 11. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. Make sure that SSL is already configured and note down the REST port number used, as shown in the screenshot below. Performance degradation occurs because the MicroStrategyWhen a cluster of MicroStrategy Intelligence Servers connects to MicroStrategy Web, the following behavior can be observed in the MicroStrategy Web Administrator page: All MicroStrategy Intelligence Servers in the cluster will be added as a single unit, as shown with the example above. System Performance Trends. Copy, paste, and execute the following XML script into the command line:Add the MicroStrategy Mobile Admin page URL with the full domain name to the list of Trusted Sites in Internet Explorer: Navigate to Tools > Internet Options > Security > Trusted Sites, like shown below: Click on the 'Sites' button. This action starts MicroStrategy Intelligence Server on 'M1. 3. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). Double-click the new connection mapping in each column to select the database instance, database connection, database login, and language. 4 GB or. Upload FilesOr drop files MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. When the job monitor depicts the status as 'executing,' the executing status can apply to the execution of the job within any Processing Unit (PU). KB440719. Login to Postman and search for MicroStrategy in the homepage search bar. Click Options. When users try to start and stop MicroStrategy Intelligence Server from Windows Services by going to Settings->Control Panel ->Administrative Tools ->Services, they can start and stop MicroStrategy. x to version 10. Note, for more information refer to tech note KB10211. Prerequisites for Windows Clustering. The requests are granted or denied according to user-configured limits on the amount of. Under Collections, click on the the “…” next to. g. 52K. Once logged in, the user must navigate to the /etc/init. For prior releases, either a cube was loaded, residing completely in RAM, or unloaded. Browse to the filter you want to convert and click Open. Selected. The path to the Web server application is entered in the Web Server Application field. Production capacity is the maximum possible output of a manufacturing business, measured in units of output per period. Configure Metadata Connection. MicroStrategy provides In-memory BI capabilities that leverage 64-bit operating systems to improve the overall performance of a BI system. By default, it is C:Program Files. Watch on. To improve the data fetching performance for JDBC connections, Administrators can also increase the JNI Bridge Heap Space. The chart below shows how the statistics collection change from MicroStrategy version 9. Start Apache Tomcat. A Processing Unit is a job-queuing and processing station with a collection of tasks, that a job will undergo after it is submitted to the MicroStrategy Intelligence Server. When State displays Running the service is ready. Refer to the following Community article for details on how to increase this setting: How to set the maximum Java Heap Size value for JDBC source connectivity in MicroStrategy Developer and Web 10. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. The requests are granted or denied according to user-configured limits on the amount of. This information can then help MicroStrategy Administrators monitor the health of their memory usage and determine when they should unload cubes, stop certain jobs, or adjust the memory limit setting. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. g. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. How to Perform Capacity. Adding more capacity to a server product. From the Windows Start menu go to All Programs > MicroStrategy Tools > Web Administrator. Select Configure Intelligence Server, and click Next. In MicroStrategy Developer, log in to a project source with administrative privileges. 2. What is the reason for the. Open your remote desktop connection. KB439951: How to set the maximum Java Heap Size value for JDBC source connectivity in MicroStrategy Developer and Web 10. This Knowledge Base article addresses an identified defect where the Web Pool Size setting doesn’t do anything in MicroStrategy 10. From the Oracle Java Virtual Machine Specification Java SE 7 Edition, the heap is described as:. Modify IE 11 Security Setting to enable Allow Font Download: Go to Internet Explorer > Internet Options. Select the component to be configured from the list. The crash collection server analyzes the incoming crashes and notifies MicroStrategy technical support and production teams for the incidents. Together, they are often referred to as the JSON Data API. xml > isAliveRequestTimeoutMillis. For example: "C:Program FilesMicroStrategyAdministratorCommand Managercmdmgr. From the DSN drop-down list, select the DSN used to connect to the metadata repository. You can use the MicroStrategy Configuration Wizard to upgrade your statistics repository. The average salary for Systems Performance/Server Capacity Analyst at companies like MICROSTRATEGY INC in the United States is $83,900 as of November 23, 2022, but the range typically falls between $72,200 and $97,000. Perform the following steps to install MicroStrategy Library on a Windows server. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. x-10. x information regarding the connected servers or to make changes manually to the connection properties of a MicroStrategy Intelligence Servers without using the MicroStrategy Web 9. x, users should see the Intelligence Server automatically rejoin a cluster upon restart. 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. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. After upgrading from MicroStrategy 2019 Update 1 to MicroStrategy 2019 Update 2, it takes much longer to start the Intelligence Server. The below steps can be used to deploy the MicroStrategyLibrary. In the MicroStrategy Library Configuration box, enter. You should periodically reevaluate the system and update it based on. From the pane on the left, select Servers. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. Find MicroStrategy’s public API in Postman and make your own copy (Fork). In the Server drop-down list, select the name of the machine on which the service is installed. Then this file is used for Web, Library to communicated with IServer right? Then the file microstrategy. Enabling LDAP Authentication for MicroStrategy Web. Once the server is stopped, you can then start it up again by using the. 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. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. log recorded by the MicroStrategy Intelligence Server on Linu… Number of Views 3. To set up MicroStrategy Intelligence Server. Click the Add button. Run Command Prompt as an administrator and enter the following command: netsh add urlacl url=or port/api user=domainusername. Network configuration best practices. 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. This can be confirmed using the MicroStrategy Service Manager, as shown. The DNS needs to recognize the entry as a machine and be able to resolve its. There's a reason we're at the top of the list. If administrators attempt starting MicroStrategy Intelligence Server from Administrative Tools > Services, they. browser cache etc is all cleared even tried with re-installing library server. Right-click in the grid and select New to create a new connection mapping. Unlike major releases and service packs, hotfixes and patches are differential updates of the product, meaning that only a few of the binaries are rebuilt and re-stamped with the hotfix or patch version. Salary ranges can vary widely depending on many important factors, including education, certifications, additional skills,. If some Intelligence Server nodes are/were down, you can start them first and then restart Library Server. optional): If True, utilize optimal number of threads to increase the download speed. 10 xxxxxxxxxx. List Nodes GET /monitors/iServer/nodes Get information about nodes in the connected Intelligence Server cluster, including: Basic information Runtime state Information for the. 1 the following memory setting must be altered in the Windows Registry ( since the default setting, is not enough to some of the MSTR functions) Set the value of HeapMaxSize under the following path to at least 2048M. Port number of the server. Select a dataset. The MicroStrategy Configuration Wizard walks you through the process. Once connected to a node, the Web user runs all MicroStrategy activity on the same node. Failover is a key feature in a. x in an interactive mode in Windows and UNIX. xml should do. The objective of this document is to provide an estimation of resource requirements for stable and performant operation of. There are a few steps that must be completed in order to restart the MicroStrategy Web Server on a Linux machine. (Min 2) Maximum number of renderer processes. There are various applications of MicroStrategy. Analyzes system performance over time using your choice of metrics. 3. Remember to replace all child object permissions. KB235107: How to Embed a Custom Font Without Having to Install it on the Client Machines using MicroStrategy Web SDK 9. Using the Memory Contract Manager. This knowledge base article outlines requirements, considerations, and steps to take when enabling MicroStrategy Library and MicroStrategy Collaboration Server for secure communication and/or load balanced service. In a UNIX console window, browse to the "bin" folder under <HOME_PATH> where the MicroStrategy is installed. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. Enter the User Name and Password for the database. , an abnormal shutdown due to errors or the process is killed). This file can be found under: <install drive>Program FilesMicroStrategyIntelligence Server for a default installation of Microstrategy on Windows. Select Configure Intelligence Server, and click Next. When the job monitor depicts the status as 'executing,' the executing status can apply to the execution of the job within any Processing Unit (PU). x. When launching the MicroStrategy Service Manager, notice the Intelligence Server is already in a stopped status. GetProjectSources. Step 4: The "status-iserver. Alternatively, please run: c:Program Files (x86)Common FilesMicroStrategyTomcatapache-tomcat-9. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. As a new platform release, MicroStrategy 2020 introduces new features that provide better performance and scalability to enhance the overall user experience. x to be restarted in order for the changes to take effect. The license check takes place anytime within the next half hour of the time specified in the setting. Telcos using MicroStrategy can run. Diagnostic logs will be sent to the Messaging Services Server after you perform the following: Enable MicroStrategy Messaging Services. The speed at which all programs and processes run depends on the CPU’s performance capacity. For example, if the RAM swap multiplier setting is 2 and the requested cache is 80 Kilobytes, 160 Kilobytes are swapped from memory to disk. 0. The Java Virtual Machine has a heap that is shared among all Java Virtual Machine threads. The ultimate goal of load balancing is to use all available resources in the most efficient manner, leading to improved system performance. This will prompt to stop the MicroStrategy Intelligence Server process in order to create the new Server Definition. Get an estimated database size . properties: document. backtrace. In the Action column in the Unconnected servers list, click Connect for the Intelligence Server to connect to. 4. Ensure auth. Make sure all Intelligence Server nodes are running during the life-time of Library Server. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. This technical note will explain six methods for determining which server definition is currently being used:Click on Access MicroStrategy Platform to open MicroStrategy Web. The video also presents how the data from Salesforce reports is converted to MicroStrategy attributes and metrics. 4. in your system. jks file including the cert with a passphrase, e. xml file: <memory> <logging_time>DATE_AND_TIME</logging_time> A connection pool is a collection of TCP connections maintained in the Web server's memory. The default value is 256 megabytes. Click on the Developer Machine Name to copy it. MicroStrategy ONE is a comprehensive intelligence platform that integrates the power of generative AI with the precision of BI. Select Configure Intelligence Server, and click Next. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. CAUSE: This is working as designed. MicroStrategy Library fully supports Kerberos authentication in Windows on Tomcat. 9Performance is a combination of speed and scale. You can search, view, and edit server-level settings. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. 5 GB. Run Command Prompt as an administrator and enter the following command: netsh add urlacl url=or port/api user=domain\username. xml', for example 'status-iserver. The MicroStrategy Intelligence Server was unable to swap out the report instances of 40MB in the Working Set. The original method of migrating MicroStrategy Metadata database server platforms consisted of creating a new MD shell in the destination environment and migrate projects one by one into the destination shell. Access to a machine with the keytool utility. mstr file is actually a . exe" utility that is installed with MicroStrategy in the "Common Files\MicroStrategy" folder to capture the logs output by the Intelligence Server. If only a single MicroStrategy Intelligence. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. x. DisconnectProjects. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. 3. A third party IP distribution tool such as Cisco Local Router, Microsoft Network Load Balancing, or Microsoft Windows Load Balancing Service distributes the user connections from the Web clients among Web Servers. 0. For an example of how to do this, see the sample code below. Property Default Value Comments; exporter. renderer. For example, sample cube. In addition to the above setting, another major reason for a slow project load could be any additional traces or logs that have been turned on for. Select one of the following to determine when and how MicroStrategy Web. xml should do. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. For this reason, outbound network traffic needs to be allowed on port 443 in order to transmit the data. On Linux, all log files are stored in /opt/mstr/MicroStrategy/log. x on Linux as a service makes changes to the scripts required to be run at the system startup. Note: Make your configuration changes to the configuration files located under the admin folder. This is likely the case if the service is disabled or. To access the Intelligence Server Configuration Editor in Developer, right-click the Intelligence Server and select Configure MicroStrategy Intelligence Server. Click Dependencies tab, the above 3 dependencies are listed. Both enabling and disabling logs are covered. Database specific settings By default MicroStrategy will still send Intelligence Server diagnostic logs to local disk. There are a few steps that must be completed in order to restart the MicroStrategy Web Server on a Linux machine. Server-level settings At the server level, only a few settings from each category need a server restart. Launch MicroStrategy Developer. MicroStrategy Developer must successfully connect to the Intelligence Server via the SSL port. The Intelligent Cube Monitor is displayed. If no Intelligence Servers are listed or connected, add an Intelligence Server and connect it to MicroStrategy Web. Start building with MicroStrategy to deliver exceptional product experiences. This can be achieved via the report level VLDB property > SQL Time. After calculating the production capacity of each product, you can calculate the factory output rate for multiple products. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. Select the Default option to set LDAP as the default authentication mode. The following are the methods that support connecting to and disconnecting from a MicroStrategy Intelligence Server: MOIOffice. io through protocol. In this article, the MicroStrategy team will review: Prerequisites. process. Setting this to a higher limit does not mean the memory will be set aside for immediate use by the Microstrategy Intelligence Server. KB20300: After removing the Tahoma font in MicroStrategy Web 10. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. Although it is possible to use the Microsoft Access database. Telemetry Server Configuration: If you want to setup messaging services cluster, tick the check box "Create a cluster of three or more Telemetry Servers", input the local machine name and remote. Select “MicroStrategy SDK”. Steps. x on Linux as a service makes changes to the scripts required to be run at the system startup. For New Export Engine in MicroStrategy 2019, when the number of concurrent user increases, the throughput (pages per minute) would remain almost unchanged. Re-run the Configuration Wizard and enabled TLS. properties file. x, join cluster fails or doesn't work fine if two nodes don't know each other’s' machine name. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. 10. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available! How to increase the Java Heap size in Tomcat Application Server; KB222220: Images are not displayed in Excel documents that are delivered through Distribution Services in MicroStrategy 9. The Servers page opens. The project default level preferences are accessed by the Web server at connection time. It also explains the setting in the Web Admin page Allow automatic login if session is lost. KB48030: Font change is not applied to the graph in MicroStrategy 9. User session and project session analysis. 2 (2020). Prerequisites. Platform Analytics repository size may be observed increase rapidly with advanced statistics enabled. Expand the Data Collector Sets node. instancename is the name of a server instance, where required. Configuring MicroStrategy and getting started. Efficiently manages thousands of end-user requests (jobs. Depending on the version installed (as a best practice no higher than the 25% of the available RAM in the server), the Maximum working set RAM values to are is on the following list:Before MicroStrategy 9. When a setting is not a runtime setting, MicroStrategy Desktop prompts users to restart MicroStrategy Intelligence Server 9. When the MicroStrategy Web 9. backtrace. 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. com) to the hosts file of the Library server machine to manually resolve the iserver name. Restart MicroStrategy Web and Mobile Server. 0. MicroStrategy Library. SSL must already be configured on the MicroStrategy Intelligence Server. Select Automatic as the Startup Type option. Add the IP to hostname mapping (e. The bSet cookie used to store various Web GUI settings such as: The state of the report details section (shown/hidden) The state of the page by axis (show/hidden) The state of the view. Significantly improves user-perceived query performance. Enable the statistics logging for the project. x instance using the following command from the bin folder of the MicroStrategy Home folder:. Use Response file. Setting this to a higher number may improve performance under high job concurrency, but it increases the amount of time caches that exist in memory only (i. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. Do not change the files under the conf folder. mstr file is a zipped file of object definition package and cube files. reg file (which is located in the Microstrategy home folder) "InstallName"="root@2015-10-21T10:09:23" needs to be changed to "InstallName"="root@" (in the HKEY_LOCAL. With the 10. csv file to keep a record of their settings, or import a previously save file to apply the setting to a project. zip and use 7Zip, or similar tools, to unzip it. Project default level preferences are set at the MicroStrategy Intelligence Server 8. zip file, with the. Enterprise environments can have up to 4 clustered nodes. The PostgreSQL ODBC Driver has the best cube publish performance as it has the highest throughput. Editing cluster membership is an administrative action and should be performed exclusively. Under Collections, click on the the “…” next to. /mstrcfgwiz. In the Service drop-down list, select MicroStrategy Intelligence Server. 1 (2019) rather than 11. process. x from the Command Line, run the following command: $ mstrctl -s IntelligenceServer stop. In reality, an . To do it, hover over the icon and click Edit Connector. What's New in MicroStrategy 2020. Queries can have a significant increase in the fetch time when there are tables containing VARCHAR without specifying a size in Snowflake. All necessary privileges are included in the Administrator role by default. There is one setting in the MicroStrategy Intelligence configuration, available in Developer and another one in the application server. This is because registering MicroStrategy Intelligence Server Universal 9. The MicroStrategy Intelligence Server 9. x or 10.