ProjectSource. Start Apache Tomcat. 1 and above on Windows and Linux operating systems. Increase the upper limit on capacity for Aurora Serverless v2 DB instances by changing the maximum ACU value for the cluster. The MCM settings are in the Intelligence Server Configuration Editor, in the Governing Rules: Default: Memory Settings category. x Statistics are enabled and a dashboard is executed the MicroStrategy Intelligence Server stats are incorrectly reported as a. In the MicroStrategy Library Configuration box, enter. If the Startup type of the MicroStrategy Intelligence Server on 'M1' is set to 'Automatic', the available projects appear automatically. There are various applications of MicroStrategy. Editing cluster membership is an administrative action and should be performed exclusively. For New Export Engine in MicroStrategy 2019, when the number of concurrent user increases, the throughput (pages per minute) would remain almost unchanged. Users experience an issue where Intelligence Servers are getting frequently disconnected from the MicroStrategy Web 9. Click Project Defaults from the Menu in the left. Step 5. Dedicate a machine for the metadata repository. Two different options exist for methods to deal with environments that have different supporting database servers. The default value is 256 megabytes. Click Options. 4. g. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. GetProjects. "rlim_fd_cur" specifies the “soft” limit on file descriptors that a single process can have open. Windows: On your desktop, from the Start menu, select Programs (or All Programs ), then MicroStrategy Tools, then Web Administrator. Note: Make your configuration changes to the configuration files located under the admin folder. Efficiently manages thousands of end-user requests (jobs. If your password was changed from the default of mstr123 update the parameter in your WEB-INF/microstrategy. Once the MicroStrategy users are linked to a Windows user account, follow the steps below to setup Windows Authentication for a MicroStrategy Web, Mobile, or Web Services 9. So MicroStrategy Intelligence Server has to be re-started for this setting change to take effect. 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 Platform Analytics Configuration section, check the box. zip file, with the. . Go to Font Download and ensure it is set to Enabled. After installation, user may need to check those folder path to locate specific 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. Once the best combination is determined, admins can test the deletion and see if the performance improves there. 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. Here at MicroStrategy, we want to ensure that our users have the information they need to get their platform up and running. Right-click an Intelligent Cube and select Delete. KB48030: Font change is not applied to the graph in MicroStrategy 9. Statistics logged. The DNS needs to recognize the entry as a machine and be able to resolve its. Number of Views 79. This action starts MicroStrategy Intelligence Server on 'M1. Open the MicroStrategy Configuration Wizard. xml'. The Server Properties page opens and displays the following information about the Intelligence Server: Name and connection status. x. timeout: The maximum waiting time when polling a job on a server. Locate the web. We tried all your suggestion but we still had the problem. It also explains the setting in the Web Admin page Allow automatic login if session is lost. This online guide covers the installation and configuration of various MicroStrategy components, such as Workstation, Library, REST Server, and Collaboration Server. From the Windows Start menu go to All Programs > MicroStrategy Tools > Web Administrator. 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. Navigate to the System Definitions folder under Web Configuration Settings. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. Once MicroStrategy Web is connected to a cluster, all nodes reference the same project. In 2019 Update 2, it takes eight minutes to load the same three projects from the same metadata. On the MicroStrategy Web Server, go to Program Files > MicroStrategy > Web Services > projectsources. In this article, the MicroStrategy team will review: Prerequisites. STEPS TO CONFIGURE: Get the path of images folder on the intelligence server machine. Select Configure Intelligence Server, and click Next. You can search, view, and edit all project-level settings. Determines how distinct counts of values are retrieved from partitioned tables. Once logged in, the user must navigate to the /etc/init. Any time difference can be accounted for,but may may make the process difficult and increase the chances of errors. 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. trusted. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. The Servers page opens. 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. Navigate to the System Definitions folder under Web Configuration Settings. Server-level settings At the server level, only a few settings from each category need a server restart. 9Performance is a combination of speed and scale. 6 (on Windows), MicroStrategy Messaging Services uses the third-party Kafka framework to handle the DSSErrors. x. In the MicroStrategy Library Configuration box, enter. 24. This file can be found under: <install drive>Program FilesMicroStrategyIntelligence Server for a default installation of Microstrategy on Windows. 5, the maximum limit is 64GB (65536. Step 2. It collects real-time data (also known as telemetry) which is generated by different components of the MicroStrategy platform like the Intelligence Server. 67. 0. 4. Launch MicroStrategy Web from the Landing Page of your environment. command is one of the commands from the list below. Note: Make these modifications and re-publish the cube to find out which combination gives better performance. 5. 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. Optionally, you can change the location or name of the Keystore file clientKey. There will most likely be a direct correlation between user load and resource consumption. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. x-10. 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. You should periodically reevaluate the system and update it based on. Launch MicroStrategy Web from the Landing Page of your environment. If no Intelligence Servers are listed or connected, add an Intelligence Server and connect it to MicroStrategy Web. 3. Tables v10. This means you can manually change the suffix to . Only the database names listed in DBAdminConfig. properties file stores the values of how often caches are loaded into memory. The higher the performance of a CPU, the faster the PC will run. Alternatively, please run: c:Program Files (x86)Common FilesMicroStrategyTomcatapache-tomcat-9. The Java Virtual Machine has a heap that is shared among all Java Virtual Machine threads. xml" file but changing the value between the <state> and </state> tags to read "Stopped" 2. max: 1/4 of the number of CPU cores. If no project sources are defined, then the Configuration Wizard opens. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. You can find this ID by running the “ps” command. This can be achieved via the report level VLDB property > SQL Time. From the pane on the left, select Servers. In the Login area, for LDAP Authentication, select. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. Click on the Developer Machine Name to copy it. Run the MicroStrategy installer by clicking the setup. 26K. Our analytics and mobility platform transforms data into actionable insights that help people make better business decisions. Continue to the steps provided in To select a configuration task. This setting limits the time, in seconds, that users can remain idle before their MicroStrategy Intelligence Server session is ended. In the left pane, click Caches and Cubes. Learn how to install and configure MicroStrategy software on Windows and Linux platforms, with detailed steps and best practices. MicroStrategy Intelligence Server is an analytical server optimized for enterprise querying, reporting, and OLAP analysis. The MicroStrategy Internal Reference number is DE50391. Retail is leveling up with omnichannel analytics. Browse to the filter you want to convert and click Open. The ultimate goal of load balancing is to use all available resources in the most efficient manner, leading to improved system performance. 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. below. Start Apache Tomcat. Enable the statistics logging for the project. In the top right corner, click MSTR User and then click Preferences to access Web Preferences. One of your most important jobs as a MicroStrategy system administrator is to find the balance that maximizes the use of your system's capacity to provide the best performance possible for the required number of users. The MicroStrategy Intelligence Server first searches for the user on the LDAP server using the login name provided. x using the MicroStrategy Configuration Wizard 9. Click Options. x-10. In the Server drop-down list, select the name of the machine on which the service is installed. sys-defaults. Related Articles. After calculating the production capacity of each product, you can calculate the factory output rate for multiple products. Although it is possible to use the Microsoft Access database. Click Save. On Windows, all log files are stored in C:Program Files (x86)Common FilesMicroStrategyLog. x at any time, run the following command: $ mstrctl -s. MicroStrategy. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. With the Parameterized Query option enabled, reports containing text filters and prompts will be executed using parameter markers (?) during SQL execution. It gives you the leverage of generating real-time reports and monitoring data. The default value is 256 megabytes. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. Synapse Analytics leverages a scale out architecture to distribute computational processing of data across multiple nodes. Clear the Enable anonymous access check box. If the Startup type of the MicroStrategy Intelligence Server on 'M1' is set to 'Automatic', the available projects appear automatically. Grid (1) or Graph (2) Mode. 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. In MicroStrategy cluster logic, Intelligence Server uses machine name to. CAUSE: In Solaris, every process is subjected to a System Kernel Parameter that defines the maximum number of files that it can have open. Install MicroStrategy Intelligence Server using the root account. 2 environment to 11. Efficiently manages thousands of end-user requests (jobs. x. 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. Or. MicroStrategy Intelligence Server provides out-of-the-box clustering capabilities. To install the MicroStrategy Library components, select the following features when prompted. The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. Step 4. 0. 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. 4. As shown in the screenshot above, only one cube cache can be loaded in RAM. Salary ranges can vary widely depending on many important factors, including education, certifications, additional skills,. From the Windows Start menu go to All Programs > MicroStrategy Tools > Web Administrator. 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. 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. Windows from the command line, then perform the following steps: From the Windows Start menu, select Run. To forecast future needs, you can plot user load against the resource consumption graphs above. The license check takes place anytime within the next half hour of the time specified in the setting. Right-click a project and choose Properties. The Intelligence Server moves from the list to the Connected servers list and MicroStrategy Web is connected to the Intelligence Server. renderer. Server Activation registers each Server Installation with MicroStrategy and locks the installation to a specific machine. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. This is because registering MicroStrategy Intelligence Server Universal 9. 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. x ODBC calls by default. Copy, paste, and execute the following XML script into the command line:Add the MicroStrategy Mobile Admin page URL with the full domain name to the list of Trusted Sites in Internet Explorer: Navigate to Tools > Internet Options > Security > Trusted Sites, like shown below: Click on the 'Sites' button. MicroStrategy is an enterprise business intelligence application. Click the icon next to a listed service. Once the server is stopped, you can then start it up again by using the. For steps to use the Configuration Wizard to upgrade your statistics repository and other MicroStrategy components, see the Upgrade Guide. Stop Tomcat. 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. MicroStrategy Developer must successfully connect to the Intelligence Server via the SSL port. /mstrweb restart” command. instancename is the name of a server instance, where required. x or 10. On the MicroStrategy Web server machine, access the IIS Internet Service Manager. 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. Network configuration best practices. Click Create Trust Relationship. In the Login area, for LDAP Authentication, select the Enabled check box. 10 xxxxxxxxxx. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. Diagnostic logs will be sent to the Messaging Services Server after you perform the following: Enable MicroStrategy Messaging Services. This chapter addresses the processes necessary to configure an installed MicroStrategy suite of products using the Configuration Wizard. g. 3. If a name is not specified, the command uses the default instance name. On MicroStrategy 11. 4. Go to Start > All Programs > Apache Tomcat x. KB13943: How to change the log destination for the DSSErrors. You can use the Reports API, the Cubes API and the Dossiers API to retrieve definitions and data from the Intelligence Server. MicroStrategy Library. ACTION: This tech note explains: File Relationships. Hover over a connected Intelligence server and click the Server Administration icon in the Properties column. 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. x and 11. Give the non-administrator user control to C:/Program Files (x86)/MicroStrategy and C:/Program Files (x86)/Common Files/MicroStrategy folders. Access to a machine with the keytool utility. Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. 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. x; KB38769: MicroStrategy Certificate Server GetCertificatList call returns an empty page on the browser for MicroStrategy Mobile Server 9. By default: -Windows: C:WindowsSystem32driversetchostsThis chapter addresses the processes necessary to configure an installed MicroStrategy suite of products using the Configuration Wizard. To launch the Database Administration Tool: Open the command prompt and navigate to the repository-administration bin folder: C:Program Files (x86)Common FilesMicroStrategy<MSTR_INSTALL>Repository epository-administrationin. x: Statistics logging option. There are three options that are available: 1. 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. Step 3. Capacity Planning for Platform Analytics. Internet or Intranet specification will depend on your connection. To allow MicroStrategy Web users to access projects, you must create a connection between a MicroStrategy Intelligence Server and MicroStrategy Web. Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. KB440719. The MicroStrategy Intelligence Server's backup frequency controls how long the server will wait to write cache and inbox files to disk. x*. Right-click on User Defined and select New. x and newer. Using the command manager script file created in Step1, create a batch file that can be used to restart the MicroStrategy Intelligence Server. The third-party product(s) discussed in this technical note are manufactured by vendors independent of MicroStrategy. Modify IE 11 Security Setting to enable Allow Font Download: Go to Internet Explorer > Internet Options. 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. When you create a new user, you need to provide some or all of the following information: Login information. Can be used instead of reportID. When State displays Stopped the service is inactive. pd_dump and pg_restore utility can be found in folder C:\Program Files (x86)\Common Files\MicroStrategy\Repository\pgsql\bin STEPS: 1. 1. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. In MicroStrategy 11. The chart below shows how the statistics collection change from MicroStrategy version 9. Note: Make your configuration changes to the configuration files located under the admin folder. Expand Intelligent Cubes, and then select General. 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. If only a single MicroStrategy Intelligence. Hover over a connected Intelligence server and click the Server Administration icon in the Properties column. For example, when creating an initial session on WS1 using Standard authentication, a MicroStrategy session was created on Intelligence Server node 2 (I-SERVER_2). Excel API. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. The purpose of this document is to guide users in the process of setting up a MicroStrategy. How to increase the Java Heap size in Tomcat Application Server;Even without coding skills. Speed is typically measured as user wait time or response time. 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. Select Intelligence Server > Default Properties. The speed at which all programs and processes run depends on the CPU’s performance capacity. Embedded is the power play — this is where the magic happens. 4. 1 and above KB10384: How to increase the Java Heap size in Tomcat Application Server Beginning in MicroStrategy 10. For this reason, outbound network traffic needs to be allowed on port 443 in order to transmit the data. Port number of the server. This setting must be greater than x x 2. System Performance Trends. 2. If present, the report is fetched from memory and the reportID argument is ignored. If administrators attempt starting MicroStrategy Intelligence Server from Administrative Tools > Services, they. The user is the basic unit in the MicroStrategy security model. The cube merge utility is available on MicroStrategy Intelligence Server 9. x, the limit is 2 TB (2097152 MB) On MicroStrategy 11. jks file including the cert with a passphrase, e. How to increase the Java Heap size in Tomcat Application Server. 4. 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. The MicroStrategy Intelligence Server was unable to swap out the report instances of 40MB in the Working Set. Go to Internet Explorer > Internet Options. x when Intelligence Server is on Linux. 1. The following is a standalone Java example to check the different preferences level for a given user's session. ) One (or more) of the above fail to start. (How?) From the pane on the left, select Servers. This technique is useful till 80%. MicroStrategy Library Web & Mobile. This section describes only the most basic guidelines. max: 1/4 of the number of CPU cores. To start the Intelligence Server in interactive mode, see KB16877: How to start MicroStrategy Intelligence Server 9. Access, filter, publish, and extract data from MicroStrategy in-memory cubes Create a Cube object to load basic information on a cube dataset. Tables v10. Enterprise environments can have up to 4 clustered nodes. jks. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. The. Add the IP to hostname mapping (e. x. - pull data out of it. Access the MicroStrategy Web Administrator page. UNIX/Linux: After you deploy MicroStrategy Web Universal and log on to the mstrWebAdmin servlet using proper. Afterwards you will see Kafka log files created in the Kafka. Login information such as the user name, login ID, password, and password expiration date. Choose Get Info if you are using a Mac. It is sometimes necessary for administrators to back up the MicroStrategy Web 9. reportViewMode. To stop MicroStrategy Intelligence Server Universal 9. From the DSN drop-down list, select the DSN used to connect to the metadata repository. Select Configure Intelligence Server, and click Next. The value provided for the entry described below would work as the service name. Open your remote desktop connection. This only works for a document or dossier instance. 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. Depending on the resources available and the version installed, please set the Maximum working set RAM to a number between the following list:. This will generate a new certificate and key pair and start the Intelligence Server. Windows: C:\Program Files (x86)\MicroStrategy\Intelligence Server\TLS. 0, the behavior has been changed and the Intelligence Server does not use Messaging Services by default. Method to. Then from there, you can create the . However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. x in Windows environment. 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. xml file and search for 'session. Select the database instance. The Upgrade Analysis Dossier is a pre-built dossier that analyzes and visualizes the output data from Integrity Manager Capacity Testing Tool results. In 2019 Update 1, it took one minute to load three projects. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. 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. Start the MicroStrategy Intelligence Server. Theoretically, capacity is a certain. Follow the below steps to change your environment's Library URL. You will be able to: - connect to MicroStrategy Server. The objective of this document is to provide an estimation of resource requirements for stable and performant operation of. 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. 7, the MicroStrategy Messaging Services services can also be registered with the operating system during installation. com) to the hosts file of the Library server machine to manually resolve the iserver name. Find MicroStrategy’s public API in Postman and make your own copy (Fork). /mstrctl -s IntelligenceServer ssic' from the bin folder to set a new configuration for the MicroStrategy Intelligence Server performance configuration. Enter the User Name and Password for the database. Once logged in, the user must navigate to. Number of Views 7. requestTimeout. Upload FilesOr drop files. This ensures changes are synchronized in a timely manner. 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 -h option is needed to change the owner on symbolic links as well. You can calculate the factory output rate for one product using the values from the machine-hour capacity formula. The amount of data that the customer chooses to keep could have a corresponding cost to the customer. g. 2. provider). token). Depending on the version installed (as a best practice no higher than the 25% of the available RAM in the server), the Maximum working set RAM values to are is on the following list:Before MicroStrategy 9. sp. Steps. What is the reason for the. MicroStrategy's flexible, scalable architecture allows organizations to deliver high performance and fast response times at scale. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using the MicroStrategy Service Manager. Once you have finished choosing your options, click Create Environment and wait for your environment to provision. Downloading and installing MicroStrategy. provider is set to 1 and save the file. Remember to replace all child object permissions. browser cache etc is all cleared even tried with re-installing library server. MicroStrategy Web must be connecting to the MicroStrategy Intelligence Server via the name configured in the certificate. Solution Deploy the 2020 MicroStrategyLibrary. yaml. 4. MicroStrategy for.