Change the default behavior in prompt search

Hello there!

Here is a tip of a great friend called Rafael Gourlart.

By default, a space between words in a prompt search is interpreted as a logical ‘OR’ in MicroStrategy Web. This behavior be changed to use ‘AND’ instead.

For example, if you are trying to search for “FelipeVilela” a possible result would be:

pic2

Now, if you change to “And”:

pic3

 

To change from “OR” to “AND” you just have to:

1.In the FilterValidation.properties file under WEB-INF\classes\resources, set the elementSearchBehavior parameter to ‘2’, and restart the MicroStrategy Web.

pic1

That’s it.

 

Hope it helps.

God bless you.

 

Shapefile/kml repository

Hello there!

I don’t know if you guys know, but it is possible to use a shapefile or kml file for Esri maps in MicroStrategy.

Here is a good tip… You can download a lot of shapefile files and kml files to work with your maps at:

http://geocommons.com

Hope it helps!

God bless you!

Using watermark for image background in Android

Hello there!

Today let’s talk about adding image as watermarks in your documents.

You can use an image for displaying an image as background and take advantage of the watermark feature.

To do that you just have to:

1. Create a new document;

2. In Developer/Desktop go to File -> Page Setup -> Document -> Watermark -> Format…

pic

3.  Click on Image Watermark and choose your image.

pic

 

Open your document in Android and you will be able to see this image as your background.

If you are facing problems using relative path, just use absolute path to the image (complete url).

 

Hope it helps!

God bless you!

The column %1’s datatype %2 with precision %3 scale %4 is not supported

Hello there!

Today let’s talk about a common error in MicroStrategy while mapping a new Attribute:

The column %1’s datatype %2 with precision %3 scale %4 is not supported…

pic1

Sometimes MicroStrategy can’t get the exact data type from Database while creating a new form attribute.

It’s always a good idea to take a look at “Column Alias” while editing or creating a new attribute, because an unknown data type could appears there, just like the image below:

pic3

That is the reason that makes this error happens. So, lets solve this problem!

1. Edit your attribute -> Click on Modify -> click on Column Alias tab -> click “Modify” -> Click on “New” button” -> Give a name and the correct data type.

pic2

pic4

pic5

pic6

 

After that, update your schema and you will be fine again!

Hope it helps!

God bless you!

Custom Subtotal over attribute elements

Hello there!

Today let’s talk about creating subtotal over attribute elements.

Let’s suppose I have 2 attributes and 1 metric in a report template: Year (in columns) , Category (in rows) and Profit(in columns). Let’s say that I need to calculate the growth of Profit among 2011 and 2012 for each category. How can I do that?

One thing that could be done is to create 2 metrics and insert a conditional “2011” for the first metric and “2012” for the second metric. Using this procedure I will have some problems to calculate the growth over different years. I would have to create another metrics with another filters for each different year.

That isn’t a good approach. Instead, you can create a subtotal that gets the first year and the last year automatically and then calculates that growth for me.

To do that you have to:

1. Go to Project Objects -> Subtotals

pic1

2. Create a new Subtotal with this formula:

pic2

Here I’m using the Last and First function to get the first year and the last year of my report. The trick here is to use the SortBy = Year. If you don’t use this SortBy, MicroStrategy won’t get the correct value for First and Last. The “@” indicates the place where Profit Metric will be inserted.

If you can’t see the functions parameters, just go to View ->and click on “Show Functions Parameters”, just like the image below:

pic8

3. Go to Profit metric and include this subtotal to the available subtotals:

pic3

4. Create a new report using these objects below:

pic4

5. Go to Data-> Subtotals and add check the Growth subtotal.

pic5

6. Now when you run your report, MicroStrategy will divide 2012/2011 just like we wanted.

pic6

 

That’s it.

Hope it helps.

 

God bless you.

Automatic/Manual Mapping while adding new Table

Hello there!

Adding new tables to a project could be a problem in terms of attribute mapping. Sometimes you have a column with the same name in older imported tables and when you add new a table, MicroStrategy will automatic map that column to an already created attribute.

Let me give you an example.

Let’s think that we added a table called “LU_TIME_SALES” and we have a column named as “YEAR” in this table.

We create an attribute pointing to that YEAR column from LU_TIME_SALES.

Now, we want to add a new table called “LU_TIME_INVENTORY” and we also have a column named as “YEAR“. But, now you don’t want to map that column to the previous YEAR attribute,  we want to create another attribute, because this is a different subject. Inventory is different from Sales, so you need to map those years in different attributes.

Every time you add a new table, MicroStrategy will search for every attribute in your project, to see if anyone has a column with the same name of the columns of our new table. If the answer is yes, it will automatic map that table as source for your matching attributes.

If it is what you want, that’s awesome. But sometimes (every time for me), you don’t want that.

To change this behavior you have to do a simple thing:

1. Open your project;

2. Go to Schema -> Warehouse Catalog -> Option -> Schema -> Automatic Mapping -> Choose: Do not map schema objects to the new tables. Just like the images below:

a.

pic1
b.

pic2

c.
pic3

 

That’s it. When you add new tables in your project, MicroStrategy won’t add that table as source for your attributes.

Hope it helps.

 

God bless you.

Workshop MicroStrategy Visual Insight

Hello there!

I’m really glad to announce my first online workshop! And we are going to talk about MicroStrategy Visual Insight!

Here are topics:

1- What is Visual Insight;
2- What is VI Dashboards;
3- Difference of MicroStrategy analytics Enterprise, MicroStrategy Analytics Desktop and express;
4- Importing data;
5- Using Time and Geography attributes;
6- Refreshing imported data;
7- Themes;
8- All panes in Visual Insight;
9- Saving, exporting and printing;
10- Visualisations (All graphs);
11- Using image layout;
12- Using ESRI map;
13- Configuring ESRI maps for Enterprise version;
14- Sorting;
15- Drilling;
16- Local Filtering;
17- Attributes selectors;
18- Thresholds;
19- Subtotals;
20- Derived Metrics;
21- Sharing Dashboards;
22- Converting Dashboard in document;
23- Visual Insight for mobile;

Terms:

  • The course will be presented in Portuguese;
  • We are going to use a Virtual Classroom;
  • Live class will be recorded and available for all students to download in .mp4;
  • Duration: 1 week. With 4 hours of live class on july 5, 2014 at 03:00 PM (15:00 hrs – Horário de Brasília) and exercises and solving doubts during the rest of the week;
  • You can send your own data (Excel or CSV) to be used in the live class;
  • Investment: R$ 70,00 that can be paid using PagSeguro/Paypal or deposit (Itaú e Banco do Brasil)
  • Date: July 5, 2014 to july 12, 2014
  • Up to 10 students;

The next course will be presented in English.

If you would like to subscribe for this Workshop (Portuguese), you can do it by filling the form below. I will be sending you the instructions for the course.