If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Using prompt macro in Congos 10.1 OLAP

Started by superman99, 20 Nov 2013 10:24:16 AM

Previous topic - Next topic

superman99

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

CognosPaul

I've done something similar with a multiselect value prompt and a lot of render variables.

Take a look here, that question was for a crosstab, but the method will work for a list.

superman99

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.



CognosPaul

Make sure you escape all regex symbols, like [ and . with a \.