You have the following analysis requirement. Products roll up to Product Family which rolls up to Product Category. You
Posted: Sun Jun 11, 2023 4:01 pm
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. ProductManagers 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 byProduct 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
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