Tag Archives: Dashboard

Performance on Dashboards

Hello there!

There are 2 very good TNs that talks about performance on dashboards. I’m sharing those with you guys. Below are the links:

http://community.microstrategy.com/t5/Web/TN31503-Data-Preparation-at-the-Intelligence-Server-level-for/ta-p/182414

http://community.microstrategy.com/t5/Web/TN31462-Client-Rendering-Optimizations-for-Dashboard-Performance/ta-p/182373

 

Hope it helps!

God bless you!

Exporting documents without Object Manager

Hello there!

Today let’s talk about how to export a document without Object Manager.

Exporting documents using Developer is very good in cases that you have different datasets in the destination project. When you export the template, you will be able to map a different dataset for each previous dataset that you had before.

To do that you just have to:

  1. Go to MicroStrategy Developer and click on the document that you want to export.
  2. Go to Tools -> Export Document Template…;

pic1

3. Save in your computer;

4. Go to the project that you want to import your document and click on Tools -> Import Document Template…

pic1

A map window will appears. You have to select a report for each original report before mapping the attributes/metrics.

pic1

After you chose each dataset you will be able to map the attributes/metrics. You just have to drag-n-drop each object to it’s respective object.

pic1

Notice that I used a dataset that don’t have all objects from the original dataset. You must use one that has exactly or more attributes/metrics.

Just let me know if you have any question.

Hope it helps.

God bless you!

How to monitor Document data preparation

Hello there!

Today I’m going to teach you how to monitor document data preparation. This is a good thing to troubleshoot document performance.

To do that, you just have to:

1.Open MicroStrategy Diagnostics and Performance logging

You can find it in Start > Programs > MicroStrategy > Tools

2. Choose CastorServer instance:

pic

3. Go to Performance Configuration

3. Enable these logs:

pic

Just save and you can now trace problems in DSSPerformanceMonitor log file. You can find those log files in C:\Program Files (x86)\Common Files\MicroStrategy\Log.

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!

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.