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

Bex - Allow External Access check box

We have the "Allow External Access to this Query" checked in BEX under the Advance tab in Properties to allow access to BOBJ. However, when we make a change to the query, or create a new query and check this, then save it, when we go back into the query it is unchecked.

This worked at one time, and something happened to make this setting so we can't save it. Any ideas?

We are on:

BI AddOn 7.X (based on 7.20)

Support Package 4, Patch 2

Revision 667

Thanks, Keith

Add a comment
10|10000 characters needed characters exceeded

Related questions

13 Answers

  • Posted on Sep 20, 2011 at 07:40 AM

    Hi,

    Please check whether a proper BEx transport Request available before you make any changes to your Query. After saving your Query, just Generate it from RSRT. This should help you.....

    Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2011 at 10:26 AM

    Hi Keith,

    This should not be a problem. Check when you are saving a query, the checkbox is enabled or not and while saving the query collect in atransport request.

    Regards,

    Geeta

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 04, 2011 at 09:01 PM

    No solution yet. We are pretty sure it is a gui issue and are trying to find Bex 7.10, but SAP only provides 7.20. We have some people here on 7.10 and they can still save that setting.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2011 at 10:35 AM

    Hi,

    I have the same problem but i am on a SAP Gui 7.10

    did you solved it ?

    Cyril

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 12, 2011 at 04:13 AM

    Hi,

    I am facing the same problem. I tried saving query several times and when I go back to it shows unchecked. For this reason I cannot use the query in BO.

    Any idea how to fix this issue?

    Thanks,

    Briston

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2011 at 03:24 PM

    Hi guys,

    Just to let you know that ... you're not alone... 😊

    Upgraded to the below recently and facing exactly the same behaviour. Damn box unchecks itself...

    BI AddOn 7.X (based on 7.20)

    Support Package 4, Patch 2

    Revision 667

    Brgds,

    Olivier

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 16, 2011 at 04:59 PM

    Hi,

    The issue is related to the GUI,try to apply latest Bex Patch, it would solve the isse however if check the box once it will be checked at the server level, its only front end issue.

    Regards,

    Satya

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2012 at 03:18 PM

    I am having the problem after installed SAP GUI 7.2 on Friday. Has anyone had any luck so far?

    Sara

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Yijeng Liu

      Review

      Note 1629430 - Query Designer: flag "Release OLE DB for OLAP" is not saved

      ->Download

      ->Support Packages and Patches

      ->Browse our Download Catalog

      ->SAP Frontend Components

      ->BI ADDON FOR SAP GUI

      ->BI 7.0 ADDON FOR SAP GUI 7.20

      ->file "bi720sp05_500-20006596.exe"

  • author's profile photo Former Member
    Former Member
    Posted on Feb 10, 2012 at 01:10 AM

    Thanks, Kevin - that worked for me.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 24, 2012 at 02:57 PM

    hi,

    problem: because of an error in the BI 720 Query Designer the "Allow external access to this query" flag is not stored. You set it, you save, and the next time you open again the query - it is gone. With a

    3.x Query designer it works.

    Result: you cannot see 7.x queries created / changed with this version. (But 3.x querys and older 7.x queries) in the BO designer.

    Solution: Install latest patches for the BI 7.20 query designer (SP08 from July 2012 works), set the flag, save the query - and open the query again, that if it was really set

    best regards

    HAns.

    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.