Then from there, you can create the . If some Intelligence Server nodes are/were down, you can start them first and then restart Library Server. 1m running on Microsoft IIS ServerOpen a new or existing dossier. User session and project session analysis. Increase the upper limit on capacity for Aurora Serverless v2 DB instances by changing the maximum ACU value for the cluster. The user is the basic unit in the MicroStrategy security model. 1 (2019) rather than 11. ProjectSource. MicroStrategy Library fully supports Kerberos authentication in Windows on Tomcat. 10 xxxxxxxxxx. SYMPTOM: The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. Once logged in, the user must navigate to the /etc/init. x on Linux as a service makes changes to the scripts required to be run at the system startup. <None>. io through protocol. When launching the MicroStrategy Service Manager, notice the Intelligence Server is already in a stopped status. Start Apache Tomcat. Failover is a key feature in a. Click on More Items > Contact Us. instancename is the name of a server instance, where required. Right-click in the grid and select New to create a new connection mapping. Significantly improves user-perceived query performance. trusted. The cube merge utility is available on MicroStrategy Intelligence Server 9. This can be done using the following command: chown -hR <new user account>:<user group> <Install folder>. exe" -n "MicroStrategy Tutorial" -u Administrator -p 007007 -f C: estartserver. Alternatively, please run: c:Program Files (x86)Common FilesMicroStrategyTomcatapache-tomcat-9. Click Options. Cube index generation will increase cube size. x and 11. Expand the Data Collector Sets node. xA user has set up MicroStrategy Web 9. This video will help you get started using the MicroStrategy REST API. Choose the individual modules to be logged. The license check takes place anytime within the next half hour of the time specified in the setting. Seeing this issue after the upgrade to latest mstr software launched in Jan 2022. 0\Distributed Logging Service\DistributedLogger. This example checks the preference WebPreferenceDpiConversion. On the other hand, some other configuration files stay as part of the configuration process and are useful to run the applications. KB440719. 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. 26K. Excel API. You can build real-time or near-real-time MicroStrategy applications based on it. g. The Intelligent Cube Monitor is displayed. STEPS TO CONFIGURE: Get the path of images folder on the intelligence server machine. KB235107: How to Embed a Custom Font Without Having to Install it on the Client Machines using MicroStrategy Web SDK 9. In the MicroStrategy Library Configuration box, enter. 11, 10. - modify the data a little bit. As seen below, the MicroStrategy Library version is still 11. Downloading and installing MicroStrategy. The Web Administrator page opens. 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. xml'. x and newer, the following information is needed: LDAP version 3 compatible Directory Server that supports Clear text or LDAPS (LDAP over SSL) communications. Select “MicroStrategy SDK”. 2. xml file. 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. instancename is the name of a server instance, where required. It also covers other features, such as importing data from external public data sources, blending. 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. g. xml" must either be edited, renamed, or deleted. Locate the web. A breakdown of memory usage is logged when: The Intelligence server enters MCM denial state for the first time. x and 11. Then from there, you can create the . There are various applications of MicroStrategy. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. Configuring MicroStrategy Using Command Line Tools: MicroStrategy tools are provided in command line mode on Linux so that you can. This means you can manually change the suffix to . In MicroStrategy Developer, log in to a project source with administrative privileges. 0. provider is set to 1 and save the file. The amount of data that the customer chooses to keep could have a corresponding cost to the customer. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. x or 10. Retrieve Data from the Intelligence Server Using the JSON Data API. ) ,. x-10. The size of the connection pool: ConfigDefaults. /mstrcfgwiz. Enter the Fully Qualified Domain Names of all Telemetry Server machines in the cluster, or the name of sole the Telemetry Server machine that will be used if there is no clustering. This online guide covers the installation and configuration of various MicroStrategy components, such as Workstation, Library, REST Server, and Collaboration Server. Windows: C:\Program Files (x86)\MicroStrategy\Intelligence Server\TLS. How to increase the JVM Heap size for Microsoft Internet information services to allow for better performance. Internet or Intranet specification will depend on your connection. As shown in the screenshot above, only one cube cache can be loaded in RAM. The MicroStrategy Intelligence Server 9. MicroStrategy Intelligence Server also provides a library of over 150. Learn how to use an external REST client to run MSTR related REST requests. In addition to the above setting, another major reason for a slow project load could be any additional traces or logs that have been turned on for. Select one: To create a new security filter, click New. KB48030: Font change is not applied to the graph in MicroStrategy 9. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. optional): If True, utilize optimal number of threads to increase the download speed. Steps. Remember to replace all child object permissions. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Select one of the following to determine when and how MicroStrategy Web. MicroStrategy Web: Web Server. Users should therefore run the "Monitor. So MicroStrategy Intelligence Server has to be re-started for this setting change to take effect. You can find this ID by running the “ps” command. The XML call's socket default read timeout: ConfigDefaults. bat. The default Intelligence Server configuration settings, defined in the Intelligence Server Configuration Editor, are provided below. For New Export Engine in MicroStrategy 2019, when the number of concurrent user increases, the throughput (pages per minute) would remain almost unchanged. xml" file but changing the value between the <state> and </state> tags to read "Stopped" 2. What's New in MicroStrategy 2020. csv file to keep a record of their settings, or import a previously save file to apply the setting to a project. However, after publishing,. For this point admins need to try the three options and see which one has better performance. Cube Extract a MicroStrategy cube into a R Data. requestTimeout. The third-party product(s) discussed in this technical note are manufactured by vendors independent of MicroStrategy. Step 3. 9Performance is a combination of speed and scale. x. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. GetProjects. jks file including the cert with a passphrase, e. 10, 10. Intelligence Server ensures the scalability and fault tolerance required for sophisticated analysis of terabyte databases and deployments to millions of users. 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. This allows the Intelligence Server to utilize the system memory resources. The requests are granted or denied according to user-configured limits on the amount of. x to version 10. MicroStrategy Health Center Master Health Agent listens for incoming connections from Health Agents and the Health Center Console on TCP port 44440 by default. xxin omcat9w. From the DSN drop-down list, select the DSN used to connect to the metadata repository. It turns data into reports for making and executing key organization decisions. 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. MicroStrategy Web must be connecting to the MicroStrategy Intelligence Server via the name configured in the certificate. This issue has been addressed in MicroStrategy 2019 Update 2 and above. ) One (or more) of the above fail to start. 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. x; KB38769: MicroStrategy Certificate Server GetCertificatList call returns an empty page on the browser for MicroStrategy Mobile Server 9. Editing cluster membership is an administrative action and should be performed exclusively. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Stay up to date on inventory needs and avoid. The below steps can be used to deploy the MicroStrategyLibrary. in your system. ACTION:MicroStrategy recommends that the Linux kernel setting vm. KB235107: How to Embed a Custom Font Without Having to Install it on the Client Machines using MicroStrategy Web SDK 9. The third-party product(s) discussed in this technical note are manufactured by vendors independent of MicroStrategy. To install the MicroStrategy Library components, select the following features when prompted. There are two cases of this: The Intelligence server has never entered MCM denial state and this is the first time doing so. 73K KB441259: Location of the Project Source Name's Intelligence. 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. In MicroStrategy 10. MicroStrategy is an enterprise business intelligence application. Microstrategy Intelligence Server status information is stored in the file system under a file called 'status-iserver. Only the database names listed in DBAdminConfig. The crash collection server analyzes the incoming crashes and notifies MicroStrategy technical support and production teams for the incidents. Users may find additional information related to managing and using Intelligent Cubes in. For example, high priority Jobs can run on both medium and low priority connections as well as the default high priority connections. To log to your screen, select. /mstrcfgwiz. trustToken and auth. Tables v10. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. After upgrading from MicroStrategy 2019 Update 1 to MicroStrategy 2019 Update 2, it takes much longer to start the Intelligence Server. A database instance specifies connection information, such as the data source name, Login ID and password, and other data source specific information. Here at MicroStrategy, we want to ensure that our users have the information they need to get their platform up and running. This option must be selected for any statistics to be logged. Tips and troubleshooting. The Java Virtual Machine has a heap that is shared among all Java Virtual Machine threads. Optionally, you can change the location or name of the Keystore file clientKey. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 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 data population for Intelligent Cubes. Re-run the Configuration Wizard and enabled TLS. Make sure that SSL is already configured and note down the REST port number used, as shown in the screenshot below. x > Configure Tomcat. Edit All Server-Level Settings. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. The ability to view or edit certain settings is determined by a user's. 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. 1, administrators can delete trust relationships through MicroStrategy Developer. The suggested number here is 65534, however, you can change the value as long as it is large. Connect to the Developer Instance. 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. Copy the new certificate to MicroStrategyLibrary's WEB-INF folder (in the same location from step 2). The Intelligence Server selection page opens. Afterwards you will see Kafka log files created in the Kafka. There is one setting in the MicroStrategy Intelligence configuration, available in Developer and another one in the application server. You can search, view, and edit server-level settings. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. In this article, the MicroStrategy team will review: Prerequisites. How to Start and Stop Intelligence Server Services in Microstrategy By Mohan Vamsi PentakotaHow to Access the Web Administrator Page. The ultimate goal of load balancing is to use all available resources in the most efficient manner, leading to improved system performance. KB20300: After removing the Tahoma font in MicroStrategy Web 10. In the left pane, click All Settings. process. 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. The MCM settings are in the Intelligence Server Configuration Editor, in the Governing Rules: Default: Memory Settings category. Statistics logged. For more information about Enterprise Manager, see the Enterprise Manager Guide. There are a few steps that must be completed in order to restart the MicroStrategy Web Server on a Linux machine. For example, when creating an initial session on WS1 using Standard authentication, a MicroStrategy session was created on Intelligence Server node 2 (I-SERVER_2). Run the MicroStrategy installer by clicking the setup. When a setting is not a runtime setting, MicroStrategy Desktop prompts users to restart MicroStrategy Intelligence Server 9. MicroStrategy ONE is a comprehensive intelligence platform that integrates the power of generative AI with the precision of BI. The Servers page opens. 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 are the methods that support connecting to and disconnecting from a MicroStrategy Intelligence Server: MOIOffice. Continue to the steps provided in To select a configuration task. Choose Get Info if you are using a Mac. Click Dependencies tab, the above 3 dependencies are listed. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). g. There are two ways to register the MicroStrategy Intelligence Server as a service: From the Configuration Wizard: on the Specify a Port Number page – “Register Intelligence Server as a Service option” needs to be checked; From the command line: in ~/MicroStrategy/bin by entering: mstrctl -s IntelligenceServer rsThe MicroStrategy Intelligence Server 9. The formula is: Production Capacity = Machine-Hour Capacity (MHC) / Hours to Produce One Product. 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 file can be found under: <install drive>Program FilesMicroStrategyIntelligence Server for a default installation of Microstrategy on Windows. After installation, user may need to check those folder path to locate specific files. Step 5. 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. Published: May 2, 2018; Last updated: Jul 17, 2023; Related versions: 10. This will prompt to stop the MicroStrategy Intelligence Server process in order to create the new Server Definition. 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. Using the command manager script file created in Step1, create a batch file that can be used to restart the MicroStrategy Intelligence Server. disk availability is below the 80% capacity threshold. To allow MicroStrategy Web users to access projects, you must create a connection between a MicroStrategy Intelligence Server and MicroStrategy Web. The default value is 256 megabytes. 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. Diagnostic logs will be sent to the Messaging Services Server after you perform the following: Enable MicroStrategy Messaging Services. x: Statistics logging option. MicroStrategy Web or Web Universal users log in to a project and request reports from their Web browsers. 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 more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (MicroStrategy projects on each Intelligence Server can be configured to log usage statistics to the staging tables. 40. Enter the Intelligence Server address (IP or FQDN): Enter the port that the Intelligence Server service is running on. Note: Make these modifications and re-publish the cube to find out which combination gives better performance. x, users should see the Intelligence Server automatically rejoin a cluster upon restart. The default one is Interactive. Browse to the filter you want to convert and click Open. renderer. This video will cover how to update the MicroStrategy Intelligence Server License Key and activate installation through License Manager. You can implement iServer easily with it. Make sure all Intelligence Server nodes are running during the life-time of Library Server. Speed is typically measured as user wait time or. Efficiently manages thousands of end-user requests (jobs. Embedded is the power play — this is where the magic happens. Expand Intelligent Cubes, and then select General. Solution Deploy the 2020 MicroStrategyLibrary. The Servers page opens. 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. Edit All Project-Level Settings. . CAUSE: This is working as designed. Select Configure Intelligence Server, and click Next. It is shared by all processes running on the machine, including the operating system. The MicroStrategy Listener will also check to see that MicroStrategy Intelligence Server is. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. 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. This feature. 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. Users experience an issue where Intelligence Servers are getting frequently disconnected from the MicroStrategy Web 9. xml" file contains the state information of the Intelligence Server. Open MicroStrategy for Office in Excel for the web or the Excel desktop application. FrameProcessor. 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. It's being used even in the biggest financial, telecom and manufacturing. If your password was changed from the default of mstr123 update the parameter in your WEB-INF/microstrategy. Optionally, you can change the location or name of the Keystore file clientKey. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. 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. Users notice multiple instances of the "mstrexec-iserver" processes in Microstrategy Intelligence Server 9. We need to use the same REST port number when binding to the SSL certificate. This is because registering MicroStrategy Intelligence Server Universal 9. Administrators can export the server settings in this tab to a . Follow these steps while connected to the MicroStrategy Intelligence Server machine to modify the processor affinity settings of an specific installation: Shutdown the MicroStrategy Intelligence Server Universal 8. To backup all databases in MicroStrategy Repository, add the database names to DBAdminConfig. instancename is the name of a server instance, where required. To start the Intelligence Server in interactive mode, see KB16877: How to start MicroStrategy Intelligence Server 9. 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). HKEY_LOCAL_MACHINE\Software\Microstrategy\Microstrategy Broadcast Server\7. It also explains the setting in the Web Admin page Allow automatic login if session is lost. Connect. View and Analyze Log Files. The Service Options dialog box opens. KB39915: A blank page appears when trying to generate the client certificate using a browser from MicroStrategy Mobile Certificate Server 9. Iserver is on windows server, web server is apache tomcat. In 2019 Update 2, it takes eight minutes to load the same three projects from the same metadata. com) to the hosts file of the Library server machine to manually resolve the iserver name. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. 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. In the Server drop-down list, select the name of the machine on which the service is installed. Governance of CPU clock speed when installing MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Narrowcast Server. x, text in documents still default to that font. 230. Edit the "status-iserver. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Clear the Enable anonymous access check box. The MicroStrategy Intelligence Server was unable to swap out the report instances of 40MB in the Working Set. Disconnect. So MicroStrategy Intelligence Server has to be re-started for this setting change to take effect. The video also presents how the data from Salesforce reports is converted to MicroStrategy attributes and metrics. 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'. The -h option is needed to change the owner on symbolic links as well. x and 10. By default, it is 34952, but ask your MicroStrategy. Select a dataset. x in an interactive mode in Windows and UNIX. HKEY_LOCAL_MACHINESoftwareMicrostrategyMicrostrategy Broadcast Server7. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. The ODBC connection uses 3. Change the path if it is incorrect. Configuring MicroStrategy Using Command Line Tools: MicroStrategy tools are provided in command line mode on Linux so that you can. 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. iserver_version The current I-Server version. 11. The objective of this document is to provide an estimation of resource requirements for stable and performant operation of. Go to the Java tab and specify a maximum memory pool: Save the changes and startup or restart Tomcat. The heap is a location in memory used by the Java Virtual Machine (JVM). The 'Maximum RAM for Working Set cache' is the governor that modulates the size of the WorkingSet Result Pool. MicroStrategy makes it easy for you to generate enterprise reporting, dashboards, scorecards, notifications, etc. 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 preferences are stored in memory. 8. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. Enter your API Server and select your authentication mode and enter your credentials. If your password was changed from the default of mstr123 update the parameter in your WEB-INF/microstrategy. sp. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. There will most likely be a direct correlation between user load and resource consumption. The steps below outline how to modify the project governing setting 'maximum report execution time' using MicroStrategy Server SDK 9. x: Statistics logging option. 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. Multiple "mstrexec-iserver" process instances are seen in MicroStrategy Intelligence Server 9. 24. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Beginning in MicroStrategy 10. max: 1/4 of the number of CPU cores. For more details, see KB442160. filename is the name of the file to read from or write to. Once the server is stopped, you can then start it up again by using the. Enter the User Name and Password for the database. 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. Windows: C:Program Files (x86)MicroStrategyIntelligence ServerTLS. In the left pane, click Caches and Cubes. This issue only happens on Windows. Why is this happening?When users try to start or stop MicroStrategy Intelligence Server from MicroStrategy Service Manager, nothing happens. x, join cluster fails or doesn't work fine if two nodes don't know each other’s' machine name. xml', for example 'status-iserver. The following article lists the settings that require MicroStrategy Intelligence Server 10. You can connect to this server by clicking Connect. xml > <propertyname="timeout">. Right-click an Intelligent Cube and select Delete. When Intelligence Server is installed, the last step is to choose a user identity under which the service will run. The ability to view or edit certain settings is determined by a user's privileges. provider). Ensure auth. If False (default), this feature will be disabled. KB48030: Font change is not applied to the graph in MicroStrategy 9. Select Configure Intelligence Server, and click Next. The MicroStrategy Configuration Wizard walks you through the process. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. Our analytics and mobility platform transforms data into actionable insights that help people make better business decisions. Turn On the Sending Log to Messaging Services Feature. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. xml file and search for 'session. You will be able to: - connect to MicroStrategy Server. 3. Watch on. Login information such as the user name, login ID, password, and password expiration date. Login to Postman and search for MicroStrategy in the homepage search bar. To improve the data fetching performance for JDBC connections, Administrators can also increase the JNI Bridge Heap Space. Navigate to Configure MicroStrategy Intelligence Server > Web Single Sign-on. On Linux, all log files are stored in /opt/mstr/MicroStrategy/log. Theoretically, capacity is a certain. KB201630: How to change the Row Limit of a report that uses an Intelligent Cube. 2. x-10. Upgrading Flash-Based Content What is load balancing? Load balancing, as it applies to MicroStrategy Intelligence Server, is a strategy aimed at achieving even distribution of MicroStrategy Web or Web Universal user sessions across MicroStrategy Intelligence Servers, so that no single machine is overwhelmed. The . Here at MicroStrategy, we want to ensure that our users have the information they need to get their platform up and running. The Web server will create a new TCP connection if it determines that only two connections are idle. If a customer opts to increase the data repository and/or cube memory requirements, they will either necessitate a change order or will be Hi @Rui Chang(PPC) (Microstrategy, Inc.