Interested to Buy Any Domain ? << Click Here >> for more details...
What are Sql Reporting Services and analysis services? Can
u Explain
- 1 Answers
- 10150 Views
- I also Faced
- E-Mail Answers
Answer Posted / selvaraj.v
Sql Reporting Services :
-----------------------
Full Reporting Life Cycle Support
SQL Server Reporting Services supports the full reporting
life cycle, including:
• Report authoring. Report developers can create reports to
be published to a report server by using Microsoft or other
design tools that use Report Definition Language (RDL), an
XML-based industry standard used to define reports.
• Report management. Report definitions, folders, and
resources are published and managed as a Web service.
Managed reports can be executed either on demand or on a
specified schedule, and are cached for consistency and
performance. New in SQL Server 2005 Reporting Services,
administrators can use SQL Server Management Studio to
organize reports and data sources, schedule report
execution and delivery, and track reporting history.
• Report delivery. SQL Server Reporting Services supports
both on-demand (pull) and event-based (push) delivery of
reports. Users can view reports in a Web-based format or in
e-mail.
• Report security. SQL Server Reporting Services implements
a flexible, role-based security model to protect reports
and reporting resources. The product includes extensible
interfaces for integrating other security models as well.
Analysis Services :
------------------
SQL Server 2005 Analysis Services (SSAS) provides, for the
first time, a unified and integrated view of all your
business data as the foundation for all of your traditional
reporting, online analytical processing (OLAP) analysis,
Key Performance Indicator (KPI) scorecards, and data mining.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What do you understand by coalesce in sql server?
how can you check the level of fragmentation on a table? : Sql server administration
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Can you tell me about the concept of ER diagrams?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What are the advantages of having an index on the sql server?
How to store and query spatial data?
Explain what is “asynchronous” communication in sql server service broker?
Explain the benefits of user-defined functions?
What command do we use to rename a db, a table and a column?
Explain having clause and where clause?
How do I install only the client tools of sql server 2000?
How to filter out duplications in the returning rows in ms sql server?
How can I check that whether automatic statistic update is enabled or not?
What is DCL?
