BEx Query greyed out in Web Intelligence

March 19, 2015 by: David Lai

A common problem when trying to access a BEx Query from Web Intelligence is that we cannot!

I want to build a query off the sales test query, however it is greyed out.

query greyed out

Well here’s an easy fix.

All you need to do is open the query up in BEx Query Designer, go to the Query menu and select Properties

select query properties

Click on the Extended tab and then make sure By OLE DB for OLAP is checked under Allow External Access to this Query

edit query properties

The BEx query will no longer be greyed out in Web Intelligence.

query selectable


One Response to “BEx Query greyed out in Web Intelligence”
  1. ASK says:

    Thanks buddy!!

Leave a Reply

6 + three =