Hi,
I am trying to place a filter on a slicer within a query. My report uses a cube as an object and I am using the topcount function to create the slicer data. I can apply filters using dimensions that are not used in the slicer but I can't seem to apply a working filter to the same dimension as the slicer.
Any help on resolving this would be much appreciated, as query runs in about 1/10 of the time using a slicer.
Thanks!