Reports


Clicking the Reports button int the Repexel menu will open the Reports taskpane. On the top there is a dropdown list, that will show all the available reports for you. Default/First Report in the list wil be initially selected and the Time and Field Filters are

Periods Filter

Under the Report selection dropdown menu you will see the Time filter section, where you can select from which time periods you want the report.

You can choose the lenght of a one repoting parameter in the firts time setting field. The default period length is the period length used in reporting. However you can use period lemght than is longer tha the default. Period lengths: Year, HalfYear (H1, H2), Quarter of a year(Q1, Q2, Q3, Q4), Month, Week, Day, Hour. F. ex if the reporting period length is month, then you can choose Year, HalfYear, Quarter in addition to the default Month.

Field Filters

Under the time filter section there is a filterin section for Fields with dimensions. The Dimensions of the table is listed in the Filters section and beside each of the Dimension Fields there is a Filter-button (). Clicking the Filter button will open/close the list of valid Dimension Values of the Field. You can do easily additional and more detailed filtering in the Pivot table, that will be generated based on the query generated with these Time and Field filters.

Loading the report will generate pivot-table to the active sheet. On the sheets you have to activate the position where you want the report to emerge. Pivot-table will require some space and the app will generate an error message if there is overlapping tables and it can generate the pivot-table.

After the report-data is loaded from the database pivot-table taskpane will show all the fields of the report. If a field (dimension) has a hierarchy, the hierarchy levels will be inidicated by a number after the fields name.

PivotTable data

PivotTable data is downloaded a separate worksheet and is named according to the name of the Repexel table witk a "PD_" prefix. You can use the same datasheet also to additional PivotTables and PivotCharts.