Options for data operations in reports

Genero Studio contains several options for performing data operations such as duplication, grouping, and aggregation. Your choice is determined by your requirements, including the type of data source, the flexibility of access, and importance of efficient performance.

  • Use a business graph in your report design if:
    • You want to display a simple table or chart.
    • The data has only one or two dimensions.
  • Use a pivot table in your report design if:
    • You want to display a simple table or chart.
    • The data has many dimensions.
  • Use a report schema transformation if:
    • You want multiple reports, some using detailed data from the data source, and others using only simple data.
    • You want multiple reports that group and aggregate the detailed data in different ways.
    • The data source is a fixed third-party source, but you need to group and aggregate the data in a different way than is supplied by the source.
    • The data is needed more than once, but issuing two SQLs to retrieve it is not an option because the data cannot change between queries.
    • Performance lags are acceptable to gain greater flexibility.