Overview
OLAP
Designer
ETL
Configurator
Security
Designer
Technology - Data Warehouse
A data warehouse is a database organized to hold information in a structure that best supports reporting and analysis. CUBOT supports multiple star schemas with enhancement support for multiple dimension levels. CUBOT Designer helps visualize and create the schema as the basic component that drives the whole implementation.
Features
  • Schema Definition   Define a star schema using a simple to use GUI and view the resulting schema graphically. Once a schema is defined it is uniformly used across all Cubot functions ensuring a consistent view of the data.
  • Create and maintain tables. Creation and maintenance of tables is straight forward and doesn't require extensive database training as most of the functions are automated.
  • Metadata. A central metadata definition allows for the unified definition of metadata across reports, listings and enquiry screen.
  • Hierarchies. Cubot hierarchies are optional and typically used for easy geographical navigation between maps: click from a world map to a regional, country or city map.
 
Benefits
  • Ease to configure and use. The user interface is easy to use and can be understood by Business Analysts, so there is no gap between IT and Business regarding the design.
  • Transparent definitions. CUBOT meta data and schema are uniformly applied throughout the application in an transparent manner, without the need to redefine relations in different parts of the application.
  • Web based. Like all parts of CUBOT, Designer is fully web based.
  • Easy drilldowns. Drilldown easily to the minutest detail in just a few clicks for root cause analysis and error correction.
  • Faster and Simpler.  Its faster and simpler to design in CUBOT reducing the chances of errors.
Copyright Robust Designs 2007. All Rights Reserved.