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. Creating a User. In practice, you get a cert for the server. 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. 4. Configuring MicroStrategy and getting started. Excel API. Diagnostic logs will be sent to the Messaging Services Server after you perform the following: Enable MicroStrategy Messaging Services. x on Linux as a service makes changes to the scripts required to be run at the system startup. g. KB441987. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. The size of the connection pool: ConfigDefaults. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. To be able to connect to the Directory Server however, MicroStrategy Intelligence Server 9. When the MicroStrategy Web 9. Add the IP to hostname mapping (e. MicroStrategy Library fully supports Kerberos authentication in Windows on Tomcat. The third-party product(s) discussed in this technical note are manufactured by vendors independent of MicroStrategy. The client libraries are certified for use with the MicroStrategy Intelligence Server by operating system platform. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. Note: Make these modifications and re-publish the cube to find out which combination gives better performance. 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. SYMPTOM: The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. GetProjects. x/9. Once activated, the user loads the cube in memory. For example, sample cube. KB485414: How to deal with Platform Analytics repository size increase rapidly in MicroStrategy 2020 and 2021. Knowing your production capacity gives you the chance to improve production planning and production scheduling, give more accurate lead times, and forecast your cash flow. Synapse Analytics leverages a scale out architecture to distribute computational processing of data across multiple nodes. If a name is not specified,. On the other hand, some other configuration files stay as part of the configuration process and are useful to run the applications. Enter the User Name and Password for the database. 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. Expand Intelligent Cubes, and then select General. Select the component to be configured from the list. x-10. Determining the necessary hardware requirements to support MicroStrategy is dependent on many factors including but not limited to the complexity of your MicroStrategy environment, the deployment strategy of MicroStrategy features, user community requirements, expected peak usage requirements, and response time expectations. If your password was changed from the default of mstr123 update the parameter in your WEB-INF/microstrategy. 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). Continue to the steps provided in To select a configuration task. The Web Administrator page opens. ACTION: This tech note explains: File Relationships. Under Collections, click on the the “…” next to. browser cache etc is all cleared even tried with re-installing library server. Launch MicroStrategy Web from the Landing Page of your environment. x, the Web Pool Size setting does perform any action or hold to it’s defined value. 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. The below steps can be used to deploy the MicroStrategyLibrary. Select Configure Intelligence Server, and click Next. The default Load balance factor value is 1. Select Configure Intelligence Server, and click Next. x. Follow the below steps to change your environment's Library URL. KB201630: How to change the Row Limit of a report that uses an Intelligent Cube. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. reportViewMode. Dedicate a machine for the metadata repository. Choose the individual modules to be logged. 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. The Intelligence Server on Windows, when started as a service, does not have a terminal to which it can write the output log data. 10 xxxxxxxxxx. disk availability is below the 80% capacity threshold. 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. Select one of the following to determine when and how MicroStrategy Web. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. The cache. How to increase the Java Heap size in Tomcat. Once the best combination is determined, admins can test the deletion and see if the performance improves there. Learn how to use an external REST client to run MSTR related REST requests. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. backtrace. KB6446: How to increase the heap size of the Java Virtual Machine to handle large result data objects with MicroStrategy Web 9. From the pane on the left, select Servers. On Windows, all log files are stored in C:Program Files (x86)Common FilesMicroStrategyLog. Click on More Items > Contact Us. renderer. xml file. You can use the MicroStrategy Configuration Wizard to upgrade your statistics repository. What's New in MicroStrategy 2020. Find MicroStrategy’s public API in Postman and make your own copy (Fork). As seen below, the MicroStrategy Library version is still 11. KB20300: After removing the Tahoma font in MicroStrategy Web 10. optional): If True, utilize optimal number of threads to increase the download speed. In the Login area, for LDAP Authentication, select the Enabled check box. provider). Step 2. Project. Frame Description Access, filter, publish, and extract data from MicroStrategy in-memory cubes. (Note: On MicroStrategy Intelligence Server machine, go to Administrative Tools -> Services, open the Microsoft Services window and locate the MicroStrategy Intelligence Server service. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Select the "exportMaxCellsPlainText" setting and modify the "Maximum" value under "Other. Port number of the server. In the Action column in the Unconnected servers list, click Connect for the Intelligence Server to connect to. Analyzes system performance over time using your choice of metrics. Action. 0. 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. x ODBC calls by default. x or 10. Tables v10. war file on a default MicroStrategy Windows installation. For example: "C:Program FilesMicroStrategyAdministratorCommand Managercmdmgr. This will generate a new certificate and key pair and start the Intelligence Server. The default one is Interactive. Clear the Enable anonymous access check box. 0. 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. xml" file contains the state information of the Intelligence Server. x. The Intelligent Cube Monitor is displayed. Restart the MicroStrategy Intelligence Server to. The formula is: Production Capacity = Machine-Hour Capacity (MHC) / Hours to Produce One Product. Select “MicroStrategy SDK”. The chart below shows how the statistics collection change from MicroStrategy version 9. The chart below shows how the statistics collection change from MicroStrategy version 9. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). 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. Then from there, you can create the . 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. xxin omcat9w. Run the MicroStrategy installer by clicking the setup. yaml. Governance of CPU clock speed when installing MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Narrowcast Server. 4. This video will help you get started using the MicroStrategy REST API. However, after publishing,. Depending on the resources available and the version installed, please set the Maximum working set RAM to a number between the following list:. Search for the files changed (below) in the target machine and create a backup of these files in all cluster nodes. MicroStrategy Library is a client application running on a desktop browser or a mobile device, whereas HyperIntelligence for Web is available as a Chrome and Microsoft Edge browser extension. This section discusses how to analyze your users' requirements, and the ways you can configure and tune your system to meet. Apache Kafka is an open-source distributed event streaming platform used by thousands of companies for high-performance data pipelines, streaming analytics and data integration. Connect. If a name is not specified, the command uses the default instance name. KB48030: Font change is not applied to the graph in MicroStrategy 9. If no Intelligence Servers are listed or connected, add an Intelligence Server and connect it to MicroStrategy Web. x-10. From the DSN drop-down list, select the DSN used to connect to the metadata repository. Optionally, you can change the location or name of the Keystore file clientKey. For New Export Engine in MicroStrategy 2019, when the number of concurrent user increases, the throughput (pages per minute) would remain almost unchanged. Select Intelligence Server > Default Properties. The MicroStrategy Internal Reference number is DE50391. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. Launch MicroStrategy Web from the Landing Page of your environment. Speed is typically measured as user wait time or. 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. The requests are granted or denied according to user-configured limits on the amount of. /mstrctl -s IntelligenceServer ssic' from the bin folder to set a new configuration for the MicroStrategy Intelligence Server performance configuration. . trusted. x to be restarted in order for the changes to take effect. KB201630: How to change the Row Limit of a report that uses an Intelligent Cube. They are part of the MicroStrategy REST Server, which is shipped inside the. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. If Custom Install is chosen, make sure "MicroStrategy Telemetry Server" is selected (it's auto selected when "MicroStrategy Intelligence" is selected). , "dirty" status). Select Intelligence Server > Default Properties. 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. Server-level settings At the server level, only a few settings from each category need a server restart. Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. Server Activation registers each Server Installation with MicroStrategy and locks the installation to a specific machine. x and 10. Although it is possible to use the Microsoft Access database. Editing cluster membership is an administrative action and should be performed exclusively. 25K. max_map_count be defined as 5,242,880 bytes. DisconnectProjects. Stay up to date on inventory needs and avoid. To run a clustered configuration, the user must be a domain account that has a trust relationship with each of the computers in the cluster. In general, there are two situations in which license key updates are required: Additional named user licenses have been purchased or need to be removed. x in an interactive mode in Windows and UNIX. Go to Font Download and ensure it is set to Enabled. jks at this time via the sslClientKeystore parameter in the microstrategy. timeout: The maximum waiting time when polling a job on a server. trustToken and auth. 1. There are a few steps that must be completed in order to restart the MicroStrategy Web Server on a Linux machine. 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. 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. Multiple "mstrexec-iserver" process instances are seen in MicroStrategy Intelligence Server 9. The crash collection server analyzes the incoming crashes and notifies MicroStrategy technical support and production teams for the incidents. 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. Beginning in MicroStrategy 10. The Web server will create a new TCP connection if it determines that only two connections are idle. Users experience an issue where Intelligence Servers are getting frequently disconnected from the MicroStrategy Web 9. Selected. x-10. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. 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. 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. First, the user must log in as the “mstr” user. The third-party product(s) discussed in this technical note are manufactured by vendors independent of MicroStrategy. xml" must either be edited, renamed, or deleted. MicroStrategy Web, statistics can be used to troubleshoot issues with hanging or slow performance of certain MicroStrategy objects, such as reports or prompts. How to increase the Java Heap size in Tomcat Application Server;Summary. 5 (on Linux) and 10. Hover over a connected Intelligence server and click the Server Administration icon in the Properties column. xml should do. reportID. Analyzes system performance over time using your choice of metrics. Select the Security Filters tab. The MicroStrategy Intelligence Server 9. For prior releases, either a cube was loaded, residing completely in RAM, or unloaded. For an example of how to do this, see the sample code below. The steps below outline how to modify the project governing setting 'maximum report execution time' using MicroStrategy Server SDK 9. Using MicroStrategy, manufacturers can run Big Data analytics on disparate sources to achieve perfect order rates and quality, and to get in-depth consumption patterns. 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 can be used by the Microstrategy Intelligence Server. You can see this in the diagram in Testing an Environment for the First Time, or by looking at the Intelligence Servers on your MicroStrategy Web Administrator page. /mstrcmdmgr -interactive and press ENTER to open Command Manager. • Enterprise Manager. This setting limits the number of concurrent jobs a user may have during a given session or connection. This will prompt to stop the MicroStrategy Intelligence Server process in order to create the new Server Definition. pd_dump and pg_restore utility can be found in folder C:\Program Files (x86)\Common Files\MicroStrategy\Repository\pgsql\bin STEPS: 1. To increase the number of server nodes, click the 'Number of Server Instances' dropdown. Ensure auth. 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. All necessary privileges are included in the Administrator role by default. Intelligence Server ensures the scalability and fault tolerance required for sophisticated analysis of terabyte databases and deployments to millions of users. The user then updates the cube. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. You can use the MicroStrategy Configuration Wizard to upgrade your statistics repository. To log to your screen, select. The book starts by detailing the different. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Under the Server tab, click Application Load Balancer. Remember to replace all child object permissions. csv file to keep a record of their settings, or import a previously save file to apply the setting to a project. Login using Usher or the login/password provided in the email. When you use the cube directly in the Dossier, the definition is applied to the cube directly and the MicroStrategy AE saves time since it doesn’t have to search and fetch an extra report definition. Give the non-administrator user control to C:/Program Files (x86)/MicroStrategy and C:/Program Files (x86)/Common Files/MicroStrategy folders. You can build real-time or near-real-time MicroStrategy applications based on it. To improve the data fetching performance for JDBC connections, Administrators can also increase the JNI Bridge Heap Space. Right mouse click on the project source of the Intelligence Server you wish to remove the trust relationship from. It is noticed that the Intelligence server hosted machine can't ping each other by machine name. in your system. FrameProcessor. This setting limits the time, in seconds, that users can remain idle before their MicroStrategy Intelligence Server session is ended. 5 GB. Select Configure Intelligence Server, and click Next. command is one of the commands from the list below. xml file. 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. Crash data is automatically uploaded to microstrategy. The higher the performance of a CPU, the faster the PC will run. . x at any time, run the following command: $ mstrctl -s. For steps to use the Configuration Wizard to upgrade your statistics repository and other. of setting up the environment for the MicroStrategy products installed. Select Automatic as the Startup Type option. Remember that the memory used will decrease. Beginning in MicroStrategy 10. ) ,. Open your remote desktop connection. Enabling LDAP Authentication for MicroStrategy Web. A new file 'status-iserver. 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. 2. 67. In the Open drop-down list, type cmd and click OK. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. Number of Views 79. How to Perform Capacity. Tips and troubleshooting. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. 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). There are various applications of MicroStrategy. Number of Views 5. From the Windows Start menu go to All Programs > MicroStrategy Tools > Web Administrator. KB439852: In MicroStrategy 10. renderer. If no project sources are defined, then the Configuration Wizard opens. 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. We have to start the install program again Pick Modify Get to the Select Components part Check “MicroStrategy Analytics Modules” and install those components After it is installed, Start the Configuration Wizard (in MicroStrategy Tools) Select “Configure Intelligence Server” Chose “Analytics_Metadata” for the DSN Default for. If present, the report is fetched from memory and the reportID argument is ignored. Note, for more information refer to tech note KB10211 . Open the MicroStrategy Configuration Wizard. MicroStrategy Web or Web Universal users log in to a project and request reports from their Web browsers. This location is set during installation and cannot be changed. browser cache etc is all cleared even tried with re-installing library server. Rename the file 'status-iserver. Iserver is on windows server, web server is apache tomcat. It's being used even in the biggest financial, telecom and manufacturing organizations. It takes you from setting up and configuring MicroStrategy to security and administration. x - 10. This is because registering MicroStrategy Intelligence Server Universal 9. Number of Views 5. 3. Both enabling and disabling logs are covered. In MicroStrategy Developer, log in to a project source with administrative privileges. How to Start and Stop Intelligence Server Services in Microstrategy By Mohan Vamsi PentakotaHow to Access the Web Administrator Page. '. By default: -Windows: C:WindowsSystem32driversetchostsThis chapter addresses the processes necessary to configure an installed MicroStrategy suite of products using the Configuration Wizard. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. xml file. The MicroStrategy Repository Administration tool’s backup operation is based on the database information in DBAdminConfig. renderer. Make sure all Intelligence Server nodes are running during the life-time of Library Server. 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. 3 — Leverage Embedded. Select the Directory Security tab, and then under Anonymous access and authentication control, click Edit. Step 4. 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. 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. MicroStrategy Telemetry Manager: This layer is the synchronization service between Telemetry Server(s),which is using Apache Zookeeper. 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. 3. There are two cases of this: The Intelligence server has never entered MCM denial state and this is the first time doing so. The. e. Scale is important because it determines how many people can submit requests or reports to an analytics platform, how many reports can be supplied by the system, and. (Min 2) Maximum number of renderer processes. Intelligence (I-Server) Homepage MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. 0\Distributed Logging Service\DistributedLogger. iserver. Alternative means for resolving the issue include using the root user to run the commands, or performing a re-install with the desired user account who should be. 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. x machine: Run the command '. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Related Articles. 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. jks at this time via the sslClientKeystore parameter in the microstrategy. Speed is important because it affects the user experience. mstr file is a zipped file of object definition package and cube files. KB440719. The suggested number here is 65534, however, you can change the value as long as it is large. Once you have finished choosing your options, click Create Environment and wait for. 0. process. From the Windows Start menu, point to All Programs, then MicroStrategy Tools, then select Service Manager. Statistics logged. io through protocol. Enter your API Server and select your authentication mode and enter your credentials. Edit the web. This only works for a document or dossier instance. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. x. Here at MicroStrategy, we want to ensure that our users have the information they need to get their platform up and running. KB7295: What is the Memory Contract Manager in MicroStrategy Intelligence Server? PART 1. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. All files under the conf folder are overwritten when you upgrade MicroStrategy. xml', for example 'status-iserver. From the DSN drop-down list, select the DSN used to connect to the. The license check takes place anytime within the next half hour of the time specified in the setting. Right-click a connected environment and choose Properties. The amount of data that the customer chooses to keep could have a corresponding cost to the customer. Type the command of CONNECTMSTR -n Project_source_name -u username -p password to connect to an existing project source. 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. Setting this to a higher limit does not mean the memory will be set aside for immediate use by the Microstrategy Intelligence Server. maxPoolSize. The MicroStrategy Intelligence Server first searches for the user on the LDAP server using the login name provided. Turn On the Sending Log to Messaging Services Feature. x or 10. In the email template, you can find the following details regarding your add-in: Platform. 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. mstrexec-iserver: WARNING: maximum number of open files 256 is low; please increase to 1000 or greater. There's a reason we're at the top of the list. To forecast future needs, you can plot user load against the resource consumption graphs above. trusted. x: Statistics logging option. x to effectively register the change. 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. Method to. 2. The Security Filter Editor opens. The crash collection server analyzes the incoming crashes and notifies MicroStrategy technical support and production teams for the incidents. The Servers page opens. Click Save. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. This Knowledge Base article addresses an identified defect where the Web Pool Size setting doesn’t do anything in MicroStrategy 10. - modify the data a little bit. Afterwards you will see Kafka log files created in the Kafka. g. How to Start and Stop Intelligence Server Services. Click on Yes. When a setting is not a runtime setting, MicroStrategy Desktop prompts users to restart MicroStrategy Intelligence Server 9. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 9Performance is a combination of speed and scale. Load balancing directs new Web connections to the least loaded node, as measured by user connections. If administrators attempt starting MicroStrategy Intelligence Server from Administrative Tools > Services, they. The Java Virtual Machine has a heap that is shared among all Java Virtual Machine threads. ACTION:MicroStrategy recommends that the Linux kernel setting vm. Increase the size of Maximum RAM for Working Set cache to a higher value. The Intelligence server has entered MCM denial state, but recovers and then works as expected.