Cognos Script 3

[stewm]

Hello,

I have a Cognos script here that is feeding an Impromptu report. It was working fine with the report had just one window of prompts. After the report was changed to have a cascading prompt the script failed. All the parameters get fed into the first window and doesn't have any left for the second window.

Any suggestions?

Thanks,

Mark

Consultants Club Corp.

 

[griffindm]

Mark,

A cascading picklist prompt report assumes the end user must make a series of selections, where the available options change based upon the original prompt entry. In a macro environment, this is accomplished by using multiple dialog boxes and either SQL-ODBC commands or the GetDataValue function to present a series of dialogs to the macro user before calling the final report. A normal cascading prompt report being used by a macro call seems contradictory in concept. Please explain what the design parameters were for the report and macro.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[stewm]

Dave,

The report was intended to be published to upfront and users would enter the prompts. However, we have some users that would like the report emailed to them. The report in the email script no longer works after it was converted to a cascading prompt report.

Mark

Consultants Club Corp.

 

[griffindm]

Mark,

Assuming the email script is a macro, and not soomething in Noticecast, you may have to do some report redesign to get this to work. Does the macro run unattended? If not, you could still answer the report prompts as they appear. If you need it unattended, you may have to use a parameter file to feed the macro and report the prompt variables they need.

If this makes sense, do a key word search here on parameter files in the Cognos forum and you'll get some insight on how to use them.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[stewm]

Dave,

We set up a parameter file like you said that feeds the reports. For now I just cloned the report (version run in macro) to accept values based on non-cascading prompts. Since the parameters come from the parameter file the Impromptu report itself would not have to ensure integrity. The other version will remain a cascading prompt in Upfront since the second prompt values are dependant upon the value of the first prompt so integrity is still important there.

I tried to write a macro last night to work with cascading prompts but as of yet it's not working.

Thanks
Mark

Consultants Club Corp.