Query Filters or Report Filters In Information space

Hi

How can I apply filters in my information space.

I know after creating we can select filters but just like in webi we hace query filters which when applied will show only that specific data.

I am using Universe built on top of database.

I can have predefined filters in that but if in that case if we require lot of filters then how can we manage.

Other approach i found is through create one more information space on top of excel and keeping only those records which we want to filter.

But we also have to take user id.

and then in main Information space e can personalize but then this will only apply filter that particular user.

This sometimes does not work.

Is there any other approach for filters before generating information space like query filter or similar.

Thanks and Regards

Gaurav.