Create a Dynamic Recipient Report based on Personalisation only for page 2 not page 1

[MushiMushi]

Hello SAP experts,

I want to create a dynamic report which on the other hand i already had a recepients infomation as (branch name, email, branch manager).

So let say i have 2 pages which page 1 consist data as (branch name and branch manager) meanwhile on pages 2 consist the (branch and sales figures). On pages 1 i dont want to discreet the result to all recepient but for page 2 is. Which on page 2 the branch manager can only see the figure for its branch only based on personalisation. 

It is posible to do on SAP BI?? 

[vishalakshmi]

Can do it in Business objects Design studio:

Create the two pages as described. Page 1 will show the branch name and branch manager, and Page 2 will display branch-specific sales figures.
Bind your data sources to the respective components (charts, crosstabs, etc.).

Use scripting within Design Studio to control the visibility of data. You can employ the USER() function to retrieve the current user's information and dynamically filter data based on this.

This script would be attached to the data source or component on Page 2 to ensure that branch managers only see their branch's data.

code:

var currentUser = USER();
DS_1.setFilter("BRANCH", "BRANCH_NAME = '" + currentUser + "'");
Note: Adjust the filtering logic to match your data model and user attribute configuration. Ensure the field used in the setFilter method matches the one in your data source that identifies the branch.