BEx Query greyed out in Web Intelligence

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. 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 Click on the Extended tab and then make sure By OLE DB for OLAP is checked under Allow External...

March 19th, 2015 by David Lai 

Custom BW hierachy level selection in WEBI

Connecting to BW using a BICS connection in WEBI is pretty cool, but unfortunately the ability to select a desired level from a hierarchy proves to be very difficult without any tricks. A common request that I’ve been finding from clients these days is the ability to select a desired level in a hierarchy and not have to expand all the way through in order to see that level. (more…)
April 8th, 2013 by David Lai