Author Archives: Felipe Vilela

Connect Tableau to MicroStrategy

Hello there,

Did you know that using REST API you can connect Tableau to any report/cube in MicroStrategy?

You can check it in this URL:

https://community.microstrategy.com/s/article/MicroStrategy-Dataset-Connector-for-Tableau?ui-force-components-controllers-recordGlobalValueProvider.RecordGvp.getRecord=1&r=8

Hope it helps.

God bless you!

Adding more users to Integrity Manager’s tests

Hello there,

Have you ever needed to add more than 50 users using Integrity Manager? Integrity manager caps the users to 50 users. To add more, it is simple. You just need to do this:

  1. Create a test with 50 users and save it;
  2. Open the MTC file and edit it;
  3. You have to add the new users manually like this:

<Login>TestUser51</Login><Authentication_Mode>1</Authentication_Mode>

That needs to be added before theĀ <Project> tag. So, you can add as many users as you want, you just need to add these tags in this order. First <Login> then <Authentication_Mode>. Remember to change the Login name to use the real users that you have created.

I hope it helps.

God bless you!

Retaining selector selections using URL API

Hello there,

Today a quick tip: How to retain the selections that you did while going to a different document using URL API.

To do that, you simply add these parameters/values to your URL:

&originMessageID={&DOCUMENTMESSAGEID}&selectorMode=2

or selectorMode=1

It depends if you want to use the selectors to match by source attribute or source name.

I hope it helps.

God bless you!

How to get the components with your custom CSS code

Hello there,

Today, let me show you a quick way to get the components in the HTML and use it in your CSS custom code.

The easiest way is to use Google Chrome, right click on the component and use INSPECT.

Once you are inspecting the component, try to find code where the component begins.To do it, mouse over the DIVs and check where it highlights in the document. Find the first node and keep going down until you find the first DIV with a “k” property.

When you find it, copy its value and you can refer to this component using a CSS code like this:

div[k=W6B9C3207D3764C09A234024F4CEFF5B0] {
display: none !important;
}

Now you can format this element using the a CSS code within your HTML Container.

I hope it helps.

God bless you!

Conditional Formatting for all components

Hello there,

Everybody knows that we can’t add a conditional formatting for grids/graphs or panel stacks, for example.

I’ve found a way to do it!

The solution is pretty simple. Add an HTML container, insert your CSS to customize the components and then you use a conditional formatting in the HTML Container to hide it based on a specific condition.

What it does is, if the HTML Container is visible, it applies the CSS, if not, it doesn’t.

Hope it helps.

God bless you!

Creating a shell script to manage the IS service

Hello there,

Today a quick tip that can help to manage the IS if it is down.

To do that, just create a new file .sh with these lines:

output=`/opt/MicroStrategy/bin/mstrctl -s IntelligenceServer gs` #use your path

if [ `echo $output | grep -c “run” ` -gt 0 ]; then check=1; else check=0; fi
if [ $check -eq 0 ]; then
if [ `echo $output | grep -c “stopped” ` -gt 0 ] || [ `echo $output | grep -c “terminated” ` -gt 0 ]; then
/opt/MicroStrategy/bin/mstrctl -s IntelligenceServer start #use your path
fi
fi

Save the file and make sure to change it to an executable file:

chmod +x filename.sh

Where filename is the name that you used above.

Now, make sure to schedule it using crontab or other scheduler tool.

Hope it helps

God bless you