We have a traditional layered approach in our FM models usign 4 layers: (data, logical,presentation,dimensional).
I want to be able to have a dimension with different subset of information:
DimItems (Products)
DimItems(Raw Materials)
DimItems(Spare Parts)
e.t.c
Is there any preference between using Native Views at Data Layer import or Filters in logical view? Provided that all necessary db indexes exist.
Not sure if there is a "best practice", but personally I like to keep the data layer as clean as possible so I would probably put them as filters.
I would probably just create a quick test package (or fork a package) and look at the generated SQL in a report. Should not take long and you can see the effect on the SQL. If they are very different which I find unlikely, dump the SQL into your database's tools and get an explain plan to see which is better performing.