How can i restrict number of rows from a dimension


I have following data in one of my dimension table.


Id                               display_name                        category

1                                 A                                                alpha

2                                 B                                                alpha

3                                 C                                                alpha

4                                  001                                           count

5                                  002                                           count


Now in my analysis view i want to see data with alpha category only. How can i implement this in OLAP schema. Neither i want to use database views nor I can change this table data. Can anybody help me? 


Thanks in advance,


Post Edited by arunsinghal01 at 02/01/2010 12:41
arunsinghal01's picture
Joined: Aug 26 2009 - 12:49am
Last seen: 14 years 1 month ago

0 Answers:

No answers yet