Wednesday, January 04, 2012 10:11 PM
I have a simple set of tables with one fact table and 4 dimension tables but I am unable to create relationships between them.
The Dim tables have unique clustered index on their Key columns and I have created relationships in the DB however they are not picked up by the wizard and when I try to create the relationship in the Tabular Model Designer I get the following:
The relationship cannot be created because each column contains duplicate values. Select at least one column that contains only unique values.
at Microsoft.AnalysisServices.Common.RelationshipController.CreateRelationship(DataModelingColumn sourceColumn, DataModelingColumn relatedColumn)
at Microsoft.AnalysisServices.Common.RelationshipController.CreateRelationship(String fkTableName, String fkColumnName, String pkTableName, String pkColumnName)
at Microsoft.AnalysisServices.Common.SandboxEditor.erDiagram_CreateRelationshipCallBack(Object sender, ERDiagramCreateRelationshipEventArgs e)
at Microsoft.AnalysisServices.Common.ERDiagram.OnCreateRelationship(String fkTable, String fkColumn, String pkTable, String pkColumn)
at Microsoft.AnalysisServices.Common.ERDiagram.ERDiagramActionCreateRelationship.Do(IDiagramActionInstance actionInstance)
Any help appreciated,
Thursday, January 19, 2012 6:45 AM
Any/all relationships created in the relational database are also exported to BISM.
Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar
Tuesday, January 31, 2012 7:54 AM
I think you should try some records to test the relationship.
If you can build the relation by few data, then you can check the whole data and maybe it has duplicate data.
And you can reference this link.