In the Service drop-down list, select the service. If some Intelligence Server nodes are/were down, you can start them first and then restart Library Server. Significantly improves user-perceived query performance. 3. Review the file to ensure all entries match the ones seen in the following screenshot (namely iserver. Beginning in MicroStrategy 10. Downloading and installing MicroStrategy. Click on the Developer Machine Name to copy it. x using the MicroStrategy Configuration Wizard 9. Failover, as it applies to MicroStrategy Intelligence Server, is a strategy by which user sessions and history list jobs are automatically transferred from a failed MicroStrategy Intelligence Server cluster node to another backup node. In other words, this name needs to be recognizable as a network machine. 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. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. Property Default Value Comments; exporter. The start time for the Intelligent Cube publication should be noted first. The video also presents how the data from Salesforce reports is converted to MicroStrategy attributes and metrics. Login to Postman and search for MicroStrategy in the homepage search bar. Launch MicroStrategy Web from the Landing Page of your environment. For New Export Engine in MicroStrategy 2019, when the number of concurrent user increases, the throughput (pages per minute) would remain almost unchanged. 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. 9Performance is a combination of speed and scale. Once the server is stopped, you can then start it up again by using the. 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. Expand the Data Collector Sets node. Locate the web. . com) to the hosts file of the Library server machine to manually resolve the iserver name. KB201630: How to change the Row Limit of a report that uses an Intelligent Cube. Easily add or change pre- and post- SQL statements. war file on a default MicroStrategy Windows installation. Specify a name and location for the new security filter and click Save. 25K. 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. CAUSE: In Solaris, every process is subjected to a System Kernel Parameter that defines the maximum number of files that it can have open. x and 10. This is likely the case if the service is disabled or. trusted. Speed is important because it affects the user experience. Enter the Intelligence Server address (IP or FQDN): Enter the port that the Intelligence Server service is running on. g. MicroStrategy Web must be connecting to the MicroStrategy Intelligence Server via the name configured in the certificate. …Go to Administration > Projects > Project Configuration. log recorded by the MicroStrategy Intelligence Server on Linu… Number of Views 3. x uses third party client libraries. 9 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… 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. This is also tuning for issues revolving around errors with Garbage Collection overhead limits and in some cases HTTP 500 errors. Specifies the ID of the report to execute. How to increase the Java Heap size in Tomcat Application Server;. The cube merge utility is available on MicroStrategy Intelligence Server 9. OR, to convert an existing filter into a security filter, click Import. bat. Editing cluster membership is an administrative action and should be performed exclusively. com) to the hosts file of the Library server machine to manually resolve the iserver name. Select Configure Intelligence Server, and click Next. disk availability is below the 80% capacity threshold. User session and project session analysis. x level and not on the cluster level. 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. The MicroStrategy Intelligence Server 9. requestTimeout. The formula is: Production Capacity = Machine-Hour Capacity (MHC) / Hours to Produce One Product. x. d/ directory. Failover is a key feature in a. 0. Configuring MicroStrategy Using Command Line Tools: MicroStrategy tools are provided in command line mode on Linux so that you can. Solution Deploy the 2020 MicroStrategyLibrary. When a setting is not a runtime setting, MicroStrategy Desktop prompts users to restart MicroStrategy Intelligence Server 9. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. Why is this happening?When users try to start or stop MicroStrategy Intelligence Server from MicroStrategy Service Manager, nothing happens. The user must review the contents of any shell scripts that have been modified post installation that are used by MicroStrategy Intelligence Server Universal. This example checks the preference WebPreferenceDpiConversion. Network configuration best practices. x; KB38769: MicroStrategy Certificate Server GetCertificatList call returns an empty page on the browser for MicroStrategy Mobile Server 9. x in an interactive mode in Windows and UNIX. . Tables v9. x: Statistics logging option. microstrategy. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. 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. 3. xA user has set up MicroStrategy Web 9. There will most likely be a direct correlation between user load and resource consumption. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. A breakdown of memory usage is logged when: The Intelligence server enters MCM denial state for the first time. The purpose of this document is to guide users in the process of setting up a MicroStrategy. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. The memory used by Intelligence Server is limited by the machine's virtual memory. Method to. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. It is shared by all processes running on the machine, including the operating system. KB235107: How to Embed a Custom Font Without Having to Install it on the Client Machines using MicroStrategy Web SDK 9. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using the MicroStrategy Service Manager. The architecture for HyperIntelligence for Web is similar to MicroStrategy Library. UNIX/Linux: After you deploy MicroStrategy Web Universal and log on to the mstrWebAdmin servlet using proper. Find MicroStrategy’s public API in Postman and make your own copy (Fork). x, the Web Pool Size setting does perform any action or hold to it’s defined value. KB440719. ) One (or more) of the above fail to start. Analyzes system performance over time using your choice of metrics. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. We tried all your suggestion but we still had the problem. Within the Tomcat installation directory, navigate to the deployed MicroStrategy directory and open the WEB-INF folder within it. One possible cause is that the user does not have permission to modify the sys_defaults_<IServer_name>. <None>. Iserver is on windows server, web server is apache tomcat. If a name is not specified,. The suggested number here is 65534, however, you can change the value as long as it is large. Add the IP to hostname mapping (e. The Server Properties page opens and displays the following information about the Intelligence Server: Name and connection status. x. e. x*. 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. backtrace. 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. If no Intelligence Servers are listed or connected, add an Intelligence Server and connect it to MicroStrategy Web. x on Linux machines. mstrexec-iserver: WARNING: maximum number of open files 256 is low; please increase to 1000 or greater. The Servers page opens. microstrategy. MicroStrategy makes no warranty, express, implied or otherwise, regarding these products, including their performance or reliability. From the Windows Start menu go to All Programs > MicroStrategy Tools > Web Administrator. Afterwards you will see Kafka log files created in the Kafka. x-10. It takes you from setting up and configuring MicroStrategy to security and administration. Using MicroStrategy, manufacturers can run Big Data analytics on disparate sources to achieve perfect order rates and quality, and to get in-depth consumption patterns. The speed at which all programs and processes run depends on the CPU’s performance capacity. The Intelligence Server moves from the list to the Connected servers list and MicroStrategy Web is connected to the Intelligence Server. To access the Intelligence Server Configuration Editor in Developer, right-click the Intelligence Server and select Configure MicroStrategy Intelligence Server. Select Configure Intelligence Server, and click Next. xml > <propertyname="timeout">. To backup all databases in MicroStrategy Repository, add the database names to DBAdminConfig. Windows from the command line, then perform the following steps: From the Windows Start menu, select Run. Administrators can export the server settings in this tab to a . Type the command of . Select the database instance. You can find this ID by running the “ps” command. x to be restarted in order for the changes to take effect. Depending on the resources available and the version installed, please set the Maximum working set RAM to a number between the following list:. When the MicroStrategy Web 9. It turns data into reports for making and executing key organization decisions. instancename is the name of a server instance, where required. On MicroStrategy 11. xml" must either be edited, renamed, or deleted. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. When Intelligence Server is installed, the last step is to choose a user identity under which the service will run. zip and use 7Zip, or similar tools, to unzip it. x server using Microsoft IIS 7. Windows: C:Program Files (x86)MicroStrategyIntelligence ServerTLS. It is sometimes necessary for administrators to back up the MicroStrategy Web 9. Currently this issue is being reviewed by MicroStrategy for a potential code fix on an upcoming MicroStrategy release. If you are configuring MicroStrategy on: Windows, go to Start > Programs > MicroStrategy Tools > Configuration Wizard. Intelligence Server ensures the. Note, for more information refer to tech note KB10211. For more information about Enterprise Manager, see the Enterprise Manager Guide. If the Startup type of the MicroStrategy Intelligence Server on 'M1' is set to 'Automatic', the available projects appear automatically. 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. This will prompt to stop the MicroStrategy Intelligence Server process in order to create the new Server Definition. STEPS TO CONFIGURE: Get the path of images folder on the intelligence server machine. Restart the MicroStrategy Intelligence Server to. 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. The setting described below (ServerName) is NOT ONLY for the '&SERVERNAME' macro used in the history list URL. Windows: On your desktop, from the Start menu, select Programs (or All Programs ), then MicroStrategy Tools, then Web Administrator. reportViewMode. filename is the name of the file to read from or write to. x, text in documents still default to that font. By default, it is C:Program Files. 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. 3. exe application from the extracted zip file. The Intelligence Server selection page opens. The MicroStrategy Configuration Wizard walks you through the process. Select Intelligence Server > Default Properties. 10, 10. x and 10. x, the limit is 4 TB (4194304 MB) Note: Increasing the 'Maximum RAM for Working Set cache' setting will increase the possible limit amount of RAM that can be used by the Microstrategy Intelligence Server. 7, the MicroStrategy Messaging Services services can also be registered with the operating system during installation. On the other hand, some other configuration files stay as part of the configuration process and are useful to run the applications. 40. x and 11. Re-run the Configuration Wizard and enabled TLS. Once MicroStrategy Web is connected to a cluster, all nodes reference the same project. This section describes only the most basic guidelines. (How?) From the pane on the left, select Servers. Once you have finished choosing your options, click Create Environment and wait for your environment to provision. 6 (on Windows), MicroStrategy Messaging Services uses the third-party Kafka framework to handle the DSSErrors. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. You can calculate the factory output rate for one product using the values from the machine-hour capacity formula. 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. In the MicroStrategy Library Configuration box, enter. 0Distributed Logging ServiceDistributedLogger. Once logged in, the user must navigate to. labs. You can use a linear or exponential extrapolation to plot how increase in user load will drive resource consumption. Refer to the following Community article for details on how to increase this setting: How to set the maximum Java Heap Size value for JDBC source connectivity in MicroStrategy Developer and Web 10. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. The "status-iserver. Published: May 2, 2018; Last updated: Jul 17, 2023; Related versions: 10. Platform Analytics is the new monitoring tool in MicroStrategy 11. x: Statistics logging option. sp. maxPoolSize. Configure Metadata Connection. renderer. x when Intelligence Server is on Linux. In reality, an . Access to a machine with the keytool utility. Right-click a connected environment and choose Properties. Increasing the 'Maximum RAM for Working Set cache' setting will increase the possible limit amount of RAM that can be used by the Microstrategy Intelligence Server. In MicroStrategy 10. 5, the maximum limit is 64GB (65536. Number of Views 7. As seen below, the MicroStrategy Library version is still 11. The default value is 256 megabytes. The default value is 10. MicroStrategy Web, statistics can be used to troubleshoot issues with hanging or slow performance of certain MicroStrategy objects, such as reports or prompts. When creating the trust relationship through MIcroStrategy Office, the token for WS1 will be written into the common metadata for both Intelligence Server nodes. 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. Expand Intelligent Cubes, and then select General. Salary ranges can vary widely depending on many important factors, including education, certifications, additional skills,. Step 3. In IIS, once Anonymous Access is configured, any web user will take an IUSR_machine_name account first as designed in IIS, so it will work for Standard Authentication users. 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. provider). After calculating the production capacity of each product, you can calculate the factory output rate for multiple products. In the left pane, click All Settings. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Select Configure Intelligence Server, and click Next. If nodes are manually removed from the cluster, projects are. 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. Diagnostic logs will be sent to the Messaging Services Server after you perform the following: Enable MicroStrategy Messaging Services. Select one: To create a new security filter, click New. MicroStrategy Library fully supports Kerberos authentication in Windows on Tomcat. GetProjects. This ensures changes are synchronized in a timely manner. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. mstr file is actually a . Tips and troubleshooting. Select a dataset. The PostgreSQL ODBC Driver has the best cube publish performance as it has the highest throughput. System Performance Trends. Turn On the Sending Log to Messaging Services Feature. When State displays Stopped the service is inactive. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. The preferences are stored in memory. Statistics logged. How to increase the Java Heap size in Tomcat Application Server. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. - push data back to MicroStrategy and save it as a new cube. Retail is leveling up with omnichannel analytics. 0. ACTION:. If your password was changed from the default of mstr123 update the parameter in your WEB-INF/microstrategy. It is noticed that the Intelligence server hosted machine can't ping each other by machine name. renderer. There is one setting in the MicroStrategy Intelligence configuration, available in Developer and another one in the application server. Note, for more information refer to tech note KB10211 . max: 1/4 of the number of CPU cores. Using the command manager script file created in Step1, create a batch file that can be used to restart the MicroStrategy Intelligence Server. command is one of the commands from the list below. To improve the data fetching performance for JDBC connections, Administrators can also increase the JNI Bridge Heap Space. 1 and aboveNote: Starting in MicroStrategy 11. This will generate a new certificate and key pair and start the Intelligence Server. 1 and above KB10384: How to increase the Java Heap size in Tomcat Application Server Beginning in MicroStrategy 10. Steps. Remember to replace all child object permissions. 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. KB6446: How to increase the heap size of the Java Virtual Machine to handle large result data objects with MicroStrategy Web 9. CAUSE: This is working as designed. MicroStrategy Web or Web Universal users log in to a project and request reports from their Web browsers. The objective of this document is to provide an estimation of resource requirements for stable and performant operation of. KB48030: Font change is not applied to the graph in MicroStrategy 9. During startup the State will display as . GetProjectSources. KB484838: Best practices for performance tuning based on Azure Synapse AnalyticsAfter an unexpected shutdown of MicroStrategy Intelligence Server, perhaps due to a power failure or a software error, services cannot be restarted from the MicroStrategy Service Manager and remain in a "starting" mode. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Click Project Defaults from the Menu in the left. This ensures changes are synchronized in a timely manner. 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. /mstrctl -s IntelligenceServer stopSample URLs for exporting a Report Services document to PDF are shown below. Expand Intelligent Cubes, and then select General. The 'Maximum RAM for Working Set cache' is the governor that modulates the size of the WorkingSet Result Pool. 52K. 2. xml > isAliveRequestTimeoutMillis. Enter the User Name and Password for the database. Cube index generation will increase cube size. optional): If True, utilize optimal number of threads to increase the download speed. log and MicroStrategy License Manager is the version of the base build installed in that machine. For example: "C:Program FilesMicroStrategyAdministratorCommand Managercmdmgr. ProjectSource. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. The heap is the run-time data area from which memory for all class instances. 1 (2019) rather than 11. In MicroStrategy cluster logic, Intelligence Server uses machine name to. The book starts by detailing the different. x when Intelligence Server is on Linux. Then from there, you can create the . 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. 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. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. The user. Prerequisites. Increase the size of Maximum RAM for Working Set cache to a higher value. Once the server definition has been changed, MicroStrategy Intelligence Server will start back up using the new server definition. Open MicroStrategy for Office in Excel for the web or the Excel desktop application. Server-level settings At the server level, only a few settings from each category need a server restart. /mstrcfgwiz. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. Run Command Prompt as an administrator and enter the following command: netsh add urlacl url=or port/api user=domain\username. Excel API. You should periodically reevaluate the system and update it based on actual system performance and use. config. This issue has been addressed in MicroStrategy 2019 Update 2 and above. Capacity Planning for Platform Analytics. x machine: Run the command '. KB439951: How to set the maximum Java Heap Size value for JDBC source connectivity in MicroStrategy Developer and Web 10. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. To specify a database instance, in the Intelligence Server Configuration Editor, select the General subcategory of the Server Definition category, and, in the Database Instance drop-down list, select the database instance to use for the History List. The MicroStrategy Listener will also check to see that MicroStrategy Intelligence Server is running as a. 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. 2. There are various applications of MicroStrategy. A cloud-native, open architecture platform, it is built on a scalable, future-fit semantic layer designed to inject AI-powered Intelligence Everywhere™. Select the component to be configured from the list. 4. First, the user must log in as the “mstr” user. Enable the statistics logging for the project. Re-run the Configuration Wizard and enabled TLS. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. This setting limits the number of concurrent jobs a user may have during a given session or connection. For example, high priority Jobs can run on both medium and low priority connections as well as the default high priority connections. Unlike major releases and service packs, hotfixes and patches are differential updates of the product, meaning that only a few of the binaries are rebuilt and re-stamped with the hotfix or patch version. yaml. From the DSN drop-down list, select the DSN used to connect to the metadata repository. xml', for example 'status-iserver. 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. Find MicroStrategy’s public API in Postman and make your own copy (Fork). On the MicroStrategy Web Server, go to Program Files > MicroStrategy > Web Services > projectsources. KB48030: Font change is not applied to the graph in MicroStrategy 9. Enterprise environments can have up to 4 clustered nodes. g. Click Project Defaults from the Menu in the left. What is the reason for the. 5 GB. KB440719. Load balancing directs new Web connections to the least loaded node, as measured by user connections. This allows resources to be shared across the network. 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. You should periodically reevaluate the system and update it based on. x ODBC calls by default. Number of Views 79. Embedded is the power play — this is where the magic happens. MicroStrategy Web: Web Server. MicroStrategy Library. This technique is useful till 80%. xml. Once logged in, the user must navigate to the /etc/init. This issue only happens on Windows. 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. You can implement iServer easily with it. All basic statistics. The default value is 256 megabytes. If False (default), this feature will be disabled. The cache. pd_dump and pg_restore utility can be found in folder C:\Program Files (x86)\Common Files\MicroStrategy\Repository\pgsql\bin STEPS: 1. /mstrcfgwiz. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). Optionally, you can change the location or name of the Keystore file clientKey. As shown in the screenshot above, only one cube cache can be loaded in RAM. If no Intelligence Servers are listed or connected, add an Intelligence Server and connect it to MicroStrategy Web. Retrieve Data from the Intelligence Server Using the JSON Data API. When we think about how to truly get the attention of users and increase analytics adoption, the answer many times is embedded analytics. After upgrading from MicroStrategy 2019 Update 1 to MicroStrategy 2019 Update 2, it takes much longer to start the Intelligence Server.