Advanced reporting components

A report is an object that provides a multi-perspective view of our data. Reports are the starting point for further business investigations and decisions. Advanced reporting allows us to create complex and sophisticated reports using several advanced objects such as advanced metrics, transformations, consolidations, custom groups, freeform SQL, and intelligent cubes.

Before you begin with this chapter, you should be familiar with basic reports and components.

• Real-life scenarios using advanced reporting features include:
• Top N products with highest sales
• Sales of current year versus previous year
• Yearly revenue splits by territory
• Sales based on seasons