Important Notes: To ensure integrity of the intelligent cubes, make sure the metadata copies on the source and target environments are exactly same. Place intelligence server close to the both the data warehouse and the metadata repository. A Google account: This account will be used to deploy the Google instance that MicroStrategy will be deployed onto. Specifies the ID of the report to execute. You can implement iServer easily with it. Project. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Embedded is the power play — this is where the magic happens. You will be able to: - connect to MicroStrategy Server. 4001 - runReport Executes the report specified by either the reportID or reportName argument. Request a demo. Production capacity is the maximum possible output of a manufacturing business, measured in units of output per period. - pull data out of it. Windows: C:\Program Files (x86)\MicroStrategy\Intelligence Server\TLS. The client libraries are certified for use with the MicroStrategy Intelligence Server by operating system platform. To allow MicroStrategy Web users to access projects, you must create a connection between a MicroStrategy Intelligence Server and MicroStrategy Web. Click the icon in the Actions column and select Start, Stop, or Restart. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. 1m running on Microsoft IIS ServerOpen a new or existing dossier. Number of Views 5. MicroStrategy Web must be connecting to the MicroStrategy Intelligence Server via the name configured in the certificate. max_map_count be defined as 5,242,880 bytes. 7, the MicroStrategy Messaging Services services can also be registered with the operating system during installation. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. This setting limits the time, in seconds, that users can remain idle before their MicroStrategy Intelligence Server session is ended. Make sure all Intelligence Server nodes are running during the life-time of Library Server. mstr file is actually a . If no Intelligence Servers are listed or connected, add an Intelligence Server and connect it to MicroStrategy Web. MDMover allows everything to be moved with one click. 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. Under the Server tab, click Application Load Balancer. type: Puppeteer exporter. When you create a new user, you need to provide some or all of the following information: Login information. The Servers page opens. In the Login area, for LDAP Authentication, select. In the Open drop-down list, type cmd and click OK. When State displays Stopped the service is inactive. instancename is the name of a server instance, where required. This online guide covers the installation and configuration of various MicroStrategy components, such as Workstation, Library, REST Server, and Collaboration Server. Launch MicroStrategy Web from the Landing Page of your environment. 1 and above on Windows and Linux operating systems. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. The speed at which all programs and processes run depends on the CPU’s performance capacity. Restart MicroStrategy Web and Mobile Server. If the Startup type of the MicroStrategy Intelligence Server. CAUSE: This is working as designed. The Intelligent Cube Monitor is displayed. The user is the basic unit in the MicroStrategy security model. This chapter addresses the processes necessary to configure an installed MicroStrategy suite of products using the Configuration Wizard. x Statistics are enabled and a dashboard is executed the MicroStrategy Intelligence Server stats are incorrectly reported as a. 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. Enabling LDAP Authentication for MicroStrategy Web. In the email template, you can find the following details regarding your add-in: Platform. polling. The user. Memory mapped files (MMF) can be used for effective RAM utilization. Platform Analytics is the new monitoring tool in MicroStrategy 11. Give the non-administrator user control to C:/Program Files (x86)/MicroStrategy and C:/Program Files (x86)/Common Files/MicroStrategy folders. x-10. For detailed information refer to the System Administration Help. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 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. To backup all databases in MicroStrategy Repository, add the database names to DBAdminConfig. x using the MicroStrategy Configuration Wizard 9. "rlim_fd_cur" specifies the “soft” limit on file descriptors that a single process can have open. log and MicroStrategy License Manager is the version of the base build installed in that machine. xml file and search for 'session. In the MicroStrategy Library Configuration box, enter. Number of Views 5. When launching the MicroStrategy Service Manager, notice the Intelligence Server is already in a stopped status. . Stop Tomcat. Description The . They are part of the MicroStrategy REST Server, which is shipped inside the. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. Perform a single project test against one project. x or 10. 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. Here you can also check the connector URL. Retrieve Data from the Intelligence Server Using the JSON Data API. Seeing this issue after the upgrade to latest mstr software launched in Jan 2022. For this reason, outbound network traffic needs to be allowed on port 443 in order to transmit the data. The Security Filter Editor opens. Include the port, which is 9092 by default separated from the Fully Qualified Domain Name by a colon. In the Server drop-down list, select the name of the machine on which the service is installed. provider is set to 1 and save the file. Select the Security Filters tab. Required Status to Perform Action. The requests are granted or denied according to user-configured limits on the amount of. x, the limit is 2 TB (2097152 MB) On MicroStrategy 11. war file to upgrade MicroStrategy Library. Login information such as the user name, login ID, password, and password expiration date. KB441987. iserver_version The current I-Server version. Network configuration best practices. By default, it is C:Program Files. Once you have finished choosing your options, click Create Environment and wait for. x-10. Element search request timeout. A new file 'status-iserver. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. Disconnect. Specify a name and location for the new security filter and click Save. From the pane on the left, select Servers. 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. zip file, with the. In other words, this name needs to be recognizable as a network machine. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. g. Enterprise environments can have up to 4 clustered nodes. /mstrcfgwiz. The formula is: Production Capacity = Machine-Hour Capacity (MHC) / Hours to Produce One Product. Change the "<Servername>" to the desired MicroStrategy Intelligence Server and save the changes. Choose Security > Internet and/or Intranet. How to increase the Java Heap size in Tomcat Application Server;. xxin omcat9w. Intelligence Server ensures the scalability and fault tolerance required for sophisticated analysis of terabyte databases and deployments to millions of users. Afterwards you will see Kafka log files created in the Kafka. Under Collections, click on the the “…” next to. This technique is useful till 80%. For example, sample cube. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. - modify the data a little bit. When creating the trust relationship through MIcroStrategy Office, the token for WS1 will be written into the common metadata for both Intelligence Server nodes. MicroStrategy Web, statistics can be used to troubleshoot issues with hanging or slow performance of certain MicroStrategy objects, such as reports or prompts. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). optional): If True, utilize optimal number of threads to increase the download speed. In the Navigation pane, click Environments. By default, the mstr database. Iserver is on windows server, web server is apache tomcat. 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. To be able to connect to the Directory Server however, MicroStrategy Intelligence Server 9. Depending on the resources available and the version installed, please set the Maximum working set RAM to a number between the following list:. In-store and online. Choose Add Data > New Data. For this reason, outbound network traffic needs to be allowed on port 443 in order to transmit the data. What's New in MicroStrategy 2020. Windows: On your desktop, from the Start menu, select Programs (or All Programs ), then MicroStrategy Tools, then Web Administrator. If the administrator would like to get the status of MicroStrategy Intelligence Server Universal 9. In practice, you get a cert for the server. Specify subset of cube to be Crash data is automatically uploaded to microstrategy. Performance is a combination of speed and scale. 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. Users may find additional information related to managing and using Intelligent Cubes in. • Enterprise Manager. Once MicroStrategy Web is connected to a cluster, all nodes reference the same project. Creating a User. 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. Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. Then this file is used for Web, Library to communicated with IServer right? Then the file microstrategy. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. We tried all your suggestion but we still had the problem. x and 10. The suggested number here is 65534, however, you can change the value as long as it is large. During a course which involved microstrategy platform i've been told that: "For MSTR 10. The MicroStrategy Intelligence Server Universal on Linux operating systems can only be registered as a service by a user running with a root or privileged account. In the Service drop-down list, select the service. x level and not on the cluster level. 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. Tables v9. 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. 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. This is because registering MicroStrategy Intelligence Server Universal 9. Seeing this issue after the upgrade to latest mstr software launched in Jan 2022. Port number of the server. It processes data and delegates commands. Deploying a GCP instance. This is because registering MicroStrategy Intelligence Server Universal 9. iserver. The following is a standalone Java example to check the different preferences level for a given user's session. Maintain your competitive edge with a data-driven retail app designed to scale—from individual locations to global franchises. MicroStrategy Intelligence Server also provides a library of over 150. Efficiently manages thousands of end-user requests (jobs. You can search, view, and edit all project-level settings. If your password was changed from the default of mstr123 update the parameter in your WEB-INF/microstrategy. Follow the below steps to change your environment's Library URL. 0. Stop MicroStrategy Intelligence Server in all cluster nodes. 1 (2019) rather than 11. ACTION:MicroStrategy recommends that the Linux kernel setting vm. xml and open it with notepad, as shown below: Locate the project source name that should be changed. Right-click an Intelligent Cube and select Delete. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. If some Intelligence Server nodes are/were down, you can start them first and then restart Library Server. 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. Windows: C:Program Files (x86)MicroStrategyIntelligence ServerTLS. Editing cluster membership is an administrative action and should be performed exclusively. The path to the Web server application is entered in the Web Server Application field. Diagnostic logs will be sent to the Messaging Services Server after you perform the following: Enable MicroStrategy Messaging Services. KB201630: How to change the Row Limit of a report that uses an Intelligent Cube. x or 10. The Web server will create a new TCP connection if it determines that only two connections are idle. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. 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. Run Command Prompt as an administrator and enter the following command: netsh add urlacl url=or port/api user=domain\username. The DNS needs to recognize the entry as a machine and be able to resolve its. in my company we are using Microstrategy 10. Go to Internet Explorer > Internet Options. After installation, user may need to check those folder path to locate specific files. Click Next. How to increase the Java Heap size in Tomcat Application Server;Even without coding skills. Users should therefore run the "Monitor. 3. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. Failover is a key feature in a. 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. Net_SessionId cookie is set by the JSP application server / IIS to track the user over the course of the its session and is required. Enter the User Name and Password for the database. From the Folder List, expand Administration, then expand System Monitors, then expand Caches, and select Intelligent Cubes. The default value is 256 megabytes. Typical scripts that are modified by users would be. Easily add or change pre- and post- SQL statements. xA user has set up MicroStrategy Web 9. csv file to keep a record of their settings, or import a previously save file to apply the setting to a project. Excel API. In the Login area, for LDAP Authentication, select the Enabled check box. How to Perform Capacity. 11. x. Afterwards you will see Kafka log files created in the Kafka. Server Activation registers each Server Installation with MicroStrategy and locks the installation to a specific machine. From MicroStrategy Platform home page, scroll down to the Essentials Connections section. 67. GetProjectSources. xml'. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. List Nodes GET /monitors/iServer/nodes Get information about nodes in the connected Intelligence Server cluster, including: Basic information Runtime state Information for the. The project default level preferences are accessed by the Web server at connection time. Step 3. renderer. The MicroStrategy Intelligence Server was unable to swap out the report instances of 40MB in the Working Set. microstrategy. In addition, this release introduces new features across the analytics, mobility, and security platform - making it easier for users to build applications. It takes you from setting up and configuring MicroStrategy to security and administration. On Linux, all log files are stored in /opt/mstr/MicroStrategy/log. 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 default one is Interactive. The license check takes place anytime within the next half hour of the time specified in the setting. If the Startup type of the MicroStrategy Intelligence Server on 'M1' is set to 'Automatic', the available projects appear automatically. Copy the new certificate to MicroStrategyLibrary's WEB-INF folder (in the same location from step 2). The Intelligent Cube Monitor is displayed. token). 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. xml', for example 'status-iserver. The amount of data that the customer chooses to keep could have a corresponding cost to the customer. x on Linux machines. 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. There are three options that are available: 1. For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (MicroStrategy projects on each Intelligence Server can be configured to log usage statistics to the staging tables. 4. The dossier includes an impact analysis where you can identify all the objects that are affected by changes in the engine behavior, manifested as differences in SQL, data or significant changes. Windows from the command line, then perform the following steps: From the Windows Start menu, select Run. Enter the Intelligence Server address (IP or FQDN): Enter the port that the Intelligence Server service is running on. HKEY_LOCAL_MACHINESoftwareMicrostrategyMicrostrategy Broadcast Server7. instancename is the name of a server instance, where required. 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. Once connected to a node, the Web user runs all MicroStrategy activity on the same node. x > Configure Tomcat. It is shared by all processes running on the machine, including the operating system. Restart the MicroStrategy Intelligence Server to. Administrators can export the server settings in this tab to a . 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. 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. of setting up the environment for the MicroStrategy products installed. If a customer opts to increase the data repository and/or cube memory requirements, they will either necessitate a change order or will be Hi @Rui Chang(PPC) (Microstrategy, Inc. Server-level settings At the server level, only a few settings from each category need a server restart. Select Configure Intelligence Server, and click Next. Right-click on User Defined and select New. You can find this ID by running the “ps” command. On MicroStrategy Intelligence Server 9. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. Here at MicroStrategy, we want to ensure that our users have the information they need to get their platform up and running. Editing cluster membership is an administrative action and should be performed exclusively. If False (default), this feature will be disabled. filename is the name of the file to read from or write to. The book starts by detailing the different. A cloud-native, open architecture platform, it is built on a scalable, future-fit semantic layer designed to inject AI-powered Intelligence Everywhere™. It takes you from setting up and configuring MicroStrategy to security and administration. Click the icon next to a listed service. /mstrcmdmgr -interactive and press ENTER to open Command Manager. Upgrading Flash-Based Content 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 Universal user sessions across MicroStrategy Intelligence Servers, so that no single machine is overwhelmed. Increase the Maximum RAM Usage (MBytes) governing setting for caches for the project to something greater than the size of the report that was sent to the History List. trusted. Iserver is on windows server, web server is apache tomcat. To increase the number of server nodes, click the 'Number of Server Instances' dropdown. 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. . Ensure auth. 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. MicroStrategy Intelligence Server is an analytical server optimized for enterprise querying, reporting, and OLAP analysis. Tips and troubleshooting. LDAP Integration with the MicroStrategy Intelligence Server: To integrate users and groups stored on an LDAP server within the MicroStrategy Intelligence Server 9. 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. MicroStrategy Web or Web Universal users log in to a project and request reports from their Web browsers. In MicroStrategy cluster logic, Intelligence Server uses machine name to. Significantly improves user-perceived query performance. KB6446: How to increase the heap size of the Java Virtual Machine to handle large result data objects with MicroStrategy Web 9. 4. 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. This option must be selected for any statistics to be logged. KB439852: In MicroStrategy 10. There is one setting in the MicroStrategy Intelligence configuration, available in Developer and another one in the application server. It is noticed that the Intelligence server hosted machine can't ping each other by machine name. Navigate to Configure MicroStrategy Intelligence Server > Web Single Sign-on. 1. In this article, the MicroStrategy team will review: Prerequisites. The MicroStrategy Intelligence Server first searches for the user on the LDAP server using the login name provided. It is sometimes necessary for administrators to back up the MicroStrategy Web 9. KB20300: After removing the Tahoma font in MicroStrategy Web 10. If a name is not specified,. microstrategy. Cube Extract a MicroStrategy cube into a R Data. Knowing your production capacity gives you the chance to improve production planning and production scheduling, give more accurate lead times, and forecast your cash flow. DisconnectProjects. The default value is 10. Intelligence Server ensures the. You can build real-time or near-real-time MicroStrategy applications based on it. 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. Watch on. Click Connect. From the Windows Start menu go to All Programs > MicroStrategy Tools > Web Administrator. Server. Launch MicroStrategy Developer. MicroStrategy provides In-memory BI capabilities that leverage 64-bit operating systems to improve the overall performance of a BI system. Click Dependencies tab, the above 3 dependencies are listed. x server machine. Alternatively, please run: c:Program Files (x86)Common FilesMicroStrategyTomcatapache-tomcat-9. The "status-iserver. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. If a name is not specified, the command uses the default instance name. Determines how distinct counts of values are retrieved from partitioned tables. The size of the connection pool: ConfigDefaults. xml" file but changing the value between the <state> and </state> tags to read "Stopped" 2. User session and project session analysis. 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. How to increase the Java Heap size in Tomcat. …Go to Administration > Projects > Project Configuration. Cube index generation will increase cube size. This section describes only the most basic guidelines. x to be restarted in order for the changes to take effect. xml file: <memory> <logging_time>DATE_AND_TIME</logging_time> A connection pool is a collection of TCP connections maintained in the Web server's memory. From the DSN drop-down list, select the DSN used to connect to the metadata repository. max: 1/4 of the number of CPU cores. This will prompt to stop the MicroStrategy Intelligence Server process in order to create the new Server Definition. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. sp. Learn how to use an external REST client to run MSTR related REST requests. , "dirty" status). Select “MicroStrategy SDK”. 1. Frame Description Access, filter, publish, and extract data from MicroStrategy in-memory cubes. (Note: On MicroStrategy Intelligence Server machine, go to Administrative Tools -> Services, open the Microsoft Services window and locate the MicroStrategy Intelligence Server service. x, the Web Pool Size setting does perform any action or hold to it’s defined value. KB440719. 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. Crash data is automatically uploaded to microstrategy. Note: Make these modifications and re-publish the cube to find out which combination gives better performance. This only works for a document or dossier instance. Intelligence (I-Server) Homepage MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. 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. MicroStrategy Intelligence Server provides out-of-the-box clustering capabilities. It is possible to re-write the URLs to be more. You can connect to this server by clicking Connect. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. 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. In general, there are two situations in which license key updates are required: Additional named user licenses have been purchased or need to be removed. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend >and integrate the MicroStrategy business intelligence functionality into other applications. Select Configure Intelligence Server, and click Next. Seeing this issue after the upgrade to latest mstr software launched in Jan 2022. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using the MicroStrategy Service Manager. Prerequisites for Windows Clustering. 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. x in Windows environment. Open the MicroStrategy Configuration Wizard. This section describes the errors you may encounter when using the Modeling service and how to troubleshoot them. The Java Virtual Machine has a heap that is shared among all Java Virtual Machine threads. Analyzes system performance over time using your choice of metrics. x and newer, the following information is needed: LDAP version 3 compatible Directory Server that supports Clear text or LDAPS (LDAP over SSL) communications. 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. trusted. x to version 10. 1. We need to use the same REST port number when binding to the SSL certificate. To do it, hover over the icon and click Edit Connector. Do not change the files under the conf folder. KB13943: How to change the log destination for the DSSErrors. 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.