Selection / datamart

Datamarts are small slices of the data warehouse. With datamarts you can select a subset of the data out of our database that is usually oriented to a specific business line or team. Datamarts improve end-user response time by allowing users to have access to the specific type of data they need to view most often by providing the data in a way that supports the collective view of a group of users.

Layers

Create individual access layers of your data warehouse environment oriented to specific business lines or teams.

Focus

Use condensed and focused views on business data.

Basis for UI elements

Supply data marts for reports, tables and charts or export them as Excel sheet.

Conjunction

Link data marts to build up cascaded updated perspectives and add stunning effectiveness to the workspaces.

Datamart DSL

SQL

Abstraction of recurring SQL statements for data selection in an easy to understand and guided DSL grammar. Always syntactically correct and performing.

Entity Model

MDX

Abstraction of complicated MDX query expressions for data slicing from OLAP cubes in an easy to understand and guided DSL grammar. Always syntactically correct and performing.

Business Process Integration

Use data persisted by BLIP such as workflow states, users, tasks, or decisions.

DSL Grammar