| Author |
 Topic  |
|
|
Bruce
Canada
51 Posts |
 Posted - 11/01/2006 : 12:39:55
|
I have a problem, but I am not sure if this belongs here or in the Wish List.
I have a sales report that has 3 filters, all items, all customers and a date filter. I set the date filter to show the last day of the data so that I calculate YTD versus YTD last year. (today it would show Oct 31 2006). So far so good everything works.
I wanted to avoid manually changing the date filters each day, now I changed the date filter to be an MDX filter (Tail(Filter(date...)). This also works great.
The problem arrives when the end user changes the customer or item filter box to something other than "All", the MDX filter is deleted.
So now the report is showing all dates, all items and some customer. AS YTD needs a real date to work with, the report is blank.
Is there a way to fix this or is this a wish for future updates?
Thanks
Bruce
Using SSAS 2000, RP build 128 |
Edited by - Bruce on 11/01/2006 13:04:43 |
|
|
admin
1645 Posts |
Posted - 11/01/2006 : 20:17:44
|
| Have you tried using your MDX expression in the “default member” property of your time dimension? |
 |
|
|
Bruce
Canada
51 Posts |
Posted - 11/02/2006 : 08:55:52
|
Good idea that I never thought of.
It works in most cases.
Bruce
 |
|
|
|
Bruce
Canada
51 Posts |
Posted - 11/07/2006 : 07:24:53
|
Just a further note on this. The filters are populated only by the default date (yesterday), and do not show the entire range of possiblities. If I ran a report everything showed up, but the filter box still did not show those missing items in the drop down.
I switched on the "filters depend on one another" option and this problem was fixed. However there was a trade off as the filters took some time to populate.
Is this a problem? I assume with the filters depend on one another option turned off, the filter boxes would show every possiblity.
Thanks
Bruce |
Edited by - Bruce on 11/07/2006 07:35:08 |
|
|
|
admin
1645 Posts |
Posted - 11/09/2006 : 10:12:00
|
Please try this option:
Options > Non Empty > Check “Show Filter Empty Items” |
|
|
| |
Topic |
|
|
|
Report Portal
Mixing RP and MDX filters on one report
