Significance
of OLAP Features:
- Execution
Time of the Query is minimized to a significant level after using OLAP
features.
- Less
complex query can be formulated by OLAP functions.
Description
of the table [PRDT_RECVD_DT_TBL] used:
Table contains the 5 columns namely
PRODUCT, BRAND, CATEGORY, SALES_CENTER (i.e Store), PRDT_RCVD_DATE. Consider
'Product, Brand, Category' as a MERCHANDISE.
High level
Requirement Specification:
Ultimate Goal is to compute the
Earliest Product Received Date. Earliest Product Received Date is the most
recent date when majority of the sales center received the goods at the
Merchandise level.