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
image-1048

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
image-1049

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
image-1050

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

query selectable
image-1051

Comments

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

    Thanks buddy!!

Leave a Reply


− one = 6