Manage the role for execution of a query.

It's a common practice in BI to have different views according to the user connected. The views are linked to the roles defined in SSAS. When testing an environment it's useful to define the role for which the case is defined. This can be done in any query targeting an SSAS environment.
NBi supports this case by providing an xml attribute named roles in any query. You can specify the role in this attribute and NBi will connect to your cube with this role for the execution of the query.

<query ref="OlapQA" roles="minimal">
     ...
<query>

Note that the user executing the test needs to be in all the roles that the testing is targeting or the test won't execute and raise a failure.

If you want, you can define more than one role for the context of execution. You just need to separate them by a semi-column (;).

Last edited Jan 20, 2014 at 6:08 PM by Seddryck, version 1

Comments

No comments yet.