06-19-2007 8:50 PM
Hello,
I would like to restrict a query in PFCG to display only on certain InfoProviders and query, please tell me if it can be done via PFCG.
Regards,
Nicolette Nguyen
Valero Energy
Re: BW 3.5 Security
Posted: Jun 13, 2007 4:16 PM in response to: Nicolette Nguyen Reply E-mail this post
Hi,
Yes you can do it. Find for the object S_RS_COMP in your role and change the acitvity field:
Activity: Gave them 03(Display).
InfoArea: Give the name of Info area
InfoCube: Give the name of the cube on which the Query was built.
Name of reporting component: Give the Query name
Type of reporting component: Reporting users only need REP,which is the ability to execute queries against the InfoCube.
Hope it helps.
Please award points if it is useful.
Thanks & regards,
Santosh
Re: BW 3.5 Security
Posted: Jun 18, 2007 10:52 PM in response to: Nicolette Nguyen Reply E-mail this post
Does the query need to be TRANSFERED, before it can be defined in the role via PFCG?
Thanks for your assistance.
Regards,
Nicolette Nguyen
Valero Energy
06-19-2007 9:25 PM
Hi Nguyen,
I dont think you need to transfer any query.
If you could explain in detail it would help.
Cheers
Soma
06-19-2007 9:25 PM
Hi Nguyen,
I dont think you need to transfer any query.
If you could explain in detail it would help.
Cheers
Soma
06-20-2007 6:11 PM
Hi Nicolette
Query need not be transported before you transport your role. But ultimately the query has to be transported if you want to access it. It does not get transported automatically with the role.
I hope this helps. Your question was not clear.
Thanks
Jay
Message was edited by:
jayaroop gullapalli