Preview the new community

We’re making it easier for you to find answers and network with others. Visit our preview site and let us know what you think.

Tips and Tricks

After a report's results are displayed, you may need to further restrict the data displayed without changing how the calculations were performed. You can limit the data displayed in a report by specifying maximum and minimum values for a given metric. These maximums and minimums determine which rows of a result set are displayed in the report, and are called report limits.


You can display your data as locations on an interactive map using the ESRI Map visualization. You can display the locations in a density map, which helps you understand patterns and trends for many geographic locations by displaying color gradients based on the concentration of geographic data


How to create a nested metric

by Pioneer Sdobbs Pioneer on ‎07-26-2016 06:04 PM (946 Views)

Nested metrics, or nested aggregation metrics, are a type of simple metric, where one aggregation function is enclosed inside another.


Parallel SQL Execution Intermediate Table Type property determines the type of intermediate table that is used when Parallel Query Execution is employed for reports and Intelligent Cubes. 


How to define allowed URLs for data importing

by Pioneer Sdobbs Pioneer on ‎07-18-2016 11:45 AM (748 Views)

In MicroStrategy 10.4, you can can restrict the type of URL that is allowed for data inporting in MicroStrategy Web. An administrator can define a list of allowed URLs, also called a whitelist, for importing data by the File from URL and Public Data options. During the import process, URLs provided by the user are compared against the whitelist and any URL that does not match any of the whitelist entries is rejected. Defining a list of allowed URLs provides control over the data coming into the MicroStrategy project.
For the strongest security, the whitelist should contain the minimal set of URLs that are needed for users to import data. In other words, the whitelist should be as restrictive as possible.
When defining the whitelist, you can specify entries for all the protocols supported by data import: http, https, ftp, and file


How to create thresholds for metrics and attributes

by Pioneer Sdobbs Pioneer on ‎07-12-2016 06:49 PM (1,144 Views)

A threshold is made up of two parts: the condition, and the formatting that will be applied to the values that meet the condition. Once a metric value meets the threshold condition, the formatting is automatically applied to the value. You can also apply thresholds to attribute elements, which allow for the formatting of entire rows when the values within the rows meet the specified condition. For thresholds on attributes, they can be applied on grids and graphs visualizations within your dashboard. 


How to add a Map visualization to a dashboard

by Pioneer Sdobbs Pioneer on ‎07-12-2016 06:48 PM (334 Views)

Maps allow you to view your data as markers on an area within a map, providing additional information about your data in a certain area. To use maps in a dashboard, the dashoboard's dataset must provide the geolocation of each map marker. 



How to create a derived attribute on a dashboard

by Pioneer Sdobbs Pioneer on ‎07-07-2016 10:52 PM (1,846 Views)

Derived attributes in dashboards are based on dataset objects that are already in your dashboard, and work the same way as any other attribute. Derived attributes can change the data type of an existing attribute, change a metric to an attribute, or create additional date-related attributes (when you have any date attributes in your dashboard). 


How to create a derived metric on a dashboard

by Pioneer Sdobbs Pioneer on ‎07-07-2016 10:50 PM (360 Views)

Derived metrics are metrics that you created based on existing objects in your dashboard.  A derived metric performs a calculation on the fly with the data available on a dashboard, without re-executing the dashboard against the data source. There are two ways to create derived metrics: you can create a basic derived metric on a visualization or you can a basic derived metric on a dashboard. 


How to create a derived metric on a report

by Pioneer Sdobbs Pioneer on ‎07-07-2016 10:49 PM (328 Views)

When viewing a report in MicroStrategy Web, you can create a derived metric based on existing metrics on the report. Derived metrics are not metric objects that can be re-used in other MicroStrategy reports and documents. They are metrics that are saved and displayed only on the specific report on which they are created.