What is Multi Dimension OLAP CUBE and give example cube with more than 3 dimensions

by

In the DW world, the word “dimension” is overloaded — changes meaning depending on context. Here is an example.

  • On a certain date, a customer walks into a store and buys a product.

This example has four dimensions (date, customer, store, product) and one fact (sales). So a typical Kimball star would look like:

dim4_model_01

A dimension (table) is a look-up table for properties of objects that rarely change. Product, customer and store may change some of their properties (attributes), but they rarely do. Fact table captures interactions between these objects. At the intersection of dimensions date, store, product and customer lies a measure SalesAmount. Note how easy is to aggregate (sum) the sales amount by date, by year, by product, by brand, by city, by country, by age group, by whatever — which was the idea in the first place.

More Related Contents:

  1. Calendar table for Data Warehouse
  2. SQL Server – error when creating stored procedure
  3. SQL Server insert if not exists best practice [closed]
  4. Are GUID collisions possible?
  5. SQL Server Escape an Underscore
  6. Does a foreign key automatically create an index?
  7. best way to convert and validate a date string
  8. Why use the INCLUDE clause when creating an index?
  9. Why do table names in SQL Server start with “dbo”?
  10. Add alternating row color to SQL Server Reporting services report
  11. LIKE vs CONTAINS on SQL Server
  12. Is there a way to simplify a NULL compare of 2 values
  13. How do I enable MSDTC on SQL Server?
  14. An attempt was made to access a socket in a way forbidden by its access permissions
  15. TSQL Try / Catch within Transaction or vice versa?
  16. What is the maximum number of characters that nvarchar(MAX) will hold?
  17. Is there any difference between DECIMAL and NUMERIC in SQL Server?
  18. SQL Server history table – populate through SP or Trigger?
  19. TSQL: Create a view that accesses multiple databases
  20. cross apply xml query performs exponentially worse as xml document grows
  21. What is the sql connection string I need to use to access localhost\SQLEXPRESS with Windows Authentication or SQL Authentication?
  22. SQL Error with Order By in Subquery
  23. How to change default language for SQL Server?
  24. Removing the remembered login and password list in SQL Server Management Studio
  25. Convert from DateTime to INT
  26. Is it possible to use user defined aggregates (clr) with window functions (over)?
  27. comma delimited list as a single string, T-SQL [duplicate]
  28. How to get only numeric column values?
  29. How to Bulk Insert from XLSX file extension?
  30. Count number of records returned by group by

Leave a Comment