Category Archives: Administration

Creating a shell script to manage the IS service

Hello there,

Today a quick tip that can help to manage the IS if it is down.

To do that, just create a new file .sh with these lines:

output=`/opt/MicroStrategy/bin/mstrctl -s IntelligenceServer gs` #use your path

if [ `echo $output | grep -c “run” ` -gt 0 ]; then check=1; else check=0; fi
if [ $check -eq 0 ]; then
if [ `echo $output | grep -c “stopped” ` -gt 0 ] || [ `echo $output | grep -c “terminated” ` -gt 0 ]; then
/opt/MicroStrategy/bin/mstrctl -s IntelligenceServer start #use your path
fi
fi

Save the file and make sure to change it to an executable file:

chmod +x filename.sh

Where filename is the name that you used above.

Now, make sure to schedule it using crontab or other scheduler tool.

Hope it helps

God bless you

Creating alias for commonly used command lines in Unix

Hello there,

Today another quick tip. If you are like me that is typing the same shell command over and over, there is a way to create alias so it will make your lifer easier.

Let’s say that you have to start the Intelligence Server every day… (for some reason). To do that you would have to type this command:

$ ./mstrctl -s IntelligenceServer start

But, you can create an alias for that and instead of writing that line, you can just type: startI

To do that, you just have to:

  1. Open your shell in Unix
  2. Type: alias startI=’./mstrctl -s IntelligenceServer start’

Now, just type: startI and it will be translate into the start command shown above.

Hope it helps.

God bless you!

How to show de diagnostic option in MicroStrategy Developer

Hello there,

If you are an administrator and needs to configure the logs, there is a shortcut in MSTR Developer where you can have a shortcut to the MicroStrategy Diagnostics and Performance Logging tool.

To do that, you just have to:

  1. Open mstr developer;
  2. Click on Tools from the menu bar
  3. Click on Preferences – Developer -> Advanced -> Check “Show diagnostics menu option”

Now you can click on the Tools -> Diagnostics and it will show the logging tool.

Hope it helps.

God bless you

Creating a package w/o locking the project in Object Manager

Hello there,

Sometimes we need to create a new package to migrate objects from one environment to another and that action locks the project that you are working on.

To prevent this lock, you just have to check these options and you will be able to create the packages without any locks.

To do that, in object go to:

  1. Tools -> Object Manager Preferences… -> Connection and check these options:

 

There you go! Now you can create packages without locking the projects.

 

Hope it helps.

God bless you!

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