Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Afterwards you will see Kafka log files created in the Kafka. It gives you the leverage of generating real-time reports and monitoring data. The requests are granted or denied according to user-configured limits on the amount of. This will generate a new certificate and key pair and start the Intelligence Server. Why is this happening?When users try to start or stop MicroStrategy Intelligence Server from MicroStrategy Service Manager, nothing happens. Select Configure Intelligence Server, and click Next. KB13943: How to change the log destination for the DSSErrors. This only works for a document or dossier instance. disk availability is below the 80% capacity threshold. 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. Rename the file 'status-iserver. This issue has been addressed in MicroStrategy 2019 Update 2 and above. 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. The following procedure describes how to ensure the web server, mobile server and intelligence server use images from the same folder in MicroStrategy 9. Select Configure Intelligence Server, and click Next. x to effectively register the change. KB7295: What is the Memory Contract Manager in MicroStrategy Intelligence Server? PART 1. Select data population for Intelligent Cubes. Here you can also check the connector URL. For example, high priority Jobs can run on both medium and low priority connections as well as the default high priority connections. xml" file but changing the value between the <state> and </state> tags to read "Stopped" 2. Edit the web. 9 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… The MicroStrategy Listener will monitor the Windows NT Application Event Log for new log entries and uses the log entry of Category 12 from the 'MSTRServer' Source as an indication that MicroStrategy Intelligence Server has been started. 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. x/9. 4. The maximum value is 99 and the minimum value is 1. It turns data into reports for making and executing key organization decisions. MicroStrategy Intelligence Server is an analytical server optimized for enterprise querying, reporting, and OLAP analysis. 8. Production capacity is the maximum possible output of a manufacturing business, measured in units of output per period. The PostgreSQL ODBC Driver has the best cube publish performance as it has the highest throughput. For steps to use the Configuration Wizard to upgrade your statistics repository and other MicroStrategy components, see the Upgrade Guide. below. xml" file contains the state information of the Intelligence Server. 10. Administrators can export the project settings in this tab to a . command is one of the commands from the list below. It also explains the setting in the Web Admin page Allow automatic login if session is lost. mstr file is a zipped file of object definition package and cube files. Enter the User Name and Password for the database. 5. 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. Expand the Data Collector Sets node. The Intelligence server has entered MCM denial state, but recovers and then works as expected. MicroStrategy ONE empowers companies worldwide to. x and 10. requestTimeout. How to increase the JVM Heap size for Microsoft Internet information services to allow for better performance. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. Preparation before taking Platform Analytics Repository dump: a. There are two types of TCP connections: busy and idle. Give the non-administrator user control to C:/Program Files (x86)/MicroStrategy and C:/Program Files (x86)/Common Files/MicroStrategy folders. A list of Web Preferences can be found in the MicroStrategy Enumeration EnumWebPreferences in the MicroStrategy Developers Library Java API Reference. properties: iserver. Right-click in the grid and select New to create a new connection mapping. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. If the administrator would like to get the status of MicroStrategy Intelligence Server Universal 9. The objective of this document is to provide an estimation of resource requirements for stable and performant operation of. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using. 0\Distributed Logging Service\DistributedLogger. KB6446: How to increase the heap size of the Java Virtual Machine to handle large result data objects with MicroStrategy Web 9. reportViewMode. bat. g. x*. Open your remote desktop connection. Locate the web. This ensures changes are synchronized in a timely manner. WORKAROUND: Disable the Cube Health Check Feature on the effected environment by adding the following key: [HKEY_LOCAL_MACHINESOFTWAREMicroStrategyDSS ServerCastor]. When a machine runs out of virtual memory, processes on the machine are no longer able. xml file. x and newer. A database instance specifies connection information, such as the data source name, Login ID and password, and other data source specific information. DisconnectProjects. Enter this value in the Server busy timeout field. polling. To improve the data fetching performance for JDBC connections, Administrators can also increase the JNI Bridge Heap Space. Governance of CPU clock speed when installing MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Narrowcast Server. x in Windows environment. x to version 10. Windows from the command line, then perform the following steps: From the Windows Start menu, select Run. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. Iserver is on windows server, web server is apache tomcat. Server Activation registers each Server Installation with MicroStrategy and locks the installation to a specific machine. , an abnormal shutdown due to errors or the process is killed). 10 xxxxxxxxxx. Enter the User Name and Password for the database. Here at MicroStrategy, we want to ensure that our users have the information they need to get their platform up and running. A breakdown of memory usage is logged when: The Intelligence server enters MCM denial state for the first time. When the MicroStrategy Web 9. From the DSN drop-down list, select the DSN used to connect to the metadata repository. All necessary privileges are included in the Administrator role by default. 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. 5, the maximum limit is 64GB (65536. Click Next. In IIS, once Anonymous Access is configured, any web user will take an IUSR_machine_name account first as designed in IIS, so it will work for Standard Authentication users. Note, for more information refer to tech note KB10211 . Open the Workstation window. If present, the report is fetched from memory and the reportID argument is ignored. provider is set to 1 and save the file. The default value is 256 megabytes. Double-click the new connection mapping in each column to select the database instance, database connection, database login, and language. Run Command Prompt as an administrator and enter the following command: netsh add urlacl url=or port/api user=domainusername. If a name is not specified, the command uses the default instance name. The CPU (Central Processing Unit) is the brain of a computer and performs many of its main tasks. x. x. Database specific settings By default MicroStrategy will still send Intelligence Server diagnostic logs to local disk. x, the limit is 2 TB (2097152 MB) On MicroStrategy 11. You should periodically reevaluate the system and update it based on actual system performance and use. pd_dump and pg_restore utility can be found in folder C:\Program Files (x86)\Common Files\MicroStrategy\Repository\pgsql\bin STEPS: 1. log recorded by the MicroStrategy Intelligence Server on Linu… Number of Views 3. Together, they are often referred to as the JSON Data API. Select the component to be configured from the list. xml file. 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. 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. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. Type in the URL box the MicroStrategy Mobile Admin page URL with the fully qualified domain name (FQDN),. The "status-iserver. This video walks through the process of directly importing data from a Salesforce report into MicroStrategy Desktop 10. Project. In the MicroStrategy Library Configuration box, enter. This issue only happens on Windows. From the DSN drop-down list, select the DSN used to connect to the metadata repository. exe application from the extracted zip file. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). Currently this issue is being reviewed by MicroStrategy for a potential code fix on an upcoming MicroStrategy release. 3s. During a course which involved microstrategy platform i've been told that: "For MSTR 10. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. Note, for more information refer to tech note KB10211. MicroStrategy for. 2 environment to 11. 9Performance is a combination of speed and scale. labs. ACTION: This tech note explains: File Relationships. renderer. Clear the Enable anonymous access check box. They are part of the MicroStrategy REST Server, which is shipped inside the. 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. It processes data and delegates commands. KB201630: How to change the Row Limit of a report that uses an Intelligent Cube. Once you have finished choosing your options, click Create Environment and wait for. Select Automatic as the Startup Type option. Once the best combination is determined, admins can test the deletion and see if the performance improves there. 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). command is one of the commands from the list below. System Performance Trends. KB7295: What is the Memory Contract Manager in MicroStrategy Intelligence Server? PART 1. Retrieve Data from the Intelligence Server Using the JSON Data API. The MicroStrategy Listener will monitor the Windows NT Application Event Log for new log entries and uses the log entry of Category 12 from the 'MSTRServer' Source as an indication that MicroStrategy Intelligence Server has been started. User session and project session analysis. Right-click an Intelligent Cube and select Delete. 1 and aboveNote: Starting in MicroStrategy 11. Excel version. Increase the size of Maximum RAM for Working Set cache to a higher value. In MicroStrategy cluster logic, Intelligence Server uses machine name to. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. 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. Once logged in, the user must navigate to the /etc/init. 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. HKEY_LOCAL_MACHINESoftwareMicrostrategyMicrostrategy Broadcast Server7. From the DSN drop-down list, select the DSN used to connect to the metadata repository. Select one of the following to determine when and how MicroStrategy Web. Statistics logged. MicroStrategy Developer must successfully connect to the Intelligence Server via the SSL port. This video will help you get started using the MicroStrategy REST API. Select Configure Intelligence Server, and click Next. x. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. Once you have finished choosing your options, click Create Environment and wait for your environment to provision. The user must review the contents of any shell scripts that have been modified post installation that are used by MicroStrategy Intelligence Server Universal. In MicroStrategy 2020, four additional lines will appear in the status-iserver. Upload FilesOr drop files. Prerequisites for Windows Clustering. Follow the below steps to change your environment's Library URL. The results of the Intelligent Cube reports can be used by multiple users and reports to avoid executing against the data warehouse. Perform the following steps to install MicroStrategy Library on a Windows server. What is the reason for the. To stop MicroStrategy Intelligence Server Universal 9. x-10. If no project sources are defined, then the Configuration Wizard opens. Select “MicroStrategy SDK”. Make sure all Intelligence Server nodes are running during the life-time of Library Server. This feature. 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. Click Connect. The cube merge utility is available on MicroStrategy Intelligence Server 9. Edit the "status-iserver. In practice, you get a cert for the server. Speed is typically measured as user wait time or. Restart the MicroStrategy Intelligence Server to. Once logged in, the user must navigate to. Users experience an issue where Intelligence Servers are getting frequently disconnected from the MicroStrategy Web 9. instancename is the name of a server instance, where required. The MicroStrategy Intelligence Server was unable to swap out the report instances of 40MB in the Working Set. Right-click on User Defined and select New. 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. It also covers other features, such as importing data from external public data sources, blending. This will prompt to stop the MicroStrategy Intelligence Server process in order to create the new Server Definition. There will most likely be a direct correlation between user load and resource consumption. Step 5. You can use the MicroStrategy Configuration Wizard to upgrade your statistics repository. The default value is 256 megabytes. reg file (which is located in the Microstrategy home folder) "InstallName"="root@2015-10-21T10:09:23" needs to be changed to "InstallName"="root@" (in the HKEY_LOCAL. MicroStrategy is the leading enterprise business intelligence tool with its mission statement to make every enterprise a more intelligent enterprise. xml file and create a backup copy of it. 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. If the Startup type of the MicroStrategy Intelligence Server on 'M1' is set to 'Automatic', the available projects appear automatically. Open the MicroStrategy Configuration Wizard. Change the path if it is incorrect. x in an interactive mode in Windows and UNIX. KB235107: How to Embed a Custom Font Without Having to Install it on the Client Machines using MicroStrategy Web SDK 9. As a new platform release, MicroStrategy 2020 introduces new features that provide better performance and scalability to enhance the overall user experience. To do it, hover over the icon and click Edit Connector. Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. MicroStrategy Web: Web Server. System Performance Trends. SSL must already be configured on the MicroStrategy Intelligence Server. max_map_count be defined as 5,242,880 bytes. Related Articles. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. . If the Startup type of the MicroStrategy Intelligence Server. To view the current status of a MicroStrategy Intelligence Server Universal instance in a UNIX/Linux environment, run the command ‘mstrctl -s IntelligenceServer gs’ from the <MicroStrategy HOME>/bin directory using a command prompt / terminal. Telcos using MicroStrategy can run. Enter the Fully Qualified Domain Names of all Telemetry Server machines in the cluster, or the name of sole the Telemetry Server machine that will be used if there is no clustering. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 24. From the Windows Start menu, point to All Programs, then MicroStrategy Tools, then select Service Manager. Do not change the files under the conf folder. /mstrcmdmgr -interactive and press ENTER to open Command Manager. - modify the data a little bit. MicroStrategy Web: Web Server. The amount of data that the customer chooses to keep could have a corresponding cost to the customer. For example: "C:Program FilesMicroStrategyAdministratorCommand Managercmdmgr. xA user has set up MicroStrategy Web 9. For prior releases, either a cube was loaded, residing completely in RAM, or unloaded. For more information about Enterprise Manager, see the Enterprise Manager Guide. Right-click a project and choose Properties. The requests are granted or denied according to user-configured limits on the amount of. 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. 5 (on Linux) and 10. Specifying Warehouse Connection Information. Capacity Planning for Platform Analytics. There will most likely be a direct correlation between user load and resource consumption. The user then updates the cube. Turn On the Sending Log to Messaging Services Feature. Efficiently manages thousands of end-user requests (jobs. Iserver is on windows server, web server is apache tomcat. Under Collections, click on the the “…” next to. Memory Contract Manager (MCM) is designed to protect Intelligence Server in cases where a memory request would cause the system to approach a state of memory depletion. Number of Views 79. Start Apache Tomcat. Click the icon in the Actions column and select Start, Stop, or Restart. MicroStrategy Server Activation is a licensing technology that ensures that installations of MicroStrategy server products are authentic and have been legitimately licensed. x information regarding the connected servers or to make changes manually to the connection properties of a MicroStrategy Intelligence Servers without using the MicroStrategy Web 9. In other words, this name needs to be recognizable as a network machine. x when Intelligence Server is on Linux. Review the file to ensure all entries match the ones seen in the following screenshot (namely iserver. Re-run the Configuration Wizard and enabled TLS. SYMPTOM: The MicroStrategy Web statistics can be used to profile the performance of the execution of a Report Services Document. Windows: On your desktop, from the Start menu, select Programs (or All Programs ), then MicroStrategy Tools, then Web Administrator. Typical scripts that are modified by users would be. KB48030: Font change is not applied to the graph in MicroStrategy 9. MicroStrategy makes no warranty, express, implied or otherwise, regarding these products, including their performance or reliability. How to increase the Java Heap size in Tomcat. x. If your password was changed from the default of mstr123 update the parameter in your WEB-INF/microstrategy. Helps optimize custom group banding when using the Count Banding method. HKEY_LOCAL_MACHINE\Software\Microstrategy\Microstrategy Broadcast Server\7. trusted. 4. Click Project Defaults from the Menu in the left. . Configure Metadata Connection. Expand Intelligent Cubes, and then select General. It is sometimes necessary for administrators to back up the MicroStrategy Web 9. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. The heap is the run-time data area from which memory for all class instances. sp. jks. 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. All basic statistics. Queries can have a significant increase in the fetch time when there are tables containing VARCHAR without specifying a size in Snowflake. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. MicroStrategy makes no warranty, express, implied or otherwise, regarding these products, including their performance or reliability. LDAP Integration with the MicroStrategy Intelligence Server: To integrate users and groups stored on an LDAP server within the MicroStrategy Intelligence Server 9. Run the MicroStrategy installer by clicking the setup. In the MicroStrategy Library Configuration box, enter. On the other hand, some other configuration files stay as part of the configuration process and are useful to run the applications. jks file including the cert with a passphrase, e. This chapter addresses the processes necessary to configure an installed MicroStrategy suite of products using the Configuration Wizard. yaml. filename is the name of the file to read from or write to. The -h option is needed to change the owner on symbolic links as well. Step 4. x to be restarted in order for the changes to take effect. MicroStrategy Telemetry Store: This service consumes all telemetry data from MicroStrategy Services layer, and do ETL process for the Platform Analytics project, also named as Platform Analytics Consumer. e. If only a single MicroStrategy Intelligence. When enabled, MCM grants or denies requests for memory from tasks in Intelligence Server. The . All MicroStrategy log files are stored in the log file lo cation. Welcome to Platform Analytics! The vision of MicroStrategy is Intelligence Everywhere. 0. The MicroStrategy Listener will also check to see that MicroStrategy Intelligence Server is running as a. The preferences are stored in memory. To log to your screen, select. This can be achieved via the report level VLDB property > SQL Time. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. Selected. Governance of CPU clock speed when installing MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Narrowcast Server. xml > isAliveRequestTimeoutMillis. The Security Filter Editor opens. How to Start and Stop Intelligence Server Services. 1, administrators can delete trust relationships through MicroStrategy Developer. x, join cluster fails or doesn't work fine if two nodes don't know each other’s' machine name. xml should do. A Google account: This account will be used to deploy the Google instance that MicroStrategy will be deployed onto. x and 10. iserver_version The current I-Server version. The following is an example of VBA code for Excel that gets the list. To allow MicroStrategy Web users to access projects, you must create a connection between a MicroStrategy Intelligence Server and MicroStrategy Web. type: Puppeteer exporter. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. 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. 10, 10. Select Intelligence Server > Default Properties. Supported data structure and distribution on Gateway. /mstrcfgwiz. 3. 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. Failover is a key feature in a. If a name is not specified,. The amount of data that the customer chooses to keep could have a corresponding cost to the customer. Edit All Server-Level Settings. This allows for more power and control over data for MicroStrategy users: Leverage data-base specific optimizations. MicroStrategy Library. Use Count (Attribute@ID) to calculate total element number (uses count distinct if necessary) For Tandem databases, the default is Use ODBC Cursor. The suggested number here is 65534, however, you can change the value as long as it is large. This setting limits the time, in seconds, that users can remain idle before their MicroStrategy Intelligence Server session is ended. Project. This setting must be greater than x x 2. 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. Analyzes system performance over time using your choice of metrics. Enabling LDAP Authentication for MicroStrategy Web. war file to upgrade MicroStrategy Library. Steps. backtrace. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration.