Many thanks for your help. I was stuck at the dimension "table" properties instead of the
dimensions. Unfortunately, linking the dimension ID to the fact ID did not fix the warning
"At least one leaf member of a hierarchy is referred to by multiple dimension keys."
Do you know how can I fix this warning?
It sounds like you might have a many-to-many relationship between the two tables you are linking (one for dimension and one for fact). This is not supported in OLAP Cube's star schema model (only a one to many relationship is supported).
I would suggest that you complete the join outside of OLAP or correct the dimension table to ensure that all dimension id's are distinct.
Thanks for the advice. My OLAP test tables are from the sample set I downloaded in the eLearning "SAS Programming" exercise.
I signed up for various eLearning courses but could not find a, so it seems, "working" set of OLAP sample tables
for dimensions and fact. Would you know if SAS has something like that?