Dec 08, 2006 · If you need to do it in T-SQL, then the other replies to use CAST is the next best thing. Friday, December 8, 2006 5:14 PM. text/html 12/11/2006 6:26:39 AM Bsraju 0. 0. Jul 10, 2009 · Use a similar expression in all of your reports and they should all be able to accept the parameter value from the same prompt. Now I’m going to be extremely rude (apologies to atruesowordsdman) and suggest that you send any further questions to a forum dedicated to Cognos (Developer Works or Cognoise Communities for instance).
Performed Migration of Reports from Cognos 7 Series Impromptu to Cognos Report Net 1.1 and Cognos 8/8.1/8.2/8.3 Series using Migration Tools Applying patches across Multiple development, test, and production environments This Oracle tutorial explains how to use the Oracle / PLSQL LPAD function with syntax and examples. The Oracle / PLSQL LPAD function pads the left-side of a string with a specific set of characters (when string1 is not null). Creating and using Contents Page. Using Bookmarks. Using Functions, such as case and cast statements. Setting up and using prompt properties to assist with filtering your data. Optional Extra’s for review, Changing the report layout using Page Structure, scheduling reports, overview of Portal Pages, what’s new at Cognos 10.2.
Jun 23, 2015 · Cognos BI Tuesday, June 23, 2015. ... (Cast(Null as Char)) ... If you want to have optional prompt then you need to Use macros. Replace the If condition with the ... To learn more about Cognos Analytics, the next-generation Cognos platform that IBM announced at Insight 2015, please check out our article on the product's top 4 release features. Update, October 6, 2015 : Cognos 10.2.2 has been around for almost a year now, and we've had a lot of time to dig...The Query service administration task wizard in Cognos BI was built using the Cognos BI Software Development Kit (SDK). Any task that can be defined through the wizard can also be established programmatically using the SDK. For more information, refer to the Cognos BI SDK documentation or the following developerWorks article: