filter top 500 data

building reports desktopintelligence
1

hi ,

I have all dimension columns in my report and i need to filter first 500 records. Please advice whta needs to be done as i dont have any measure i cannot use rank function.

Thanks in adv
abc

abc (BOB member since 2007-06-05)

2

What is the selection criteria? Is it only the first 500? If it is so, I think you can use rowindex()

cyberdude :india: (BOB member since 2007-02-05)

3

i used row index but i am unable to put a filter it says list of value not available

abc (BOB member since 2007-06-05)

4

try row level restriction may be it helps you

Nags :india: (BOB member since 2007-02-07)

5

could you please tell me what exactly we need to do at row level restrictions

abc (BOB member since 2007-06-05)