You have the following analysis requirement. Products roll up to Product Family which rolls
up to Product Category. You also need to group Products by Product Manager. Product
Managers may manage one or more Products across product families. You do not need to
create reports with Product Manager by Product Family. You need to secure products by
Product Manager for planning submissions. You consider Shared members as a solution
because of which two options?
A.
Shared members provide cross tab reporting (Product Manager in the rows and Product
Family across the column)
B.
Shared members provide additional categorization but results in a smaller database then
if you were to add Product Manager as a separate dimension
C.
You can assign security to shared members
D.
Shared members can be assigned to sparse members only
Explanation:
http://www.oracledatabase12g.com/wpcontent/uploads/book/Oracle%20Essbase%20&%20
Oracle%20OLAP.pdfpage 95
You cannot assign access directly to a shared member. A shared member inherits access permissions from its base member, parent, or ancestor.