10, 10. The ultimate goal of load balancing is to use all available resources in the most efficient manner, leading to improved system performance. 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. If no Intelligence Servers are listed or connected, add an Intelligence Server and connect it to MicroStrategy Web. Edit All Server-Level Settings. Go to Start > All Programs > Apache Tomcat x. 0. It is noticed that the Intelligence server hosted machine can't ping each other by machine name. This only works for a document or dossier instance. In MicroStrategy 2020, four additional lines will appear in the status-iserver. The setting described below (ServerName) is NOT ONLY for the '&SERVERNAME' macro used in the history list URL. This command is used to terminate a process. x and 10. The Intelligent Cube Monitor is displayed. Description The . From the Windows Start menu go to All Programs > MicroStrategy Tools > Web Administrator. System Performance Trends. 3. If Custom Install is chosen, make sure "MicroStrategy Telemetry Server" is selected (it's auto selected when "MicroStrategy Intelligence" is selected). Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. 8. There is one setting in the MicroStrategy Intelligence configuration, available in Developer and another one in the application server. Prerequisites for Windows Clustering. Request a demo. Can be used instead of reportID. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using the MicroStrategy Service Manager. KB39915: A blank page appears when trying to generate the client certificate using a browser from MicroStrategy Mobile Certificate Server 9. This chapter addresses the processes necessary to configure an installed MicroStrategy suite of products using the Configuration Wizard. MicroStrategy Library is a client application running on a desktop browser or a mobile device, whereas HyperIntelligence for Web is available as a Chrome and Microsoft Edge browser extension. In the email template, you can find the following details regarding your add-in: Platform. iserver. The default path is C:Program FilesApache GroupTomcatwebappsMicroStrategyWEB-INF. How to increase the Java Heap size in Tomcat Application Server. Click Next. DisconnectProjects. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Windows: C:\Program Files (x86)\MicroStrategy\Intelligence Server\TLS. 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. Specify subset of cube to be Crash data is automatically uploaded to microstrategy. If some Intelligence Server nodes are/were down, you can start them first and then restart Library Server. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. MicroStrategy achieves 4-tier load balancing by incorporating load balancers into the MicroStrategy Web products. Once the server is stopped, you can then start it up again by using the. Beginning in MicroStrategy 10. x > Configure Tomcat. Increase the size of Maximum RAM for Working Set cache to a higher value. You can search, view, and edit all project-level settings. The default Load balance factor value is 1. To allow MicroStrategy Web users to access projects, you must create a connection between a MicroStrategy Intelligence Server and MicroStrategy Web. 10. Follow the below steps to change your environment's Library URL. Install MicroStrategy Intelligence Server using the root account. When State displays Running the service is ready. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Tables v9. type: Puppeteer exporter. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. You can search, view, and edit server-level settings. The MCM settings are in the Intelligence Server Configuration Editor, in the Governing Rules: Default: Memory Settings category. 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. For example, high priority Jobs can run on both medium and low priority connections as well as the default high priority connections. This section describes only the most basic guidelines. So MicroStrategy Intelligence Server has to be re-started for this setting change to take effect. of setting up the environment for the MicroStrategy products installed. When installing MicroStrategy Intelligence Server Universal in Unix environment, user needs to specify the path for Home, Install and Log directory as below: As default, the Install and Log folders are under Home folder. This ensures changes are synchronized in a timely manner. The DUMMY_SERVER instance for example, helps for the configuration of the Intelligence. ACTION: Open IIS on the MicroStrategy Web, Mobile, or Web Services 9. command is one of the commands from the list below. x server using Microsoft IIS 7. Upload FilesOr drop files MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. It also explains the setting in the Web Admin page Allow automatic login if session is lost. To backup all databases in MicroStrategy Repository, add the database names to DBAdminConfig. Queries can have a significant increase in the fetch time when there are tables containing VARCHAR without specifying a size in Snowflake. The example above can be summarized by ensuring that the project loading is optimized by making the max Ram usage of object cache 10 times greater than the estimated schema size. The governing setting 'Maximum Report Execution Time' can be defined at the Project Configuration level in MicroStrategy, as shown below: Although there is no direct equivalent to this setting at the report level, there is an alternative that should suit many scenarios. The higher the performance of a CPU, the faster the PC will run. x: Statistics logging option. The heap is a location in memory used by the Java Virtual Machine (JVM). The cache. This setting limits the number of concurrent jobs a user may have during a given session or connection. Open Performance Monitor from the Administrative Tools in the Windows Control Panel. There's a reason we're at the top of the list. In the left pane, click Caches and Cubes. The following article lists the settings that require MicroStrategy Intelligence Server 10. Enable the statistics logging for the project. 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. 25K. KB7295: What is the Memory Contract Manager in MicroStrategy Intelligence Server? PART 1. Re-run the Configuration Wizard and enabled TLS. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. The important functions of MicroStrategy Intelligence Server are: Managing the sharing of data and objects in a controlled and secure environment. xml file: <memory> <logging_time>DATE_AND_TIME</logging_time> A connection pool is a collection of TCP connections maintained in the Web server's memory. x. 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. Together, they are often referred to as the JSON Data API. yaml are backed up by this tool. Step 5. xml file and create a backup copy of it. ) ,. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. ACTION:. From the DSN drop-down list, select the DSN used to connect to the metadata repository. Hello, We had the same problem after upgrading our 11. x when Intelligence Server is on Linux. . During a course which involved microstrategy platform i've been told that: "For MSTR 10. xml' will be created and the MicroStrategy Intelligence Server Universal should start normally. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. The suggested number here is 65534, however, you can change the value as long as it is large. …The version displayed in the DSSErrors. 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. command is one of the commands from the list below. 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. xml file. in your system. com) to the hosts file of the Library server machine to manually resolve the iserver name. The crash collection server analyzes the incoming crashes and notifies MicroStrategy technical support and production teams for the incidents. Step 2. Double-click the new connection mapping in each column to select the database instance, database connection, database login, and language. (Min 2) Maximum number of renderer processes. x Statistics are enabled and a dashboard is executed the MicroStrategy Intelligence Server stats are incorrectly reported as a. Any time difference can be accounted for,but may may make the process difficult and increase the chances of errors. Connect. g. 0Distributed Logging ServiceDistributedLogger. The MicroStrategy Internal Reference number is DE50391. By default: -Windows: C:WindowsSystem32driversetchostsThis chapter addresses the processes necessary to configure an installed MicroStrategy suite of products using the Configuration Wizard. All files under the conf folder are overwritten when you upgrade MicroStrategy. As seen below, the MicroStrategy Library version is still 11. Follow the below steps to change your environment's Library URL. Expand Intelligent Cubes, and then select General. 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. x; KB38769: MicroStrategy Certificate Server GetCertificatList call returns an empty page on the browser for MicroStrategy Mobile Server 9. Once logged in, the user must navigate to the /etc/init. The default value is 256 megabytes. 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. Editing cluster membership is an administrative action and should be performed exclusively. MicroStrategy is an enterprise business intelligence application. From MicroStrategy Platform home page, scroll down to the Essentials Connections section. Users should therefore run the "Monitor. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. browser cache etc is all cleared even tried with re-installing library server. Using the command manager script file created in Step1, create a batch file that can be used to restart the MicroStrategy Intelligence Server. Choose the individual modules to be logged. 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. 6 (on Windows), MicroStrategy Messaging Services uses the third-party Kafka framework to handle the DSSErrors. If a name is not specified, the command uses the default instance name. trusted. The Intelligence Server selection page opens. If no Intelligence Servers are listed or connected, add an Intelligence Server and connect it to MicroStrategy Web. Specifying Warehouse Connection Information. 24. /mstrctl -s IntelligenceServer stopSample URLs for exporting a Report Services document to PDF are shown below. The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. ACTION:MicroStrategy recommends that the Linux kernel setting vm. Dedicate a machine for the metadata repository. This can be achieved via the report level VLDB property > SQL Time. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. All necessary privileges are included in the Administrator role by default. Downloading and installing MicroStrategy. Expand Intelligent Cubes, and then select General. Click the icon in the Actions column and select Start, Stop, or Restart. 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. 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. 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. 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. Retail is leveling up with omnichannel analytics. x or 10. This port is configurable when setting up the Master Health Agent. Select a dataset. x, users may notice that the "Maximum quota per user (MB)" governing setting (located in Developer under Project configuration > Governing rules > Import Data) is applied at the Intelligence Server node level instead of the Intelligence Server cluster level. xml" file but changing the value between the <state> and </state> tags to read "Stopped" 2. xml file. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. 4 GB or. x, the Web Pool Size setting does perform any action or hold to it’s defined value. The third-party product(s) discussed in this technical note are manufactured by vendors independent of MicroStrategy. After calculating the production capacity of each product, you can calculate the factory output rate for multiple products. 4. You should periodically reevaluate the system and update it based on. The user must review the contents of any shell scripts that have been modified post installation that are used by MicroStrategy Intelligence Server Universal. Easily add or change pre- and post- SQL statements. 5 GB . The MicroStrategy Listener will also check to see that MicroStrategy Intelligence Server is running as a. MicroStrategy makes no warranty, express, implied or otherwise, regarding these products, including their performance or reliability. MicroStrategy makes no warranty, express, implied or otherwise, regarding these products, including their performance or reliability. 4001 - runReport Executes the report specified by either the reportID or reportName argument. It gives you the leverage of generating real-time reports and monitoring data. Expand the Data Collector Sets node. This action starts MicroStrategy Intelligence Server on 'M1. x or 10. Platform Analytics repository size may be observed increase rapidly with advanced statistics enabled. How to increase the Java Heap size in Tomcat Application Server;. A list of Web Preferences can be found in the MicroStrategy Enumeration EnumWebPreferences in the MicroStrategy Developers Library Java API Reference. Make sure that SSL is already configured and note down the REST port number used, as shown in the screenshot below. To improve the data fetching performance for JDBC connections, Administrators can also increase the JNI Bridge Heap Space. In the Service drop-down list, select MicroStrategy Intelligence Server. 9 release, MicroStrategy has introduced a new application called Library, which allows users to interact with their analytics from any device and to collaborate across their organization. Welcome to Platform Analytics! The vision of MicroStrategy is Intelligence Everywhere. Change the path if it is incorrect. Enterprise environments can have up to 4 clustered nodes. Edit All Project-Level Settings. MicroStrategy Web or Web Universal users log in to a project and request reports from their Web browsers. 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 on Yes. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. Number of Views 79. If nodes are manually removed from the cluster, projects are. Restart MicroStrategy Web and Mobile Server. If no project sources are defined, then the Configuration Wizard opens. properties: document. To do it, hover over the icon and click Edit Connector. Then from there, you can create the . Make sure all Intelligence Server nodes are running during the life-time of Library Server. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using the MicroStrategy Service Manager. g. MicroStrategy Library fully supports Kerberos authentication in Windows on Tomcat. Search for the files changed (below) in the target machine and create a backup of these files in all cluster nodes. 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. All files under the conf folder are overwritten when you upgrade MicroStrategy. When configuring a MicroStrategy Intelligence Server cluster, special configuration must be made in order for the Intelligence Server cluster nodes to be able to access report and. For example: "C:Program FilesMicroStrategyAdministratorCommand Managercmdmgr. The user. Excel version. 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. 1. In the Action column in the Unconnected servers list, click Connect for the Intelligence Server to connect to. Remember to replace all child object permissions. The license check takes place anytime within the next half hour of the time specified in the setting. The MicroStrategy Listener will monitor the Windows NT Application Event Log for new log entries and uses the log entry of Category 12 from the 'MSTRServer' Source as an indication that MicroStrategy Intelligence Server has been started. The amount of data that the customer chooses to keep could have a corresponding cost to the customer. Choose Add Data > New Data. Perform the following steps to install MicroStrategy Library on a Windows server. The Intelligence Server moves from the list to the Connected servers list and MicroStrategy Web is connected to the Intelligence Server. Right-click on User Defined and select New. 2 (2020). If you are configuring MicroStrategy on: Windows, go to Start > Programs > MicroStrategy Tools > Configuration Wizard. Remember to replace all child object permissions. Tables v10. In practice, you get a cert for the server. microstrategy. MicroStrategy ONE empowers companies worldwide to. Database specific settings By default MicroStrategy will still send Intelligence Server diagnostic logs to local disk. Start Apache Tomcat. MicroStrategy Health Center Master Health Agent listens for incoming connections from Health Agents and the Health Center Console on TCP port 44440 by default. iserver_version The current I-Server version. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. In the MicroStrategy Library Configuration box, enter. 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. Then from there, you can create the . command is one of the commands from the list below. The Master Health Agent checks for updates from MicroStrategy by connecting to TCP port 443, Enterprise Manager can help you analyze the Intelligence Server statistics data. Failover is a key feature in a. On Windows, all log files are stored in C:Program Files (x86)Common FilesMicroStrategyLog. Analyzes system performance over time using your choice of metrics. xml and open it with notepad, as shown below: Locate the project source name that should be changed. Helps you to manipulate the database in a single package. Select the Default option to set LDAP as the default authentication mode. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. 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. Select data population for Intelligent Cubes. jks file including the cert with a passphrase, e. Drop Files. SYMPTOM: The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. You can build real-time or near-real-time MicroStrategy applications based on it. Then it presents this data to the administrators, developers, and analysts to help them optimize the performance of. reportName. Cube Extract a MicroStrategy cube into a R Data. MOIOffice. Navigate to the System Definitions folder under Web Configuration Settings. Step 4: The "status-iserver. You can use the MicroStrategy Configuration Wizard to upgrade your statistics repository. io through protocol. The search specifies a base location in the directory tree as specified by the user in the "Search root distinguished name (DN)" field of the MicroStrategy Intelligence Server configuration. 10, 10. Server-level settings At the server level, only a few settings from each category need a server restart. How to Start and Stop Intelligence Server Services. This article describes one of the reason why MicroStrategy Web application could hang intermittently and works well for some time after restart of the server and how to fix it. trusted. 3. Choose the individual modules to be logged. 52K. x to effectively register the change. It is shared by all processes running on the machine, including the operating system. There will most likely be a direct correlation between user load and resource consumption. The speed at which all programs and processes run depends on the CPU’s performance capacity. The Intelligence Server is added to the Connected Servers list. Expand the Database Instances category, and then select Connection Mapping. MicroStrategy Web: Web Server. Tables v9. To forecast future needs, you can plot user load against the resource consumption graphs above. In reality, an . You can use a linear or exponential extrapolation to plot how increase in user load will drive resource consumption. instancename is the name of a server instance, where required. When the MicroStrategy Web 9. Efficiently manages thousands of end-user requests (jobs. 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. The ability to view or edit certain settings is determined by a user's. xml" must either be edited, renamed, or deleted. Deploying a GCP instance. x and 10. 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. Click Project Defaults from the Menu in the left. (Min 2) Maximum number of renderer processes. This allows resources to be shared across the network. For steps to use the Configuration Wizard to upgrade your statistics repository and other. mstr file is actually a . x and 11. This option must be selected for any statistics to be logged. This reduces the load on Integrity Manager and ensures that the recorded times are as accurate as possible. MicroStrategy for. If present, the report is fetched from memory and the reportID argument is ignored. In the Login area, for LDAP Authentication, select. trusted. You can implement iServer easily with it. Related articles from the Community: Knowledge Base: How to Increase JVM Heap Size in IISA temporary file or folder is the location or files temporary generated by all the applications running on the machine. View and Analyze Log Files. process. 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. 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). How to Perform Capacity. Intelligence (I-Server) Homepage MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. Remember that the memory used will decrease. Step 4. This is likely the case if the service is disabled or. For an example of how to do this, see the sample code below. Significantly improves user-perceived query performance. Each segment executing in the MicroStrategy Narrowcast Server establishes one session or connection to the MicroStrategy Intelligence Server. This feature. Enabling LDAP Authentication for MicroStrategy Web. LDAP Integration with the MicroStrategy Intelligence Server: To integrate users and groups stored on an LDAP server within the MicroStrategy Intelligence Server 9. Although it is possible to use the Microsoft Access database. To increase the number of server nodes, click the 'Number of Server Instances' dropdown. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. d/ directory. Restart the MicroStrategy Intelligence Server to. Launch MicroStrategy Developer. Once MicroStrategy Web is connected to a cluster, all nodes reference the same project. MicroStrategy Intelligence Server also provides a library of over 150. This can be done using the following command: chown -hR <new user account>:<user group> <Install folder>. We finally found our root cause : Web server need to comunicate with IS-Server on port 34962 for the Rest api, after opening this stream, the problem was solvedIncrease Maximum RAM for working set cache setting from Server Configuration > Governing Settings > Default > Memory Settings Disable “Web User Session Recovery on Logout” setting from Intelligence Server configuration > Governing Rules > Temporary Storage SettingsTo increase the limit of number of cells that MicroStrategy Web will allow to export to plain text follow the following steps: Create a new plugin the Web Customization Editor. Depending on the resources available and the version installed, please set the Maximum working set RAM to a number between the following list:. MicroStrategy Intelligence Server is an analytical server optimized for enterprise querying, reporting, and OLAP analysis. 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. Published: May 2, 2018; Last updated: Jul 17, 2023; Related versions: 10. Copy the new certificate to MicroStrategyLibrary's WEB-INF folder (in the same location from step 2). Request timeout to check if the Intelligence Server is alive. x in Windows environment. The MicroStrategy Configuration Wizard walks you through the process. x-10. Our analytics and mobility platform transforms data into actionable insights that help people make better business decisions. The Web server will create a new TCP connection if it determines that only two connections are idle. They are part of the MicroStrategy REST Server, which is shipped inside the. You can calculate the factory output rate for one product using the values from the machine-hour capacity formula. This online guide covers the installation and configuration of various MicroStrategy components, such as Workstation, Library, REST Server, and Collaboration Server. x-10. Network configuration best practices. 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. In MicroStrategy 10. Currently this issue is being reviewed by MicroStrategy for a potential code fix on an upcoming MicroStrategy release. There are a few steps that must be completed in order to restart the MicroStrategy Web Server on a Linux machine. List Nodes GET /monitors/iServer/nodes Get information about nodes in the connected Intelligence Server cluster, including: Basic information Runtime state Information for the. This setting must be greater than x x 2. Enter this value in the Server busy timeout field. Server-level settings At the server level, only a few settings from each category need a server restart.