Monthly Archives: September 2014

MicroStrategy 9.4.1 Hotfix 6

Hello there!

MicroStrategy has released a new hotfix for 9.4.1, hotfix 6.

You can see the complete changes in the link below:

http://community.microstrategy.com/t5/Release-Notes/TN201038-MicroStrategy-Analytics-9-4-1-Hotfix-6-Readme/ta-p/201038

God bless you!

Hotfix 5 for MicroStrategy 9.4.1

Hello there!

Just to announce! MicroStrategy released a new hotfix for 9.4.1: MicroStrategy 9.4.1 Hotfix 5.

Take a look at the bug corrections at the link below and see if something that wen wrong is now right!

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

 

God bless you!

Unicode in Linux

Hello there!

Today I’m going to talk about an error in strings when you have accents. If you have a word like this: baú in your database and in MicroStrategy you see something like ba?, for example. This is an Unicode problem. You have to set odbc connection to allow accents in your odbc.ini file.

Just go to:

mstrInstallationFolder/odbc.ini

In your odbc connection, change the default value of IANAAppCodePage to 111.

Before: IANAAppCodePage=106

After: IANAAppCodePage=111

It will allow MicroStrategy to use Unicode for that specific database connection.

Hope it helps.

God bless you!

Linux parameters

Hello there!

Today let’s talk about how to install MicroStrategy in Linux.

When you read the documentation, you see that it requires some changes in Linux parameters to install and run MicroStrategy correctly.

If you don’t change those parameters, you can get some errors like:

WARNING: maximum number of semaphore arrays 128 is low; please increase to 2048 or greater to use high performance share memory IPC.

Just execute this command below in a terminal to setup your environment:

echo 'kernel.sem = 250 32000 100 2048' >> /etc/sysctl.conf;echo 'kernel.shmmni = 4096' >> /etc/sysctl.conf;sysctl -p /etc/sysctl.conf;/sbin/sysctl -w vm.max_map_count=5242880

If you want, I have created a shell script file for bash that you can execute and do it for you:

install_mstr_parameters

Just download it, unzip and give permission to execute to the .sh (chmod +x install_mstr_parameters.sh).

Execute using this command:

./install_mstr_parameters.sh

That’s it.

Hope it helps.

 

God bless you.

Creating a Preview of your Links Using HTML Container

Hello there!

Today I’m going to talk about a cool features that works on Web using Interactive modeCss tooltip on links!

To do that you have to:

1. Create a screenshot of your dashboard/report and make the image small as possible.

Tips to take a screenshot:

If you use Windowsyou can use snippingtool: Open start menu -> Execute -> type: snippingtool
If you use Mac OS, you can use Grab: Command + space -> type: grab

2. Save this image inside images folder of your Microstrategy Web and name it as imagetooltip.png, for example:

For ISS the default folder is: C:\Program Files (x86)\MicroStrategy\Web Aspx\images
For J2EE the default folder is: webapps(of your java container)\MicroStrategy\images

3. Create a new Document in Web;

4. Create an HTML Container:

Click Insert -> Html Container

pic2

5. Paste this code below in your HTML Container (just double click on the HTML Container to edit it):

<style type="text/css">
a.tooltip {outline:none; }
a.tooltip strong {line-height:30px;}
a.tooltip:hover {text-decoration:none;} 
a.tooltip span {
 z-index:10;display:none; padding:14px 20px;
 margin-top:-30px; margin-left:28px;
 width:300px; line-height:16px;
}
a.tooltip:hover span{
 display:inline; position:absolute; color:#111;
 border:1px solid #DCA; background:#fffAF0;}
.callout {z-index:20;position:absolute;top:30px;border:0;left:-12px;}

a.tooltip span
{
 border-radius:4px;
 box-shadow: 5px 5px 8px #CCC;
}
</style>
<a href="#" class="tooltip">
 Dashboard A
 <span>
 <img  src="./images/imagetooltip.png" class="callout" />
 </span>
</a>

6. Execute your Document using Interactive Mode, mouse hover the link and you will see something like this:

pic3

If you want to change the name of the link, just change the  “Dashboard A” to another text in:

<a href="#" class="tooltip">
 Dashboard A
 <span>
 <img class="callout" src="./images/imagetooltip.png" />
 
 </span>
</a>

You can:

A. Customize the CSS;

B. Use an Image to substitute the text link;

C. Insert more links. To do that just replicate this extract of code below and change the Dashboard Name and the src=”” of the img tag with another image URL:

<br />
<a href="#" class="tooltip">
 Dashboard Name
 <span>
 <img class="callout" src="./images/imagetooltip.png" />
 
 </span>
</a>

That’s it!
If you need help with the customization or how to create more links, just post a comment below.

Hope it helps!
God bless you!

Hidding data labels in a graph

Hello there!

Today let’s talk about how to display only specific values for data labels in graphs.

Let’s go!

1. Create a new report with Year and Cost using Web:

pic1

2. Switch to graph:

pic1

3. Run your report. Go to Data->Advance Threshold Editor:

pic1

4. Create a new Threshold for Cost using Year = 2010:

pic1

5. Click on Cell formatting… (pic1)button. Format the number to Custom and use this value:

“[>0] ”

You have to type a space after the square brackets and remove the double “. So, if must be something like this

[>0]            <- Remove to type 1 space after everything

pic1

6. Apply the threshold. Now you won’t see the data label for 2010.

pic1

That’s it.

Hope it helps!

 

God bless you!

Adding filter in a Derived Metric

Hello there!

Today let’s talk about an excellent trick with derived metrics.

There is a way to insert a filter in your derived metric!

Let me show you an example:

1. Create a filter with Year = 2010 and save your filter as “2010“:

pic2

pic2

2. Create a blank report with Year and the metric Cost:

pic1

As you can see, I am fetching all years from database and displaying the Cost for each year.

2. Create a new derived metric:

pic2

3. Use a Sum formula, for example, like this:

Sum(Cost) {~ }

pic2

4. Insert <[name_of_the_filter]; @x; -> after the dimensionality of the metric. Where @x is the embedding method number:

In my case, I’m going to write: <[2010]; @2; -> 

pic2

In x you can use:

1 – Merge into new;

2– Merge report filter into metric;

3– Merge metric condition into report;

When you edit your metric and select Condition there is an Advanced… button where you can see those options.

You can also use + instead of the :

<[2010]; @3; +> – That means that you will “Remove related report filter elements”

<[2010]; @3;> – That means that you will not “Remove related report filter elements”

 

5. Now, edit your “New metric” and use the Fact Cost instead of the Metric Cost in the formula:

Was: pic2

Now: pic2

6. Save your metric;

7. Re-run your report:

pic2

As you can see, we have filtered only 2010 to the “New Metric“! So, you don’t need to create a lot of metrics with different filters to use in just 1 report, you can create a local filtered metric and reduce the amount of metrics created in your project…

Hope it helps!

God bless you!