Skip to Content
Former Member
Jan 26, 2011 at 07:38 PM

OLEDB for OLAP Release for a BEx Query


Hi Experts !!

We are working in BI7.0 and BOE 3.1x env.

In the process we are releasing BEx queries for Universe Design by Releasing them for OLAP Connectivity.

While releasing one of the BEx queries for the same purpose, it says "The Query Contains a formula with the operator %GT, therefore the query can not be released for OLEDB for OLAP. If you used OLE DB for OLAP or MDX, this formula would deliver unexpected values."

And as we are using some %GT operators required for the query, we are just wondering what can be the way out for releasing this query for OLAP when we still want to keep those formula with %GT things?"

We are at present trying to rule out building those formulae at Webi Doc level instead, because of reasons like there are many of them in different queries, the time lines set and all that.

We are just wondering if we can get a solution for this while we are still using those formulae in the queries, Thanks.