Hello,
I am a brand-new Cognos Report Studio user, so please forgive me if this has been covered in a previous post. I have not been able to find a solution.
I want the same data item in my report two times, but I want a different filter on each of them. For one of the data items, I'd like to show all activity; for the other one, I'd like to show only some activity.
Thoughts on how to handle this?
Thanks!
First of, are you using a relational or a dimensional source?
And what is your goal? Where and how are you gonna show this in a report?
ideally you can create two instance of your data item. (can copy paste or create a new one with different name)
then add a filter to each.
you can drag dataitem1 into the filters section and in the menus available you can select one or select many.
use "in" or "="
select the value/values you want.
do this to the dataitem2 as well.
Just try this for relational.
In dimensional you can use the set function or except function.
Thanks for your thoughts.
It's a relational database.
I'm trying to pull all of our grants, which are accounted for in separate funds, into a report and show which ones get indirect costs. Two of the data items--YTD activity--are identical. I'm filtering on the indirect costs account code; however, when you do this, both YTD activity data items are filtered on this account code. What I want, though, is for one YTD activity data item to be filtered on the indirect costs account code and the other to return all YTD activity less revenue and indirect costs-i.e., only direct costs.
it will be better, if you can describe your goal specifically.
How are you showing the data? Via List/crosstab?
Or much better, you can plot what you want to do in excel, have a screenshot and post it here.