Author Archives: Felipe Vilela

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

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:

https://demo.microstrategy.com/MicroStrategy/servlet/mstrWeb

User: guest

Pwd:

*The PWD is blank.

Hope it helps!

God bless you!

Subtotal on top in VI 10

Hello there,

Today let’s talk about a quick tip: “How to move the grid subtotal to top in Visual Insight 10”.

In version 9.x we couldn’t display the subtotal on top but in version 10 it is quite simple.

To change the subtotal position you just have to:

  1. Click on the header of a column and select Subtotal. Choose the proper subtotal that fits your needs;
  2. Scroll the grid all the way down until you see the total and then right click on it and select “Move to top”;

 

pic1

 

I hope it helps.

God bless you!

Data Trends: Linguagem Natural e Mapas 3D no MicroStrategy para otimizar a leitura e visualização de dados

Hello there,

 

I’m here to announce that Data Meaning will be presenting two great implementations in the next Microstrategy conference in São Paulo: Natural Language and 3D Maps. This is a great opportunity to see one of the top companies in the world, that works with BI, presenting high quality integrations in Microstrategy.

If you speak portuguese and want to see some great things that Data Meaning has been doing, check out a short description of what you will see at the conference:

Como estender as funcionalidades do MicroStrategy para atender as tendências de mercado?

Poder interagir com a plataforma através de comandos de voz (Natural Language Processing) e visualizar mapas em 3 Dimensões são algumas das funcionalidades que a Data Meaning estará apresentando nesse evento. 

Caio Gouveia, co-founder of Data Meaning Services Group will be presenting both sessions. Check out a little bit of his background:

Caio Gouveia, natural de São Paulo, começou sua carreira na MicroStrategy EUA em 2000 como responsável pelo suporte técnico da América Latina. Em 2004, fundou a Data Meaning, empresa baseada na Florida e especializada em serviços da MicroStrategy. Como parceiro Premium, tem atendido clientes no mundo inteiro e em diversos segmentos. Há dois anos, a Data Meaning foi convidada a criar o design e desenvolvimento do aplicado móvel da MicroStrategy World e vem dando continuidade a mais esta parceria.

I hope seeing you there.

God bless you!

MicroStrategy Dossier

Hello there,

Microstrategy Dossier is fantastic! With this new MicroStrategy tool you can deliver your discoveries very fast and easy.

For those who have a MAC OS, you guys can download an early adopter version in this url:

https://download,microstrategy.com

Just go to Features Releases -> version 10.9.0 -> MicroStrategy 10.9 Workstation Early Adopter

 

There is also a Windows version of the same Workstation. Just keep in mind that it is still in an alpha release, so it might contain bugs.

Hope it helps.

God bless you!