How to increase the microstrategy iserver capacity in. We have focused on the features that have been developed specifically to support and enhance the SQL Server integration. How to increase the microstrategy iserver capacity in

 
 We have focused on the features that have been developed specifically to support and enhance the SQL Server integrationHow to increase the microstrategy iserver capacity in  Synapse Analytics leverages a scale out architecture to distribute computational processing of data across multiple nodes

KB441987. From the DSN drop-down list, select the DSN used to connect to the metadata repository. After calculating the production capacity of each product, you can calculate the factory output rate for multiple products. One of your most important jobs as a MicroStrategy system administrator is to find the balance that maximizes the use of your system's capacity to provide the best performance possible for the required number of users. The following is an example of VBA code for Excel that gets the list. During a course which involved microstrategy platform i've been told that: "For MSTR 10. The Intelligent Cube Monitor is displayed. Statistics logged. Frame Description Access, filter, publish, and extract data from MicroStrategy in-memory cubes. Database Instance. x-10. /mstrcfgwiz. There is one setting in the MicroStrategy Intelligence configuration, available in Developer and another one in the application server. x and 11. 24. Project default level preferences are set at the MicroStrategy Intelligence Server 8. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. x, text in documents still default to that font. 1. Grid (1) or Graph (2) Mode. The governing setting 'Maximum Report Execution Time' can be defined at the Project Configuration level in MicroStrategy, as shown below: Although there is no direct equivalent to this setting at the report level, there is an alternative that should suit many scenarios. If the services are registered, it is much simpler to check status: # service kafka-zookeeper status # service consumer-iserver status Right-click on 'Administration' in MicroStrategy Desktop and select 'Start Server'. Downloading and installing MicroStrategy. To forecast future needs, you can plot user load against the resource consumption graphs above. 0. You need to increase the ulimit parameters by running ulimit -n 65534. Iserver is on windows server, web server is apache tomcat. Although it is possible to use the Microsoft Access database. Significantly improves user-perceived query performance. Type the command of CONNECTMSTR -n Project_source_name -u username -p password to connect to an existing project source. KB440719. x and 11. For example, sample cube. All MicroStrategy log files are stored in the log file lo cation. This video walks through the process of directly importing data from a Salesforce report into MicroStrategy Desktop 10. If the Startup type of the MicroStrategy Intelligence Server. The Intelligent Cube Monitor is displayed. Users notice multiple instances of the "mstrexec-iserver" processes in Microstrategy Intelligence Server 9. How to increase the Java Heap size in Tomcat Application Server;. The Servers page opens. Make sure all Intelligence Server nodes are running during the life-time of Library Server. 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. There will most likely be a direct correlation between user load and resource consumption. Choose Get Info if you are using a Mac. x. x-10. Multiple "mstrexec-iserver" process instances are seen in MicroStrategy Intelligence Server 9. x-10. x-10. Right-click on 'Administration' in MicroStrategy Desktop and select 'Start Server'. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. 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. microstrategy. The default Load balance factor value is 1. The memory used by Intelligence Server is limited by the machine's virtual memory. 0. war file to upgrade MicroStrategy Library. Depending on the resources available and the version installed, please set the Maximum working set RAM to a number between the following list:. 0 Hotfix 2 (9. max: 1/4 of the number of CPU cores. 26K. This is working as designed. MicroStrategy Web, statistics can be used to troubleshoot issues with hanging or slow performance of certain MicroStrategy objects, such as reports or prompts. 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. This location is set during installation and cannot be changed. x level and not on the cluster level. 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. 0, the behavior has been changed and the Intelligence Server does not use Messaging Services by default. max_map_count be defined as 5,242,880 bytes. x in an interactive mode in Windows and UNIX. Analyzes system performance over time using your choice of metrics. g. The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. Optionally, you can change the location or name of the Keystore file clientKey. This feature. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. Disconnect. Expand Intelligent Cubes, and then select General. There are three options that are available: 1. 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. This is because registering MicroStrategy Intelligence Server Universal 9. x instance using the following command from the bin folder of the MicroStrategy Home folder:. In 2019 Update 1, it took one minute to load three projects. Click on More Items > Contact Us. New Export Engine in MicroStrategy 2019 can deliver a high-quality PDF files with complete data, diversified widgets and various fonts, compared with the Legacy Engine in 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 chart below shows how the statistics collection change from MicroStrategy version 9. It takes you from setting up and configuring MicroStrategy to security and administration. Speed is typically measured as user wait time or response time. x: Statistics logging option. x to effectively register the change. View and Analyze Log Files. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. 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. trusted. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. The crash collection server analyzes the incoming crashes and notifies MicroStrategy technical support and production teams for the incidents. The MicroStrategy Intelligence Server was unable to swap out the report instances of 40MB in the Working Set. KB235107: How to Embed a Custom Font Without Having to Install it on the Client Machines using MicroStrategy Web SDK 9. xml file. In the Navigation pane, click Environments. The token file is created in the MicroStrategy Web Services deployment root directory when establishing a trust. The project default level preferences are accessed by the Web server at connection time. In the top right corner, click MSTR User and then click Preferences to access Web Preferences. 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. g. Specify a name and location for the new security filter and click Save. The default value is 256 megabytes. Configuring MicroStrategy and getting started. MicroStrategy Library Web & Mobile. Using the command manager script file created in Step1, create a batch file that can be used to restart the MicroStrategy Intelligence Server. The ODBC connection uses 3. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Then it presents this data to the administrators, developers, and analysts to help them optimize the performance of. Establish server and request timeout settings, as follows: Specify the length of time (in seconds) that a Web request should wait for a connection from the connection pool, if the maximum number of connections are all busy. Retrieve Data from the Intelligence Server Using the JSON Data API. How to increase the Java Heap size in Tomcat Application Server;The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. You can use the MicroStrategy Configuration Wizard to upgrade your statistics repository. 67. Click the MicroStrategy connector. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using the MicroStrategy Service Manager. xA user has set up MicroStrategy Web 9. SSL must already be configured on the MicroStrategy Intelligence Server. The following are the methods that support connecting to and disconnecting from a MicroStrategy Intelligence Server: MOIOffice. Right-click in the grid and select New to create a new connection mapping. xA user has set up MicroStrategy Web 9. Efficiently manages thousands of end-user requests (jobs. The Intelligence Server is added to the Connected Servers list. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. Enabling LDAP Authentication for MicroStrategy Web. 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. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. While this code may apply to other releases directly, MicroStrategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. 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. 9 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… The MicroStrategy Listener will monitor the Windows NT Application Event Log for new log entries and uses the log entry of Category 12 from the 'MSTRServer' Source as an indication that MicroStrategy Intelligence Server has been started. maxPoolSize. For example, if a startup script has the following name: "mstr-root@2015-10-21T10:09:23-iserver-CastorServer", it can be changed to "mstr-root@-iserver-CastorServer", but in MSIReg. In MicroStrategy 10. On Windows, all log files are stored in C:Program Files (x86)Common FilesMicroStrategyLog. By default, it is C:Program Files. Login to Postman and search for MicroStrategy in the homepage search bar. To stop MicroStrategy Intelligence Server Universal 9. 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. From the DSN drop-down list, select the DSN used to connect to the metadata repository. The following procedure describes how to ensure the web server, mobile server and intelligence server use images from the same folder in MicroStrategy 9. Project. browser cache etc is all cleared even tried with re-installing library server. Using absolute (fully qualified) URLs will work but require administrative maintenance to edit and correct URLs whenever MicroStrategy Web server names, MicroStrategy Intelligence Server names, or ports change (this can happen during migration from development to production). mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. 4. 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. It also explains the setting in the Web Admin page Allow automatic login if session is lost. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. x or 10. In the left pane, click All Settings. If MicroStrategy Intelligence Server Universal is running on a Unix machine, then the default location of the DSSErrors. reportName. The cube merge utility is available on MicroStrategy Intelligence Server 9. It is shared by all processes running on the machine, including the operating system. 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. Failover, as it applies to MicroStrategy Intelligence Server, is a strategy by which user sessions and history list jobs are automatically transferred from a failed MicroStrategy Intelligence Server cluster node to another backup node. properties file stores the values of how often caches are loaded into memory. 10 xxxxxxxxxx. 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. 3. When a setting is not a runtime setting, MicroStrategy Desktop prompts users to restart MicroStrategy Intelligence Server 9. KB484838: Best practices for performance tuning based on Azure Synapse AnalyticsAfter an unexpected shutdown of MicroStrategy Intelligence Server, perhaps due to a power failure or a software error, services cannot be restarted from the MicroStrategy Service Manager and remain in a "starting" mode. 2. Any time difference can be accounted for,but may may make the process difficult and increase the chances of errors. The Intelligence server has entered MCM denial state, but recovers and then works as expected. below. 4. "rlim_fd_cur" specifies the “soft” limit on file descriptors that a single process can have open. MicroStrategy. yaml. 40. xml', for example 'status-iserver. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Enterprise Manager consists of a MicroStrategy project, the Enterprise Manager server (service), and an interface in MicroStrategy Command Manager where administrators can control how the server. This issue has been addressed in MicroStrategy 2019 Update 2 and above. Install MicroStrategy Intelligence Server using the root account. x, text in documents still default to that font. Diagnostic logs will be sent to the Messaging Services Server after you perform the following: Enable MicroStrategy Messaging Services. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend >and integrate the MicroStrategy business intelligence functionality into other applications. sys-defaults. When a machine runs out of virtual memory, processes on the machine are no longer able. It's being used even in the biggest financial, telecom and manufacturing. xml" file contains the state information of the Intelligence Server. xml and open it with notepad, as shown below: Locate the project source name that should be changed. xxin omcat9w. This can be confirmed using the MicroStrategy Service Manager, as shown. Afterwards you will see Kafka log files created in the Kafka. Under the Server tab, click Application Load Balancer. /mstrctl -s IntelligenceServer ssic' from the bin folder to set a new configuration for the MicroStrategy Intelligence Server performance configuration. x from the Command Line, run the following command: $ mstrctl -s IntelligenceServer stop. It takes you from setting up and configuring MicroStrategy to security and administration. This action starts MicroStrategy Intelligence Server on 'M1. Solution Deploy the 2020 MicroStrategyLibrary. For example, high priority Jobs can run on both medium and low priority connections as well as the default high priority connections. The cache. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. KB20300: After removing the Tahoma font in MicroStrategy Web 10. 0. 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. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. log will depend on the Log Path specified during installation. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. There are two types of TCP connections: busy and idle. Run the file mstr-repo-ondemand-dba-operations. 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. Once activated, the user loads the cube in memory. 9Performance is a combination of speed and scale. On the MicroStrategy Web server machine, access the IIS Internet Service Manager. jks at this time via the sslClientKeystore parameter in the microstrategy. x Statistics are enabled and a dashboard is executed the MicroStrategy Intelligence Server stats are incorrectly. If your password was changed from the default of mstr123 update the parameter in your WEB-INF/microstrategy. 5 GB. On MicroStrategy Intelligence Server 9. In MicroStrategy 9. Edit All Server-Level Settings. properties: document. Using the Memory Contract Manager. instancename is the name of a server instance, where required. max: 1/4 of the number of CPU cores. Alternatively, please run: c:Program Files (x86)Common FilesMicroStrategyTomcatapache-tomcat-9. Enter the User Name and Password for the database. In 2019 Update 2, it takes eight minutes to load the same three projects from the same metadata. Restart the MicroStrategy Intelligence Server to. If some Intelligence Server nodes are/were down, you can start them first and then restart Library Server. war file on a default MicroStrategy Windows installation. Load balancing directs new Web connections to the least loaded node, as measured by user connections. exe. Note: Make your configuration changes to the configuration files located under the admin folder. Configure Metadata Connection. In 2019 Update 1, it took one minute to load three projects. If no project sources are defined, then the Configuration Wizard opens. 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. 1. Increasing this setting can increase caching efficiency in cases where the cache memory is full and several concurrent reports are trying to swap from disk. MOIOffice. You can calculate the factory output rate for one product using the values from the machine-hour capacity formula. Windows: C:Program Files (x86)MicroStrategyIntelligence ServerTLS. Iserver is on windows server, web server is apache tomcat. If nodes are manually removed from the cluster, projects are. renderer. x uses third party client libraries. Hello, We had the same problem after upgrading our 11. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. The amount of data that the customer chooses to keep could have a corresponding cost to the customer. If a name is not specified, the command uses the default instance name. 4 GB or. The CPU (Central Processing Unit) is the brain of a computer and performs many of its main tasks. command is one of the commands from the list below. System Performance Trends. Once logged in, the user must navigate to. User session and project session analysis. x; KB38769: MicroStrategy Certificate Server GetCertificatList call returns an empty page on the browser for MicroStrategy Mobile Server 9. Once MicroStrategy Web is connected to a cluster, all nodes reference the same project. Introduction Integrated Authentication to the MicroStrategy Intelligence Server utilizes the Kerberos authentication protocol to provide a Single Sign-On capability for MicroStrategy users connecting from Web or Developer from a Microsoft Active Directory environment. When Intelligence Server is installed, the last step is to choose a user identity under which the service will run. If some Intelligence Server nodes are/were down, you can start them first and then restart Library Server. (Min 2) Maximum number of renderer processes. The Intelligence Server selection page opens. Double-click the new connection mapping in each column to select the database instance, database connection, database login, and language. Note, for more information refer to tech note KB10211. 52K. 1 and aboveNote: Starting in MicroStrategy 11. CAUSE: In Solaris, every process is subjected to a System Kernel Parameter that defines the maximum number of files that it can have open. There are various applications of MicroStrategy. In the MicroStrategy Library Configuration box, enter. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Open Performance Monitor from the Administrative Tools in the Windows Control Panel. The DUMMY_SERVER instance for example, helps for the configuration of the Intelligence. x, users may notice that the "Maximum quota per user (MB)" governing setting (located in Developer under Project configuration > Governing rules > Import Data) is applied at the Intelligence Server node level instead of the Intelligence Server cluster level. x server using Microsoft IIS 7. If the administrator would like to get the status of MicroStrategy Intelligence Server Universal 9. Specifies the ID of the report to execute. This ensures changes are synchronized in a timely manner. For this reason, outbound network traffic needs to be allowed on port 443 in order to transmit the data. io through protocol. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. Step 4: The "status-iserver. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. CAUSE: This is working as designed. Seeing this issue after the upgrade to latest mstr software launched in Jan 2022. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. 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. MicroStrategy Web must be connecting to the MicroStrategy Intelligence Server via the name configured in the certificate. 6. In the Add a server manually field, specify the DNS name of the Intelligence Server machine. Speed is important because it affects the user experience. The Intelligence Server on Windows, when started as a service, does not have a terminal to which it can write the output log data. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. For steps to use the Configuration Wizard to upgrade your statistics repository and other MicroStrategy components, see the Upgrade Guide. x, the limit is 4 TB (4194304 MB) Note : Increasing the 'Maximum RAM for Working Set cache' setting will increase the possible limit amount of RAM that. You can implement iServer easily with it. mstr file is a zipped file of object definition package and cube files. The client libraries are certified for use with the MicroStrategy Intelligence Server by operating system platform. The license check takes place anytime within the next half hour of the time specified in the setting. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. In the Open drop-down list, type cmd and click OK. MicroStrategy Intelligence Server is an analytical server optimized for enterprise querying, reporting, and OLAP analysis. It is possible to re-write the URLs to be more. There might be extreme cases when customer move the pgdata folder to a NAS drive and create a soft link, and then experience abnormal scenarios such as Platform Analytics Consumer is taking hours to startup or data intermittent not submitted into the Platform Analytics Warehouse access. This technique is useful till 80%. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. Project. Users may find additional information related to managing and using Intelligent Cubes in. ACTION:. To specify a database instance, in the Intelligence Server Configuration Editor, select the General subcategory of the Server Definition category, and, in the Database Instance drop-down list, select the database instance to use for the History List. Afterwards you will see Kafka log files created in the Kafka. Due to the highly customizable nature of how changes can be made, it is outside the scope of MicroStrategy Technical Support to troubleshoot these custom changes. 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. What is the reason for the. It is sometimes necessary for administrators to back up the MicroStrategy Web 9. renderer. For this reason, outbound network traffic needs to be allowed on port 443 in order to transmit the data. 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. filename is the name of the file to read from or write to. Click the icon in the Actions column and select Start, Stop, or Restart. So MicroStrategy Intelligence Server has to be re-started for this setting change to take effect. For steps to use the Configuration Wizard to upgrade your statistics repository and other. x on Linux machines. Find MicroStrategy’s public API in Postman and make your own copy (Fork). The chart below shows how the statistics collection change from MicroStrategy version 9. MicroStrategy is an enterprise business intelligence application. It also covers other features, such as importing data from external public data sources, blending. pd_dump and pg_restore utility can be found in folder C:\Program Files (x86)\Common Files\MicroStrategy\Repository\pgsql\bin STEPS: 1. 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. jks file including the cert with a passphrase, e. Selected. The speed at which all programs and processes run depends on the CPU’s performance capacity. This port is configurable when setting up the Master Health Agent. Select the database instance. trusted. When creating the trust relationship through MIcroStrategy Office, the token for WS1 will be written into the common metadata for both Intelligence Server nodes. Start Apache Tomcat. 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. Number of Views 7. KB201630: How to change the Row Limit of a report that uses an Intelligent Cube. Restart MicroStrategy Web and Mobile Server. The book starts by detailing the different. This Knowledge Base article addresses an identified defect where the Web Pool Size setting doesn’t do anything in MicroStrategy 10. This is likely the case if the service is disabled or. The setting described below (ServerName) is NOT ONLY for the '&SERVERNAME' macro used in the history list URL. View the out-of-the-box Platform Analytics Project Dossier>Database Capacity Planning dossier, go to Overview This video shows how to change the user idle timeouts that affec MicroStrategy Web users. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. old' or delete the file. After upgrading from MicroStrategy 2019 Update 1 to MicroStrategy 2019 Update 2, it takes much longer to start the Intelligence Server. 0\Distributed Logging Service\DistributedLogger. 6 (on Windows), MicroStrategy Messaging Services uses the third-party Kafka framework to handle the DSSErrors. Click on the Developer Machine Name to copy it. However, after publishing,. In the MicroStrategy 2021 release, Parameterized Query is enabled by default for all newly created database connections against a list of MicroStrategy certified Diamond Gateways. This will generate a new certificate and key pair and start the Intelligence Server. The Security Filter Editor opens. '. Theoretically, capacity is a certain. In the MicroStrategy Library Configuration box, enter. Select a dataset. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Enterprise environments can have up to 4 clustered nodes. The example above can be summarized by ensuring that the project loading is optimized by making the max Ram usage of object cache 10 times greater than the estimated schema size. A list of Web Preferences can be found in the MicroStrategy Enumeration EnumWebPreferences in the MicroStrategy Developers Library Java API Reference. They are part of the MicroStrategy REST Server, which is shipped inside the. Copy the new certificate to MicroStrategyLibrary's WEB-INF folder (in the same location from step 2). Optionally, you can change the location or name of the Keystore file clientKey. 2. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. The video also presents how the data from Salesforce reports is converted to MicroStrategy attributes and metrics. Required Status to Perform Action. System Performance Trends. Server.