Hello there,
Have you ever wanted to show the last execution time or the last refreshed time for a cube in a document?
To do that you just need to:
Where REPORTNAME will be the name of your report or Cube. For example, if you have a report with the name: Report Analysis, the auto-text will be {&[Report Analysis]:EXECUTIONTIME}
God bless you!
Hello there,
If you are out of ideas ideas for your dashboard, Microstrategy has a nice gallery that you can check to help you with that:
https://community.microstrategy.com/s/gallery?tabset-89baf=2
Hope that helps.
God bless you!
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:
Hope it helps!
God bless you!
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:
3. Save in your computer;
4. Go to the project that you want to import your document and click on Tools -> Import Document Template…
A map window will appears. You have to select a report for each original report before mapping the attributes/metrics.
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.
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!
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:
3. Go to Performance Configuration
3. Enable these logs:
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!
Hello there!
Today I’m going to talk about a cool features that works on Web using Interactive mode: Css 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 Windows, you 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
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:
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!
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
2. Right click on the attribute and choose Grouping Properties…
3. Check Sheet break between groups
4. Export to Excel and choose Expand Page-by
When you open in excel you will get something like this:
Each element has one sheet in the exported excel file.
I hope it helps you!
God bless you.
