Setup Metrics, Dimensions, Roles - simpleBI Designer™
Overview
A powerful simpleBI component used by Administrator to configure business metrics and business dimensions and manage system security. It is transparent to the end users.
How is it different ?
It has a powerful visual interface through which users can configure business metrics and dimensions with simple drag and drops, with various helpful features.
simpleBI Designer™ allows Administrator to write SQL querys and embed them in metrics/dimensions configuration. This provides for great flexibility in dealing with complex data structure.
As a result of all this, the time you have to spend on configuration and set-up is minimal; Thus, customers no longer have to wait months after months to see the results of a BI project.
simpleBI Designer™ Feature List
- No IT involvement - Supports a full Self Service model
- Zero infrastructure cost - No need for a BI Server
- No code; Business Metrics and Dimension created using powerful visual interface
- No Cubes; Supports any complex data model
- Allows freely navigating highly normalized data models, star/snow-flake schemas
- Supports slowly changing (Type 1 and 2) Dimensions
- Dynamic Views - Use a SQL output as a table to create metric/dimension
- Facts support
- Allows unlimited filters and conditional operators
- Expression support for complex calculations
- A number of embedded data aggregation algorithm
- Accessing data with ADO/ODBC
- Current release supports mySQL, Oracle, SQL Server, PostgreSQL and Teradata