Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. The Service Options dialog box opens. xml" file but changing the value between the <state> and </state> tags to read "Stopped" 2. Do not change the files under the conf folder. Similar to the MicroStrategy Web application, Library connects to your Intelligence Server and supports multiple different methods of. MicroStrategy Web must be connecting to the MicroStrategy Intelligence Server via the name configured in the certificate. The steps below outline how to modify the project governing setting 'maximum report execution time' using MicroStrategy Server SDK 9. 4. A Processing Unit is a job-queuing and processing station with a collection of tasks, that a job will undergo after it is submitted to the MicroStrategy Intelligence Server. 0\Distributed Logging Service\DistributedLogger. Seeing this issue after the upgrade to latest mstr software launched in Jan 2022. x when Intelligence Server is on Linux. Within the Tomcat installation directory, navigate to the deployed MicroStrategy directory and open the WEB-INF folder within it. For this reason, outbound network traffic needs to be allowed on port 443 in order to transmit the data. Solution Deploy the 2020 MicroStrategyLibrary. There is one setting in the MicroStrategy Intelligence configuration, available in Developer and another one in the application server. 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. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. Doing so avoids issues where a busy database can't scale up to a capacity with enough memory for the features that are turned on in your cluster and the database workload. x to version 10. Two different options exist for methods to deal with environments that have different supporting database servers. For New Export Engine in MicroStrategy 2019, when the number of concurrent user increases, the throughput (pages per minute) would remain almost unchanged. On Windows, all log files are stored in C:Program Files (x86)Common FilesMicroStrategyLog. When the MicroStrategy Web 9. If some Intelligence Server nodes are/were down, you can start them first and then restart Library Server. To increase the number of server nodes, click the 'Number of Server Instances' dropdown. Scale is important because it determines how many people can submit requests or reports to an analytics platform, how many reports can be supplied by the system, and. 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. x server using Microsoft IIS 7. 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. Enabling LDAP Authentication for MicroStrategy Web. Enter your API Server and select your authentication mode and enter your credentials. You can search, view, and edit all project-level settings. x machine: Run the command '. . To increase the number of server nodes, click the 'Number of Server Instances' dropdown. View the out-of-the-box Platform Analytics Project Dossier>Database Capacity Planning dossier, go to Overview This video shows how to change the user idle timeouts that affec MicroStrategy Web users. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. Expand the Database Instances category, and then select Connection Mapping. 0 GA. KB20300: After removing the Tahoma font in MicroStrategy Web 10. If your password was changed from the default of mstr123 update the parameter in your WEB-INF/microstrategy. Click on More Items > Contact Us. properties: iserver. Tables v10. In MicroStrategy 10. In a UNIX console window, browse to the "bin" folder under <HOME_PATH> where the MicroStrategy is installed. Start the MicroStrategy Intelligence Server. optional): If True, utilize optimal number of threads to increase the download speed. instancename is the name of a server instance, where required. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. The default value is 10. x. Enable the statistics logging for the project. System Performance Trends. KB48030: Font change is not applied to the graph in MicroStrategy 9. 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. All files under the conf folder are overwritten when you upgrade MicroStrategy. In the Service drop-down list, select MicroStrategy Intelligence Server. 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. Open the MicroStrategy Configuration Wizard. MicroStrategy Web: Web Server. x/9. Steps. of setting up the environment for the MicroStrategy products installed. Efficiently manages thousands of end-user requests (jobs. Database specific settings By default MicroStrategy will still send Intelligence Server diagnostic logs to local disk. exe application from the extracted zip file. MicroStrategy achieves 4-tier load balancing by incorporating load balancers into the MicroStrategy Web products. Upload FilesOr drop files. 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. In reality, an . Specifies the ID of the report to execute. 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. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. x and 11. 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. x, text in documents still default to that font. Number of Views 5. maxPoolSize. From MicroStrategy Platform home page, scroll down to the Essentials Connections section. The license check takes place anytime within the next half hour of the time specified in the setting. So MicroStrategy Intelligence Server has to be re-started for this setting change to take effect. x at any time, run the following command: $ mstrctl -s. A database instance specifies connection information, such as the data source name, Login ID and password, and other data source specific information. MicroStrategy Intelligence Server also provides a library of over 150. WORKAROUND: Disable the Cube Health Check Feature on the effected environment by adding the following key: [HKEY_LOCAL_MACHINESOFTWAREMicroStrategyDSS ServerCastor]. Expand Intelligent Cubes, and then select General. - push data back to MicroStrategy and save it as a new cube. Restart MicroStrategy Web and Mobile Server. xml and open it with notepad, as shown below: Locate the project source name that should be changed. The MicroStrategy Intelligence Server was unable to swap out the report instances of 40MB in the Working Set. Place intelligence server close to the both the data warehouse and the metadata repository. The Intelligence Server selection page opens. browser cache etc is all cleared even tried with re-installing library server. , an abnormal shutdown due to errors or the process is killed). zip file, with the. xml' will be created and the MicroStrategy Intelligence Server Universal should start normally. When State displays Stopped the service is inactive. Failover is a key feature in a. For example: "C:Program FilesMicroStrategyAdministratorCommand Managercmdmgr. x or 10. MicroStrategy makes no warranty, express, implied or otherwise, regarding these products, including their performance or reliability. Telcos using MicroStrategy can run. To improve the data fetching performance for JDBC connections, Administrators can also increase the JNI Bridge Heap Space. If no Intelligence Servers are listed or connected, add an Intelligence Server and connect it to MicroStrategy Web. The requests are granted or denied according to user-configured limits on the amount of. Required Status to Perform Action. 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. 0. From the pane on the left, select Servers. x on Linux as a service makes changes to the scripts required to be run at the system startup. max: 1/4 of the number of CPU cores. Clear the Enable anonymous access check box. 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. 3. MicroStrategy provides In-memory BI capabilities that leverage 64-bit operating systems to improve the overall performance of a BI system. 11. 7, the MicroStrategy Messaging Services services can also be registered with the operating system during installation. KB235107: How to Embed a Custom Font Without Having to Install it on the Client Machines using MicroStrategy Web SDK 9. Under Collections, click on the the “…” next to. The following article lists the settings that require MicroStrategy Intelligence Server 10. Configuring MicroStrategy and getting started. There are two cases of this: The Intelligence server has never entered MCM denial state and this is the first time doing so. scpBACKGROUND: 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 document caches, intelligent cubes, history list messages, and session recovery files that were created on other nodes of the cluster. Add the IP to hostname mapping (e. 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. If the Startup type of the MicroStrategy Intelligence Server on 'M1' is set to 'Automatic', the available projects appear automatically. g. List Nodes GET /monitors/iServer/nodes Get information about nodes in the connected Intelligence Server cluster, including: Basic information Runtime state Information for the. 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. jks file including the cert with a passphrase, e. By default, the cluster will be re-joined automatically as long as the cluster node was not shut down normally (e. ACTION: This tech note explains: File Relationships. Give the non-administrator user control to C:/Program Files (x86)/MicroStrategy and C:/Program Files (x86)/Common Files/MicroStrategy folders. renderer. Using the Memory Contract Manager. CAUSE: In Solaris, every process is subjected to a System Kernel Parameter that defines the maximum number of files that it can have open. Enable the statistics logging for the project. Expand Intelligent Cubes, and then select General. The Java Virtual Machine has a heap that is shared among all Java Virtual Machine threads. This information can then help MicroStrategy Administrators monitor the health of their memory usage and determine when they should unload cubes, stop certain jobs, or adjust the memory limit setting. Note: Make your configuration changes to the configuration files located under the admin folder. The 'Maximum RAM for Working Set cache' is the governor that modulates the size of the WorkingSet Result Pool. Efficiently manages thousands of end-user requests (jobs. x-10. xml file and search for 'session. Python coding is short, minimal and easy. All basic statistics. In the top right corner, click MSTR User and then click Preferences to access Web Preferences. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. Load balancing directs new Web connections to the least loaded node, as measured by user connections. With the 10. command is one of the commands from the list below. disk availability is below the 80% capacity threshold. Select Configure Intelligence Server, and click Next. 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. Number of Views 5. Right-click on 'Administration' in MicroStrategy Desktop and select 'Start Server'. Maintain your competitive edge with a data-driven retail app designed to scale—from individual locations to global franchises. - pull data out of it. Adding more capacity to a server product. Queries can have a significant increase in the fetch time when there are tables containing VARCHAR without specifying a size in Snowflake. 5 (on Linux) and 10. 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. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. MicroStrategy Web or Web Universal users log in to a project and request reports from their Web browsers. Perform the following steps to install MicroStrategy Library on a Windows server. When Intelligence Server is installed, the last step is to choose a user identity under which the service will run. This action starts MicroStrategy Intelligence Server on 'M1. You can use the Reports API, the Cubes API and the Dossiers API to retrieve definitions and data from the Intelligence Server. g. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Click Project Defaults from the Menu in the left. renderer. command is one of the commands from the list below. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. The default value is 256 megabytes. The important functions of MicroStrategy Intelligence Server are: Managing the sharing of data and objects in a controlled and secure environment. Administrators can export the project settings in this tab to a . After changing the ACU settings for the cluster. Select one: To create a new security filter, click New. There are a few steps that must be completed in order to restart the MicroStrategy Web Server on a Linux machine. 1. Add the IP to hostname mapping (e. 10 xxxxxxxxxx. Enterprise environments can have up to 4 clustered nodes. Access the MicroStrategy Web Administrator page. Edit All Project-Level Settings. Search for the files changed (below) in the target machine and create a backup of these files in all cluster nodes. 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. The user then updates the cube. jks at this time via the sslClientKeystore parameter in the microstrategy. For this reason, outbound network traffic needs to be allowed on port 443 in order to transmit the data. g. Together, they are often referred to as the JSON Data API. Right-click an Intelligent Cube and select Delete. 1. Interactive jobs per project:Step. On the other hand, some other configuration files stay as part of the configuration process and are useful to run the applications. You should periodically reevaluate the system and update it based on. If False (default), this feature will be disabled. The. Specify subset of cube to be Crash data is automatically uploaded to microstrategy. The MicroStrategy Intelligence Server was unable to swap out the report instances of 40MB in the Working Set. x and 11. Optionally, you can change the location or name of the Keystore file clientKey. Verify that the token file physically exists on the machine running MicroStrategy Web Services and that the token file is named according to the Intelligence Server machine name (I-SERVER_MACHINE_NAME. The Intelligence Server moves from the list to the Connected servers list and MicroStrategy Web is connected to the Intelligence Server. For prior releases, either a cube was loaded, residing completely in RAM, or unloaded. ProjectSource. trustToken and auth. You can build real-time or near-real-time MicroStrategy applications based on it. Statistics logged. Network configuration best practices. x in Microsoft IIS to use Anonymous authentication, but for security reasons, would want to have the MicroStrategy Web Administration page to authenticate using Windows authentication, the following steps will ensure that a user must enter the application server's administrative credentials in order. 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. Tables v9. 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. zip and use 7Zip, or similar tools, to unzip it. Typical scripts that are modified by users would be. How to increase the JVM Heap size for Microsoft Internet information services to allow for better performance. The Server Properties page opens and displays the following information about the Intelligence Server: Name and connection status. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. Select Automatic as the Startup Type option. The bSet cookie used to store various Web GUI settings such as: The state of the report details section (shown/hidden) The state of the page by axis (show/hidden) The state of the view. filename is the name of the file to read from or write to. 4 GB or higher. KB6446: How to increase the heap size of the Java Virtual Machine to handle large result data objects with MicroStrategy Web 9. ) One (or more) of the above fail to start. It collects real-time data (also known as telemetry) which is generated by different components of the MicroStrategy platform like the Intelligence Server. You will be able to: - connect to MicroStrategy Server. 3. If you are configuring MicroStrategy on: Windows, go to Start > Programs > MicroStrategy Tools > Configuration Wizard. Platform Analytics repository size may be observed increase rapidly with advanced statistics enabled. If a name is not specified,. Step 4. yaml are backed up by this tool. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. Intelligence Server ensures the. It turns data into reports for making and executing key organization decisions. KB439951: How to set the maximum Java Heap Size value for JDBC source connectivity in MicroStrategy Developer and Web 10. Under Collections, click on the the “…” next to. The objective of this document is to provide an estimation of resource requirements for stable and performant operation of. 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. 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. As a new platform release, MicroStrategy 2020 introduces new features that provide better performance and scalability to enhance the overall user experience. All basic statistics. Select Configure Intelligence Server, and click Next. In the event of a code change in future builds, MicroStrategy may not be able to provide additional code on this matter even though this customization is provided. Server-level settings At the server level, only a few settings from each category need a server restart. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. iserver_version The current I-Server version. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. How to Perform Capacity. 24. MicroStrategy Library Web & Mobile. MicroStrategy makes it easy for you to generate enterprise reporting, dashboards, scorecards, notifications, etc. In the Login area, for LDAP Authentication, select. Once the server is stopped, you can then start it up again by using the. xxin omcat9w. Cube Extract a MicroStrategy cube into a R Data. log recorded by the MicroStrategy Intelligence Server on Linu… Number of Views 3. The MicroStrategy Intelligence Server first searches for the user on the LDAP server using the login name provided. It takes you from setting up and configuring MicroStrategy to security and administration. The start time for the Intelligent Cube publication should be noted first. In MicroStrategy 2020, four additional lines will appear in the status-iserver. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). After watching this 3 minutes video you will be able to test mstrio library (based on REST API) yourself. mstr file is a zipped file of object definition package and cube files. x Statistics are enabled and a dashboard is executed the MicroStrategy Intelligence Server stats are incorrectly reported as a. MicroStrategy Health Center Master Health Agent listens for incoming connections from Health Agents and the Health Center Console on TCP port 44440 by default. They are part of the MicroStrategy REST Server, which is shipped inside the. x. Access, filter, publish, and extract data from MicroStrategy in-memory cubes Create a Cube object to load basic information on a cube dataset. Depending on the resources available and the version installed, please set the Maximum working set RAM to a number between the following list:. The MicroStrategy Listener will also check to see that MicroStrategy Intelligence Server is. 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. The amount of data that the customer chooses to keep could have a corresponding cost to the customer. Enter the User Name and Password for the database. How to increase the Java Heap size in Tomcat Application Server;The following knowledge base article discusses the governing limit for Intelligent Cubes in MicroStrategy 9. 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 results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. 8. Prerequisites for Windows Clustering. Fields Disk Storage Cache file directory: The. For example, sample cube. instancename is the name of a server instance, where required. '. 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 starting and stopping. You can build real-time or near-real-time MicroStrategy applications based on it. x; KB38769: MicroStrategy Certificate Server GetCertificatList call returns an empty page on the browser for MicroStrategy Mobile Server 9. Restart MicroStrategy Web and Mobile Server. After installation, user may need to check those folder path to locate specific files. …The version displayed in the DSSErrors. msgID. csv file to keep a record of their settings, and import a previously saved file to apply settings to an environment. Enter the User Name and Password for the database. e. 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. A cloud-native, open architecture platform, it is built on a scalable, future-fit semantic layer designed to inject AI-powered Intelligence Everywhere™. 67. The client libraries are certified for use with the MicroStrategy Intelligence Server by operating system platform. KB7295: What is the Memory Contract Manager in MicroStrategy Intelligence Server? PART 1. There will most likely be a direct correlation between user load and resource consumption. 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. MicroStrategy ONE is a comprehensive intelligence platform that integrates the power of generative AI with the precision of BI. The Upgrade Analysis Dossier is a pre-built dossier that analyzes and visualizes the output data from Integrity Manager Capacity Testing Tool results. Preparation before taking Platform Analytics Repository dump: a. x. 5. KB20300: After removing the Tahoma font in MicroStrategy Web 10. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. old' or delete the file. The crash collection server analyzes the incoming crashes and notifies MicroStrategy technical support and production teams for the incidents. Deploying a GCP instance. 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. Synapse Analytics leverages a scale out architecture to distribute computational processing of data across multiple nodes. For detailed information refer to the System Administration Help. Drop Files. This setting limits the time, in seconds, that users can remain idle before their MicroStrategy Intelligence Server session is ended. Hello, We had the same problem after upgrading our 11. xml file. If present, the report is fetched from memory and the reportID argument is ignored. Solution. instancename is the name of a server instance, where required. Navigate to the System Definitions folder under Web Configuration Settings. If only a single MicroStrategy Intelligence. Select Configure Intelligence Server, and click Next. SYMPTOM: The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. 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. x-10. Open MicroStrategy for Office in Excel for the web or the Excel desktop application. Tables v9. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. Iserver is on windows server, web server is apache tomcat. So MicroStrategy Intelligence Server has to be re-started for this setting change to take effect. The user. ACTION:. . Here at MicroStrategy, we want to ensure that our users have the information they need to get their platform up and running. x or 10. Here you can also check the connector URL. 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. Capacity Planning for Platform Analytics. Before following this KB article, the following prerequisites must have been completed: Make sure that the MicroStrategy Intelligence Server is configured correctly to use Integrated Authentication as per the following technical note KB19110Workstation for both Windows and Mac OS has a set of log files that can be found or enabled for troubleshooting purposes. It takes you from setting up and configuring MicroStrategy to security and administration. This can be done using the following command: chown -hR <new user account>:<user group> <Install folder>. Supported data structure and distribution on Gateway. For this point admins need to try the three options and see which one has better performance. You can calculate the factory output rate for one product using the values from the machine-hour capacity formula. Note, for more information refer to tech note KB10211. Using absolute (fully qualified) URLs will work but require administrative maintenance to edit and correct URLs whenever MicroStrategy Web server names, MicroStrategy Intelligence Server names, or ports change (this can happen during migration from development to production). Learn how to install and configure MicroStrategy software on Windows and Linux platforms, with detailed steps and best practices. In 2019 Update 1, it took one minute to load three projects. 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. xml file.