Author Topic: Problem with filter and crosstab  (Read 799 times)

Offline rafaelwk

  • Associate
  • **
  • Posts: 1
  • Forum Citizenship: +0/-0
Problem with filter and crosstab
« on: 30 Dec 2009 05:44:20 pm »
I have a problem with filter and crosstab,

when I use a filter in on crosstab, appear an error:

"This query contains set aggregation. Detail of summary filters should not be applied"

and  not le me use a filter,
why?

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Posts: 2,909
  • Forum Citizenship: +137/-1
  • Cognos Software Muppet
Re: Problem with filter and crosstab
« Reply #1 on: 04 Jan 2010 10:06:21 pm »
Is this ReportNet or Cognos 8?

Sounds a lot to me like Cognos 8 - with the report written using a dimensional package.  What filter do you wish to apply?  Could it be done with a slicer?

MF.
Meep!