Replacement path query with input ready variable

[Former Member]

Dear experts.

We are trying to use two querys via replacement path by query:

- 1st query creates a top 70% condition of hotels by sales.

- 2nd query uses the selection of hotels of the first query via replacement path of query.

The problem is that we want to select only hotels from a particular region via variable user prompt, but when you introduce the input variable in the 1st query the 2nd query does not work, the system returns the next error message

The query cannot be released for OLE DB for OLAP

The standar documentation does not talk about this requirement:

http://help.sap.com/saphelp_nw70/helpdata/EN/2c/78a03c1178ad2ce10000000a114084/content.htm

Do you know if it is posible to work with replacement path with an input ready variable?

Thanks for the help!!

[cornelia_lezoch · Accepted solution]

Hello Ivan,

the names you use are a bit confusing.

I assume you have query1 with input ready variable1

and

query2 with replacement path variable2

right?

this is a very standard way, I use it a lot.

so if there are strange messages, either it´s something wrong with your variable definition or with the query properties.

the error points to the query property "released for OLE DB for OLAP"

why do you want to set this property?

regards

Cornelia

[Former Member · Accepted solution]

Hi Cornelia, thanks for your answer.

As you comment:

Query_1 has an input Variable_1 (region). This query returns the top 70% of hotels by sales.

Query_2 has a replacement Variable_2 with the result of Query_1.

If we use this setting the system returns the error "The query cannot be released for OLE DB for OLAP".

We are using SAP HANA database, so I am fearing that maybe this type of replacement can't be used in this type of database...

[cornelia_lezoch · Accepted solution]

you did not answer the most important question - why do you want to release the query by OLE DB for OLAP? Or is this a standard setting für queries on HANA?

[Former Member · Accepted solution]

Now I see your point!

That option is marked because we need to export that query to BO.

If I quit that option the query works as expected, so I think that we can't use replacement path by query in OLE DB for OLAP with input variable ready and that makes sense.

Thanks for the help.

[Former Member · Accepted solution]

Hi Cornelia,

I have the same problem. I have 2 queries.

1. Query with replacement path variable

2. Pre-Selection Query with input ready variable

I have to check  the box "By OLE DB for OLAP" because I have to use BO WEBi and Design Studio.

I get the message: The query cannot be released for OLE DB for OLAP

Do I have any other chances to get a solution?

Thanks and greetings

René

[cornelia_lezoch · Accepted solution]

Hi René,

you should try to create an exit variable which creates the same selection that the prequery and the replacement path variable would create.

regards

Cornelia