bpf with report bex with variable BPC Embedded 10.1

[Former Member]

Hi BPC Friends

I am creating a BPF with BPC 10.1 Unified.

I have attached at this BPF a BPC report based on a Bex Query with a variable for the company code.

The driving dimension of the BPF  is  the company code so I have selected some company codes.

I have created the BPF Istance and I have assigned at the different company codes the proper users as performers.

The problem is this:

The user run the bpf istance for its company but  the report having the variable for the company code allow to the user to select also a different company code.

I was expecting that the variable for the company code was locked for the company code assigned to the user

Thanks

Michele

[Former Member · Accepted solution]

Hi Michele

If I understand your question correctly, if you want the company code to only display the company codes that the user has been assigned to

Example:

User A - has been allowed to see values 1000, 1002, 2093 from 0COMP_CODE

User B - has been allowed to see values 1003, 1004, 2094 from 0COMP_CODE

You will need to define the variable as an authorization variable on the BEx query.You can make reference to the below for additional help on BEx Authorization variables.

Reference Links:

Hope this helps,

Kind Regards

Daniel

[Former Member · Accepted solution]

thanks Daniel

if I create the variable as authorization variable on the BEx query it will be automatically filled using the property performer (owner) when I create the BPF or I have to set up the Data Access Profile in BPC as well?

[Former Member · Accepted solution]

Hi Michele

In the above scenario, from what I was able to understand, you have defined a BPF, the activity within the BPF opens a workbook, the workbook is using a BEx query that has already been defined. The BEx query has a variable which prompts the user for values for company code.

The authorization variable will populate the BEx company code variable with the values that the user has been allowed to see.

For example: If the user has a BW analysis authorization that only allows them to see company code 1000, 1003. When the user executes the report in Analysis For Office, the prompt in the workbook should only display the values 1000 and 1003. (Meaning that the user only has access to 1000,1003 to choose from)

I don't understand where the performer is a prompt?.

The data access profile is typically used to restrict access to the data (restrict what you can see in your report). The BEx authorization variable will not be driven by the Data Access Profile, this will be driven by the BW Analysis Authorization. (I say this under possible correction)

Do you want the prompt in the workbook to display the performer of the BPF activity ? If so, I don't understand the requirement or why you would want to achieve this.

Please could you provide more context,

Hope this helps,

Kind Regards

Daniel

[Former Member · Accepted solution]

Hi Daniel

I agree with you about the authorization variable.

I think that the DAP  it is useful for restrict the access.

My question is if the performer that I assign at the process instance of the BPF would be able to restrict the access (without using authorizatIon relevant and dap)

I explain below

Dimension 0comp_code with the attribute Owner

ID     ...... Owner

IT10....... Michele

I create the process template with driver dimension 0comp_code and select member IT10 and mapping the performer with the owner.

So the user Michele will see among his activity the report bpc.

The report bpc at the moment is based on a bex query with a variable for the comp_code

The situation is that when the user run the report he can choose also a different company!!!!