Skip to Content
author's profile photo Former Member
Former Member

No able to exceute a ERP InfoSet with a BEx Query in the ERP system

Hi experts,

with the help of ERP transaction code SQBWPROP Maintenance of BW Settings of Classic InfoSets it´s possible to allow acces to a ERP InfoSet with the help of a BEx Query within the ERP System.

I have checked this setting for a example InfoSet and created a BEx Query based on this InfoSet.

But, if I execute the BEx Query with t/code RSRT the "No Authorization" message appears.

Check log per t/code RSUDO:

BEx Authorities in PFCG:

What are the prerequisites to use BEx Query based on a ERP InfoSet in a ERP system?

Many thanks in advance and best regards,

Michael

RSRT_1.png (40.4 kB)
PFCG_1.png (51.4 kB)
RSUDO_1.png (27.7 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2014 at 12:41 PM

    I´have tested it again on a ERP system with EHP 7 and BI Client installation... It work´s successuflly.

    Any ideas to improve the performance? It´s not really good!

    Regards,

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 10, 2014 at 07:07 PM

    I am not a security expert but could you turn on the authorization trace back in BW using ST05 to help troubleshoot the issue? There could be more missing.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 15, 2014 at 11:05 AM

    Hi Michael

    Check with SU53 if you can see the missing authorization that you have to add in PFCG.

    Thank you

    YK

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.