If your grid uses Planning Details as a database connection, Financial Reporting gives you access privileges on members in certain dimensions. The dimensions include Accounts, Entities, Scenarios, and Versions. In the Select Member dialog box, all members for the Planning Details database connection are listed regardless of access privileges. Therefore, you can place members on a grid that are not returned when the report is run. The members you choose affect the output of the report. For example, if you select a member to which the user cannot access in the Point of View or Page Axis, an error message is returned.
The following four scenarios describe which values are returned on a grid that contains valid and invalid dimensions or members.
For the following scenarios, the user is reporting against a Planning Details database connection and has access privileges to the following dimensions and members:
The user runs a report for the following grid:
Result: Because the user does not have access to Central, South, and 2nd Draft, the report returns the following results:
The user runs a report for the following grid:
Result: Because the user does not have access to Scenarios: Actual on the Page, no page is displayed and an error message describing your access privileges is returned.
The user runs a report for the following grid:
Result: Because the user does not have access to the Entities on the rows, no page is displayed and an error message describing your access privileges is returned.
The user runs a report for the following grid: