An app contains of datasets and components. The most common component is the grid component which is similar to a pivot table common in spreadsheet applications.
Dataset
A dataset contains of one or several valuetypes and can be used on one or more pages. Some important parts of a dataset configuration are described below.
Initial Values
Initial Values are configured to (1) show cells, and (2) open cells for input. One common use for this is to e.g. show all periods even if they do not all have values from the valuetypes in the dataset
Locked Values
Values in a dataset (or cells) can be locked for input. One common use case for this is to lock historical periods that contains actual values while keeping future periods open for editing.
Dataset filter
Filters can be added on the dataset level meaning data will not be visible in components using the dataset. This shall not be mixed up with app filters (described below).
Included dimensions and propertys
A dataset can never have data on a lower granularity level than the set of dimensions shared across all included valuetypes. The checkboxes marked with (A) below shows how to select which dimensions and valuetypes that will be included in the dataset. Only dimensions and propertys selected here can be shown on the pages using the dataset. The aggregation config marked with (B) determines how data will be aggregated across dimensions excluded in the dataset.
End-User Components
Grid component
A grid component (or page) is a pivot-table like grid. The layout (groupings, intermediaries, pivots) can be configured in the admin page but also edited via grid settings in the end-user interface (see screenshot below). When a layout has been edited and saved via grid settings, changes from the admin interface will not be applied unless the layout is reset in grid settings.
Action component
Action components can be configured from the admin interface. These components can for example be used to add or remove data.
App filters
Filters can be configured to be hidden or available in apps. This filter is applied on the dataset (after dataset filters) and does not persist efter closing an app.