Overview
OLAP
Designer
ETL
Configurator
Security
Configurator
Technology - ETL
CUBOT Configurator is a core module that helps a business analyst configure: Metadata including measures and dimensions.

Org structure and access - users, groups, roles, access matrix. Metadata provides a semantic layer over the data warehouse for the business users to understand the Business Intelligence system in business terms rather than tables and column names.

Configurator also provides a facility to input the organizational structure with access rights. The user interface is designed to be used by Business Analysts rather than IT specialists, this gives the ownership of metadata, org structure and access rights to the business. It also helps to remove ambiguities of translating business requirements to technical designs.
Features
  • Metadata configuration. 
    • Semantic layer over Data Warehouse.
    • Defined at a measure or dimension level.
    • Measure can be a formula from multiple tables e.g., currency conversion.
    • Configurable by Business Analysts with limited IT background. Used uniformly across CUBOT.
  • Org Structure and Access configuration: 
    • Users can be organized into groups reflecting the org chart.
    • Roles are defined at measure or dimension level.
    • Users or groups can be assigned multiple roles and vice versa.
    • All CUBOT reports will use this access matrix to filter out dimensions and measures.
    • All CUBOT reports will use this access matrix to filter out dimensions and measures.
 
Benefits
  • Business Intelligence configured by Business Analysts.  Configurator gives the power of CUBOT directly to Business Analysts and users with minimal IT support allowing them to define the entire structure of reporting and analysis.
  • Secure access.  Information is distributed on a need-to- know basis through accurate and granular definitions.
  • Cube design and set up automated. CUBOT handles cube creation internally and provides logical cube views with proper access to business users. This eliminates IT overheads and ensures high performance and response times while providing a complete picture of the business.
Copyright Robust Designs 2007. All Rights Reserved.