BookmarkSubscribeRSS Feed
metalray
Calcite | Level 5
WARNING: At least one leaf member of a hierarchy is referred to by multiple dimension keys.

I have only two dimensions
Product_Dim , linking to Product_ID in the fact and
Customer_Dim, NOT linking to customer_ID in the fact.

When I want to edit the cube, the dimension properties are "read-only".
How can I edit the dimension?

I just read the SAS® 9.2 OLAP Server
User’s Guide (http://support.sas.com/documentation/cdl/en/olapug/59574/PDF/default/olapug.pdf) and found nothing regarding the read-only problem)
5 REPLIES 5
AngelaHall
SAS Employee
If you are in SAS OLAP Cube Studio, and you have RM/WM access to the cube, you can right click on the cube name & select 'Edit Cube Structure'.

Click next through the GUI until you arrive at the 'Cube Designer - Dimension' screen. Select the Dimension you would like to edit & select the button 'Modify'. You can then edit the cube accordingly.

~ Angela Hall
http://sas-bi.blogspot.com
metalray
Calcite | Level 5
Hello Angela,

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?
AngelaHall
SAS Employee
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.

~ Angela
http://sas-bi.blogspot.com
metalray
Calcite | Level 5
Hi Angela,

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?

Many thanks for your help.
AngelaHall
SAS Employee
I typically utilize the SASHELP.SHOES table to generate an OLAP cube. This uses the 'detail table' option rather than the 'star schema' (on the first GUI page).

You can set up two dimensions: Product and Location
With Location including Region & Subsidiary Levels.
Measures can contain Sales &/or Returns

~ Angela
http://sas-bi.blogspot.com

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1264 views
  • 0 likes
  • 2 in conversation