Monday, August 29, 2005

Restricting Rows In Analysis Services 2005

Quick Tip:

When working with a cube and you want to restrict the rowset that is returned for testing etc you can do this within the DSV.

Right click on the fact table and select the replace table with named query option. You will then be presented with a query editor, edit the select statement to include select top x where x is the number of rows you want to test with.

This saves you from having to ask for or change database objects / views etc , pretty cool !