The OLAP Report Creation Structure

Alchemex 7.1

previous page next page

Home > OLAP Module > The OLAP Module Report Creation Structure

OLAP Module Report Creation Structure

The following diagram provides a step-by-step explanation of the OLAP 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 Microsoft 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 Microsoft Excel Templates

previous page start next page