Introduction to Advanced Reporting

Advanced reporting features build on the concepts and procedures presented in the Basic Reporting Help by providing more technical details and advanced options for report design. Advanced reporting allows you to create more sophisticated reports using advanced report functionality such as data marting and Freeform SQL, and advanced objects such as level metrics, conditional metrics, prompted filters, custom groups, and drill maps.

Examples of advanced reporting in action include:

• The contribution to revenue and profit of products bought by your top customers
• The quarterly revenue, split by regions
• The inventory for time periods you select at report run-time
• A comparison of new customers this year to last year
• The revenue for electronics in the first quarter of 2023 and music in the third quarter of 2023, or other attribute combinations you can select at report runtime
• Allowing users to drill only to the call center level, not the employee level, for a salary report

Before You Begin

To work with advanced reporting functionality, you must have a working project containing schema objects such as attributes and facts. For information on creating projects, facts, and attributes, refer to the Project Design Help. Many of the facts, attributes, and other objects used in the examples in this guide are available in the MicroStrategy Tutorial project.

Warehouse data in the sample MicroStrategy projects is updated regularly, and these changes are reflected in the documentation whenever possible. However, the sample reports, documents, objects, and images in this guide may display warehouse data that no longer appears in the software.

For steps to import data, as well as steps to link the imported data to project attributes, see the Import Data chapter of MicroStrategy Web Help.