I created a dimension table with 3 columns. Col1 is member key(FK) associated with a PK table. Col2 is parent key column with sequence number based on Col1. Col3 is the member name. Then I built up a dimension with parent-child hierarchy based on this table. when processing cube, error message told me that member key is not unique. I try to modify the dimension property "member key unique" from true to false. The property pane is grey. Can I define FK Unique? I don't think so. I made virtual dimension to force "member key unique" to false. It still didn't work. I hope who can help me ASAP. Thank you so much in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SOS!! Who can help me in SQL Analysis Manager
- Thread starter citic
- Start date
Similar threads
- Locked
- Question
- Locked
- Question