Identifying Characteristic based on Infocube

[former_member680816]

Hi All ,

I need some suggestion on how to identify the which Characteristic is authorization relevant for the respective infocube.

Example when a user execute a query  through BEX example U_ABC_MFA01_0006  in RSA1 the multiprovider assign to 3 info cube is they any table  or transaction where i can identify user required which relevant characteristic for the cube  (like company code , organizational key etc)  to execute the report . 

At the moment we are doing trace and finding the table RSECVAL   to identify the the role .

[Former Member]

Hi,

What version of BW are you running? If you have analysis auths then auth relevant characteristics are global & you can see this in RSA1 in the infoobject view.  All you need to know then is which infoobjects are in your reports & cubes

[former_member680816]

Hi Alex  ,

We are using BI 7.3 . In RSA1 when i right click display   option there are multiple tab example infocubes , infoObject and etc for a multiprovider .

Let say if infocubes assigned to a multiprovider  is that mean i need to find out which authorization relevent object assigned to these cubes . If yes appreciate if you could advice how to do this in RSA1 or we can use any table to get this information .  

[Former Member]

Use Table - RSDCHA and put 'X' in auth relevant field. In this table you can get list of all auth-relevant Info-Objects part of a specific Infocube.

[Former Member]

Hello Kumar,

In general while creation of analysis authorization object , when we click blue rectangular button called infocube authorizations, then all authorization relevant infoobjects related to infoprovider or multiproviders will be displayed.

RSDCHA is table where all authorization relevant infoobjects are displayed,. But it does not show any assignment to infocubes.

Regards,
Sneha

[Former Member]

One more table, RSDCUBEIOBJ , where all inobjects related to infoproviders are displayed. So you can use these two tables RSDCHA and RSDCUBEIOBJ and get result as authorization relevant infoobjects to infoproviders. Hope this helps.

[shivraj_singh2]

Kumar,

You don't need to check the underlying Infocubes for authorization relevant InfoObjects. Just check for the multi-provider U_ABC_MFA01, the easiest way is to check it in RSECADMIN/RSECAUTH itself, just open any analysis authorization and click on InfoCube button and enter the InfoProvider.

Regards,

Shivraj Singh

[Former Member]

Kumar,

its not a prudent idea to find an Auth Relevant Object based on InfoCubes - reason - most of the Queries pull data from multiple Cubes.

Solution 1) Answer from ShivRaj

2) Answer from Pankaj - to add to this Pull the characteristics from the Query being executed - this will Narrow down the number or characteristics to check in RSDCHA table.

3) find the Restrictions on the Query being executed and check them against the RSDCHA table

4) Setup  a trace in Rsecadmin - Execute the Query - Pull the Trace - it will show what characterstic is being validated - use RSDCHA or RSD1 to find the Authorization Relevance.

Hope this Helps.

Chander

[niteshgupta87]

Try in table RSDICMULTIIOBJ..