Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dave1500
Starting Member
3 Posts |
 Posted - 2008-12-15 : 12:39:15
|
| Hi, I am beginning a new reporting project. For the first time it has been suggested that I use a single Data Source View for reporting . The reporting solution based on a standard MSSQL 2005 database. There is no OLAP involved. I then create a Report model to use as the basis of the reporting solution. I understand the technical concepts involved but am unsure as to the practicalities or limitations of using this approach. I have not used Data Source Views before. Some of the reports will be quite complex. I am worried that the Data Source View and Report Model solution may prove insufficiently flexible and that the more complex reports may require a more traditional query builder approach. I am particularly worried that the single Data Source View (or maybe Data Source Views) may need to be too complex compared to developing reports individually. I am also worried that there may be resource issues in using a complex Data Source View although I have been assured that Data Source Views are efficient in their execution plan. I was wondering if anyone had any experieince of using Data Source Views and Report Models and found them to be a scucessful and flexible solution to their reporting needs. Thanks Dave |
|
|
|
|
|
Data Source Views & Report Models