Author Topic: Filtering in Active Reports 10.2.2  (Read 373 times)

Offline GoKartMozart

  • Full Member
  • ***
  • Join Date: Oct 2017
  • Posts: 6
  • Forum Citizenship: +0/-0
Filtering in Active Reports 10.2.2
« on: 27 Oct 2017 08:04:02 am »
Hi

I'm trying to produce an active report in 10.2.2 with a chart filtered by multiple criteria

The chart is a column chart visualisation with

Measure: Income
Category: Provider

The filter criteria are 'subject' and 'income source'. The requirement is to filter by these criteria but not display them on the chart.

I can include them in the query and extra categories of the chart but this changes the grain of the query (as expected). This means the totals of the measure as displayed in the chart is wrong. For example, the income the highest subject is returned rather than the total income for the provider.

So, my question is: Is it possible to have extra items in the query without affecting the aggregated measure?

Cheers

James

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,208
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: Filtering in Active Reports 10.2.2
« Reply #1 on: 27 Oct 2017 08:22:33 am »
Hi James,

Quick sanity check:

1. Build the visualization with just the following and see what result you get:
Measure: Income
Category: Provider

2. Add the following items into Extra Categories and see what result you get:
Extra Category: Subject
Extra Category: Income Source

You should see exactly the same result. If not, let's check to see you're using the right approach in your report.

When using visualizations, you wouldn't use a data deck, as these can only display one card at a time. You'd use a visualization on its own (not within a data deck), and your controls use the FILTER option connecting directly to the visualization, rather than the SELECT option you would use when linking them to a data deck.

Can you tell us exactly how the controls and the visualization are linked? From your description of only seeing the highest subject, it makes me guess a data deck is in play...

Cheers!

MF.
Meep!

Offline GoKartMozart

  • Full Member
  • ***
  • Join Date: Oct 2017
  • Posts: 6
  • Forum Citizenship: +0/-0
Re: Filtering in Active Reports 10.2.2
« Reply #2 on: 30 Oct 2017 06:02:09 am »
Hi MF

Thanks for replying. The controls are linked directly to the chart but the charts are nested inside a standard deck. I've tried producing it from scratch and the filtering and aggregation works as expected.

Cheers

James

 


       
Twittear