Monthly Archives: August 2016

Problems with MicroStrategy Mobile Connectivity? Fiddler can help you

Hello there,

I found an excellent TN that explains a way to troubleshoot MicroStrategy Mobile connectivity issues.

Just follow the steps described in this TN:

https://community.microstrategy.com/t5/Miscellaneous/TN38017-How-to-use-Fiddler-Web-Debugger-to-troubleshoot-iPad-and/ta-p/188200

Hope it helps!

God bess you!

Calculate Derived metrics at the level of all attributes in the report objects

Hello there,

I found an excellent TN that can save some time. Maybe you already have to create a derived metric that was calculate using all attribute that you have in the report objects and not in the grid and you couldn’t find a way to do that. There is a hidden option that you can enable to allow that option.

You just have these steps:

 

  • Locate the XML file sys_defaults.xml which can be found in the path C:\Program Files (x86)\MicroStrategy\Web ASPx\WEB-INF\xml.
  • Right-click on this file and edit it using a text editor.
  • Search for the showAggFromBaseOnMetricEditor flag and change it from the default value of 0 to 1.
  • Save and close.
  • Restart Web Server.
  • Log into Web, create a new report with the desired attributes and metrics, run the report, and create a new Derived Metric.
  • As can be seen in the screenshot below, the Aggregate from base setting is now available, whereas previously it did not appear.
  • Note that this setting can only be applied in Web, however, it will take effect when reports are run via Desktop or Web.
  • This setting can be used to calculate a Derived Metric at the level of an attribute that is in the Reports Objects window but not on the grid.

Hope it helps.

God bless you

 

Copied from https://community.microstrategy.com/t5/Web/TN41447-The-ability-to-create-a-Derived-Metric-that-calculates/ta-p/191356

 

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!

Using a “case” function multiple times

Hello there,

Today a quick tip about how use the case MicroStrategy function multiple times. To do that you just have to:

  1. Create a metric
  2. Add an expression like this:

Case(([metric] = 1),‘true’, ([metric] = 2), ‘true’, ‘false’)

Blue: The condition

Green: When the condition is true

False: When the condition is false

This way, you can add as many conditions as you need. Just replace the ‘false’ part with a new condition.

Hope it helps.

 

God bless you

More hands

Hello there,

I’m very pleased to announce that the blog is going to have one more author. His name is Sandeep and you can find some info about him below:

Sandeep Kumar HR
Experience: 6 Years with BI
Certification: CRD, CDMD, CPD, MCD
Location: India

Thank you for helping this blog, Sandeep.

God bless you!

Technical Reviewer of the book Mastering Business Intelligence with MicroStrategy

Hello there!

I’m really glad to announce that I was a technical reviewer of the book: Mastering Business Intelligence with MicroStrategy.

If you want to take a look at the book, you can see it here: https://www.amazon.com/Mastering-Business-Intelligence-MicroStrategy-Anoshin/dp/1785884409?ie=UTF8&ref_=pe_1098610_137716200_cm_rv_eml_rv0_dp

 

God bless you!