Shiva

• Nov 11th, 2006

 

 Any schema or Table or Report which gives you meaningful information  of  one attribute  wrt more than one attribute is called  a cube.

For Ex: In a product table with Product ID and Sales colomns , we can analyse Sales  wrt to Prodcut Name , but if you analyse Sales wrt Product as well as Region( region being attribute in Location Table) the report or Resultant table or schema would be Cube.

ETL Cubes : Built in the staging area to load frequently accessed reports  to the target.

Reporting Cubes : Built after the actual load of all the tables to the target depending on the customer requirement for his business analysis.