I found a blog post describing a program that allows you to change the BEx query “External Access” flag en masse. Very useful if you start integrating SAP BO and SAP BW and want to expose your existing queries.
The blog author is named Campbell Skene and here is the link to his blog:
You can download the program he proposes in Saplink format here below.
Download – ZBW_QUERY_EXTERNAL_UPDATE – 7.8 KB – 555 downloads