A dimension is the name we use for a business category such as customer, no rx territory, ampoule product, stuff or any predefined time period (YTD, Month to Date, etc.) A dimensional design is a structure that yields a unified and consistent view of these business categories (or dimensions). This type of design is extremely beneficial for organizations where information is distributed across different and sometimes inconsistent departmental and divisional databases.

Business Intelligence News