Monthly Archives: May 2015

OLAP Metric Functions

Hello there!

I’ve created a website for Microstrategy Online Courses.

Now I’m recording an URL API course (Portuguese) and an Olap Metric Functions course (Portuguese). If you are interested in Microstrategy online courses, that site can help you out!

I’m going to record in Portuguese and in English.

Hope you enjoy it.

God bless you!

Microstrategy 9.4.1 Hotfix 9

Hello there!

Microstrategy has just released a brand new hotfix for version 9.4.1: Hotfix 9.

If you want to read the “Readme”, just enter the link below:

http://community.microstrategy.com/t5/Release-Notes/TN244111-MicroStrategy-Analytics-9-4-1-Hotfix-9-Readme/ta-p/244111

God bless you!

Parallel Query Execution

Hello there!

There is a excellent vldb option to execute in parallel independent sql passes.So. if you have more than one pass in your SQL and those aren’t dependent, you can instruct Microstrategy to execute them separately. Microstrategy will open DB connections to execute those SQLs.

Example:

You have a query with some passes like:

Pass1

 Pass2

  Pass3

   Pass4

If Pass1 isn’t dependent of Pass2, Microstrategy will execute them separately.

To do that, you just have to:

1. Open your report;

2. Click on Data -> VLDB Properties

3. Select Query Optimization -> Parallel Query Execution

pic

Justchoose one of those 2 “Enable” options. Just read it and see which one is better for you.

Hope it helps!

God bless you!

Creating a pie scatter graph in Visual Insight

Hello there!

A friend of mine asked me to write about how to create a pie scatter graph in Visual Insight. Today let’s talk about it!

To create a graph like this:

Scatter

You just have to:

1. Create a new Visual Insight dashboard with 1 dataset.

2. Create a new visualization and select a scatter.

Scatter

3. Go to the graph properties and choose “Pie” in “Shape”.

Scatter

4. Set your graph like this:

Scatter

That’s it.

Now you have for each pie slice a country with the discount as the size of them.

Hope it helps!

God bless you!