Hi,
Is there any workaround other than ranking to solve the “cannot use aggregates in compex filters” problem ?
Because when I do ranking, I lose the sorting order.
Thanks
nandita (BOB member since 2004-06-22)
Hi,
Is there any workaround other than ranking to solve the “cannot use aggregates in compex filters” problem ?
Because when I do ranking, I lose the sorting order.
Thanks
nandita (BOB member since 2004-06-22)
Isolate your data using a sub-query.
Use the sequential query process in version 6.
Export your report data to a text file and import that new file as a data provider, using filters on the new data set.
Use VBA to create a new data provider within the document.
Enough options?
Some of them are easier than others, of course.
Dave Rathbun (BOB member since 2002-06-06)
Another option:
Ask your universe designer if he/she can provide a Dimension object based on the SQL statement Rank or Dense Rank etc. Once created you can use this dimension “Rank” object in your result set of your data provider, and you can filter on it etc. (in other words do the ranking on the database side instead of in the report).
Andreas (BOB member since 2002-06-20)
If possible… i.e. you need to filter on aggregation at the SAME granule as your query…
Apply your filter requirements as a query condition. The SQL will allow you to effectively filter on an aggregate (i.e. a HAVING clause)
…just another option
philmorris (BOB member since 2002-11-12)