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!

How to redirect errors to a specific file in Unix

Hello there,

Sometimes we have to check for Errors in the DSSerrors.log and the log is huge. To help you with this task, we can execute a simple command that will redirect the Errors to a specific file. To do that in Unix, you just have to:

cat ../log/DSSErrors.log | grep “Error” >> /folder/filename

So, right after the CAT, you have to specify where is the DSSErrors.log and right after the >> the folder and the filename that you want to use to store the errors.

Hope it helps.

God bless you!

Converting to String with Patterns

Here there,

Quick tip today: How to convert a value to String in a derived metric, for example, using patterns.

Let’s say that you have a date and you want to convert it to a string and get only the Month name with 3 chars. You just need to:

ToString<Pattern=mmm>([Date Attribute])

Get day with 2 numbers:

ToString<Pattern=dd>([Date Attribute]),

Get year with 4 numbers:

ToString<Pattern=yyyy>([Date Attribute])

Convert the value to 0,000 pattern:

ToString<Pattern=”0,000″>([Value metric])

Etc…

You can play around with these Patterns to convert your attributes/metrics to a string using a specific format.

Hope it helps.

God bless you!

Think

Hello there,

I’ve been trying to drive people in my team to think and not just do what they are asked to do. I want to do exactly the same here in this post. Show you that think is the best way.

Today, people are driven to do the tasks and sometimes they don’t find space to think on what they are doing neither better ways to do it.

When you have to create several metrics, what do you normally do? Probably you check if the project has the facts and attributes and you start building the metrics as there were no tomorrow.

Let’s think about this metric creation task. Have you ever thought that we could create metrics using the advanced metric option in MSTR Developer and that could save a huge amount of time?

Last week, I had a task to create approximately 80 metrics and I realized that I could do it in a better way. See that I used the word realized? Instead of just start doing the task, I first stopped for a moment, and thought in better ways to perform those creations. The metrics needed filters, a count function and the value format to be as a percentage.

1. Filters: do you know that filters can be created using command manager? Yes, we can do it with CM. Here is the script:

CREATE FILTER “NameOfTheFilter ” IN FOLDER “\Public Objects\Filters” EXPRESSION “Attribute@DESC= ^” value to be filtered ^” ; ON PROJECT “MicroStrategy Tutorial”;

With this script, you will save a lot of time right clicking and left clicking your mouse to create and save a new filter. Using the advanced filter in Developer, you can add the metrics/filters/transformations and MicroStrategy will create the combination of them with just a single click of your mouse. This feature will let you go home earlier that day.

2. Base formula: Think about creating a base formula for your metrics. This way you won’t need to create a new expression every time that you have to create a new metric.

In java, we are driven to reuse the classes and method. It’s not a good idea to create new line of codes if you are have them. Reuse, don’t rewrite the same piece of code multiple times. That’s the reason why Jave has methods.

The same concept applies to MicroStrategy. We are good to say that with MicroStrategy we can reuse objects. That’s not stands true if you don’t use it.

Let’s think about using base formulas to create the metrics so they will be consistent and we can reuse the formulas in multiple objects.

3. Find and replace: do you know that we can format a bulk of metrics with just a few clicks? If you go to Tools -> Find and Replace in Developer, you will see that we can easily change the format of the metrics. This way, you will also save a LOT OF TIME.

This is just an example that confirms that think and do is better than just do.

I hope I’ve encouraged you to think…

God bless you.

How to migrate objects without Object Manager

Hello there,

Today a quick tip: how to migrate objects without using Object Manager.

To do that, you need to create an update package.

You will find all information in this link below:

https://community.microstrategy.com/s/article/KB34262-How-to-create-an-update-package-from-the-command-line-in

Hope it helps

God bless you!