Hi Gurus,
We have our reports developed on top of SAP BW (BEX query) and the and there are some reports which are having performance issue because they have close to 30 columns in a list report.
I was thinking of using prompt token function so the user can select the column for which they want to run the report from the prompt page and I would like someone to guide as to how can I handle it with OLAP and I am open to any other suggestion(s).
Will really appreciate your prompt response.
Thank You
I've done something similar with a multiselect value prompt and a lot of render variables.
Take a look here (http://www.cognoise.com/index.php/topic,10171.msg33389.html#msg33389), that question was for a crosstab, but the method will work for a list.
First of all, I would like to thank you for your prompt response.
I am using what you have mentioned but getting the error which I have attahced. Are there any setting at the Admininstration which needs to be enable.
Thanks in advance.
Make sure you escape all regex symbols, like [ and . with a \.