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!

Adding a prompt to a filter based on a metric

Hello there,

If you need to add a prompt to a filter based on a metric, you just need to do this:

  1. Create a filter using a metric in a report;
  2. In the parameters, just use Custom for the expression;
  3. Insert an Applysimple function. Ex.:

ApplySimple(“Dateadd(Month, Datediff(Month, 0, DATEADD(m, -#0, current_timestamp)), 0)”,? Months)

4.   In this example, I’m using a Months prompt to get an integer answer from the user to fill the #0 wildcard.

The trick here is the put the prompt name as: ? NAME_OF_THE_PROMPT

Hope it helps.

God bless you.

Managing Enterprise Manager with Command Manager

Hello there,

Today I would like to share a nice document from MSTR to explains how to manage the Enterprise Manager 10.x using Command Manager.

Sometimes it is frustrating managing EM using the Operations Manager, so MSTR created a way to use Command Manager instead.

Below is the link:

https://community.microstrategy.com/servlet/fileField?entityId=ka1440000009K0LAAU&field=Attachment__Body__s

 

Hope it helps.

 

God bless you.

 

How to easily remove elements from a selector

Hello there,

Today let's talk about a quick tip of how to easily remove elements from a selector in a document.

Let's say that we have a dropdown selector that has 4 elements: books, movies, games and dogs. Let's say that I don't want to display books in the list anymore but I still use this value in another grid/graph or another component.

To easily remove this element, you can do this:

1. Create another selector with the same attribute;
2. Target the selector that you don't want to display books anymore in the selector option;
3. Instead of using the selector as Include in the selector option, you should use Exclude.

Now, execute the document, select books in this new selector, go back to edit mode and on properties and formatting -> General uncheck visible.

You won't be seeing books in the selector anymore.

Hope that helps!

God bless you!

Creating a custom radio button in MicroStrategy Mobile to change panels

Hello there,

I would like to share this implementation that I did for mobile devices. In this case, I had to create a custom radio button using an HTML Container with CSS and JavaScript to change the panels of a panel stack.

The trick is to create anchors with your URL API parameters to change the panels based on the click of the radio button.

I have one function per button in this case, but you can improve it to use only one.

You just need to create an HTML Container and past this code below:

<!DOCTYPE html>

<html lang="en-gb">

<head>

<meta charset="UTF-8">
<style>

.buttons{

margin-bottom : 1.5em;

}

input[type=radio   ]:not(old){

width     : 2em;

margin    : 0;

padding   : 0;

font-size : 1em;

opacity   : 0;

}

input[type=radio   ]:not(old) + label{

display      : inline-block;

margin-left  : -2em;

line-height  : 1.5em;

}

input[type=radio   ]:not(old) + label > span{

display          : inline-block;

width            : 0.875em;

height           : 0.875em;

margin           : 0.25em 0.5em 0.25em 0.25em;

border           : 0.0625em solid rgb(192,192,192);

border-radius    : 0.25em;

background       : rgb(224,224,224);

background-image :    -moz-linear-gradient(rgb(240,240,240),rgb(224,224,224));

background-image :     -ms-linear-gradient(rgb(240,240,240),rgb(224,224,224));

background-image :      -o-linear-gradient(rgb(240,240,240),rgb(224,224,224));

background-image : -webkit-linear-gradient(rgb(240,240,240),rgb(224,224,224));

background-image :         linear-gradient(rgb(240,240,240),rgb(224,224,224));

vertical-align   : bottom;

}

input[type=radio   ]:not(old):checked + label > span{

background-image :    -moz-linear-gradient(rgb(224,224,224),rgb(240,240,240));

background-image :     -ms-linear-gradient(rgb(224,224,224),rgb(240,240,240));

background-image :      -o-linear-gradient(rgb(224,224,224),rgb(240,240,240));

background-image : -webkit-linear-gradient(rgb(224,224,224),rgb(240,240,240));

background-image :         linear-gradient(rgb(224,224,224),rgb(240,240,240));

}

input[type=radio]:not(old):checked +  label > span > span{

display          : block;

width            : 0.5em;

height           : 0.5em;

margin           : 0.125em;

border           : 0.0625em solid rgb(115,153,77);

border-radius    : 0.125em;

background       : #000;

}
</style>

<script>

function clickLvl() {

var event = document.createEvent('MouseEvent');

event = new CustomEvent('click');

var a = document.getElementById('lvlLink');

a.dispatchEvent(event);

}

function clickVP() {

var event = document.createEvent('MouseEvent');

event = new CustomEvent('click');

var a = document.getElementById('vpLink');

a.dispatchEvent(event);

}

function clickDivision() {

var event = document.createEvent('MouseEvent');

event = new CustomEvent('click');

var a = document.getElementById('divisionLink');

a.dispatchEvent(event);

}

function clickDepartment() {

var event = document.createEvent('MouseEvent');

event = new CustomEvent('click');

var a = document.getElementById('departmentLink');

a.dispatchEvent(event);

}

function clickClass() {

var event = document.createEvent('MouseEvent');

event = new CustomEvent('click');

var a = document.getElementById('classLink');

a.dispatchEvent(event);

}

</script>

</head>

<body>

<a id="lvlLink" href="mstr://?evt=2048076&psName=ttl|comp&pName=Panel3531|Panel3531"></a>

<a id="vpLink" href="mstr://?evt=2048076&psName=ttl|comp&pName=Panel3535|Panel3535"></a>

<a id="divisionLink" href="mstr://?evt=2048076&psName=ttl|comp&pName=Panel3534|Panel3534"></a>

<a id="departmentLink" href="mstr://?evt=2048076&psName=ttl|comp&pName=Panel3533|Panel3533"></a>

<a id="classLink" href="mstr://?evt=2048076&psName=ttl|comp&pName=Panel4483|Panel4431"></a>
<div class="buttons">
<div>

<input id="radio1" type="radio" name="radio" value="1" checked="checked" onclick="clickLvl()"><label for="radio1"><span><span></span></span>Button 1</label></div>
<div>

<input id="radio2" type="radio" name="radio" value="2"><label for="radio2" onclick="clickVP()"><span><span></span></span>Button 2</label></div>
<div>

<input id="radio3" type="radio" name="radio" value="3"><label for="radio3" onclick="clickDivision()"><span><span></span></span>Button 3</label></div>
<div>

<input id="radio4" type="radio" name="radio" value="4"><label for="radio4" onclick="clickDepartment()"><span><span></span></span>Button 4</label></div>
<div>

<input id="radio5" type="radio" name="radio" value="5"><label for="radio5" onclick="clickClass()"><span><span></span></span>Button 5</label></div>
</div>
</body>

</html>

Each input is a different radio button.

Just let me know if you need help with this code.

Hope it helps.

God bless you!