MicroStrategy - Technical Notes


TN42054 - Making Excel header and footer appears on every page when printed

TNs related to web:connectionValue:

  • TN9704 - The user connection information does not appear after adding the connectionValue tag to a web page in MicroStrategy Web 8.x

TNs related to History List:

TNs related to logging:

As for the MicroStrategy Diagnostics and Performance Logging Tool, if you are running a Windows Sever, the System Log could write to Windows Event Viewer File. As for forwarding to a Server, that of course would need to be handled on your end, as MicroStrategy does not have that support. As well, Enterprise Manager and Statistics is not for logging purposes, as it is to be used as a MicroStrategy project to run reports on Data Usage. Health Center if correctly set up can pull logs off of a machine for vieiwing on another machine, but, this would not help in your implementation as you would just be moving the files to a different location, not forwarding them to your Logging Server.

If you can find a usage for the System Log to the Windows Event Viewer File, to be forwarded to your Server, then that should accomplish your goal. However, this would involve 3rd party software not involving Microstrategy and thus not supported on our end. As for performance Hits - Any additional Logging can be considered a performance drop. If you reach a point where you are confident with the System Logging, you could disable the file Log Portion, but I cannot guarantee or provide information on Performance when forwarding the System Log to a file Server. The following Technote gives an idea of the MicroStrategy Diagnostics and Performance Logging Tool settings which can hopefully clear up the options:

TNs related to ACL and permission:

  • TN47607 - How to Modify the ACL of an Attribute Using MicroStrategy Web SDK (give a group access to a folder). In your case, you would need to change the object to a folder and the Enum for Full Control. DssXmlAccessRightFullControl = 255.

TNs related to cluster configuration:

TNs related to an issue that I had with 9.3:

TNs related to session affinity?

I do not think this setting deals with caches in any way. When the 'User Affinity Cluster' setting is enabled it makes it so when a user logs on it will check if the user already has a session open. If they do have a session open MSTR will create another session on the same node as the first session. This helps with performance because History List messages are loaded from the database to the I-Server at login. If a connection is made on an I-Server with an already open connection for the same user no data will be needed from the HL database (since it's already there for the first session). If there are no sessions open then MSTR will open the new session on any node, then open any new connections from that user on the same node. A user can have multiple connections such as one in Desktop and one in Web. I do not think this setting deals with any caches though, just History List messages.

The Subscription Load Balancing setting makes it so that when a subscription is run with multiple recipients the jobs are allocated evenly over all of the nodes. When a subscription is started the I-Server will create a user session for the user who is receiving the document and then execute all of the jobs for the document as that user. So when this setting is enabled all of the jobs will be sent to different nodes to balance the load. This goes against what the Affinity Clustering feature provides (logs each user session on the same node). Since the user is creating a user session on all the different loads there will be a load on the HL database. When this setting is turned off all of the jobs will be executed on the same load, creating much less load on the HL database when signing in the sessions.

TNs related to domain accounts being used to run MSTR:

TNs related to Email sending:

  • TN7264 - What is SMTP Smart Host in MicroStrategy Narrowcast Server 9.x
  • TN20402

TNs related to Health Center:

  • TN32556 - How to Configure an FTP/FTPS Destination in MicroStrategy Health Center
  • TN36259 - How to configure SMTP Smart Host Server for MicroStrategy Health Center

TNs related to exporting to PDF or Excel:

  • TN33301 - When exporting to PDF the user get prompted to save the file "Main.aspx" instead of the PDF
  • This dialog box is expected when you have a version of Excel installed that is 2007 or later. The following Microsoft tech note explains more about why this dialog shows in new versions of Excel: http://support.microsoft.com/kb/948615. One way to have this dialog box not show up when export documents from Web is to change a setting in the MicroStrategy Web Preferences. Within the Web Preferences, you can navigate to export reports > Excel options and switch the Excel version to 2007 or newer versions. You should not see the dialog box pop up afterwards.

TNs related to performance:

  • TN44089 - How to increase the maximum number of parallel SQL queries per report in MicroStrategy 9.3.0 and later
  • TN16624 - Network threads
  • TN19523
  • TN5972

TNs related to Object Manager:

  • TN36167 - How to create an Object Manager package from the command line in MicroStrategy 9.0.2 - 9.2.x - 9.3.0

TNs related to governing settings:

  • TN13020 - How to limit the ‘Executing Jobs per User’ governing setting at the User/Group Level in MicroStrategy 9.x
  • TN14358 - ‘The object specified by %1 is not found in the pool’ error occurs when executing a Report Services document in Microstrategy Web 8.1.x and 9.0.x

TNs related to installation:

  • TN40486 - Whilst modifying the MicroStrategy installation the error: "MISSING: Microsoft Visual C++ 2005 64-bit Runtime or MISSING: Microsoft Visual C++ 2005 32-bit Runtime" occurs in MicroStrategy 9.x.x

TNs related to the Save As dialog:

  • TN34667 - How to add custom folder links in prompt "Save As" dialog in MicroStrategy SDK 9.3.1

TNs related to Report Design:

TNs related to security:

  • TN37643 - New security feature introduced in MicroStrategy Web 9.0.2 Hotfix 7 and 9.2.1 — Prevention of CSRF attack (Cross-Site Request Forgery)

TNs related to Custom Task:

  • TN35228 - How to Create a Custom Task that Returns a List of Projects a User has Access to Using the MicroStrategy Java Web SDK 9.4.1

Other TNs:

  • TN6684 - How to create an HTML tag form for an attribute that can be used as a hyperlink in MicroStrategy Web 9.x
  • TN31945 - "An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode" error comes back when trying to access IIS 7 from MicroStrategy Office 9.0.x
  • TN31205 - Error creating a session: (Cannot create a configuration-level object in a project; cannot create a project-level object in a configuration) when creating a new User using the MicroStrategy Web API
  • TN31464 - "Cannot create a configuration-level object in a project; cannot create a project-level object in a configuration" error is thrown when saving a newly created user through MicroStrategy Web SDK 9.0.0 API
  • TN31083 - "Device 'XXX' cannot be deleted because it is used by N object(s)." error message appears when deleting a device in MicroStrategy Distribution Services 9.x


Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License