Security setting for BPC Embedded model in Analysis for Office

[Freeter]

In BPC 10.1, two different models are supported: standard and embedded. For Embedded model, Analysis for Office (AFO) could be used as reporting tool, but the place we need to pay attention is the data security setting. As we know, there are 3 layers data security setting for BPC embedded model:

1. BW analysis authorization
2. Environment  (option)
3. Data Access Profile (DAP)

The final scope end user could access is the intersection of layer 1 and layer 3. (refer to BPC 10.1 security guide for more detailed information).

By default only the layer 1 security (BW analysis authorization) will be checked when you open a query on BPC Embedded Model in AFO.

1. How does AFO use DAP of BPC Embedded model? and What type of setting is needed?

From AFO 2.0 version, user could set the planning model in workbook. This is the method to connect the workbook with BPC Embedded Environment. Only when this connection is setup, DAP defined in BPC Embedded Model could be checked during query.

Support for different version:

AFO Version	Can set planning Model?
1.4	NO
2.0	YES
2.1	YES
2.2	YES

2. How to check it?

You could set break-point in the highlighted place in report LRSEC_CHECKSF03 as shown below. Only when the “Planning Model” is set,  BPC authorization defined in DAP will be checked.