COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Business Insight Advanced / Cognos Workspace Advanced => Topic started by: Steve on 26 Jan 2014 05:56:54 PM

Title: Show filters in the report
Post by: Steve on 26 Jan 2014 05:56:54 PM
Let's say I apply 2 filters in the report. When I run the report, how can I see what filter values have been applied? This is available in Query Studio but not in BIA, nor is thare an option to use a Layout calculation to display the parameter value.

Also, can somebody show the main uses of BIA? Why would you use BIA instead of Query Studio? It does allow multiple queries but apart from that, what else?

Thanks
Title: Re: Show filters in the report
Post by: MFGF on 27 Jan 2014 03:58:37 AM
Hi,

Tom posted a very useful technique for doing this:

http://www.cognoise.com/index.php/topic,21461.0.html

The benefits of BIA over Query Studio are manifold - it has much broader capabilities than Query Studio and allows both reporting and analysis type interaction - giving you almost all of the capabilities of Query Studio and Analysis Studio combined in one authoring tool. It also provides the ability to open and modify reports authored in Report Studio - the report specification is shared between both which means they can be used interchangeably.

Lynn and Pat presented a superb session on this at IOD last November - you can find the materials here:

https://www-950.ibm.com/events/wwe/iod/iod2013cms.nsf/download/ke266465ed3c0d3c141e63c9d4f/$FILE/IOD2013_BBI-1186.pdf

Cheers!

MF.
Title: Re: Show filters in the report
Post by: Steve on 29 Jan 2014 02:00:34 PM
Thanks MFGF ! That helped a lot !

Since we don't want the users to have the burden of putting the code, I made a template which will have 5 rows (inside table cells) and put the code there to display the parameter values of the filters. They will name the paremeters like 'Parameter1', 'Parameter2' etc and the code will display the values so they don't have to do the coding.

Thought to share it.