For more details, see KB442160. In the Open drop-down list, type cmd and click OK. 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. KB20300: After removing the Tahoma font in MicroStrategy Web 10. Increase the size of Maximum RAM for Working Set cache to a higher value. Edit the "status-iserver. Step 5. Salary ranges can vary widely depending on many important factors, including education, certifications, additional skills,. exe. 0. MicroStrategy Intelligence Server is an analytical server optimized for enterprise querying, reporting, and OLAP analysis. Follow the below steps to change your environment's Library URL. The Intelligent Cube Monitor is displayed. Description The . List Nodes GET /monitors/iServer/nodes Get information about nodes in the connected Intelligence Server cluster, including: Basic information Runtime state Information for the. After calculating the production capacity of each product, you can calculate the factory output rate for multiple products. To start the Intelligence Server in interactive mode, see KB16877: How to start MicroStrategy Intelligence Server 9. Crash data is automatically uploaded to microstrategy. Published: May 2, 2018; Last updated: Jul 17, 2023; Related versions: 10. MicroStrategy Web must be connecting to the MicroStrategy Intelligence Server via the name configured in the certificate. For this reason, outbound network traffic needs to be allowed on port 443 in order to transmit the data. Enable the statistics logging for the project. of setting up the environment for the MicroStrategy products installed. The dossier includes an impact analysis where you can identify all the objects that are affected by changes in the engine behavior, manifested as differences in SQL, data or significant changes. To access the Intelligence Server Configuration Editor in Developer, right-click the Intelligence Server and select Configure MicroStrategy Intelligence Server. In MicroStrategy 10. 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 start time for the Intelligent Cube publication should be noted first. Microstrategy Intelligence Server status information is stored in the file system under a file called 'status-iserver. Enter the User Name and Password for the database. KB39915: A blank page appears when trying to generate the client certificate using a browser from MicroStrategy Mobile Certificate Server 9. The Intelligent Cube Monitor is displayed. x > Configure Tomcat. 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. browser cache etc is all cleared even tried with re-installing library server. MicroStrategy Web, statistics can be used to troubleshoot issues with hanging or slow performance of certain MicroStrategy objects, such as reports or prompts. KB485414: How to deal with Platform Analytics repository size increase rapidly in MicroStrategy 2020 and 2021. MicroStrategy Telemetry Manager: This layer is the synchronization service between Telemetry Server(s),which is using Apache Zookeeper. This option must be selected for any statistics to be logged. KB201630: How to change the Row Limit of a report that uses an Intelligent Cube. While this code may apply to other releases directly, MicroStrategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. Diagnostic logs will be sent to the Messaging Services Server after you perform the following: Enable MicroStrategy Messaging Services. The following steps will show you how to register/deregister your Server Instance and other ports from the Application Load Balancer: Click the blue plus button to expand the environment details. This means you can manually change the suffix to . maxPoolSize. Ensure auth. disk availability is below the 80% capacity threshold. Server. 3s. By default: -Windows: C:WindowsSystem32driversetchostsThe MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. xml" must either be edited, renamed, or deleted. When the MicroStrategy Web 9. For example: "C:Program FilesMicroStrategyAdministratorCommand Managercmdmgr. The cube merge utility is available on MicroStrategy Intelligence Server 9. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. There are two cases of this: The Intelligence server has never entered MCM denial state and this is the first time doing so. The Server Properties page opens and displays the following information about the Intelligence Server: Name and connection status. Creating a User. log and MicroStrategy License Manager is the version of the base build installed in that machine. 5, the maximum limit is 64GB (65536. x. When you create a new user, you need to provide some or all of the following information: Login information. 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. 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 New Export Engine in MicroStrategy 2019, when the number of concurrent user increases, the throughput (pages per minute) would remain almost unchanged. x server machine. First, the user must log in as the “mstr” user. Both enabling and disabling logs are covered. 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. log recorded by the MicroStrategy Intelligence Server on Linu… Number of Views 3. Select Configure Intelligence Server, and click Next. Network configuration best practices. MOIOffice. 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. Perform the following steps to install MicroStrategy Library on a Windows server. If some Intelligence Server nodes are/were down, you can start them first and then restart Library Server. Database specific settings By default MicroStrategy will still send Intelligence Server diagnostic logs to local disk. The MicroStrategy Intelligence Server first searches for the user on the LDAP server using the login name provided. Once MicroStrategy Web is connected to a cluster, all nodes reference the same project. Login information such as the user name, login ID, password, and password expiration date. renderer. x server using Microsoft IIS 7. Request timeout to check if the Intelligence Server is alive. There's a reason we're at the top of the list. For prior releases, either a cube was loaded, residing completely in RAM, or unloaded. KB439852: In MicroStrategy 10. ACTION:. KB48030: Font change is not applied to the graph in MicroStrategy 9. 5 GB. You can find this ID by running the “ps” command. Remember to replace all child object permissions. Enter this value in the Server busy timeout field. exe" -n "MicroStrategy Tutorial" -u Administrator -p 007007 -f C: estartserver. Learn how to install and configure MicroStrategy software on Windows and Linux platforms, with detailed steps and best practices. Select the component to be configured from the list. They are part of the MicroStrategy REST Server, which is shipped inside the. Once activated, the user loads the cube in memory. The original method of migrating MicroStrategy Metadata database server platforms consisted of creating a new MD shell in the destination environment and migrate projects one by one into the destination shell. yaml. The book starts by detailing the different. After watching this 3 minutes video you will be able to test mstrio library (based on REST API) yourself. This can be achieved via the report level VLDB property > SQL Time. Find MicroStrategy’s public API in Postman and make your own copy (Fork). Speed is important because it affects the user experience. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. Selected. How to increase the Java Heap size in Tomcat. Enterprise environments can have up to 4 clustered nodes. 11, 10. In the Navigation pane, click Environments. Select “MicroStrategy SDK”. x Statistics are enabled and a dashboard is executed the MicroStrategy Intelligence Server stats are incorrectly reported as a. You can search, view, and edit server-level settings. Python coding is short, minimal and easy. Open your remote desktop connection. 4001 - runReport Executes the report specified by either the reportID or reportName argument. 2. Make sure that SSL is already configured and note down the REST port number used, as shown in the screenshot below. This video walks through the process of directly importing data from a Salesforce report into MicroStrategy Desktop 10. By default: -Windows: C:WindowsSystem32driversetchostsThis chapter addresses the processes necessary to configure an installed MicroStrategy suite of products using the Configuration Wizard. 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. iserver_version The current I-Server version. 5 (on Linux) and 10. 6 (on Windows), MicroStrategy Messaging Services uses the third-party Kafka framework to handle the DSSErrors. To stop the server using this command, you would need to run the following command: “kill -9 PID” PID is the process ID of the MicroStrategy Intelligence Server. To set up MicroStrategy Intelligence Server. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. KB235107: How to Embed a Custom Font Without Having to Install it on the Client Machines using MicroStrategy Web SDK 9. Afterwards you will see Kafka log files created in the Kafka. Choose the individual modules to be logged. Capacity Planning for Platform Analytics. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. SYMPTOM: The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. Within this directory, the user will need to execute the “. On the MicroStrategy Web server machine, access the IIS Internet Service Manager. Once logged in, the user must navigate to the /etc/init. Speed is typically measured as user wait time or. On the other hand, some other configuration files stay as part of the configuration process and are useful to run the applications. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. …Go to Administration > Projects > Project Configuration. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. All basic statistics. There will most likely be a direct correlation between user load and resource consumption. You can use a linear or exponential extrapolation to plot how increase in user load will drive resource consumption. There is one setting in the MicroStrategy Intelligence configuration, available in Developer and another one in the application server. jks. Configure Metadata Connection. In a UNIX console window, browse to the "bin" folder under <HOME_PATH> where the MicroStrategy is installed. command is one of the commands from the list below. exe application from the extracted zip file. xml and open it with notepad, as shown below: Locate the project source name that should be changed. Select Configure Intelligence Server, and click Next. Number of Views 7. sys-defaults. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. The client libraries are certified for use with the MicroStrategy Intelligence Server by operating system platform. If present, the report is fetched from memory and the reportID argument is ignored. Login to Postman and search for MicroStrategy in the homepage search bar. 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. below. Click the icon in the Actions column and select Start, Stop, or Restart. The Servers page opens. If the Startup type of the MicroStrategy Intelligence Server on 'M1' is set to 'Automatic', the available projects appear automatically. A new file 'status-iserver. 090) 1. You can use the MicroStrategy Configuration Wizard to upgrade your statistics repository. 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. Number of Views 5. Select Intelligence Server > Default Properties. You can implement iServer easily with it. The user is the basic unit in the MicroStrategy security model. Hover over a connected Intelligence server and click the Server Administration icon in the Properties column. Go to Internet Explorer > Internet Options. The default value is 256 megabytes. x and 10. KB48030: Font change is not applied to the graph in MicroStrategy 9. Helps optimize custom group banding when using the Count Banding method. (Min 2) Maximum number of renderer processes. war file to upgrade MicroStrategy Library. MicroStrategy ONE is a comprehensive intelligence platform that integrates the power of generative AI with the precision of BI. On MicroStrategy 10. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. Open the MicroStrategy Configuration Wizard. This allows the Intelligence Server to utilize the system memory resources. Enter the User Name and Password for the database. 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. Users notice multiple instances of the "mstrexec-iserver" processes in Microstrategy Intelligence Server 9. Seeing this issue after the upgrade to latest mstr software launched in Jan 2022. x level and not on the cluster level. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. 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. To increase the number of server nodes, click the 'Number of Server Instances' dropdown. 4 GB or higher. In reality, an . x on Linux machines. 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. When the MicroStrategy Web 9. Right-click a connected environment and choose Properties. The steps below outline how to modify the project governing setting 'maximum report execution time' using MicroStrategy Server SDK 9. Re-run the Configuration Wizard and enabled TLS. Once connected to a node, the Web user runs all MicroStrategy activity on the same node. x or 10. in your system. MicroStrategy makes it easy for you to generate enterprise reporting, dashboards, scorecards, notifications, etc. SYMPTOM. Click the Add button. This chapter addresses the processes necessary to configure an installed MicroStrategy suite of products using the Configuration Wizard. Using the Memory Contract Manager. A list of Web Preferences can be found in the MicroStrategy Enumeration EnumWebPreferences in the MicroStrategy Developers Library Java API Reference. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. Step 3. , "dirty" status). First, the user must log in as the “mstr” user. Iserver is on windows server, web server is apache tomcat. The project default level preferences are accessed by the Web server at connection time. This section describes only the most basic guidelines. The MicroStrategy Intelligence Server 9. Windows: C:\Program Files (x86)\MicroStrategy\Intelligence Server\TLS. It is noticed that the Intelligence server hosted machine can't ping each other by machine name. jks at this time via the sslClientKeystore parameter in the microstrategy. LDAP Integration with the MicroStrategy Intelligence Server: To integrate users and groups stored on an LDAP server within the MicroStrategy Intelligence Server 9. This setting limits the time, in seconds, that users can remain idle before their MicroStrategy Intelligence Server session is ended. If a name is not specified,. 1m running on Microsoft IIS ServerOpen a new or existing dossier. What's New in MicroStrategy 2020. browser cache etc is all cleared even tried with re-installing library server. 40. 2 (2020). max: 1/4 of the number of CPU cores. The objective of this document is to provide an estimation of resource requirements for stable and performant operation of. 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. Give the non-administrator user control to C:/Program Files (x86)/MicroStrategy and C:/Program Files (x86)/Common Files/MicroStrategy folders. x and 10. Run the MicroStrategy installer by clicking the setup. Perform a single project test against one project. The preferences are stored in memory. Enterprise Manager consists of a MicroStrategy project, the Enterprise Manager server (service), and an interface in MicroStrategy Command Manager where administrators can control how the server. Increase the upper limit on capacity for Aurora Serverless v2 DB instances by changing the maximum ACU value for the cluster. Click Next. 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. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Continue to the steps provided in To select a configuration task. This file can be found under: <install drive>Program FilesMicroStrategyIntelligence Server for a default installation of Microstrategy on Windows. Performance is a combination of speed and scale. Restart MicroStrategy Web and Mobile Server. In this article, the MicroStrategy team will review: Prerequisites. x instance using the following command from the bin folder of the MicroStrategy Home folder:. Users should therefore run the "Monitor. When a setting is not a runtime setting, MicroStrategy Desktop prompts users to restart MicroStrategy Intelligence Server 9. process. Database Instance. x information regarding the connected servers or to make changes manually to the connection properties of a MicroStrategy Intelligence Servers without using the MicroStrategy Web 9. Note: Make your configuration changes to the configuration files located under the admin folder. Select Configure Intelligence Server, and click Next. 11. Install MicroStrategy Intelligence Server using the root account. x using the MicroStrategy Configuration Wizard 9. xml file. x Administration page although the Intelligence Servers are set to automatically connect. Grid (1) or Graph (2) Mode. Click Connect. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using the MicroStrategy Service Manager. Edit the web. MicroStrategy Web: Web Server. In other words, this name needs to be recognizable as a network machine. Dedicate a machine for the metadata repository. By the same token, our platform is also the source of valuable data. MicroStrategy Intelligence Server also provides a library of over 150. backtrace. For example, if the RAM swap multiplier setting is 2 and the requested cache is 80 Kilobytes, 160 Kilobytes are swapped from memory to disk. 1 the following memory setting must be altered in the Windows Registry ( since the default setting, is not enough to some of the MSTR functions) Set the value of HeapMaxSize under the following path to at least 2048M. Step 3. Then this file is used for Web, Library to communicated with IServer right? Then the file microstrategy. 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. 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. For example, if Initial Pool Size is two, when the first user logs in to MicroStrategy Web, a new. Downloading and installing MicroStrategy. View and Analyze Log Files. 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. Under Collections, click on the the “…” next to. instancename is the name of a server instance, where required. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. CAUSE: This is working as designed. MicroStrategy Web: Web Server. 4. From the DSN drop-down list, select the DSN used to connect to the metadata repository. The ultimate goal of load balancing is to use all available resources in the most efficient manner, leading to improved system performance. With the Parameterized Query option enabled, reports containing text filters and prompts will be executed using parameter markers (?) during SQL execution. Double-click the new connection mapping in each column to select the database instance, database connection, database login, and language. Select Configure Intelligence Server, and click Next. In MicroStrategy Developer, log in to a project source with administrative privileges. With the 10. The Intelligence Server selection page opens. Start Apache Tomcat. It turns data into reports for making and executing key organization decisions. Find MicroStrategy’s public API in Postman and make your own copy (Fork). Copy the new certificate to MicroStrategyLibrary's WEB-INF folder (in the same location from step 2). Start building with MicroStrategy to deliver exceptional product experiences. If administrators attempt starting MicroStrategy Intelligence Server from Administrative Tools > Services, they. reportID. Only the database names listed in DBAdminConfig. There will most likely be a direct correlation between user load and resource consumption. After changing the ACU settings for the cluster. Excel API. The following article lists the settings that require MicroStrategy Intelligence Server 10. Intelligence Server ensures the scalability and fault tolerance required for sophisticated analysis of terabyte databases and deployments to millions of users. ProjectSource. The following is a standalone Java example to check the different preferences level for a given user's session. SSL must already be configured on the MicroStrategy Intelligence Server. This action starts MicroStrategy Intelligence Server on 'M1. 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). There are various applications of MicroStrategy. 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. x to version 10. As shown in the screenshot above, only one cube cache can be loaded in RAM. The Intelligence Server selection page opens. The MicroStrategy Internal Reference number is DE50391. Important Notes: To ensure integrity of the intelligent cubes, make sure the metadata copies on the source and target environments are exactly same. Upload FilesOr drop files MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. Together, they are often referred to as the JSON Data API. If no Intelligence Servers are listed or connected, add an Intelligence Server and connect it to MicroStrategy Web. The value provided for the entry described below would work as the service name. This video will cover how to update the MicroStrategy Intelligence Server License Key and activate installation through License Manager. There are a few steps that must be completed in order to restart the MicroStrategy Web Server on a Linux machine. xml file and search for 'session. Here at MicroStrategy, we want to ensure that our users have the information they need to get their platform up and running. Platform Analytics is the new monitoring tool in MicroStrategy 11. x. If MicroStrategy Intelligence Server Universal is running on a Unix machine, then the default location of the DSSErrors. 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. The MicroStrategy Intelligence Server was unable to swap out the report instances of 40MB in the Working Set. Edit All Server-Level Settings. 4. Restart MicroStrategy Web and Mobile Server. Click on Yes. MicroStrategy Web submits a get folder ID command to Intelligence Server to verify if Intelligence Server is still alive. 67. Expand Intelligent Cubes, and then select General. What is the reason for the. Connect to the Developer Instance. Published: May 2, 2018; Last updated: Jul 17, 2023; Related versions: 10. 2. 50s. x from the Command Line, run the following command: $ mstrctl -s IntelligenceServer stop. Launch MicroStrategy Developer. Modify IE 11 Security Setting to enable Allow Font Download: Go to Internet Explorer > Internet Options. Telemetry Server Configuration: If you want to setup messaging services cluster, tick the check box "Create a cluster of three or more Telemetry Servers", input the local machine name and remote. x to be restarted in order for the changes to take effect. MicroStrategy makes no warranty, express, implied or otherwise, regarding these products, including their performance or reliability. '. Significantly improves user-perceived query performance. 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. Establish server and request timeout settings, as follows: Specify the length of time (in seconds) that a Web request should wait for a connection from the connection pool, if the maximum number of connections are all busy. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Preparation before taking Platform Analytics Repository dump: a. Efficiently manages thousands of end-user requests (jobs. x when Intelligence Server is on Linux. It's being used even in the biggest financial, telecom and manufacturing. 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. mstrexec-iserver: WARNING: maximum number of open files 256 is low; please increase to 1000 or greater. The user must review the contents of any shell scripts that have been modified post installation that are used by MicroStrategy Intelligence Server Universal. (How?) From the pane on the left, select Servers. 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. x and newer, the following information is needed: LDAP version 3 compatible Directory Server that supports Clear text or LDAPS (LDAP over SSL) communications. To start Intelligence Server service automatically (when it fails unexpectedly) using the Restarter: In the Server drop-down list, select the machine on which the MicroStrategy Intelligence Server service is installed. exe" utility that is installed with MicroStrategy in the "Common Files\MicroStrategy" folder to capture the logs output by the Intelligence Server. Use Count (Attribute@ID) to calculate total element number (uses count distinct if necessary) For Tandem databases, the default is Use ODBC Cursor. There are three options that are available: 1. For this point admins need to try the three options and see which one has better performance. microstrategy. Expand Intelligent Cubes, and then select General. Cube index generation will increase cube size. Do not change the files under the conf folder. Change the owner of the files to be the new non-root user account (and non root user group. x-10. Tips and troubleshooting. backtrace. /mstrcfgwiz. Users experience an issue where Intelligence Servers are getting frequently disconnected from the MicroStrategy Web 9. Fields Disk Storage Cache file directory: The. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. It is shared by all processes running on the machine, including the operating system.