Category Archives: Dashboards

Performance on Dashboards

Hello there!

There are 2 very good TNs that talks about performance on dashboards. I’m sharing those with you guys. Below are the links:

http://community.microstrategy.com/t5/Web/TN31503-Data-Preparation-at-the-Intelligence-Server-level-for/ta-p/182414

http://community.microstrategy.com/t5/Web/TN31462-Client-Rendering-Optimizations-for-Dashboard-Performance/ta-p/182373

 

Hope it helps!

God bless you!

Exporting the document with the current selections

Hello there,

Today I’ll explain how to export the current document with the current selections.

To export to PDF, you just have to create a hyperlink using:

ASPx:

Main.aspx?evt=3069&src=Main.aspx.3069&executionMode=3&messageID={&DOCUMENTMESSAGEID}

JSP:

mstrWeb?evt=3069&src=mstrWeb.3069&executionMode=3&messageID={&DOCUMENTMESSAGEID}

 

To export to Excel, you just have to use these urls:

ASPx:

Main.aspx?evt=3069&src=Main.aspx.3069&executionMode=4&messageID={&DOCUMENTMESSAGEID}

JSP:

mstrWeb?evt=3069&src=mstrWeb.3069&executionMode=4&messageID={&DOCUMENTMESSAGEID}

 

Hope it helps!

God bless you!

Change the image layout map dynamically

Hello there,

Today let’s talk about how to change the image layout map dynamically.

Let’s imagine that we need to use 2 maps, one for US and another one for CA and you have a country selector that when you change the element to US, you want to see US map and the same for CA.

To do that, you just have to:

  1. Create a new attribute and add an expression like this: ApplySimple(“case when #0 = ‘US’ then ‘VisFramework/map/us.html’ else ‘VisFramework/map/ca.html’ end”; country_name)

As you can see, we have this applysimple with a case to test when the country is US or CA, then we are adding the string and pointing where are the image maps in Microstrategy Web/Mobile.

Now you have to rename the attribute form to “SHAPEFILE”, like the image below:

pic1

2. Save your attribute. Open the document and add that attribute with your desired attribute, like this:

pic1

3. Configure it to use the Image Layout Widget:

pic1

Now, when you select US or CA in your selector, it will automatically change to the right map.

Hope it helps!

God bless you!

Custom Visualization Gallery

Hello there!

MicroStrategy has a place that there are a lot of custom visualizations for version 10 already built.

You can find these graphs in the link below:

https://community.microstrategy.com/t5/Custom-Visualization-Gallery/bg-p/vizgallery

 

God bless you!

 

Adding D3 graphs to Visual Insight 10

Hello there!

If you want to import a D3 in MicroStrategy, you can follow the steps that are presented in this link below:

https://lw.microstrategy.com/msdz/MSDL/10/docs/projects/VisSDK_All/default.htm#topics/HTML5/CreatingCustomD3Visualizations.htm

It is pretty easy to download an existing D3 graph and use in Visual Insight 10.

Just let me know if you had any issues.

God bless you!