Category Archives: Exporting

Conditional Formatting for all components

Hello there,

Everybody knows that we can’t add a conditional formatting for grids/graphs or panel stacks, for example.

I’ve found a way to do it!

The solution is pretty simple. Add an HTML container, insert your CSS to customize the components and then you use a conditional formatting in the HTML Container to hide it based on a specific condition.

What it does is, if the HTML Container is visible, it applies the CSS, if not, it doesn’t.

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 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!

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!