Author Archives: Felipe Vilela

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!

Interviews

Hello there,

I’ve been doing a lot os screenings and I have some tips to share with you guys.

People have a lot of experience in MicroStrategy, but when I ask simple things, they just can’t answer them correctly. It’s bad when we have such a great resume but don’t know the basics. So, the first tip is:

1. Study harder

There are a so many good material that can be read for free that explains the basics of MicroStrategy and all terminologies. Spend more time reading those manuals. They are gold.

2. If you don’t know the answer, it’s not bad to say that you don’t know

If you don’t know the answer, you can ask for a hint, maybe you will remember, if not, don’t try to answer with other things or anything else. Go direct to the point, don’t spend too much time answering a question. Sometimes I want to ask more things, but the person simple doesn’t allow me to do, since they don’t stop speaking.

3. Don’t try to learn things while you are in the interview

Another common situation is when I ask a specific thing, the person doesn’t know the answer and ask me how to do it and keep asking examples of it. You are not there to learn, but to be tested. I think it’s ok to ask straight questions, but don’t spend too much time trying to learn new things.

4. Don’t ask for help

Maybe you don’t know, but whispering can be heard… I already caught people asking others if what she said was ok. Please, don’t do that. Don’t ask the questions to someone else.

Please, let me know what are your thoughts about that. Do you have some tips? Leave the tips in the comments below.

Hope it helps.

God bless you!

Showing the execution date and time for the datasets and Cubes

Hello there,

Have you ever wanted to show the last execution time or the last refreshed time for a cube in a document?

To do that you just need to:

  1. Create a text;
  2. Add this auto-text: {&REPORTNAME:EXECUTIONTIME}

Where REPORTNAME will be the name of your report or Cube. For example, if you have a report with the name: Report Analysis, the auto-text will be {&[Report Analysis]:EXECUTIONTIME}

God bless you!

Hiding menu options in a document

Hello there,

Have you ever wanted to hide a specific item from the document menu so the users won’t be able to use a specific feature? Some of the options can be removed at a user level, but what if you want to remove for a specific dashboard?

To do that, we can use a custom CSS code. In our example we will be removing the Export option. Let’s go!

  1. Open the document in web and add a HTML container to your document;
  2. Click on on the HTML container -> properties and formatting -> select HTML TEXT from the general menu;
  3. Double click on the HTML container and type this code:

<style type=”text/css”> .mstrmojo-Popup.mstrShortcutsListPopup .export, .mstrmojo-Popup.mstrShortcutsListPopup .zoom{display:none !important;}</style>

Voilà! The export button is no longer there.

If you want to remove other buttons, you just need to add the classes for the button inside of the <style> </style> tags and make sure to use the display:none !important.

To get the classes for the other buttons, you just need to use Chrome, for example, and inspect the button to get the classes.

Please, let you know if you need help inspecting elements.

God bless you!

MicroStrategy 10.11

Hello there,

Microstrategy has released a new version: MicroStrategy 10.11

If you want to check what’s new, you can use this link for that:

https://www.microstrategy.com/us/company/press/microstrategy-further-transforms-visual-data-discovery-with-microstrategy-1011

God bless you!