Interested to Buy Any Domain ? << Click Here >> for more details...
What are Sql Reporting Services and analysis services? Can
u Explain
- 1 Answers
- 10025 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 is the user of Primary key?
What are the instances when triggers are appropriate?
What are partitioned views?
What are the different types of columns types constraints in the sql server?
Is the log file is a part of file group?
What is difference between order by and group by?
If no size is defined while creating the database, what size will the database have?
Can the query output be sorted by multiple columns in ms sql server?
what's sql server? : Sql server database administration
How to write a query with a left outer join in ms sql server?
What is named calculation? : sql server analysis services, ssas
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is difference between aggregate and analytic function?
What is difference between foreign key and unique key?
What Are the Main Features of SQL Azure?
