COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: JBCLARK20 on 04 Jan 2018 02:25:16 PM

Title: data item expression formula tab in Cognos 11.x?
Post by: JBCLARK20 on 04 Jan 2018 02:25:16 PM
Working in Cognos 11.8 now and noticed changes in the tabs on Data Item Expression box.
In 10.2 In addition to Source, Data Items, Queries, and Parameters - there was a formulas tab with various Cognos functions and when they were referenced the hints would describe the function.

Is this functionality still available in Cognos 11 (and not visible on my system), or has the formulas tab been deprecated?

Thank you!
Title: Re: data item expression formula tab in Cognos 11.x?
Post by: br54016 on 04 Jan 2018 04:02:46 PM
The functions tab is still available in 11.x
Title: Re: data item expression formula tab in Cognos 11.x?
Post by: Nikhil Shenoy on 07 Jan 2018 11:04:52 PM
That option is still available.
Go to "Queries" tab and click on any query. Now click on the "Toolbox" section, there you will find Query Calculation & Data Item.
If you drag & drop it to "Data Items" list, you will get the expression box.

Hope this has helped!