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 |
|
wkm1925
Posting Yak Master
207 Posts |
 Posted - 2011-08-02 : 23:24:48
|
| I intent to develop an application with no insert, no delete and no update. It's just VIEW the data like reportingWith1. Visual Studio 20102. SQL Server 2008 Database Engine3. SAP Crystal ReportI can achieve the above objectiveI want to know, what's the significant features I can get if I'm using SQL Server 2008 Analysis Services?Please help to digest the beauty of Analysis Services. As a result, I can make the decision wisely |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-02 : 23:28:08
|
If the data never changes, you never need to rebuild your cubes.One (or more) less jobs to fail  |
 |
|
|
wkm1925
Posting Yak Master
207 Posts |
Posted - 2011-08-02 : 23:34:15
|
| I'm not intend to build a data warehouse. i just need to build the application can view the report only |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-03 : 01:27:05
|
| Then just build your report.Is contention (blocking) expected to be an issue?Analysis Services allows you to fairly easliy build cubes which you can report against. But, you can always report against your OLTP data. Depends very much on what your requirements are. Sometimes it makes sense to replicate your OLTP data and report against that. Sometimes it makes sense to build a data warehouse for reporting purposes.We don't have enoguh information to give you solid advice. |
|
|
|
|
|
|
What's the beauty of SQL Server Analysis Services?