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. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. Then it presents this data to the administrators, developers, and analysts to help them optimize the performance of. To manually configure the MicroStrategy Repository, Platform Analytics, and the Collaboration Server database user, schema, and warehouse, use the steps below: Prerequisite : Ensure the mstr user, or any other non-root user used to register services, is a valid system user and able to log in. The license check takes place anytime within the next half hour of the time specified in the setting. This video walks through the process of directly importing data from a Salesforce report into MicroStrategy Desktop 10. Right-click an Intelligent Cube and select Delete. Load balancing directs new Web connections to the least loaded node, as measured by user connections. What is the reason for the. The preferences are stored in memory. Upload FilesOr drop files MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. x - 10. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. 11. KB48030: Font change is not applied to the graph in MicroStrategy 9. This will generate a new certificate and key pair and start the Intelligence Server. renderer. Open the MicroStrategy Configuration Wizard. • Enterprise Manager. System Performance Trends. in my company we are using Microstrategy 10. This Knowledge Base article addresses an identified defect where the Web Pool Size setting doesn’t do anything in MicroStrategy 10. x. Configuring MicroStrategy Using Command Line Tools: MicroStrategy tools are provided in command line mode on Linux so that you can. Database specific settings By default MicroStrategy will still send Intelligence Server diagnostic logs to local disk. 4. This is because registering MicroStrategy Intelligence Server Universal 9. 5. x Statistics are enabled and a dashboard is executed the MicroStrategy Intelligence Server stats are incorrectly reported as a. 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. Microstrategy Intelligence Server status information is stored in the file system under a file called 'status-iserver. However, MicroStrategy NT authentication will fail to login since IIS will not pass the user's NT login ID which comes from the MicroStrategy Login process. On MicroStrategy 10. 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. Run Command Prompt as an administrator and enter the following command: netsh add urlacl url=or port/api user=domain\username. Right mouse click on the project source of the Intelligence Server you wish to remove the trust relationship from. io through protocol. log recorded by the MicroStrategy Intelligence Server on Linu… Number of Views 3. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend >and integrate the MicroStrategy business intelligence functionality into other applications. Two different options exist for methods to deal with environments that have different supporting database servers. We need to use the same REST port number when binding to the SSL certificate. The JSESSIONID or ASP. Make sure that SSL is already configured and note down the REST port number used, as shown in the screenshot below. How to increase the Java Heap size in Tomcat Application Server;. There will most likely be a direct correlation between user load and resource consumption. log and MicroStrategy License Manager is the version of the base build installed in that machine. Number of Views 5. Why is this happening?When users try to start or stop MicroStrategy Intelligence Server from MicroStrategy Service Manager, nothing happens. Users notice multiple instances of the "mstrexec-iserver" processes in Microstrategy Intelligence Server 9. Iserver is on windows server, web server is apache tomcat. x in Windows environment. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. ) One (or more) of the above fail to start. MicroStrategy Developer must successfully connect to the Intelligence Server via the SSL port. Can be used instead of reportID. Copy the new certificate to MicroStrategyLibrary's WEB-INF folder (in the same location from step 2). Select Automatic as the Startup Type option. x to effectively register the change. View and Analyze Log Files. For this point admins need to try the three options and see which one has better performance. x to be restarted in order for the changes to take effect. When creating the trust relationship through MIcroStrategy Office, the token for WS1 will be written into the common metadata for both Intelligence Server nodes. CONTENT When migrating database instances between two different environments there are several details to be aware of. Element search request timeout. Type the command of CONNECTMSTR -n Project_source_name -u username -p password to connect to an existing project source. The default Load balance factor value is 1. Administrators can export the server settings in this tab to a . g. Access the MicroStrategy Web Administrator page. The MicroStrategy Listener will also check to see that MicroStrategy Intelligence Server is. timeout: The maximum waiting time when polling a job on a server. KB20300: After removing the Tahoma font in MicroStrategy Web 10. Choose the individual modules to be logged. If changes are made to any objects in the Metadata from a 2-tier connection, those changes will not be reflected in any server connections unless the object cache in the server memory. Review the file to ensure all entries match the ones seen in the following screenshot (namely iserver. The Java Virtual Machine has a heap that is shared among all Java Virtual Machine threads. Learn how to install and configure MicroStrategy software on Windows and Linux platforms, with detailed steps and best practices. The Service Options dialog box opens. MicroStrategy provides In-memory BI capabilities that leverage 64-bit operating systems to improve the overall performance of a BI system. If False (default), this feature will be disabled. Determines how distinct counts of values are retrieved from partitioned tables. 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. For example, sample cube. In IIS, once Anonymous Access is configured, any web user will take an IUSR_machine_name account first as designed in IIS, so it will work for Standard Authentication users. xml file and search for 'session. Here at MicroStrategy, we want to ensure that our users have the information they need to get their platform up and running. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. 11. Click on Yes. Use Response file. Under Collections, click on the the “…” next to. Connection borrowing occurs when MicroStrategy Intelligence Server executes a Job on a lower priority connection because no connections with an equivalent priority is available for the Job at execution time. In 2019 Update 2, it takes eight minutes to load the same three projects from the same metadata. On the MicroStrategy Web Server, go to Program Files > MicroStrategy > Web Services > projectsources. The objective of this document is to provide an estimation of resource requirements for stable and performant operation of. Login using Usher or the login/password provided in the email. backtrace. In the left pane, click All Settings. All necessary privileges are included in the Administrator role by default. To stop MicroStrategy Intelligence Server Universal 9. xml" file contains the state information of the Intelligence Server. Internet or Intranet specification will depend on your connection. Select the Directory Security tab, and then under Anonymous access and authentication control, click Edit. reportViewMode. The Intelligent Cube Monitor is displayed. To create the Enterprise Manager project, run Configuration Wizard on the MicroStrategy Intelligence Server machine that uses the Metadata where the project should be created, and select the Create Enterprise Manager project option. x and 11. Enabling LDAP Authentication for MicroStrategy Web. Login to Postman and search for MicroStrategy in the homepage search bar. Add the IP to hostname mapping (e. 4 GB or higher. ACTION:MicroStrategy recommends that the Linux kernel setting vm. x in Microsoft IIS to use Anonymous authentication, but for security reasons, would want to have the MicroStrategy Web Administration page to authenticate using Windows authentication, the following steps will ensure that a user must enter the application server's administrative credentials in order. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Similar to the MicroStrategy Web application, Library connects to your Intelligence Server and supports multiple different methods of. To increase the number of server nodes, click the 'Number of Server Instances' dropdown. Queries can have a significant increase in the fetch time when there are tables containing VARCHAR without specifying a size in Snowflake. MicroStrategy Telemetry Store: This service consumes all telemetry data from MicroStrategy Services layer, and do ETL process for the Platform Analytics project, also named as Platform Analytics Consumer. 0. The Performance Analysis folder in Enterprise Manager has reports that measure such metrics as average job execution time and other job performance trends, cache analysis, longest executing reports, and so on. On Linux, all log files are stored in /opt/mstr/MicroStrategy/log. Do not change the files under the conf folder. Multiple "mstrexec-iserver" process instances are seen in MicroStrategy Intelligence Server 9. Right-click a connected environment and choose Properties. Retrieve Data from the Intelligence Server Using the JSON Data API. Setting this to a higher limit does not mean the memory will be set aside for immediate use by the Microstrategy Intelligence Server. For New Export Engine in MicroStrategy 2019, when the number of concurrent user increases, the throughput (pages per minute) would remain almost unchanged. Upgrading Flash-Based Content What is load balancing? Load balancing, as it applies to MicroStrategy Intelligence Server, is a strategy aimed at achieving even distribution of MicroStrategy Web or Web Universal user sessions across MicroStrategy Intelligence Servers, so that no single machine is overwhelmed. After installation, user may need to check those folder path to locate specific files. d/ directory. 0 Hotfix 2 (9. x, the Web Pool Size setting does perform any action or hold to it’s defined value. You can implement iServer easily with it. MOIOffice. Click on More Items > Contact Us. 0. x Administration page although the Intelligence Servers are set to automatically connect. Under Collections, click on the the “…” next to. By default: -Windows: C:WindowsSystem32driversetchostsThis chapter addresses the processes necessary to configure an installed MicroStrategy suite of products using the Configuration Wizard. You can implement iServer easily with it. renderer. x and 10. The path to the Web server application is entered in the Web Server Application field. This allows resources to be shared across the network. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). When we think about how to truly get the attention of users and increase analytics adoption, the answer many times is embedded analytics. Start Apache Tomcat. Change the "<Servername>" to the desired MicroStrategy Intelligence Server and save the changes. Give the non-administrator user control to C:/Program Files (x86)/MicroStrategy and C:/Program Files (x86)/Common Files/MicroStrategy folders. 3. Tables v10. When Intelligence Server is installed, the last step is to choose a user identity under which the service will run. instancename is the name of a server instance, where required. Edit All Server-Level Settings. 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. old' or delete the file. 4. Learn how to use an external REST client to run MSTR related REST requests. x interface. The video also presents how the data from Salesforce reports is converted to MicroStrategy attributes and metrics. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. Cube index generation will increase cube size. The MicroStrategy Configuration Wizard walks you through the process. 5, the maximum limit is 64GB (65536. . x ODBC calls by default. The Intelligence Server selection page opens. The Microstrategy SQL Engine calculates the size based on two bytes per character as a standard to encompass Unicode and Double-Byte Character Set (DBCS) data. It takes you from setting up and configuring MicroStrategy to security and administration. You should periodically reevaluate the system and update it based on. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. MicroStrategy makes it easy for you to generate enterprise reporting, dashboards, scorecards, notifications, etc. You can search, view, and edit server-level settings. The MicroStrategy Intelligence Server's backup frequency controls how long the server will wait to write cache and inbox files to disk. Efficiently manages thousands of end-user requests (jobs. By the same token, our platform is also the source of valuable data. The Security Filter Editor opens. war file on a default MicroStrategy Windows installation. There are three options that are available: 1. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Capacity Planning for Platform Analytics. 8. The ability to view or edit certain settings is determined by a user's. Creating a User. Ensure auth. Users experience an issue where Intelligence Servers are getting frequently disconnected from the MicroStrategy Web 9. x at any time, run the following command: $ mstrctl -s. exe" -n "MicroStrategy Tutorial" -u Administrator -p 007007 -f C: estartserver. Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. A list of Web Preferences can be found in the MicroStrategy Enumeration EnumWebPreferences in the MicroStrategy Developers Library Java API Reference. x. The Web server will create a new TCP connection if it determines that only two connections are idle. 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. If no project sources are defined, then the Configuration Wizard opens. Expand Intelligent Cubes, and then select General. '. By default: -Windows: C:WindowsSystem32driversetchostsThe MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Navigate to the System Definitions folder under Web Configuration Settings. The Intelligence Server is added to the Connected Servers list. ACTION: This tech note explains: File Relationships. Step 5. This setting must be greater than x x 2. SYMPTOM: The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. xml file. 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. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. Platform Analytics is the new monitoring tool in MicroStrategy 11. KB201630: How to change the Row Limit of a report that uses an Intelligent Cube. Because the ID of the event associated with the "RW Fast Export PDF" page is "3069", the evt parameter in the URL is set to "3069". (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. In-store and online. Right-click in the grid and select New to create a new connection mapping. 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; KB41943: How to create a metric that calculates the distinct count of an attribute order to display total number of regist…Summary. jks at this time via the sslClientKeystore parameter in the microstrategy. xml > isAliveRequestTimeoutMillis. This document discusses Microsoft SQL Server Database support in MicroStrategy, provides an overview of the integration, summarizes supported workflows, and describes configuration and implementation details. Select Configure Intelligence Server, and click Next. HKEY_LOCAL_MACHINE\Software\Microstrategy\Microstrategy Broadcast Server\7. There are various applications of MicroStrategy. Dedicate a machine for the metadata repository. The . 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. x to version 10. Telcos using MicroStrategy can run. The goal of failover is to maximize availability of the MicroStrategy Intelligence Server. For more details, see KB442160. After watching this 3 minutes video you will be able to test mstrio library (based on REST API) yourself. GetProjectSources. 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. yaml. Find MicroStrategy’s public API in Postman and make your own copy (Fork). 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. Continue to the steps provided in To select a configuration task. Note, for more information refer to tech note KB10211 . When installing MicroStrategy Intelligence Server Universal in Unix environment, user needs to specify the path for Home, Install and Log directory as below: As default, the Install and Log folders are under Home folder. Server-level settings At the server level, only a few settings from each category need a server restart. max_map_count be defined as 5,242,880 bytes. All basic statistics. Solution Deploy the 2020 MicroStrategyLibrary. Select Configure Intelligence Server, and click Next. Efficiently manages thousands of end-user requests (jobs. command is one of the commands from the list below. In the top right corner, click MSTR User and then click Preferences to access Web Preferences. 2. xml and open it with notepad, as shown below: Locate the project source name that should be changed. 50s. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. Click Save. Choose the individual modules to be logged. In 2019 Update 1, it took one minute to load three projects. In MicroStrategy Developer, log in to a project source with administrative privileges. 2. Open the Workstation window. As seen below, the MicroStrategy Library version is still 11. Increase the size of Maximum RAM for Working Set cache to a higher value. Note, for more information refer to tech note KB10211. To improve the data fetching performance for JDBC connections, Administrators can also increase the JNI Bridge Heap Space. Once you have finished choosing your options, click Create Environment and wait for. Drop Files. For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (MicroStrategy projects on each Intelligence Server can be configured to log usage statistics to the staging tables. Go to Font Download and ensure it is set to Enabled. There are a few steps that must be completed in order to restart the MicroStrategy Web Server on a Linux machine. To increase the number of server nodes, click the 'Number of Server Instances' dropdown. This location is set during installation and cannot be changed. 1 and above KB10384: How to increase the Java Heap size in Tomcat Application Server Beginning in MicroStrategy 10. Intelligence Server ensures the. Select Configure Intelligence Server, and click Next. xml', for example 'status-iserver. xA user has set up MicroStrategy Web 9. So MicroStrategy Intelligence Server has to be re-started for this setting change to take effect. The start time for the Intelligent Cube publication should be noted first. 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. WORKAROUND: Disable the Cube Health Check Feature on the effected environment by adding the following key: [HKEY_LOCAL_MACHINESOFTWAREMicroStrategyDSS ServerCastor]. The Servers page opens. You can build real-time or near-real-time MicroStrategy applications based on it. It also explains the setting in the Web Admin page Allow automatic login if session is lost. The user must review the contents of any shell scripts that have been modified post installation that are used by MicroStrategy Intelligence Server Universal. How to Perform Capacity Planning to Fine-tune your BI Project for Sub-Second Response Times MicroStrategy's flexible, scalable architecture allows organizations to deliver high performance and fast response times at scale. The ability to view or edit certain settings is determined by a user's privileges. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. For more information about Enterprise Manager, see the Enterprise Manager Guide. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Within this directory, the user will need to execute the “. x-10. Expand Intelligent Cubes, and then select General. The following procedure describes how to ensure the web server, mobile server and intelligence server use images from the same folder in MicroStrategy 9. Salary ranges can vary widely depending on many important factors, including education, certifications, additional skills,. Published: May 2, 2018; Last updated: Jul 17, 2023; Related versions: 10. Tables v9. In MicroStrategy 2020, four additional lines will appear in the status-iserver. Using the Memory Contract Manager. The chart below shows how the statistics collection change from MicroStrategy version 9. x uses third party client libraries. This is also tuning for issues revolving around errors with Garbage Collection overhead limits and in some cases HTTP 500 errors. The formula is: Production Capacity = Machine-Hour Capacity (MHC) / Hours to Produce One Product. 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. 0. The following is an example of VBA code for Excel that gets the list. x when Intelligence Server is on Linux. x and 11. Once the server definition has been changed, MicroStrategy Intelligence Server will start back up using the new server definition. 3. For example: "C:Program FilesMicroStrategyAdministratorCommand Managercmdmgr. log will depend on the Log Path specified during installation. ProjectSource. To start Intelligence Server service automatically (when it fails unexpectedly) using the Restarter: In the Server drop-down list, select the machine on which the MicroStrategy Intelligence Server service is installed. 4. pd_dump and pg_restore utility can be found in folder C:\Program Files (x86)\Common Files\MicroStrategy\Repository\pgsql\bin STEPS: 1. This option must be selected for any statistics to be logged. In other words, this name needs to be recognizable as a network machine. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. Property Default Value Comments; exporter. Once the MicroStrategy users are linked to a Windows user account, follow the steps below to setup Windows Authentication for a MicroStrategy Web, Mobile, or Web Services 9. During startup the State will display as . 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. com) to the hosts file of the Library server machine to manually resolve the iserver name. 10. sp. The MicroStrategy Intelligence Server was unable to swap out the report instances of 40MB in the Working Set. Then from there, you can create the . Type in the URL box the MicroStrategy Mobile Admin page URL with the fully qualified domain name (FQDN),. This allows the Intelligence Server to utilize the system memory resources. Seeing this issue after the upgrade to latest mstr software launched in Jan 2022. MicroStrategy Web, statistics can be used to troubleshoot issues with hanging or slow performance of certain MicroStrategy objects, such as reports or prompts. List Nodes GET /monitors/iServer/nodes Get information about nodes in the connected Intelligence Server cluster, including: Basic information Runtime state Information for the. x; KB38769: MicroStrategy Certificate Server GetCertificatList call returns an empty page on the browser for MicroStrategy Mobile Server 9. In this knowledge-based article, we will review the next steps that you can take to obtain the log files and find the locations you will need. Select data population for Intelligent Cubes. From the Windows Start menu go to All Programs > MicroStrategy Tools > Web Administrator. When the MicroStrategy Web 9. 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. The following are the methods that support connecting to and disconnecting from a MicroStrategy Intelligence Server: MOIOffice. Description. Enter the User Name and Password for the database. All files under the conf folder are overwritten when you upgrade MicroStrategy. So MicroStrategy Intelligence Server has to be re-started for this setting change to take effect. /mstrctl -s IntelligenceServer ssic' from the bin folder to set a new configuration for the MicroStrategy Intelligence Server performance configuration. Once you have finished choosing your options, click Create Environment and wait for your environment to provision. This feature. Specify a name and location for the new security filter and click Save. In the Open drop-down list, type cmd and click OK. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. It processes data and delegates commands. x or 10. In the Action column in the Unconnected servers list, click Connect for the Intelligence Server to connect to. A database instance specifies connection information, such as the data source name, Login ID and password, and other data source specific information. Once logged in, the user must navigate to the /etc/init. If the Startup type of the MicroStrategy Intelligence Server. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. The project default level preferences are accessed by the Web server at connection time. instancename is the name of a server instance, where required. Clear the Enable anonymous access check box. xml. Upload FilesOr drop files. The MicroStrategy Repository Administration tool’s backup operation is based on the database information in DBAdminConfig. Select the database instance. Step 3. During a course which involved microstrategy platform i've been told that: "For MSTR 10. When considering load balancing in MicroStrategy environment, the two most critical points. jks file including the cert with a passphrase, e. You can use the MicroStrategy Configuration Wizard to upgrade your statistics repository. Related articles from the Community: Knowledge Base: How to Increase JVM Heap Size in IISA temporary file or folder is the location or files temporary generated by all the applications running on the machine. MicroStrategy Telemetry Manager: This layer is the synchronization service between Telemetry Server(s),which is using Apache Zookeeper. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. From the DSN drop-down list, select the DSN used to connect to the metadata repository. x machine: Run the command '. The following article lists the settings that require MicroStrategy Intelligence Server 10. The DNS needs to recognize the entry as a machine and be able to resolve its. Theoretically, capacity is a certain. Number of Views 7. Optionally, you can change the location or name of the Keystore file clientKey. SYMPTOM. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Configuring MicroStrategy and getting started. If a customer opts to increase the data repository and/or cube memory requirements, they will either necessitate a change order or will be Hi @Rui Chang(PPC) (Microstrategy, Inc. The DUMMY_SERVER instance for example, helps for the configuration of the Intelligence. To backup all databases in MicroStrategy Repository, add the database names to DBAdminConfig. Follow these steps while connected to the MicroStrategy Intelligence Server machine to modify the processor affinity settings of an specific installation: Shutdown the MicroStrategy Intelligence Server Universal 8. Easily add or change pre- and post- SQL statements. Configuring MicroStrategy Using Command Line Tools: MicroStrategy tools are provided in command line mode on Linux so that you can. Place intelligence server close to the both the data warehouse and the metadata repository. 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. The CPU (Central Processing Unit) is the brain of a computer and performs many of its main tasks. 5 GB. The default value is 256 megabytes. 52K. jks file including the cert with a passphrase, e.