September 14, 2010 at 12:43 pm
I created an SSAS data cube a couple of years ago. At that point I was knowledgeable enough to be dangerous. Since then I’ve realized that I should have created one of the relationships between a fact table and dimension table using two columns instead of the one column that I used. My question is: how or where can I redefine that relationship? I’m working in VS 2005.
Thanks for any help you provide.
September 15, 2010 at 2:54 am
Rich Wyble (9/14/2010)
I created an SSAS data cube a couple of years ago. At that point I was knowledgeable enough to be dangerous. Since then I’ve realized that I should have created one of the relationships between a fact table and dimension table using two columns instead of the one column that I used. My question is: how or where can I redefine that relationship? I’m working in VS 2005.Thanks for any help you provide.
I believe you mean about dimension mapping
In BIDS terminology, it is Dimension Usage
Raunak J
September 16, 2010 at 6:35 am
I usually define them first in the datasource view and then check if they are correct in the dimension usage tab of the cube.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 20, 2010 at 8:32 am
Since then I’ve realized that I should have created one of the relationships between a fact table and dimension table using two columns instead of the one column that I used.
Fact and dimension tables should only be connected by one column, usually an autoincrementing integer, but a plain integer or small integer will also work. If the OLTP model would use the two columns as the primary key, then set whatever unique constraint you have to to make this work and then manage it through the ETL process.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply