Access Privileges for Members in the Planning Database Source
Financial Reporting Web Studio gives you access privileges on members.
Access privileges are available on members in the following dimensions:
-
Accounts
-
Entities
-
Scenarios
-
Versions
In the Select Member dialog box, all members for the Planning 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 what values are returned on a grid that contains valid and invalid dimensions or members. These scenarios assume that you are reporting against a Planning database connection and have access privileges to the following dimensions and members:
-
Accounts: Sales, Profit
-
Versions: 1st Draft, 3rd Draft, Final Version
-
Entities: North, Canada
-
Scenarios: Budget
Scenario 1
You run a report based on the following grid:
Page: Budget
Because you do not have access to Central, South, and 2nd Draft, the report returns the following results:
Page: Budget
Scenario 2
You run a report based on the following grid:
Page: Actual
Because you do not have access to the Scenario dimension in the Pages axis of the grid, the member Actual is in the Scenario dimension, no page is displayed and an error message describing your access privileges is returned.
Scenario 3
You run a report based on the following grid:
Page: Budget
Because you do not have access to the entities on the rows, no page is displayed and an error message describing your access privileges is returned.
Scenario 4
You run a report based on the following grid:
Page: Budget
The report returns the following data:
Page: Budget