Analyzing data on a report

When reports return large amounts of data, it can be difficult to understand what the data is telling you. Several MicroStrategy tools can help you analyze large amounts of data more quickly.

The following analysis tools are available in MicroStrategy Developer:

• Sorting a report

• Finding values in a report

• Displaying outline results, to expand and collapse sets of data

• Grouping report data: Page-by

• Report limits

• Determining how metric data is combined: Metric join types

• Designating an evaluation order

• Applying subtotals to a report

In addition, you can also perform the following tasks to analyze data:

• Add or remove objects from reports without re-executing against the warehouse

• Set scale values for a graph report

• Refresh a report

• Merge header cells on a report

• Lock report row headers

• Lock report column headers

• Filter report data in a View filter

• Change an object's name on a report

• Move rows and columns in a report

• Resize column widths and row heights

• Apply banding

• Apply thresholds to display conditional formatting

• Drill on a report

• Remove data from a report