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:
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:
- 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:
nbsp;nbsp;Child 1 (for 2 spaces)
nbsp;nbsp;nbsp;Child 2 (for 3 spaces)
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:
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!