SSAS - just the last few years

Question

SSAS - just the last few years

darth vodka

SSCrazy

Points: 2367
More actions
January 7, 2009 at 9:56 am

#204721

hi
i have cube, very nice
just wondering how to restrict it to the last few years...i don't need to create a partition do i?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 1

What do you mean restrict it? You could use security to prevent users from accessing the dimension members for older years. You could filter data out of the cube entirely by limiting the query in your dsv. What are you trying to accomplish?

darth vodka SSCrazy Points: 2367 More actions · Answer 2

hi

i'm trying to filter the data source, to get rid of old years from the data source completely...

regards

dv

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 3

Just add a WHERE to your dsv and full-process the cube.

darth vodka SSCrazy Points: 2367 More actions · Answer 4

i think i'm missing something obvious here...how do i change the SQL of the DSV?

?

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 5

In BIDS, when you created the cube you had to create at least one dsv (data source view) that is basically a collection of queries against your data source(s) and the relationships between those queries. It will be near the top in the project explorer when you have your SSAS project open.

In this dsv, you will find either the fact table, or a query representing your fact data. If the table itself is referenced, you can right-click on it and convert it to a query. You then just have to add a WHERE clause to limit the data returned.

darth vodka SSCrazy Points: 2367 More actions · Answer 6

aaaah

i actually have three tables and i replaced one with a named query and stuck a filter onit

thanks muchly :D:D:D