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

Changing the value format of several metrics at the same time

Hello there,

Have you ever needed to change the formatting of several metrics to Percentage, for example? It’s a tedious process and it can be painful.

Hopefully there is a way to change them all with just a few clicks:

  1. Go to MSTR Developer;
  2. Click on Tools -> Find and Replace…
  3. Select “Metric formatting”
  4. Select the metrics using the search
  5. Click Update Summary
  6. Check: Set the formatting properties individually
  7. Check Metric Values
  8. Click Formatting
  9. Format your metrics accordingly

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!

Adding a Long Prompt option

Hello there,

Do you know that we have a Long prompt option for the Value prompt? Yes, we have it, but it’s hidden. Today let’s show you how to enable this prompt.

You just have to:

  1. Open MicroStrategy Developer;
  2. Go to Tools -> My Preferences -> General -> Prompts -> Check “Add long prompts to the list of available value prompts”

Now when you create a new prompt and select Value Prompt, you will have this new option:

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!