For New Export Engine in MicroStrategy 2019, when the number of concurrent user increases, the throughput (pages per minute) would remain almost unchanged. Server-level settings At the server level, only a few settings from each category need a server restart. 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. MicroStrategy's flexible, scalable architecture allows organizations to deliver high performance and fast response times at scale. The maximum value is 99 and the minimum value is 1. Search for the files changed (below) in the target machine and create a backup of these files in all cluster nodes. Note: Make your configuration changes to the configuration files located under the admin folder. Launch MicroStrategy Web from the Landing Page of your environment. <None>. 6. 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. This knowledge base article outlines requirements, considerations, and steps to take when enabling MicroStrategy Library and MicroStrategy Collaboration Server for secure communication and/or load balanced service. 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. 0 GA. To stop MicroStrategy Intelligence Server Universal 9. If False (default), this feature will be disabled. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. xxin omcat9w. renderer. Prerequisites for Windows Clustering. backtrace. The test is for a single cube (4M rows) republish executed on the MicroStrategy 2021 Update 2 release with platform as 32 CPU, 244 GB memory Amazon Linux machine. Retrieve Data from the Intelligence Server Using the JSON Data API. x, join cluster fails or doesn't work fine if two nodes don't know each other’s' machine name. This section describes only the most basic guidelines. x interface. Note: The utility is not available on MicroStrategy 9. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. jks. In 2019 Update 2, it takes eight minutes to load the same three projects from the same metadata. token). For example, if Initial Pool Size is two, when the first user logs in to MicroStrategy Web, a new. Change the UseUTC value to 1, as shown below: Restart the MicroStrategy Logging Client and MicroStrategy Logging Server services from Control Panel > Services for the changes to take effect. Select the "exportMaxCellsPlainText" setting and modify the "Maximum" value under "Other. When creating the trust relationship through MIcroStrategy Office, the token for WS1 will be written into the common metadata for both Intelligence Server nodes. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using the MicroStrategy Service Manager. 0+, you have the ability to see how long it takes each visualization to execute, what query is being sent to the DataWarehouse, or what request is being done to an In-Memory intelligent cube. Connect to the Developer Instance. Click Save. KB441987. 0. This port is configurable when setting up the Master Health Agent. Then this file is used for Web, Library to communicated with IServer right? Then the file microstrategy. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. Find MicroStrategy’s public API in Postman and make your own copy (Fork). 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. Select data population for Intelligent Cubes. x*. Setting this to a higher limit does not mean the memory will be set aside for immediate use by the Microstrategy Intelligence Server. 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. Project. Similar to the MicroStrategy Web application, Library connects to your Intelligence Server and supports multiple different methods of. CAUSE: In Solaris, every process is subjected to a System Kernel Parameter that defines the maximum number of files that it can have open. Click Project Defaults from the Menu in the left. Downloading and installing MicroStrategy. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. This allows resources to be shared across the network. Select Intelligence Server > Default Properties. Click Options. How to increase the Java Heap size in Tomcat Application Server;Summary. 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. x using the MicroStrategy Configuration Wizard 9. x*. 4. Iserver is on windows server, web server is apache tomcat. The goal of failover is to maximize availability of the MicroStrategy Intelligence Server. The Intelligent Cube Monitor is displayed. Platform Analytics repository size may be observed increase rapidly with advanced statistics enabled. The MicroStrategy Configuration Wizard walks you through the process. 0. MicroStrategy Telemetry Manager: This layer is the synchronization service between Telemetry Server(s),which is using Apache Zookeeper. Request timeout to check if the Intelligence Server is alive. Two different options exist for methods to deal with environments that have different supporting database servers. This is likely the case if the service is disabled or. Failover is a key feature in a. Intelligence Server ensures the scalability and fault tolerance required for sophisticated analysis of terabyte databases and deployments to millions of users. Right-click an Intelligent Cube and select Delete. Only the database names listed in DBAdminConfig. 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. In the event of a code change in future builds, MicroStrategy may not be able to provide additional code on this matter even though this customization is provided. Once logged in, the user must navigate to. Open Performance Monitor from the Administrative Tools in the Windows Control Panel. The following is a standalone Java example to check the different preferences level for a given user's session. How to increase the JVM Heap size for Microsoft Internet information services to allow for better performance. KB20300: After removing the Tahoma font in MicroStrategy Web 10. KB6446: How to increase the heap size of the Java Virtual Machine to handle large result data objects with MicroStrategy Web 9. MicroStrategy Library fully supports Kerberos authentication in Windows on Tomcat. Before following this KB article, the following prerequisites must have been completed: Make sure that the MicroStrategy Intelligence Server is configured correctly to use Integrated Authentication as per the following technical note KB19110Workstation for both Windows and Mac OS has a set of log files that can be found or enabled for troubleshooting purposes. x. Place intelligence server close to the both the data warehouse and the metadata repository. All necessary privileges are included in the Administrator role by default. It is noticed that the Intelligence server hosted machine can't ping each other by machine name. In 2019 Update 1, it took one minute to load three projects. SYMPTOM. msgID. In addition, this release introduces new features across the analytics, mobility, and security platform - making it easier for users to build applications. 2. There are three options that are available: 1. properties: iserver. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. Excel API. This technique is useful till 80%. 3 — Leverage Embedded. Copy the new certificate to MicroStrategyLibrary's WEB-INF folder (in the same location from step 2). The license check takes place anytime within the next half hour of the time specified in the setting. 0Distributed Logging ServiceDistributedLogger. 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 this reason, outbound network traffic needs to be allowed on port 443 in order to transmit the data. Windows: C:\Program Files (x86)\MicroStrategy\Intelligence Server\TLS. The PostgreSQL ODBC Driver has the best cube publish performance as it has the highest throughput. You will be able to: - connect to MicroStrategy Server. Action. command is one of the commands from the list below. 1. x > Configure Tomcat. The following are the methods that support connecting to and disconnecting from a MicroStrategy Intelligence Server: MOIOffice. csv file to keep a record of their settings, and import a previously saved file to apply settings to an environment. You can search, view, and edit server-level settings. "rlim_fd_cur" specifies the “soft” limit on file descriptors that a single process can have open. KB39915: A blank page appears when trying to generate the client certificate using a browser from MicroStrategy Mobile Certificate Server 9. Make sure all Intelligence Server nodes are running during the life-time of Library Server. Select the "exportMaxCellsPlainText" setting and modify the "Maximum" value under "Other. If the administrator would like to get the status of MicroStrategy Intelligence Server Universal 9. x to be restarted in order for the changes to take effect. The JSESSIONID or ASP. 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. Seeing this issue after the upgrade to latest mstr software launched in Jan 2022. 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. 5 GB . This online guide covers the installation and configuration of various MicroStrategy components, such as Workstation, Library, REST Server, and Collaboration Server. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using. 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. Perform the following steps to install MicroStrategy Library on a Windows server. Seeing this issue after the upgrade to latest mstr software launched in Jan 2022. In the MicroStrategy Library Configuration box, enter. The MCM settings are in the Intelligence Server Configuration Editor, in the Governing Rules: Default: Memory Settings category. Optionally, you can change the location or name of the Keystore file clientKey. Connect. When the MicroStrategy Web 9. Restart the MicroStrategy Intelligence Server to. Configuring MicroStrategy and getting started. x. What's New in MicroStrategy 2020. Remember that the memory used will decrease. Login to Postman and search for MicroStrategy in the homepage search bar. Property Default Value Comments; exporter. All basic statistics. WORKAROUND: Disable the Cube Health Check Feature on the effected environment by adding the following key: [HKEY_LOCAL_MACHINESOFTWAREMicroStrategyDSS ServerCastor]. Click on Yes. Setting this to a higher number may improve performance under high job concurrency, but it increases the amount of time caches that exist in memory only (i. The default Intelligence Server configuration settings, defined in the Intelligence Server Configuration Editor, are provided below. Perform a single project test against one project. After installation, user may need to check those folder path to locate specific files. 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. To set up MicroStrategy Intelligence Server. The requests are granted or denied according to user-configured limits on the amount of. mstr file is a zipped file of object definition package and cube files. Both enabling and disabling logs are covered. Beginning in MicroStrategy 10. If a name is not specified, the command uses the default instance name. Step 5. Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. You can build real-time or near-real-time MicroStrategy applications based on it. x when Intelligence Server is on Linux. Re-run the Configuration Wizard and enabled TLS. You need to increase the ulimit parameters by running ulimit -n 65534. In the Add a server manually field, specify the DNS name of the Intelligence Server machine. xml" file but changing the value between the <state> and </state> tags to read "Stopped" 2. View and Analyze Log Files. OR, to convert an existing filter into a security filter, click Import. So MicroStrategy Intelligence Server has to be re-started for this setting change to take effect. labs. Open the MicroStrategy Configuration Wizard. The important functions of MicroStrategy Intelligence Server are: Managing the sharing of data and objects in a controlled and secure environment. Step 5. x or 10. 11. 4. 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. timeout: The maximum waiting time when polling a job on a server. Administrators can export the server settings in this tab to a . Description. Efficiently manages thousands of end-user requests (jobs. Published: May 2, 2018; Last updated: Jul 17, 2023; Related versions: 10. Add the IP to hostname mapping (e. 67. Under the Server tab, click Application Load Balancer. 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. Number of Views 7. (Min 2) Maximum number of renderer processes. jks file including the cert with a passphrase, e. 4. The ODBC connection uses 3. Database Instance. in my company we are using Microstrategy 10. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. The value provided for the entry described below would work as the service name. Every time that a user does something in MicroStrategy, like. By default, the mstr database. This location is set during installation and cannot be changed. The default value is 10. If no Intelligence Servers are listed or connected, add an Intelligence Server and connect it to MicroStrategy Web. Cube Extract a MicroStrategy cube into a R Data. With these statistic logs, administrators can observe the amount of time spent on each step of the process for a certain task in MicroStrategy Web. Connect. x on Linux machines. renderer. Re-run the Configuration Wizard and enabled TLS. 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. Beginning in MicroStrategy 10. "" -n "" -u -p -f. trusted. 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). Users notice multiple instances of the "mstrexec-iserver" processes in Microstrategy Intelligence Server 9. Crash data is automatically uploaded to microstrategy. This will prompt to stop the MicroStrategy Intelligence Server process in order to create the new Server Definition. During shutdown the State will display as . yaml. 40. Expand Intelligent Cubes, and then select General. The ultimate goal of load balancing is to use all available resources in the most efficient manner, leading to improved system performance. With the 10. DisconnectProjects. Multiple "mstrexec-iserver" process instances are seen in MicroStrategy Intelligence Server 9. This can be confirmed using the MicroStrategy Service Manager, as shown. KB235107: How to Embed a Custom Font Without Having to Install it on the Client Machines using MicroStrategy Web SDK 9. Change the path if it is incorrect. The Intelligence Server selection page opens. 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. 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. Change the UseUTC value to 1, as shown below: Restart the MicroStrategy Logging Client and MicroStrategy Logging Server services from Control Panel > Services for the changes to take effect. Then it presents this data to the administrators, developers, and analysts to help them optimize the performance of. STEPS TO CONFIGURE: Get the path of images folder on the intelligence server machine. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. Enabling LDAP Authentication for MicroStrategy Web. Make sure that SSL is already configured and note down the REST port number used, as shown in the screenshot below. Iserver is on windows server, web server is apache tomcat. Each segment executing in the MicroStrategy Narrowcast Server establishes one session or connection to the MicroStrategy Intelligence Server. • Enterprise Manager. Step 4. x - 10. old' or delete the file. Launch MicroStrategy Developer. /mstrctl -s IntelligenceServer ssic' from the bin folder to set a new configuration for the MicroStrategy Intelligence Server performance configuration. mstrexec-iserver: WARNING: maximum number of open files 256 is low; please increase to 1000 or greater. From the DSN drop-down list, select the DSN used to connect to the metadata repository. 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. The chart below shows how the statistics collection change from MicroStrategy version 9. Create Response fileMicroStrategy Internal case number: 379474 -----Installation instructions-----This patch should be applied on top of MicroStrategy 9. Watch on. x and newer. To view the current status of a MicroStrategy Intelligence Server Universal instance in a UNIX/Linux environment, run the command ‘mstrctl -s IntelligenceServer gs’ from the <MicroStrategy HOME>/bin directory using a command prompt / terminal. 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. Configure Metadata Connection. 1 and above KB10384: How to increase the Java Heap size in Tomcat Application Server Beginning in MicroStrategy 10. In the Service drop-down list, select MicroStrategy Intelligence Server. The Intelligence Server is added to the Connected Servers list. The heap is the run-time data area from which memory for all class instances. MicroStrategy makes no warranty, express, implied or otherwise, regarding these products, including their performance or reliability. (How?) From the pane on the left, select Servers. x server machine. 1 (2019) rather than 11. 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 build real-time or near-real-time MicroStrategy applications based on it. 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. , an abnormal shutdown due to errors or the process is killed). First, the user must log in as the “mstr” user. Salary ranges can vary widely depending on many important factors, including education, certifications, additional skills,. xml should do. How to Start and Stop Intelligence Server Services. MDMover allows everything to be moved with one click. MicroStrategy provides In-memory BI capabilities that leverage 64-bit operating systems to improve the overall performance of a BI system. 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. When State displays Stopped the service is inactive. The first is the 'Web User Session Idle Time' setting located in Developer by right clicking the project source -> Configure MicroStrategy Intelligence Server -> Governing -> General, as shown in the image below. Any time difference can be accounted for,but may may make the process difficult and increase the chances of errors. For steps to use the Configuration Wizard to upgrade your statistics repository and other. If a customer opts to increase the data repository and/or cube memory requirements, they will either necessitate a change order or will beIntroduction. KB201630: How to change the Row Limit of a report that uses an Intelligent Cube. LDAP Integration with the MicroStrategy Intelligence Server: To integrate users and groups stored on an LDAP server within the MicroStrategy Intelligence Server 9. The video also presents how the data from Salesforce reports is converted to MicroStrategy attributes and metrics. 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. 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. 2. Change the owner of the files to be the new non-root user account (and non root user group. All files under the conf folder are overwritten when you upgrade MicroStrategy. Afterwards you will see Kafka log files created in the Kafka. browser cache etc is all cleared even tried with re-installing library server. 25K. d/ directory. x from the Command Line, run the following command: $ mstrctl -s IntelligenceServer stop. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. Synapse Analytics leverages a scale out architecture to distribute computational processing of data across multiple nodes. How to increase the Java Heap size in Tomcat Application Server. Add the IP to hostname mapping (e. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for the memory available on Intelligence Server machine. Edit the web. provider). filename is the name of the file to read from or write to. 26K. 2. Learn how to use an external REST client to run MSTR related REST requests. You can implement iServer easily with it. browser cache etc is all cleared even tried with re-installing library server. Helps optimize custom group banding when using the Count Banding method. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. /mstrweb restart” command. Determines how distinct counts of values are retrieved from partitioned tables. Hover over a connected Intelligence server and click the Server Administration icon in the Properties column. Administrators can export the project settings in this tab to a . The XML call's socket default read timeout: ConfigDefaults. Navigate to the System Definitions folder under Web Configuration Settings. If only a single MicroStrategy Intelligence. 4 GB or. The project default level preferences are accessed by the Web server at connection time. instancename is the name of a server instance, where required. Fields Disk Storage Cache file directory: The. When considering load balancing in MicroStrategy environment, the two most critical points. Select the Default option to set LDAP as the default authentication mode. 3. In the MicroStrategy Library Configuration box, enter. 11, 10. Net_SessionId cookie is set by the JSP application server / IIS to track the user over the course of the its session and is required. Steps. xml file and create a backup copy of it. Access, filter, publish, and extract data from MicroStrategy in-memory cubes Create a Cube object to load basic information on a cube dataset. MicroStrategy Intelligence Server provides out-of-the-box clustering capabilities. Speed is typically measured as user wait time or. x: Statistics logging option. This is also tuning for issues revolving around errors with Garbage Collection overhead limits and in some cases HTTP 500 errors. After upgrading from MicroStrategy 2019 Update 1 to MicroStrategy 2019 Update 2, it takes much longer to start the Intelligence Server. xml file. com) to the hosts file of the Library server machine to manually resolve the iserver name. Drop Files. xml', for example 'status-iserver. To be able to connect to the Directory Server however, MicroStrategy Intelligence Server 9. GetProjects. command is one of the commands from the list below. Include the port, which is 9092 by default separated from the Fully Qualified Domain Name by a colon. 52K. requestTimeout. 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. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. For detailed information refer to the System Administration Help. Diagnostic logs will be sent to the Messaging Services Server after you perform the following: Enable MicroStrategy Messaging Services. 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. With the Parameterized Query option enabled, reports containing text filters and prompts will be executed using parameter markers (?) during SQL execution. 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. The Java Virtual Machine has a heap that is shared among all Java Virtual Machine threads. csv file to keep a record of their settings, or import a previously save file to apply the setting to a project. The Servers page opens. For prior releases, either a cube was loaded, residing completely in RAM, or unloaded. You can use the MicroStrategy Configuration Wizard to upgrade your statistics repository. 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. - modify the data a little bit. 10. From MicroStrategy Platform home page, scroll down to the Essentials Connections section. To increase the number of server nodes, click the 'Number of Server Instances' dropdown. Right mouse click on the project source of the Intelligence Server you wish to remove the trust relationship from. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. Platform Analytics is the new monitoring tool in MicroStrategy 11. 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. 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. System Performance Trends. 2. If administrators attempt starting MicroStrategy Intelligence Server from Administrative Tools > Services, they. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. SYMPTOM: The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. This is working as designed. If some Intelligence Server nodes are/were down, you can start them first and then restart Library Server. When State displays Running the service is ready. The setting described below (ServerName) is NOT ONLY for the '&SERVERNAME' macro used in the history list URL. The following procedure describes how to ensure the web server, mobile server and intelligence server use images from the same folder in MicroStrategy 9.