OLEDB for OLAP Release for a BEx Query

[Former Member]

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.

Regds.

[Former Member]

Hai ,

I am also facing the same problem. So I have to create a universe on the Bex query.Can you let me know the solution .What is the solution to create a universe on top of bex query which contacins Calculated Key figure's.

[Former Member]

Hai amit,

I am also facing the same problem. So I have to create a universe on the Bex query.Can you let me know the solution.