OLAP Cube:It's consider the three dimension cube means we can analyze the date through any of the cube but some time the more than three dimensions are used known as Hypercube.The cube is shortcut for the Multi-dimensional datasets.The data can have the arbitrary dimensions.
Slicer is a term for a dimension which is held constant for all cells so that multidimensional information can be shown in a two dimensional physical space of a spreadsheet or pivot table.
Slicer is a term for a dimension which is held constant for all cells so that multidimensional information can be shown in a two dimensional physical space of a spreadsheet or pivot table.
Each cell of the cube holds a number that represents some measure of the business, such as sales, profits, expenses, budget and forecast.
OLAP data is typically stored in a star schema or snowflake schema in a relational data warehouse or in a special-purpose data management system. Measures are derived from the records in the fact table and dimensions are derived from the dimension tables.
No comments:
Post a Comment