To allow MicroStrategy Web users to access projects, you must create a connection between a MicroStrategy Intelligence Server and MicroStrategy Web. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. This issue only happens on Windows. GetProjectSources. 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. 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. MicroStrategy's flexible, scalable architecture allows organizations to deliver high performance and fast response times at scale. Once the server definition has been changed, MicroStrategy Intelligence Server will start back up using the new server definition. xml'. 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. command is one of the commands from the list below. ACTION:MicroStrategy recommends that the Linux kernel setting vm. x when Intelligence Server is on Linux. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. The default value is 256 megabytes. Editing cluster membership is an administrative action and should be performed exclusively. xml', for example 'status-iserver. Restart the MicroStrategy Intelligence Server to. 1m running on Microsoft IIS ServerOpen a new or existing dossier. 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. xml file. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). The default Load balance factor value is 1. Frame Description Access, filter, publish, and extract data from MicroStrategy in-memory cubes. Determines how distinct counts of values are retrieved from partitioned tables. 4. Search for the files changed (below) in the target machine and create a backup of these files in all cluster nodes. x, join cluster fails or doesn't work fine if two nodes don't know each other’s' machine name. 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. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. x and 11. Salary ranges can vary widely depending on many important factors, including education, certifications, additional skills,. The size of the connection pool: ConfigDefaults. 1, administrators can delete trust relationships through MicroStrategy Developer. log and MicroStrategy License Manager is the version of the base build installed in that machine. Windows from the command line, then perform the following steps: From the Windows Start menu, select Run. 3 — Leverage Embedded. Access the MicroStrategy Web Administrator page. A database instance specifies connection information, such as the data source name, Login ID and password, and other data source specific information. In MicroStrategy Developer, log in to a project source with administrative privileges. Depending on the resources available and the version installed, please set the Maximum working set RAM to a number between the following list:. The -h option is needed to change the owner on symbolic links as well. On MicroStrategy Intelligence Server 9. Go to Internet Explorer > Internet Options. Significantly improves user-perceived query performance. It's being used even in the biggest financial, telecom and manufacturing organizations. In the top right corner, click MSTR User and then click Preferences to access Web Preferences. g. 5 (on Linux) and 10. x on Linux machines:. Diagnostic logs will be sent to the Messaging Services Server after you perform the following: Enable MicroStrategy Messaging Services. The MicroStrategy Intelligence Server 9. MicroStrategy provides In-memory BI capabilities that leverage 64-bit operating systems to improve the overall performance of a BI system. io through protocol. Note, for more information refer to tech note KB10211 . csv file to keep a record of their settings, or import a previously save file to apply the setting to a project. x Statistics are enabled and a dashboard is executed the MicroStrategy Intelligence Server stats are incorrectly. 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. Statistics logged. However, MicroStrategy NT authentication will fail to login since IIS will not pass the user's NT login ID which comes from the MicroStrategy Login process. xml" file but changing the value between the <state> and </state> tags to read "Stopped" 2. 52K. When considering load balancing in MicroStrategy environment, the two most critical points. If the services are registered, it is much simpler to check status: # service kafka-zookeeper status # service consumer-iserver status Right-click on 'Administration' in MicroStrategy Desktop and select 'Start Server'. Two different options exist for methods to deal with environments that have different supporting database servers. This technique is useful till 80%. Learn how to install and configure MicroStrategy software on Windows and Linux platforms, with detailed steps and best practices. 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. Select Configure Intelligence Server, and click Next. If no Intelligence Servers are listed or connected, add an Intelligence Server and connect it to MicroStrategy Web. Find MicroStrategy’s public API in Postman and make your own copy (Fork). We need to use the same REST port number when binding to the SSL certificate. 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. Step 2. Note, for more information refer to tech note KB10211. 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. mstr file is actually a . Upload FilesOr drop files. iserver. Number of Views 7. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. Note: Make these modifications and re-publish the cube to find out which combination gives better performance. They are part of the MicroStrategy REST Server, which is shipped inside the. x, the Web Pool Size setting does perform any action or hold to it’s defined value. As a new platform release, MicroStrategy 2020 introduces new features that provide better performance and scalability to enhance the overall user experience. command is one of the commands from the list below. max_map_count be defined as 5,242,880 bytes. 24. 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. Connect. 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. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. This document discusses Microsoft SQL Server Database support in MicroStrategy, provides an overview of the integration, summarizes supported workflows, and describes configuration and implementation details. Enter the User Name and Password for the database. The Intelligence Server selection page opens. 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. exe application from the extracted zip file. One possible cause is that the user does not have permission to modify the sys_defaults_<IServer_name>. exe" utility that is installed with MicroStrategy in the "Common Files\MicroStrategy" folder to capture the logs output by the Intelligence Server. labs. If only a single MicroStrategy Intelligence. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Find MicroStrategy’s public API in Postman and make your own copy (Fork). 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. Project. The ability to view or edit certain settings is determined by a user's privileges. This file can be found under: <install drive>Program FilesMicroStrategyIntelligence Server for a default installation of Microstrategy on Windows. From the Oracle Java Virtual Machine Specification Java SE 7 Edition, the heap is described as:. For example, sample cube. Open the Workstation window. The PostgreSQL ODBC Driver has the best cube publish performance as it has the highest throughput. The Upgrade Analysis Dossier is a pre-built dossier that analyzes and visualizes the output data from Integrity Manager Capacity Testing Tool results. max: 1/4 of the number of CPU cores. Iserver is on windows server, web server is apache tomcat. MicroStrategy is an enterprise business intelligence application. Easily add or change pre- and post- SQL statements. If administrators attempt starting MicroStrategy Intelligence Server from Administrative Tools > Services, they. , an abnormal shutdown due to errors or the process is killed). Significantly improves user-perceived query performance. Setting this to a higher limit does not mean the memory will be set aside for immediate use by the Microstrategy Intelligence Server. 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. The MCM settings are in the Intelligence Server Configuration Editor, in the Governing Rules: Default: Memory Settings category. User session and project session analysis. Edit All Server-Level Settings. The MicroStrategy Internal Reference number is DE50391. Steps. 3. The MicroStrategy Repository Administration tool’s backup operation is based on the database information in DBAdminConfig. 3. Intelligence (I-Server) Homepage MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. The crash collection server analyzes the incoming crashes and notifies MicroStrategy technical support and production teams for the incidents. How to increase the Java Heap size in Tomcat Application Server;Summary. The value provided for the entry described below would work as the service name. From the Windows Start menu, point to All Programs, then MicroStrategy Tools, then select Service Manager. x, text in documents still default to that font. You can calculate the factory output rate for one product using the values from the machine-hour capacity formula. x machine: Run the command '. Step 4. The "status-iserver. You should periodically reevaluate the system and update it based on. Single-Node Architecture DiagramOn the MicroStrategy Intelligence Server 9. How to increase the Java Heap size in Tomcat. Although it is possible to use the Microsoft Access database. reportID. x and 10. System Performance Trends. g. 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. In MicroStrategy 2020, four additional lines will appear in the status-iserver. From the pane on the left, select Servers. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. When a machine runs out of virtual memory, processes on the machine are no longer able. The Web Administrator page opens. There are two types of TCP connections: busy and idle. It's being used even in the biggest financial, telecom and manufacturing. The formula is: Production Capacity = Machine-Hour Capacity (MHC) / Hours to Produce One Product. 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. Method to. x. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. exe. If False (default), this feature will be disabled. 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. Welcome to Platform Analytics! The vision of MicroStrategy is Intelligence Everywhere. Number of Views 79. 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. Remember that the memory used will decrease. Increase 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 Settings To 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. Telcos using MicroStrategy can run. 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. Once logged in, the user must navigate to. You can build real-time or near-real-time MicroStrategy applications based on it. On the MicroStrategy Web Server, go to Program Files > MicroStrategy > Web Services > projectsources. The Intelligence Server moves from the list to the Connected servers list and MicroStrategy Web is connected to the Intelligence Server. For example, if a startup script has the following name: "mstr-root@2015-10-21T10:09:23-iserver-CastorServer", it can be changed to "mstr-root@-iserver-CastorServer", but in MSIReg. Number of Views 5. MicroStrategy is an enterprise business intelligence application. Windows: C:\Program Files (x86)\MicroStrategy\Intelligence Server\TLS. In MicroStrategy 10. Click Connect. FrameProcessor. /mstrcfgwiz. In the left pane, click All Settings. New Export Engine in MicroStrategy 2019 can deliver a high-quality PDF files with complete data, diversified widgets and various fonts, compared with the Legacy Engine in 10. This allows resources to be shared across the network. MicroStrategy Server Activation is a licensing technology that ensures that installations of MicroStrategy server products are authentic and have been legitimately licensed. xml file. Enter the User Name and Password for the database. Click the icon in the Actions column and select Start, Stop, or Restart. This will generate a new certificate and key pair and start the Intelligence Server. A new file 'status-iserver. From the DSN drop-down list, select the DSN used to connect to the metadata repository. 1. ACTION: This tech note explains: File Relationships. In the Action column in the Unconnected servers list, click Connect for the Intelligence Server to connect to. Navigate to the System Definitions folder under Web Configuration Settings. x-10. 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. Each segment executing in the MicroStrategy Narrowcast Server establishes one session or connection to the MicroStrategy Intelligence Server. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using the MicroStrategy Service Manager. For an example of how to do this, see the sample code below. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. Excel API. Start the MicroStrategy Intelligence Server. …Go to Administration > Projects > Project Configuration. In 2019 Update 2, it takes eight minutes to load the same three projects from the same metadata. 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. The Intelligence Server selection page opens. Choose Get Info if you are using a Mac. Related Articles. 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. Production capacity is the maximum possible output of a manufacturing business, measured in units of output per period. x in Windows environment. 0 Hotfix 2 (9. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. The cache. 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. KB7295: What is the Memory Contract Manager in MicroStrategy Intelligence Server? PART 1. It also covers other features, such as importing data from external public data sources, blending. For more information about Enterprise Manager, see the Enterprise Manager Guide. Step 4. KB440719. 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. The user is the basic unit in the MicroStrategy security model. This ensures changes are synchronized in a timely manner. backtrace. To improve the data fetching performance for JDBC connections, Administrators can also increase the JNI Bridge Heap Space. 4001 - runReport Executes the report specified by either the reportID or reportName argument. Required Status to Perform Action. Right-click an Intelligent Cube and select Delete. jks at this time via the sslClientKeystore parameter in the microstrategy. Login information such as the user name, login ID, password, and password expiration date. Watch on. The 'Maximum RAM for Working Set cache' is the governor that modulates the size of the WorkingSet Result Pool. xml' will be created and the MicroStrategy Intelligence Server Universal should start normally. log will depend on the Log Path specified during installation. 0Distributed Logging ServiceDistributedLogger. Choose the individual modules to be logged. 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. 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. MicroStrategy makes it easy for you to generate enterprise reporting, dashboards, scorecards, notifications, etc. 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. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. 4. microstrategy. MicroStrategy makes no warranty, express, implied or otherwise, regarding these products, including their performance or reliability. The user. zip file, with the. On MicroStrategy 11. On the MicroStrategy Web server machine, access the IIS Internet Service Manager. (Note: On MicroStrategy Intelligence Server machine, go to Administrative Tools -> Services, open the Microsoft Services window and locate the MicroStrategy Intelligence Server service. x-10. For more information regarding the MicroStrategy Web architecture or the process of customizing MicroStrategy Web, please refer to MicroStrategy Developer Zone (the Server Instance tab. instancename is the name of a server instance, where required. Multiple "mstrexec-iserver" process instances are seen in MicroStrategy Intelligence Server 9. Review the file to ensure all entries match the ones seen in the following screenshot (namely iserver. You can use the MicroStrategy Configuration Wizard to upgrade your statistics repository. Within this directory, the user will need to execute the “. Use Response file. From the pane on the left, select Servers. The Servers page opens. The project default level preferences are accessed by the Web server at connection time. bat. 10. command is one of the commands from the list below. Specifies the ID of the report to execute. To manually configure the MicroStrategy Repository, Platform Analytics, and the Collaboration Server database user, schema, and warehouse, use the steps below: Prerequisite : Ensure the mstr user, or any other non-root user used to register services, is a valid system user and able to log in. 1. 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. It takes you from setting up and configuring MicroStrategy to security and administration. x instance using the following command from the bin folder of the MicroStrategy Home folder:. 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. 67. Add the IP to hostname mapping (e. All MicroStrategy log files are stored in the log file lo cation. Crash data is automatically uploaded to microstrategy. There will most likely be a direct correlation between user load and resource consumption. Modify IE 11 Security Setting to enable Allow Font Download: Go to Internet Explorer > Internet Options. Server. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. 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. Together, they are often referred to as the JSON Data API. MicroStrategy Telemetry Manager: This layer is the synchronization service between Telemetry Server(s),which is using Apache Zookeeper. Re-run the Configuration Wizard and enabled TLS. Hello, We had the same problem after upgrading our 11. Every time that a user does something in MicroStrategy, like. x or 10. If the Startup type of the MicroStrategy Intelligence Server. Step 3. User session and project session analysis. Supported data structure and distribution on Gateway. properties: document. You can implement iServer easily with it. yaml. The requests are granted or denied according to user-configured limits on the amount of. Enter your API Server and select your authentication mode and enter your credentials. To forecast future needs, you can plot user load against the resource consumption graphs above. x-10. Drop Files. When you use the cube directly in the Dossier, the definition is applied to the cube directly and the MicroStrategy AE saves time since it doesn’t have to search and fetch an extra report definition. trustToken and auth. 3. If no Intelligence Servers are listed or connected, add an Intelligence Server and connect it to MicroStrategy Web. Select Configure Intelligence Server, and click Next. List Nodes GET /monitors/iServer/nodes Get information about nodes in the connected Intelligence Server cluster, including: Basic information Runtime state Information for the. Login to Postman and search for MicroStrategy in the homepage search bar. old' or delete the file. x to effectively register the change. The purpose of this document is to guide users in the process of setting up a MicroStrategy. process. x or 10. 0. com) to the hosts file of the Library server machine to manually resolve the iserver name. Server Activation registers each Server Installation with MicroStrategy and locks the installation to a specific machine. It is possible to re-write the URLs to be more. You can use the Reports API, the Cubes API and the Dossiers API to retrieve definitions and data from the Intelligence Server. x, the limit is 2 TB (2097152 MB) On MicroStrategy 11. Re-run the Configuration Wizard and enabled TLS. /mstrcfgwiz. 11, 10. 9Performance is a combination of speed and scale. Both enabling and disabling logs are covered. 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. Launch MicroStrategy Developer. How to increase the Java Heap size in Tomcat Application Server;. This action starts MicroStrategy Intelligence Server on 'M1. Cube index generation will increase cube size. Select Intelligence Server > Default Properties. The Intelligence Server is added to the Connected Servers list. browser cache etc is all cleared even tried with re-installing library server. In the Service drop-down list, select the service. What's New in MicroStrategy 2020. instancename is the name of a server instance, where required. To access the Intelligence Server Configuration Editor in Developer, right-click the Intelligence Server and select Configure MicroStrategy Intelligence Server. 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. Step 3. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. war file on a default MicroStrategy Windows installation. 6 (on Windows), MicroStrategy Messaging Services uses the third-party Kafka framework to handle the DSSErrors. '. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. You can use the MicroStrategy Configuration Wizard to upgrade your statistics repository. Run the MicroStrategy installer by clicking the setup. The Security Filter Editor opens. 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. 4. MicroStrategy Web or Web Universal users log in to a project and request reports from their Web browsers. KB13943: How to change the log destination for the DSSErrors. Continue to the steps provided in To select a configuration task. xml > isAliveRequestTimeoutMillis. 26K. How to Perform Capacity. Select the "exportMaxCellsPlainText" setting and modify the "Maximum" value under "Other. When you create a new user, you need to provide some or all of the following information: Login information. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using. Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. In the Open drop-down list, type cmd and click OK. x; KB38769: MicroStrategy Certificate Server GetCertificatList call returns an empty page on the browser for MicroStrategy Mobile Server 9. Run the file mstr-repo-ondemand-dba-operations. For this reason, outbound network traffic needs to be allowed on port 443 in order to transmit the data. MicroStrategy Health Center Master Health Agent listens for incoming connections from Health Agents and the Health Center Console on TCP port 44440 by default. Choose Add Data > New Data.