BookmarkSubscribeRSS Feed
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 ( and found nothing regarding the read-only problem)
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
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?
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
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.
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



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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.

Get the $99 certification deal.jpg



Back in the Classroom!

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

View all other training opportunities.

Discussion stats
  • 5 replies
  • 2 in conversation