Question:
Dear All,
I´m having a problem with loading SAP BW-Users into a query. Whenever a mobile User logs on to BW, his or her Login-Name should be used as a filter value and variables should be filled, according to his authorization.
Can anybody give me a hint, how to solve this??
Thanks,
Thorin
Answer:
Are they login in using one single user ID? Is each of them has his/her login ID?
Regards,
_________________
Ali H. Alwan
Atos Origin Middle East
Saudi Arabia
Answer:
May be u can try writing USER Exit for a variable populating the user login and then executing the the query with that variable with OPTIONAL as an Variable selection.
_________________
Chetan
@ CP...
Answer:
ANY MORE INPUTS??????????????????????
Answer:
Maybe "personalization" on userID-level can help...?
Answer:
Would an authorization variable do what you want?
http://help.sap.com/saphelp_bw33/helpdata/en/44/599b3c494d8e15e10000000a114084/frameset.htm
Answer:
Thanks so much.I never knew of this .I am sure this works.
Answer:
One more thing…..I need to write a code behind the authorization variable. Because I need the variable to actually get filled by the attribute of the person logging in…
Is it possible?
Answer:
One more thing…..I need to write a code behind the authorization variable. Because I need the variable to actually get filled by the attribute of the person logging in…
Is it possible?
If you want to do more than just automatically restrict users based on their authorization you would need to use a customer exit, which could be tricky; maybe you can find another way to address the additional requirements.
Answer:
What are the variables that should be filled? If they single values which are in the parameters of the persons R/3 profile, then you can pull that via the Authorizations ODS and have it automitically assigned by user w/o having to write a custom exit.
Alternatively if they are more general, you could add those authorizations to the uer roles to assign the values and have it automatically restrict based upon Authorization in the variable definition for the attributes of whatever you need ot automatically filter by.
- Stephen
_________________
As a rule I don't answer Questions in PM.
(this is not to be a d**k, but it is to allow everyone to benefit from information. Not just one person.) Ask a question in the forum and I will answer it if I can.
Answer:
I need to fill attributes of the person loging in but they are single values.I am also sorry but i dint understand your solution.Would you mind being a bit more elaborate.
And thanks for all your inputs.
Answer:
Sure... no problem.
First, what are the attributes that you need to fill? (InfoObject name in BW)
Second, where are you getting those attributes from currently? (Source where the relation to user - attribute is stored currently, if any.)
(From there I can better explain my idea.)
- Stephen
_________________
As a rule I don't answer Questions in PM.
(this is not to be a d**k, but it is to allow everyone to benefit from information. Not just one person.) Ask a question in the forum and I will answer it if I can.
Answer:
The attributes are “service line” and “function,”. We have the Infoobject 0costcenter which has service line and function and employee number as attributes.
The basic logic is …………..A person logs in with his employee id and we have to filter a particular characteristic in our query to his service line (and same for FUNCTION).We have to look into the 0Costcenter master table for his attributes.We also have an ODS which has these relations.
Let me know if you need more info.
Answer:
The attributes are “service line” and “function,”. We have the Infoobject 0costcenter which has service line and function and employee number as attributes.
The basic logic is …………..A person logs in with his employee id and we have to filter a particular characteristic in our query to his service line (and same for FUNCTION).We have to look into the 0Costcenter master table for his attributes.We also have an ODS which has these relations.
Let me know if you need more info.
OK, where do you have this information currently? (Not for BW, but for R/3.)
You can pull employee information via 0EMPLOYEE, and you can simply create an authorization object in RSSM for 0EMPLOYEE to relate that to the persons USERNAME. (You would actually create it for 0USERNAME, and pass in the persons username.)
As for cost center, if that is in the users R/3 profile as a parameter, you can pull that from the appropirate USR* table (I forget which one off the top of my head) as a datasource in BW to fill the Authorizations ODS and fille the authorization object against 0COSTCENTER - being authorizaed from the ODS.
With the authorization values automatically pulled over, you create authorization relevant variables against username and costcenter in yoru queries and the user will automatically be filtered when they go to execute the queries.
I would suggest reading up on authorizations in BW and the authorization concept as it relates to BW (check this forum for links to the specific docuemnts) before proceeding further.
- Stephen
_________________
As a rule I don't answer Questions in PM.
(this is not to be a d**k, but it is to allow everyone to benefit from information. Not just one person.) Ask a question in the forum and I will answer it if I can.
Answer:
I got you but the whole challenge is the query should not be restricted to his service line and function but the characteristics in the query. Because the employee needs to see how is service line is doing as a whole( it should not be restricted against his contribution to his serviceline …..I mean it should not be a subset of his contribution to his serviceline) .hope I am clear .Can I get your email id so that I can show u the actual problem……..This is a big challenge ………and I appreciate your prompt inputs.