Monthly Archives: January 2018

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:

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.



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

Try MicroStrategy Dossier for free

Hello there,

If you want to test MicroStrategy Dossier, MicroStrategy provided a web server that you can use to create some dossier dashboards.

You just need to enter this url:

User: guest


*The PWD is blank.

Hope it helps!

God bless you!