Category Archives: Database

Adding blank spaces to indent on MicroStrategy 10

Hello there,

Today let’s talk about how to add blank spaces for the descriptions of your attribute to display them as an hierarchy, just like this:

Parent 1

Child 1

Child 2

Parent 2

Child 1

MicroStrategy 10 is trimming by default the blank spaces on the attribute while using grids when executing the dashboard on the presentation mode. In order to add blank spaces you have to:

  1. Add nbsp; for each blank space that you want to display. You have to do that on your table/column in your database. So, in your ETL process you will have to add something like this:

Parent 1

nbsp;nbsp;Child 1 (for 2 spaces)

nbsp;nbsp;nbsp;Child 2 (for 3 spaces)

Got it?

2. In MicroStrategy, when you are going to map this column as an attribute form, you just have to change the Form type to be like this:

pic1

Use HTML Tag instead of Text.

Just remember to add a SORT column in your table and map it on MicroStrategy in order to sort the descriptions correctly.

Now, when you open your dashboard using this attribute, you will see them with an indentation in the grids.

Hope it helps.

God bless you!

Using Extended Fetch

Hello there!

Today let’s talk about a very important thing! Extended Fetch!

Do you know what is extended fetch?

Extended Fetch is an option that can be used in MicroStrategy that returns multiple rows at one time when querying your Data Warehouse.

Without Extended fetch(the Default option): MicroStrategy returns data one row at a time. With Extended Fetch: MicroStrategy returns multiple rows at one time. Extended Fetch may therefore facilitate faster retrieval of query results, especially when the number of result sets is large.

There is a list of the supported (MicroStrategy didn’t update the list, so maybe your database can support extended fetch) databases in this link below:

https://resource.microstrategy.com/support/Authoring/DisplayTN.aspx?tnkey=32213&formatted=1

To use Extended Fetch, you have to make sure to use 2.0 ODBC Calls instead of 3.x ODBC Calls ODBC Version.

To inspect which ODBC version you are using for your database connection, just go to:

MicroStrategy Developer -> Administration -> Configuration Managers -> Database Instances -> Choose your Database Instance and Edit it -> Go to Advanced tab and look for ODBC Version section:

pic4

pic3

Now just go to General tab:

pic7

Choose your Database Connection and click on the Modify button.

Go to Advanced tab and check: “Use Extended Fetch” option:

pic6

If you are using Tier-3 connection, restart your Intelligence Server to apply those settings. If using 2-tier, just disconnect and reconnect to your project source.

That’s it.

Hope it helps.

God bless you.