topic Re: BW Query in Application Development and Automation Discussions

BW Query

Former Member — Tue, 19 Jun 2007 19:50:53 GMT

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

Re: BW Query

Former Member — Tue, 19 Jun 2007 20:25:14 GMT

Hi Nguyen,

I dont think you need to transfer any query.

If you could explain in detail it would help.

Cheers

Soma

Re: BW Query

Former Member — Wed, 20 Jun 2007 17:11:14 GMT

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