–> This wizard is used to add, remove dimensions and their relationships.
–> We can add dimensions to another dimension (or) measure group table.
1. No Relationship
6. Data mining
–> The dimension and measure group are not related.
–> The dimension available in the cube but at the times of analysis, it doesn’t participate in its values.
Ex: Removing the relationship between product dimensions and measure group table.
Deploy, Go To Browser and Analysis now the product dimension doesn’t participate in the analysis.
–> Here dimension adds to a measure group table directly. (Generally, represents ‘Star Schema’ structure)
–> When we are going to this, we should have proper key relationships between dimension & FACT.
Eg: Adding product dimension to the measure group table.
Product ID – –> CLICK –>
Select Relationship Type: Regular
Granularity Attribute: PRODUCT ID
Dimension Table: PRODUCT
Measure Group Table: TEXT_FACT
Dimensions Columns Measure Group Columns
Product ID Product ID
Deploy –> Go To Browser & analyze, now product table participates in the analysis.
–> The dimension table is joined to an intermediate dimension table, which in turn, is joined to the font table.
–> It provides the ‘Snow Flake’ schema type of structure.
–> We require approximate column references between suitable to main tbale.
Eg: Connecting sub product dimension to a product dimension.
Sub Product ID – –> CLICK –>
Selection Relationship type : Reference
Reference Dimension : Product
Intermediate Dimension: RAW SUBPRODUCT
Reference Dimension Attribute : Product ID
Intermediate Dimension Attribute : Subproduct ID
–> The dimension is the fact table here.
–> Generally textual information represents dimension information and numeric information represents fact information in this table.
–> These types of cubes are called “Standalone Cubes”.
–> The dimension table is joined to an intermediate fact table. The intermediate fact table is joined, inurn, to an intermediate dimension table table to which the fact table is joined.
–> The target dimension is based on a mining model built from the source dimension.
The source dimension must also be included in the cube.
|SCCM||SQL Server DBA|
|Team Foundation Server||BizTalk Server Administrator|
Get Updates on Tech posts, Interview & Certification questions and training schedules