Create relationships in PowerPivot using two unique fields
I'm working on a PT built from 7 tables:
- Tables 1-5 contain information about customer usage of products, including product # and customer #
- Table 6 contains detailed product information only, including product #
- Table 7 contains detailed customer information only, including customer #
In PowerPivot I created relationships between tables 1-5 and table 6 based on product #. I also created relationships between tables 1-5 and table 7 based on customer #.
The PT works until I try to slice the data based on customer #. I get the error message: ‘Slicer field could not be added. Result: Exception from HRESULT: 0x800A03EC’. I also see at the top of the Pivot table list the message ‘Relationship may be needed’ appears. When I click the ‘Create’ box that also appears, I get a message saying ‘No relationships detected’, with the details saying ‘No relationships were detected. Fields might have been added to a PivotTable or PivotChart from tables that do not have a relationship defined in the PowerPivot window. Alternatively, the relationship might be too complex to be detected automatically. To continue, use the Manage Relationships dialog box in the PowerPivot window to create new relationships or edit existing ones.’
I tried the suggestions at http://www.powerpivotpro.com/2010/08...rror-messages/ but no luck.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1