Problem: What is SQL Server Analysis
Services Cube.?
In SQL Server, Analysis Services data is stored in database
as cubes.
Cubes are set of facts and dimensions that are used to analyze
the data.
- A fact, which is a transactional value or measurement that a user may want to aggregate. Measures are sourced from columns in one or more source tables, and are grouped into measure groups. Facts have keys related to dimensions.
- A dimension is a group of attributes that represent an
area of interest related to the measures in the cube, and which are used
to analyze the measures in the cube. For example, a Customer dimension
might include the attributes Customer Name, Customer Gender, and Customer
City, which would enable measures in the cube to be analyzed by Customer
Name, Customer Gender, and Customer City. Attributes are sourced from
columns in one or more source tables. The attributes within each dimension
can be organized into hierarchies to provide paths for analysis.
A cube is a data source view of facts and dimensions like below is the finance cube which is formed from facts and dimensions of a finance group tables.
0 comments:
Post a Comment