SSAS: Named Queries or Database Views?

I was recently asked about the issue of whether it is better to use views in the database or named queries in the data source view (dsv). I don't think there is any one correct answer. I think it comes down to the following 2 issues:

  1. Consistency: If you already have logic in database views, I would continue to use them. As long as you know that you go to one spot to view/change the logic. Putting the logic in 2 different spots could lead to confusion.
  2. Security Permissions: often you may not have permission to alter the source databases, in this case you have no choice but to setup named queries in the dsv.

Ultimately, I am not aware of any significant performance differences, they both result in SQL query being sent to the source system.

Print | posted on Tuesday, September 5, 2006 8:28 PM