Category Archives: Dashboards

Showing the execution date and time for the datasets and Cubes

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:

  1. Create a text;
  2. Add this auto-text: {&REPORTNAME:EXECUTIONTIME}

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!

Hiding menu options in a document

Hello there,

Have you ever wanted to hide a specific item from the document menu so the users won’t be able to use a specific feature? Some of the options can be removed at a user level, but what if you want to remove for a specific dashboard?

To do that, we can use a custom CSS code. In our example we will be removing the Export option. Let’s go!

  1. Open the document in web and add a HTML container to your document;
  2. Click on on the HTML container -> properties and formatting -> select HTML TEXT from the general menu;
  3. Double click on the HTML container and type this code:

<style type=”text/css”> .mstrmojo-Popup.mstrShortcutsListPopup .export, .mstrmojo-Popup.mstrShortcutsListPopup .zoom{display:none !important;}</style>

Voilà! The export button is no longer there.

If you want to remove other buttons, you just need to add the classes for the button inside of the <style> </style> tags and make sure to use the display:none !important.

To get the classes for the other buttons, you just need to use Chrome, for example, and inspect the button to get the classes.

Please, let you know if you need help inspecting elements.

God bless you!

Performance in Web

Hello there,

I read an important page from MicroStrategy that explains certain steps to improve performance in web using WebLogic.

Today, I’m sharing this page with you:

https://www2.microstrategy.com/producthelp/10.9/InstallConfig/WebHelp/Lang_1033/Content/InstallationConfig/Performance_based_setup_information.htm#ic_wuconfig_2660991842_1037510

I hope it helps.

God bless you!

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 the document with the current selections

Hello there,

Today I’ll explain how to export the current document with the current selections.

To export to PDF, you just have to create a hyperlink using:

ASPx:

Main.aspx?evt=3069&src=Main.aspx.3069&executionMode=3&messageID={&DOCUMENTMESSAGEID}

JSP:

mstrWeb?evt=3069&src=mstrWeb.3069&executionMode=3&messageID={&DOCUMENTMESSAGEID}

 

To export to Excel, you just have to use these urls:

ASPx:

Main.aspx?evt=3069&src=Main.aspx.3069&executionMode=4&messageID={&DOCUMENTMESSAGEID}

JSP:

mstrWeb?evt=3069&src=mstrWeb.3069&executionMode=4&messageID={&DOCUMENTMESSAGEID}

 

Hope it helps!

God bless you!