There are four main sql ssas dimension relationships. Regular, Referenced, Many-to-Many and Fact.
Regular - Is used when relationship of a dimension is linked directly to a measure group through the attribute.
Reference - Is used when relationship of a dimension is linked directly to a measure group through a intermediate dimension.
Many-to-Many - Is used when relationship of a dimension is linked through a measure group through an intermediate measure group.
Fact - Is used when relationship of a dimension is linked through a fact table to define the measure group.
If anyone can elaborate further on this, you are welcome.
thanks. do not hesitate trying various tools for how to ensure queries executed in batch sequence in sql server, it is often the only choice to retrieve the data from corrupted documents
ReplyDelete