Sorry for the bump, I think I can make what I'm asking a bit clearer.
Essentially what I'm asking is:
Is there any way that the current time, according to my PC, can be used to drive filters?
I don't know anything about cubes so I have no idea if this applies. But...
-- The last x days can be done with a date filter. Drop the Date field on the filter shelf and set it for last x days, then it will filter and show the last x day counted back from the date the workbook is opened.
-- If you filter on TODAY() you'll only get records for the date the workbook is opened
-- Time is a little trickier. You can use NOW() if DateTime format works for you. If you only want time to the second you'll have to do this: LEFT(RIGHT(STR(NOW()),14),9) which gives you the current time expressed as a string e.g. "21:12:04"
There are several other date related functions that make dealing with dates relatively easy. But again I have no idea what issues you'll have to deal with when working with cubes.
Thanks, but that's only available for relational data sources as far as I can tell.
I'm not hopeful that it's possible with cubes, but I wanted to make sure there's no workaround. I've looked at several dashboard tools and not many seem to have functionality for date dimensions.
Adam, sorry these functions don't work on cubes. Thanks, that's good to know just in case I ever run into one (not likely). Maybe this exchange will pique the interest of one of the folks that really know their stuff and you'll get a definitive answer, I sure hope so.
I ran into the same problem.
Saw the beautiful date-filtering options given with tableau 7 and want to use them with Microsoft analysis services.
But my experience were, that it works only with flatfiles like excel or relational database. In both cases the date fields have to be formatted as date or datetime.
I would be happy if anyone has got a workaround to use this filter options with cubes.
I don't have a working SQL Server cube to hand to try this out for you but there is an MDX function called Now(), how about creating a calculated member using the NOW() function and then using that for filtering?