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

Set the value of a parameter without a prompt

Started by Zapp, 13 Apr 2011 06:52:33 AM

Previous topic - Next topic

Zapp

Hi there,

I'm looking for a solution to set parameter values in Cognos 8 Report Studio without a prompt.
We have a Frameworkmanager model where our querysubjects have filters with prompts for a version of data in our warehouse. (?p_date? between VALID_FROM and VALID_TO)
By default, report studio will show a date prompt when you create a report with data from the querysubject mentioned above.

Is there a way in report studio, to tell the report to always use "current_date" as input for "p_date" without showing a prompt page to the customer?
So the customer runs the report and gets data with "current_date" without being prompted.

Basically its the question whether you can define values for parameters in the report specification to avoid the prompt page.
Building the filter directly with current_date in the fm model is not an option, because we sometimes need another point in time.

Best regards,
Zapp

RobsWalker68

Hi Zapp,

The current version of support link has a technique that might help you in this respect.

https://www-950.ibm.com/blogs/basupportlink/entry/dynamic_date_selection_in_scheduled_report1?lang=en_gb

Kind Regards

Rob

Zapp

Hi Rob,

thx for the link, but I guess this will not help in my task. Our customer wishes the promptpage to entirely disappear.
So our endusers run the report and get results without being prompted.

I want to predefine the value for the prompt and make it disappear.
Something like ?p_date? = current_date with regard to my initial post.

Kind regards,
Zapp





Lynn

Try using a prompt macro in Framework Manager where the default is set to current date.

Then uncheck the "Prompt for values" property for those reports where you don't want to have a prompt page. You can find this property on the "Report" tab of the report properties in Cognos Connection.

Hopefully this is what you're after.