You want to display top 20 rows of the relational table in the diimensional table.
How you will achieve it in SSAS.
I wondered the important use of DSV is to integrate the tables from different DS.
For achieving above functionality there is one another option in DSV where you can customize your SQL to fetch the corresponding Rowset from the Relational tables.
Here is the tip as it is in the blog.
http://markiehill.blogspot.com/2005/08/restricting-rows-in-analysis-services.html
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 !
Meet you all in the next blog. Awaiting the next meet.
