|
| Hi,
Does it possible to create a perspective based on a subcube?
We have a set of dimensions & 1 fact table.
2 Dimensions should be used at the same time to provide accurate results
(filtering the first dimension on particular member and you should filter
the second dimension on particular member for some answer while another
combination provide other answers for other needs)
advanced users are trained and know how to use or not a dimension.
but "basic" users are not aware about this particularities.
So I want to provide dedicated perspectives to insure that the user will
access relevant members.
also... advanced users can create reports based on this cube and this report
can be opened by simple users, so I can't apply any security because its a
business logic issue not a security issue.
What can I do?
creating 2 cubes? (1 for advanced users, 1 for other users with dimensions
limited to specific members)
or I can use only 1 cube and play with perspectives?
Thanks.
Jerome.
|
|