Replacement path query with input ready variable
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:
Do you know if it is posible to work with replacement path with an input ready variable?
Thanks for the help!!