As you can see, no automatic relationship is created between the Geography dimension and the measure groups. Click on the Define Relationship button in the Fact Reseller Sales column on the Geography dimension.
- Adding dimensions to the FirstCube project
- from Getting Started with SQL Server 2012 Cube Development
- Publisher: Packt Publishing
- Released: September 2013
Could have mentioned to select the Dimension Usage tab. Then click the ... in the Fact Reseller Sales column where the Geography Dimension intersects.
Share this highlighthttp://www.safaribooksonline.com/a/getting-started-with/11316736/