Tag Archives: grid

How to change the default messages for blank rows in grid/graphs

Hello there!

Today I’m going to show you have to change the default blank message: No data returned for this view. This might be because the applied filter excludes all data.

You just have to:

1. Go to Desktop/Developer;

2. Log using Administrator;

3. Right click on the project and go to Project Configuration

pic

4. Go to Report Definition -> Advanced;

5. Fill the text Area with some text. This text is going to be used when you don’t have rows for a grid/graph.

pic

You can also hide the document grid if you want.

Restart your Intelligence Server and Web Server.

That’s it.

Hope it helps!

God bless you!

4.

Hide permanently the “Metrics” column for MicroStrategy Web

Hello there !

Today let’s talk about removing the “Metric” column forever in MicroStrategy Web !!!

I always have to remove the extra column (web only) for every grid that I create in MicroStrategy, because I just don’t like seeing that there. But sometimes is very boring doing that everytime that I create a new report or grid in a document. So, if you are like me that simply don’t like that extra column, here is a very good tip to remove it forever from your Microstrategy Web visualization.

To do that you just have to:

1. Make sure the language that you are using in your projects in MicroStrategy web. To see which language your project is setup, just go enter in a project, go to Web Preferences -> Project Defaults -> Language.

pic1 pic2

2. Go to the folder where your MicroStrategy Web is installer. If you use IIS, go to: C:\Program Files (x86)\MicroStrategy\Web ASPx\WEB-INF\classes\resources or C:\Program Files\MicroStrategy\Web ASPx\WEB-INF\classes\resources. If you use Tomcat, C:\Program Files\Apache Software Foundation\Tomcat X\webapps\MicroStrategy\WEB-INF\classes\resources (where X is the version of your installed Tomcat ).

3. Edit the MessagesBundle specific to the language that you use in your MicroStrategy Web. In my case I use English, so I’m going to edit the MessagesBundle_en_US.properties file. If I was using Spanish, for example, I just have to edit the MessagesBundle_es.properties file, and so on.

pic3

4. Open the file in notepad (or other text edit of your choice) and find the word “Metrics”.

pic4

5. In version 9.4.1 Hotfix 3, just delete the word “metrics” from the “mstrWeb.962” content, andadd blank a space.

pic5

6. After that, restart MicroStrategy Web. If you use IIS, click in: Start, click Run type IISReset, and then click OK. If Tomcat, go to Tomcat Monitor and restart your web server.

7. Now, create a new report and you will see, when you execute it, that the “Metrics” column has just gone forever!!

pic6

Enjoy it! Hope it helps!

God bless you.