Hi,
While trying to create a Cube using the Cube Wizard, Under 'Identify Fact and Dimension Tables' screen, When I try to check either 'Fact' or 'Dimension' option box for a FactTable, SS is flagging an error.
Can someone tell me as to why this is happening ?
The wizard relies on the relationships in the DSV, so if these are missing or incorrect the wizard may have problems figuring things out.|||A little more specificially, every Fact Table must have one or more Dimension Tables which can be reached from it based on the relationships in the DSV. You probably just need to select a table for use as a dimension, possibly even the fact table itself, and then the wizard should let you continue.|||Thanks Darren and Matt for your replies.
I modified the Fact table to have FKs with Dimension Tables and now the Wizard detects it successfully.
Cheers,
Sundar
No comments:
Post a Comment