Limiting or "Filtering" A Cube By Date in Analysis Services

Good Morning Fellow MSAS-niks!

Thanks in advance for any light you may be able to shine on this
issue. I know of only two ways to set up an MSAS Cube and limit or
filter it by date:

1. Create a view in SQL Server, with a where clause limiting date,
and then build a Cube on the view. This seems to create performance
problems re build. I have had little success with this technique

or,

2. Within an MSAS Cube, create a date partition with a where clause
limiting data and then also within Cube edit, go to the date dimension
and then "source table" within properties and place that same where
clause expression. That seems to work.

Am I missing something? Are there better techniques?

Thanks so much.

Pete

Pete Hohenhaus
Kirkland, WA, East Side Seattle

An obvious answer would be to have a Time dimension and then you could slice
based on that dimension.
Somehow I get the feeling that you are asking something different.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Pete Hohenhaus" <cam_pete (AT) hotmail (DOT) com> wrote

Dave --

Thanks but yes I am asking a different question. To enhance
processing time for some Cubes I do not want to incorporate data for
all dates, all time, instead what I want to do is do a last 7 days
Cube, or a last 3 months Cube, for example. The only ways I know how
to do this are covered in my first message.

But, shouldn't there be easier ways of doing this? And, why when I
filter on a source table date column do I also have to build a similar
partition for it to work?

Any insight would be greatly appreciated.

Pete


cam_pete (AT) hotmail (DOT) com (Pete Hohenhaus) wrote in message news:<3b5c906d.0309080641.3ed5efa1 (AT) posting (DOT) google.com>...