Story/report to show all members of a Public Dimension

[VivekD]

Is it possible to create a report in SAC that will just show all the members and corresponding properties from a Public Dimension?

Basically, a report which users can use to view/review master data. 

[William_Yu · Accepted solution]

You can put this dimension into row axis and select property you need from table builder panel, switch show unbook on and finally hide the measure column. 

[VivekD · Accepted solution]

Not sure if I'm doing something wrong but when I do as you've described, it produces all combinations of the dimensions and properties i.e. if I had 10 company codes in my master data across 5 countries then I get 50 rows instead of 10 (see screenshot below).

Here's what the company code dimension looks like. Country Name is just a property of Company Code. 

[VivekD · Accepted solution]

I was able to get this to work. I was adding the properties from the add dimension option itself as opposed to specifically adding them from the properties option of the dimension. When I add properties it works fine.