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.
Create individual access layers of your data warehouse environment oriented to specific business lines or teams.
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.
Link data marts to build up cascaded updated perspectives and add stunning effectiveness to the workspaces.
Abstraction of recurring SQL statements for data selection in an easy to understand and guided DSL grammar. Always syntactically correct and performing.
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.