topic Re: BI 7 Security in Application Development and Automation Discussions

BI 7 Security

Former Member — Mon, 20 Aug 2007 01:34:29 GMT

hi,

People, I am new to this BI 7 security. I am trying to setup new Authorizations using T-code RSECADMIN. After creating this Authorizations, while generating I am getting Error msg " Error occurred when reading the data from DataStore object XXXXXXXX".

So how do we resolve this issue.

we are migrating from BW 3.5 to BI 7. As per the documentation it is advisable to create a new authorizations in BI 7, since the old one is not supported any more.

Regards,

Ajay

Re: BI 7 Security

PKing — Mon, 20 Aug 2007 11:44:29 GMT

Hello Ajay,

please provide some further information and ensure that the DSOs you are using are filled properly. Here is an example:

0TCADS01:

0TCTUSERNM 0TCTAUTH 0TCTADTO 0TCTIOBJNM 0TCTSIGN 0TCTOPTION 0TCTLOW 0TCTHIGH 0TCTOBJVERS 0TCTSYSID 0TCTADFROM

CALLKENNZAHL 31.12.9999 0TCAACTVT I EQ 3 A AL_SID_002 31.12.2006

CALLKENNZAHL 31.12.9999 0TCAIPROV I CP ZC* A AL_SID_002 31.12.2006

CALLKENNZAHL 31.12.9999 0TCAKYFNM I CP * A AL_SID_002 31.12.2006

CALLKENNZAHL 31.12.9999 0TCAVALID I CP * A AL_SID_002 31.12.2006

CCOMP_BASIS 31.12.9999 0TCAIPROV I BT ZC0 ZCEJ A AL_SID_002 31.12.2006

0TCADS02:

0TCTUSERNM 0TCTAUTH 0TCTADTO 0TCTIOBJNM 0TCTHIENM 0TCTHIEVERS 0TCTHIEDATE 0TCTNIOBJNM 0TCTNODE 0TCTATYPE 0TCTACOMPM 0TCTTLEVEL 0TCTNDEF 0TCTOBJVERS 0TCTSYSID 0TCTADFROM

DWERK013AALT 31.12.9999 0PLANPLANT NEUE_WERKE A 31.12.9999 0HIER_NODE KNOTEN_013A 1 0 A AL_SID_002 31.12.2006

0TCADS03.

0TCTAUTH 0TCTADTO 0TCALANG 0TCATXTSH 0TCATXTMD 0TCATXTLG

CALLMERKMALE 31.12.9999 D short text middle text long text

CMP_BASIS 31.12.9999 D short text2 middle text2 long text2

CEKCOMP_0007 31.12.9999 D short text3 middle text3 long text3

CEKCOMP_0145 31.12.9999 D short text4 middle text4 long text4

If so, you will be able to generate the authorizations easily.

Bye,

Petra

Re: BI 7 Security

Former Member — Tue, 21 Aug 2007 01:32:07 GMT

Hi Petra,

Thanks,

But I am trying to create a BI authorization with info Cube and Activity and having few problems with this.

1: activity is complanining about "Characteristic 0TCAACTVT not authorization relavent".

2: other problem is when I am generating this without activity (only with info cube). I am getting an error about datastore.

Can you please help me with this issue.

regards,

Ajay

Re: BI 7 Security

Former Member — Tue, 21 Aug 2007 18:36:02 GMT

I suggest looking at some fo the documentation for the BI analysis authorization concept.

There are some pre-requisites to creating the analysis auths via RSECADMIN, primarily activate all business content related to authorizations and seeting some of the InfoObjects as "authorization relevant"

The presentation to look at is The New SAP Netweaver BI Analysis Authorization

which is located here --> https://www.sdn.sap.com/irj/sdn/wiki?path=/display/bi/authorizationinSAPNWBI&showChildren=false

Re: BI 7 Security

Former Member — Tue, 21 Aug 2007 19:15:43 GMT

Hi Ajay

Before creating analysis authorisations Make sure the info objects 0TCAACTVT,0TCAIPROV,0TCAVALID are authorization relevant.

There are many prerequisites before using Analysis authorisations please make sure u have gone thru those.

Thank you

Re: BI 7 Security

PKing — Tue, 21 Aug 2007 19:16:52 GMT

Hello Ajay,

point 1) first you have to define the three special dimensions for Activity, Infoprovider and Date as authorization relevant. In case you will need to restrict on key figures mark 0TCAKYFNM also relevant in RSD1. These three are absolutely mandatory - otherwise analysis auths. won't work!

point2) I guess the generation program is checking if your intension is feasible and because of the missing changes from 1) it will abort.

Please read the suggested documentations and watch Marc Bernard's session.

Bye,

Petra

Re: BI 7 Security

Former Member — Wed, 22 Aug 2007 00:55:18 GMT

Hi Experts,

I have followed the document

1: Using t-code RSD1, i have set authorization relevant for following

0TCAACTVT

0TCAIPROV

0TCAKYFNM

0TCAVALID

and then added 0COMP_CODE to this BI authorization.

while generating I am still getting error msg datastore cannot be found.

can you please help.

regards,

Ajay

Re: BI 7 Security

PKing — Thu, 23 Aug 2007 20:02:44 GMT

Hello Ajay,

please show me the content of your DSOs.

Bye,

Petra