Category Archives: Exporting

Connect Tableau to MicroStrategy

Hello there,

Did you know that using REST API you can connect Tableau to any report/cube in MicroStrategy?

You can check it in this URL:

https://community.microstrategy.com/s/article/MicroStrategy-Dataset-Connector-for-Tableau?ui-force-components-controllers-recordGlobalValueProvider.RecordGvp.getRecord=1&r=8

Hope it helps.

God bless you!

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!