Defining Dimension Usage Relationships
Page 1 of 1
Defining Dimension Usage Relationships
I’ve got one fact table linked to 5 dimension tables.
If I add another fact table and join the new fact table to one of the original dimension tables.
My question I want to link my fact table to another dimension table. so why do I need to drag and drop a link from the fact table to the dimension table. When I can just use the usage dimension.
So basically what purpose does creating a link in the data souse view achieve when I can just use the dimension usage.
If I add another fact table and join the new fact table to one of the original dimension tables.
My question I want to link my fact table to another dimension table. so why do I need to drag and drop a link from the fact table to the dimension table. When I can just use the usage dimension.
So basically what purpose does creating a link in the data souse view achieve when I can just use the dimension usage.
ganley- Posts : 2
Join date : 2013-11-06
![-](https://2img.net/i/empty.gif)
» Hot swappable dimension and conformed dimension usage (bank/ credit union)
» Usage flags in subscriber dimension
» Modelling many to many relationships in a dimension
» How best to allow for future custom facts and dimensions while defining a new star schema
» Unknown number of relationships from dimension to fact until fact loaded
» Usage flags in subscriber dimension
» Modelling many to many relationships in a dimension
» How best to allow for future custom facts and dimensions while defining a new star schema
» Unknown number of relationships from dimension to fact until fact loaded
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum