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!

MicroStrategy 10.11

Hello there,

Microstrategy has released a new version: MicroStrategy 10.11

If you want to check what’s new, you can use this link for that:

https://www.microstrategy.com/us/company/press/microstrategy-further-transforms-visual-data-discovery-with-microstrategy-1011

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!

MicroStrategy Dataset Connector

Hello there,

Microstrategy has a nice article showing how to fetch reports or cubes from another project or environment.

If you want to take a look at the article, please refer to the link below:

https://community.microstrategy.com/s/article/MicroStrategy-Dataset

Hope it helps.

God bless you!

Creating a dynamic constant metric using prompts

Hello there,

Sometimes we need to create a constant to compare some numbers with this constants.

Like:

Profit < CONSTANT

And in this case, this constant can be changed by the user.

To create a dynamic constant you can use this simple example:

  1. Create a numeric prompt and name it as promptTest
  2. Create a derived metric as Constant Metric in your report like:Max(?[promptTest]) {~+}
  3. Create the case metric like this: case(profit < [Constant Metric], 1,0)

Now you have a dynamic constant prompt metric.

I hope it helps.

God bless you