Category Archives: Administration

Enabling HTTP Compression

Hello there!

There is a nice way to increase performance on Mstr Web using HTTP Compression.

You can set that on IIS or Tomcat. Below is the link that explains the steps to do that:

http://community.microstrategy.com/t5/Web/TN31501-Network-for-Dashboard-Performance-Optimizations-in/ta-p/182412

Hope it helps.
God bless you

Problems with MicroStrategy Mobile Connectivity? Fiddler can help you

Hello there,

I found an excellent TN that explains a way to troubleshoot MicroStrategy Mobile connectivity issues.

Just follow the steps described in this TN:

https://community.microstrategy.com/t5/Miscellaneous/TN38017-How-to-use-Fiddler-Web-Debugger-to-troubleshoot-iPad-and/ta-p/188200

Hope it helps!

God bess you!

Calculate Derived metrics at the level of all attributes in the report objects

Hello there,

I found an excellent TN that can save some time. Maybe you already have to create a derived metric that was calculate using all attribute that you have in the report objects and not in the grid and you couldn’t find a way to do that. There is a hidden option that you can enable to allow that option.

You just have these steps:

 

  • Locate the XML file sys_defaults.xml which can be found in the path C:\Program Files (x86)\MicroStrategy\Web ASPx\WEB-INF\xml.
  • Right-click on this file and edit it using a text editor.
  • Search for the showAggFromBaseOnMetricEditor flag and change it from the default value of 0 to 1.
  • Save and close.
  • Restart Web Server.
  • Log into Web, create a new report with the desired attributes and metrics, run the report, and create a new Derived Metric.
  • As can be seen in the screenshot below, the Aggregate from base setting is now available, whereas previously it did not appear.
  • Note that this setting can only be applied in Web, however, it will take effect when reports are run via Desktop or Web.
  • This setting can be used to calculate a Derived Metric at the level of an attribute that is in the Reports Objects window but not on the grid.

Hope it helps.

God bless you

 

Copied from https://community.microstrategy.com/t5/Web/TN41447-The-ability-to-create-a-Derived-Metric-that-calculates/ta-p/191356

 

Enterprise Manager for V.9x data beyond 2015

Hello there!

If you are experiencing some issues about collecting statistics beyond 2015 in your MicroStrategy v.9x, you must read this TN below:

http://community.microstrategy.com/t5/Server/TN270405-How-to-manually-extend-MicroStrategy-Enterprise-Manager/ta-p/270405

God bless you!

 

A list of VLDBs

Hello there!

Here is a list of TNs for DB VLDBs:

Oracle 11g:
https://resource.microstrategy.com/Support/Authoring/DisplayTN.aspx?tnkey=31555&formatted=1
SQL Server
https://resource.microstrategy.com/Support/Authoring/DisplayTN.aspx?tnkey=31572&formatted=1
HP NeoView
https://resource.microstrategy.com/Support/Authoring/DisplayTN.aspx?tnkey=31539&formatted=1
Sybase IQ
https://resource.microstrategy.com/Support/Authoring/DisplayTN.aspx?tnkey=31573&formatted=1
DB2
https://resource.microstrategy.com/Support/Authoring/DisplayTN.aspx?tnkey=31537&formatted=1

Hope it helps!

God bless you!

Microstrategy 9.4.1 Hotfix 8 cluster issue

Hello there!

Microstrategy has announced a new hotfix for version 9.4.1. There is an issue in hotfix 8 that is described in this link: http://community.microstrategy.com/t5/Server/TN243886-MicroStrategy-Intelligence-Server-9-4-1-Hotfix-8-seems/ta-p/243886

Microstrategy recommends that everyone that has hotfix 8 installed, install this new hotfix.

God bless you!

Performance in Unix

Hello there!

Here is a compiled list of all good TNs to troubleshooting performance issues in Unix environments:

http://community.microstrategy.com/t5/Server/TN19155-Recommended-performance-logging-counters-to-enable-when/ta-p/179379

http://community.microstrategy.com/t5/Server/TN36843-How-to-determine-CPU-intensive-tasks-on-a-Linux/ta-p/187130

http://community.microstrategy.com/t5/Server/TN14769-How-to-use-NMON-and-NMON-Analyser-to-obtain-detailed/ta-p/175234

Hope it helps!

God bless you!