In the Add a server manually field, specify the DNS name of the Intelligence Server machine. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. Login to Postman and search for MicroStrategy in the homepage search bar. 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. GetProjectSources. SYMPTOM. ACTION: Open IIS on the MicroStrategy Web, Mobile, or Web Services 9. On the MicroStrategy Web Server, go to Program Files > MicroStrategy > Web Services > projectsources. Click the icon in the Actions column and select Start, Stop, or Restart. e. command is one of the commands from the list below. With these statistic logs, administrators can observe the amount of time spent on each step of the process for a certain task in MicroStrategy Web. Locate the web. In other words, this name needs to be recognizable as a network machine. Setting this to a higher number may improve performance under high job concurrency, but it increases the amount of time caches that exist in memory only (i. To run a clustered configuration, the user must be a domain account that has a trust relationship with each of the computers in the cluster. On MicroStrategy Intelligence Server 9. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. yaml. jks at this time via the sslClientKeystore parameter in the microstrategy. '. MicroStrategy Web submits a get folder ID command to Intelligence Server to verify if Intelligence Server is still alive. renderer. 0. The MicroStrategy Configuration Wizard walks you through the process. xml > <propertyname="timeout">. x and 10. Clear the Enable anonymous access check box. ProjectSource. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. KB6446: How to increase the heap size of the Java Virtual Machine to handle large result data objects with MicroStrategy Web 9. Disconnect. With the Parameterized Query option enabled, reports containing text filters and prompts will be executed using parameter markers (?) during SQL execution. Once you have finished choosing your options, click Create Environment and wait for. In MicroStrategy Developer, log in to a project source with administrative privileges. From the DSN drop-down list, select the DSN used to connect to the metadata repository. Hover over a connected Intelligence server and click the Server Administration icon in the Properties column. Windows: C:\Program Files (x86)\MicroStrategy\Intelligence Server\TLS. 4. 2. process. Administrators can export the project settings in this tab to a . provider). Search for the files changed (below) in the target machine and create a backup of these files in all cluster nodes. 0, the behavior has been changed and the Intelligence Server does not use Messaging Services by default. process. disk availability is below the 80% capacity threshold. Action. There are two cases of this: The Intelligence server has never entered MCM denial state and this is the first time doing so. Open MicroStrategy for Office in Excel for the web or the Excel desktop application. Dynamic Sourcing can be enabled by going to Project Configuration ->Intelligent Cubes ->General ->Enable Dynamic Sourcing. The third-party product(s) discussed in this technical note are manufactured by vendors independent of MicroStrategy. Place intelligence server close to the both the data warehouse and the metadata repository. The size of the connection pool: ConfigDefaults. So MicroStrategy Intelligence Server has to be re-started for this setting change to take effect. 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. max: 1/4 of the number of CPU cores. disk availability is below the 80% capacity threshold. Step 3. The crash collection server analyzes the incoming crashes and notifies MicroStrategy technical support and production teams for the incidents. Copy the new certificate to MicroStrategyLibrary's WEB-INF folder (in the same location from step 2). How to increase the Java Heap size in Tomcat Application Server;. log will depend on the Log Path specified during installation. The default Load balance factor value is 1. /mstrweb restart” command. The user is the basic unit in the MicroStrategy security model. On MicroStrategy 10. 52K. Request timeout to check if the Intelligence Server is alive. The governing setting 'Maximum Report Execution Time' can be defined at the Project Configuration level in MicroStrategy, as shown below: Although there is no direct equivalent to this setting at the report level, there is an alternative that should suit many scenarios. What is the reason for the. 1. If present, the report is fetched from memory and the reportID argument is ignored. Production capacity is the maximum possible output of a manufacturing business, measured in units of output per period. Memory mapped files (MMF) can be used for effective RAM utilization. g. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. If nodes are manually removed from the cluster, projects are. The Servers page opens. All necessary privileges are included in the Administrator role by default. When the job monitor depicts the status as 'executing,' the executing status can apply to the execution of the job within any Processing Unit (PU). Tables v10. To improve the data fetching performance for JDBC connections, Administrators can also increase the JNI Bridge Heap Space. If the Startup type of the MicroStrategy Intelligence Server. 26K. For prior releases, either a cube was loaded, residing completely in RAM, or unloaded. Run the file mstr-repo-ondemand-dba-operations. List Nodes GET /monitors/iServer/nodes Get information about nodes in the connected Intelligence Server cluster, including: Basic information Runtime state Information for the. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. Choose the individual modules to be logged. It's being used even in the biggest financial, telecom and manufacturing. All files under the conf folder are overwritten when you upgrade MicroStrategy. KB439951: How to set the maximum Java Heap Size value for JDBC source connectivity in MicroStrategy Developer and Web 10. Introduction Integrated Authentication to the MicroStrategy Intelligence Server utilizes the Kerberos authentication protocol to provide a Single Sign-On capability for MicroStrategy users connecting from Web or Developer from a Microsoft Active Directory environment. labs. Within this directory, the user will need to execute the “. If a name is not specified, the command uses the default instance name. 7, the MicroStrategy Messaging Services services can also be registered with the operating system during installation. x. The Service Options dialog box opens. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. Click the MicroStrategy connector. Specifies the ID of the report to execute. When State displays Running the service is ready. x to be restarted in order for the changes to take effect. Access, filter, publish, and extract data from MicroStrategy in-memory cubes Create a Cube object to load basic information on a cube dataset. 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. Together, they are often referred to as the JSON Data API. The memory used by Intelligence Server is limited by the machine's virtual memory. renderer. Enter the User Name and Password for the database. mstr file is actually a . Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. Right-click an Intelligent Cube and select Delete. The -h option is needed to change the owner on symbolic links as well. 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. Start Apache Tomcat. Restart the MicroStrategy Intelligence Server to. Our analytics and mobility platform transforms data into actionable insights that help people make better business decisions. 3. Learn how to use an external REST client to run MSTR related REST requests. x-10. x: Statistics logging option. Enable the statistics logging for the project. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. xA user has set up MicroStrategy Web 9. Follow the below steps to change your environment's Library URL. After watching this 3 minutes video you will be able to test mstrio library (based on REST API) yourself. Stop MicroStrategy Intelligence Server in all cluster nodes. On Windows, all log files are stored in C:Program Files (x86)Common FilesMicroStrategyLog. Follow the below steps to change your environment's Library URL. Give the non-administrator user control to C:/Program Files (x86)/MicroStrategy and C:/Program Files (x86)/Common Files/MicroStrategy folders. polling. All basic statistics. Click Create Trust Relationship. This is also tuning for issues revolving around errors with Garbage Collection overhead limits and in some cases HTTP 500 errors. The DUMMY_SERVER instance for example, helps for the configuration of the Intelligence. A list of Web Preferences can be found in the MicroStrategy Enumeration EnumWebPreferences in the MicroStrategy Developers Library Java API Reference. This action starts MicroStrategy Intelligence Server on 'M1. mstrexec-iserver: WARNING: maximum number of open files 256 is low; please increase to 1000 or greater. 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. Configure Metadata Connection. iserver. Description The . From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. Database specific settings By default MicroStrategy will still send Intelligence Server diagnostic logs to local disk. Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. Because the ID of the event associated with the "RW Fast Export PDF" page is "3069", the evt parameter in the URL is set to "3069". This can be done using the following command: chown -hR <new user account>:<user group> <Install folder>. They are part of the MicroStrategy REST Server, which is shipped inside the. x using the MicroStrategy Configuration Wizard 9. Here you can also check the connector URL. Failover is a key feature in a. Afterwards you will see Kafka log files created in the Kafka. 4 GB or. browser cache etc is all cleared even tried with re-installing library server. You can use. Click on Yes. The MicroStrategy Intelligence Server 9. KB235107: How to Embed a Custom Font Without Having to Install it on the Client Machines using MicroStrategy Web SDK 9. However, after publishing,. x - 10. Cube Extract a MicroStrategy cube into a R Data. bat. This section discusses how to analyze your users' requirements, and the ways you can configure and tune your system to meet. We have focused on the features that have been developed specifically to support and enhance the SQL Server integration. 1 and above KB10384: How to increase the Java Heap size in Tomcat Application Server Beginning in MicroStrategy 10. Start the MicroStrategy Intelligence Server. KB440719. There will most likely be a direct correlation between user load and resource consumption. The important functions of MicroStrategy Intelligence Server are: Managing the sharing of data and objects in a controlled and secure environment. xml" must either be edited, renamed, or deleted. It turns data into reports for making and executing key organization decisions. Connect. 4. 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. Connect to the Developer Instance. 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. Expand the Database Instances category, and then select Connection Mapping. After calculating the production capacity of each product, you can calculate the factory output rate for multiple products. Number of Views 7. command is one of the commands from the list below. Enter the User Name and Password for the database. Choose Security > Internet and/or Intranet. Then from there, you can create the . Select the "exportMaxCellsPlainText" setting and modify the "Maximum" value under "Other. Speed is important because it affects the user experience. x and 11. There are three options that are available: 1. The Intelligence Server selection page opens. Click Options. Dedicate a machine for the metadata repository. microstrategy. Browse to the filter you want to convert and click Open. A new file 'status-iserver. Step 2. 73K KB441259: Location of the Project Source Name's Intelligence. 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. This example checks the preference WebPreferenceDpiConversion. The below steps can be used to deploy the MicroStrategyLibrary. First, the user must log in as the “mstr” user. . The default value is 256 megabytes. In the MicroStrategy Library Configuration box, enter. SYMPTOM: The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. This will generate a new certificate and key pair and start the Intelligence Server. You can use the MicroStrategy Configuration Wizard to upgrade your statistics repository. 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-10. Once you have finished choosing your options, click Create Environment and wait for your environment to provision. Grid (1) or Graph (2) Mode. There's a reason we're at the top of the list. 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. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. This only works for a document or dossier instance. Retail is leveling up with omnichannel analytics. Note: Make these modifications and re-publish the cube to find out which combination gives better performance. This setting must be greater than x x 2. To stop MicroStrategy Intelligence Server Universal 9. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. When the job monitor depicts the status as 'executing,' the executing status can apply to the execution of the job within any Processing Unit (PU). System Performance Trends. This feature. Login information such as the user name, login ID, password, and password expiration date. For New Export Engine in MicroStrategy 2019, when the number of concurrent user increases, the throughput (pages per minute) would remain almost unchanged. For this point admins need to try the three options and see which one has better performance. The Server Properties page opens and displays the following information about the Intelligence Server: Name and connection status. KB7295: What is the Memory Contract Manager in MicroStrategy Intelligence Server? PART 1. xml file. '. xA user has set up MicroStrategy Web 9. Afterwards you will see Kafka log files created in the Kafka. You can see this in the diagram in Testing an Environment for the First Time, or by looking at the Intelligence Servers on your MicroStrategy Web Administrator page. MOIOffice. x, text in documents still default to that font. In MicroStrategy 11. Determines how distinct counts of values are retrieved from partitioned tables. browser cache etc is all cleared even tried with re-installing library server. Speed is typically measured as user wait time or response time. 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. …The version displayed in the DSSErrors. 6. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. 2. If a customer opts to increase the data repository and/or cube memory requirements, they will either necessitate a change order or will beIntroduction. With the 10. The maximum value is 99 and the minimum value is 1. 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. 0. Right-click a project and choose Properties. Specify a name and location for the new security filter and click Save. 2 environment to 11. Steps. 1. max_map_count be defined as 5,242,880 bytes. To allow MicroStrategy Web users to access projects, you must create a connection between a MicroStrategy Intelligence Server and MicroStrategy Web. Efficiently manages thousands of end-user requests (jobs. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. What is load balancing? Load balancing, as it applies to MicroStrategy Intelligence Server, is a strategy aimed at achieving even distribution of MicroStrategy Web or Web. Access the MicroStrategy Web Administrator page. By default, the cluster will be re-joined automatically as long as the cluster node was not shut down normally (e. Editing cluster membership is an administrative action and should be performed exclusively. KB201630: How to change the Row Limit of a report that uses an Intelligent Cube. 4 GB or higher. To access the Intelligence Server Configuration Editor in Developer, right-click the Intelligence Server and select Configure MicroStrategy Intelligence Server. x and 10. war file on a default MicroStrategy Windows installation. 4. Efficiently manages thousands of end-user requests (jobs. exe. xml and open it with notepad, as shown below: Locate the project source name that should be changed. x on Linux machines:. 4. . For an example of how to do this, see the sample code below. io through protocol. Select Configure Intelligence Server, and click Next. Note: The utility is not available on MicroStrategy 9. Browse to and right-click the MicroStrategy virtual folder and select Properties. Optionally, you can change the location or name of the Keystore file clientKey. 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. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Users should therefore run the "Monitor. Step 3. The MicroStrategy Listener will also check to see that MicroStrategy Intelligence Server is. For more information about Enterprise Manager, see the Enterprise Manager Guide. Iserver is on windows server, web server is apache tomcat. trusted. You can implement iServer easily with it. 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). Request a demo. g. g. Review the file to ensure all entries match the ones seen in the following screenshot (namely iserver. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. Under Collections, click on the the “…” next to. Do not change the files under the conf folder. 10, 10. 0. Speed is typically measured as user wait time or. It is shared by all processes running on the machine, including the operating system. Choose the individual modules to be logged. Setting this to a higher limit does not mean the memory will be set. 1. You can search, view, and edit server-level settings. The Intelligent Cube Monitor is displayed. The following are the methods that support connecting to and disconnecting from a MicroStrategy Intelligence Server: MOIOffice. x Statistics are enabled and a dashboard is executed the MicroStrategy Intelligence Server stats are incorrectly. Choose Get Info if you are using a Mac. DisconnectProjects. The value provided for the entry described below would work as the service name. If you are configuring MicroStrategy on: Windows, go to Start > Programs > MicroStrategy Tools > Configuration Wizard. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. sp. There is one setting in the MicroStrategy Intelligence configuration, available in Developer and another one in the application server. How to Start and Stop Intelligence Server Services in Microstrategy By Mohan Vamsi PentakotaHow to Access the Web Administrator Page. 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. Select one of the following to determine when and how MicroStrategy Web. 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). trusted. The Intelligence Server selection page opens. Helps you to manipulate the database in a single package. trusted. In the top right corner, click MSTR User and then click Preferences to access Web Preferences. We have to start the install program again Pick Modify Get to the Select Components part Check “MicroStrategy Analytics Modules” and install those components After it is installed, Start the Configuration Wizard (in MicroStrategy Tools) Select “Configure Intelligence Server” Chose “Analytics_Metadata” for the DSN Default for. How to increase the Java Heap size in Tomcat. It collects real-time data (also known as telemetry) which is generated by different components of the MicroStrategy platform like the Intelligence Server. ) One (or more) of the above fail to start. x. In MicroStrategy 2020, four additional lines will appear in the status-iserver. Performance degradation occurs because the MicroStrategyWhen a cluster of MicroStrategy Intelligence Servers connects to MicroStrategy Web, the following behavior can be observed in the MicroStrategy Web Administrator page: All MicroStrategy Intelligence Servers in the cluster will be added as a single unit, as shown with the example above. There are a few steps that must be completed in order to restart the MicroStrategy Web Server on a Linux machine. MicroStrategy Web: Web Server. x, text in documents still default to that font. Users notice multiple instances of the "mstrexec-iserver" processes in Microstrategy Intelligence Server 9. Select Intelligence Server > Default Properties. Start Apache Tomcat. Published: May 2, 2018; Last updated: Jul 17, 2023; Related versions: 10. Select data population for Intelligent Cubes. 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 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. (Note: On MicroStrategy Intelligence Server machine, go to Administrative Tools -> Services, open the Microsoft Services window and locate the MicroStrategy Intelligence Server service. This setting limits the number of concurrent jobs a user may have during a given session or connection. xml'. Number of Views 79. Find MicroStrategy’s public API in Postman and make your own copy (Fork). CAUSE: In Solaris, every process is subjected to a System Kernel Parameter that defines the maximum number of files that it can have open. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. 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. filename is the name of the file to read from or write to. MicroStrategy Web: Web Server. 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. Each segment executing in the MicroStrategy Narrowcast Server establishes one session or connection to the MicroStrategy Intelligence Server. Once the server is stopped, you can then start it up again by using the. This Knowledge Base article addresses an identified defect where the Web Pool Size setting doesn’t do anything in MicroStrategy 10. 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. Perform a single project test against one project. You can implement iServer easily with it. HKEY_LOCAL_MACHINE\Software\Microstrategy\Microstrategy Broadcast Server\7. 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. 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. The license check takes place anytime within the next half hour of the time specified in the setting. x-10. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using the MicroStrategy Service Manager. Remember to replace all child object permissions. From the DSN drop-down list, select the DSN used to connect to the metadata repository. 2. instancename is the name of a server instance, where required. If some Intelligence Server nodes are/were down, you can start them first and then restart Library Server. jks. Use Response file. This option must be selected for any statistics to be logged. In a UNIX console window, browse to the "bin" folder under <HOME_PATH> where the MicroStrategy is installed. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. . /mstrcmdmgr -interactive and press ENTER to open Command Manager. After changing the ACU settings for the cluster.