Monthly Archives: May 2014

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.

Default Visualization for Reports

Hello there.

Today I’m going to talk about the default visualization when you execute a report in MicroStrategy Web.

If you want to change the default visualization of the report you just have to do this:

1. Go to MicroStrategy Web and execute your Report.

pic2

 

2. Click on Tools.

pic1

3. Select Report Options… After that, just go to the Formats tab.

pic3

4. Now, just choose from the list of Run by default as… the desired view.

pic4

 

I hope it helps you.

 

God bless you.

Using Burst with Distribution Service

Hello there!

Let’s talk about a great feature that is included with the Distribution Service. If you don’t know, Distribution Service is the delivery option that you can use to send documents and reports to folders, email, printers and even send push notifications to mobile devices.

MicroStrategy has discontinued NarrowCast Server, the older brother of Distribution Service, to add this integrated solution. There are a lot of things that you still can’t do with Distribution Service and that the older one does.

But let’s talk about good features that are present in DS list, like Burst.

Burst is a cool feature that makes possible splitting each attribute element in the Grouping Area/Page-By of your document/report to a different file.

Let’s get it done!

1. Create a new report using MicroStrategy Tutorial project with Category, Subcategory and Profit in the report objects. Place Category in Page-By area, Subcategory in rows and Profit in Columns. Just like the image below:

Pic1

2. Save it and place the mouse over the saved report using MicroStrategy Web and click on the Subscription button.

pic2

3. Add a new File Subscription.

pic3

4. Click on the Burst… button. Now you see a Select bursting criteria area that will list every attribute that is inside the Grouping/Page-By. Select Category attribute like the image below.

pic5

PS: Note that I’m using the User Selected Location for the Location field. You have to setup a folder to send the delivered files. To do this, just go to Developer -> login using Administrator -> go to Administration section -> Delivery Managers -> Devices -> Edit “User selected location” and choose a specific folder of you desire.

pic6

5. Click OK button, go to the destination folder and you will see a lot of files, one for each Category element.

pic7

I’m going to talk about how to change those files name in another post.

That’s it for today!

I hope it helps you.

God bless you.

Splitting attribute element into different sheets in Excel

Hi there, today I’m going to talk about splitting in different sheets your attribute elements when you export your document to MS Excel.

To do this trick, you just need to:

1. Add your attribute in the Grouping area like image 1 below:

Image 1

Image 1

2. Right click on the attribute and choose Grouping Properties

pic2

3. Check Sheet break between groups

pic3 

4. Export to Excel and choose Expand Page-by

pic4

When you open in excel you will get something like this:

pic5

Each element has one sheet in the exported excel file.

I hope it helps you!

God bless you.