The OLAP Report Creation Structure

Alchemex

previous page next page

Home > Analysis Module > The Analysis Module Report Creation Structure

Analysis Module Report Creation Structure

The following diagram provides a step-by-step explanation of the Analysis Module report creation i.e. creating a report that extracts from a local cube (.cub file) as opposed to directly from the source database and renders directly to a pre-configured Excel Template. The component steps include:

  • Database Connection

  • Creation of a Container based on database Tables and Fields

  • Create a Date Dimension table

  • Creation of Dimensions and Measures

  • Creation of the .cub file

  • Creation of BI reports

  • Saving the report output into Excel Templates

previous page start next page