Managing dimension hierarchy-level security
So far so good; you've allowed cube-level access to users, but this might only be a part of the battle. Cube-level access does not restrict any dimensions or attributes. This means that each employee could see not only those sales that he/she is directly responsible for, but also the sales of his/her peers and managers. Furthermore, not all employees need to see highly sensitive data such as salaries and commission rates.
You can manage access to dimensions using the Dimension Data tab within the Role Properties dialog. The same dialog also has the Dimensions tab that is used less frequently and allows you to specify write access if the dimension write-back is configured; otherwise, all dimensions are available for read-only access. The Dimension Data tab, on the other hand, is for securing individual dimension attribute hierarchy members.
You will begin by implementing a simple requirement of only allowing the role to see bikes and accessories product...