0TCAIFAREA and 0INFOPROV

[Former Member]

Hi,

I have a question about 0TCAIFAREA and 0INFOPROV.

According to a document stored in 'SDN Library',

there is a direction 'Add 0TCAIFAREA as an external hierarchy characteristic to 0INFOPROV' as a preparation

before migration into new analysis autorization from

old authorization objects.

What is this setting for?

In which situation, is this setting necessary?

Best regards,

Kaito Hosoyamada

[former_member192700 · Accepted solution]

Hi Kaito,

The InfoArea (0TCAIFAREA) is acting as a external hierarchy to the InfoProviders (0TCAIRPOV), and can hence be used to authorize whole InfoAreas.

Cheers

SAP NetWeaver BI Organisation

PS: If I should make a statement about the recommendation in the SDN paper, please provide link or access path in SDN.

[Former Member · Accepted solution]

Hi, Andreas

Thanks for your quick answer.

I have understood why this setting for 0TCAIFAREA and 0INFOPROV is necessary.

I guess this setting is not relevant to migration

from reporting authorization.

(since it is not reporting authorization but S_RS_COMP

that is used for authorizing InfoAreas.)

Am I correct?

Cheers,

Kaito

[former_member192700 · Accepted solution]

Hi Kaito,

S_RS_COMP can be used for the objects (in general queries) in a certain InfoArea for the usage in the query designer, whereas 0TCAIFAREA can be used to protect the data contained in a certain InfoArea / InfoProvider area.

Cheers

SAP NetWeaver BI Organisation

[Former Member · Accepted solution]

Hi Andreas,

Thank you for your help.

What I'd like to know is whether this setting is

necessary or not as a preparation before migration from

report authroization.

(I can not judge whether or not, since I don't know

if the data contained in a certain InfoArea / InfoProvider area

can be protected by report authorization.)

Cheers,

Kaito

[former_member192700 · Accepted solution]

Nope, not necessary.

Cheers

SAP NetWeaver BI Organisation

[Former Member · Accepted solution]

Hi Andreas,

Thank you so much.

Cheers,

Kaito Hosoyamada

[Former Member · Accepted solution]

I've recently tried to implement these authorizations in InfoAreas, but came across the following problem. Before, the infoarea field in the S_RS_COMP and S_RS_ICUBE objects acted directly on the RSA1 infoarea / infoprovider structure. Now this does not seem to be working anymore. Do you need to import the RSA1 structure in the 0TCAIFAREA InfoObject ? If so, how is this done ? Thanks for the help !

[former_member192700 · Accepted solution]

Hi Chris,

please search the forum first before posting questions. Questions regarding the difference between the usage of S_RS_COMP and 0TCAIFAREA have been covered in multiple threads.

- <b>S_RS_COMP:</b> Standard authorisation to protect the access to queries (in the query designer)

- <b>0TCAIFAREA:</b> InfoObject to design hierarchical authorisation on the data (contents) within an InfoArea (structuring means for InfoProvider in the DataWarehousing Workbench).

Cheers

SAP NetWeaver BI Organisation

[Former Member · Accepted solution]

Andreas,

Thanks for your response. However, my question was about how setting up hierarchy authorizations using the 0TCAIFAREA InfoObject. The used hierarchy should be the same as the RSA1 hierarchy, but I didn't manage to get that hierarchy in 0TCAIFAREA. Could you summarize the steps to have authorizations implemented on InfoAreas using analysis authorizations.

Thanks again for the help !

Chris.

[klaus_werner · Accepted solution]

Hi Chris,

there have been some problems with the virtual hierarchy. Please check whether the two SAP Notes help: 954673, 968823.

In Support Package 12 you will be able to repair the hierarchy with the method

CL_RRHI_VIRT_INFOAREAHIER=>CREATE_DIRECTORY_ENTRY

Regards, Klaus

[Former Member · Accepted solution]

Hi,

I have a similar problem that might be the same issue as this.

I our company have they built Multiproviders with no naming convention hence I need to build Analysis authorization based on 0TCAIFAREA but I can not get this to work.

In RSD1 is 0TCAIFAREA is set to be Authorization relevant and added as an external hierarchy characteristic to 0INFOPROV but still is 0TCAIFAREA not checked when running a reports, only 0TCAIPROV. I don't want to maintain the analysis authorization every time the BI team develop new Info Providers to add new values.

Has this fact that 0TCAIFAREA is not checked even if it is authorization relevant to do with the Viritual Hierarchy? If so can this be fixed by running the method you suggest CL_RRHI_VIRT_INFOAREAHIER=>CREATE_DIRECTORY_ENTRY?

If this method will fix my problem how is this the executed? Is there any decription of which steps I need to do in order to get this right that I can use?

We run SAP BI 7.0 SP15

Thanks in advance!

Stefan J Persson

Edited by: Stefan J Persson on Jun 19, 2008 9:21 AM