Dashboard Design Reporting Services Gateway Installation Guide
■ Dashboard Design Reporting Services Gateway
2010-11-05
Copyright
© 2010 SAP AG. All rights reserved.SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP
Business ByDesign, and other SAP products and services mentioned herein as well as their respective
logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business
Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web
Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well
as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the
United States and in other countries. Business Objects is an SAP company.All other product and
service names mentioned are the trademarks of their respective companies. Data contained in this
document serves informational purposes only. National product specifications may vary.These materials
are subject to change without notice. These materials are provided by SAP AG and its affiliated
companies ("SAP Group") for informational purposes only, without representation or warranty of any
kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The
only warranties for SAP Group products and services are those that are set forth in the express
warranty statements accompanying such products and services, if any. Nothing herein should be
construed as constituting an additional warranty.
2010-11-05
Contents
About this Guide.....................................................................................................................5Chapter 1
Planning Installations..............................................................................................................7Chapter 2
2.1
2.1.1
2.2
2.2.1
3.1
3.1.1
4.1
4.1.1
4.1.2
4.2
4.3
Index 17
Getting started.........................................................................................................................7
Overview of Dashboard Design Reporting Services Gateway..................................................7
Naming conventions.................................................................................................................7
Variables..................................................................................................................................7
Performing Installations..........................................................................................................9Chapter 3
Installing the Dashboard Design Reporting Services Gateway..................................................9
To install the Dashboard Design Reporting Services Gateway.................................................9
Post Installation....................................................................................................................11Chapter 4
Configuring the Dashboard Design Reporting Services Gateway...........................................11
To configure the Dashboard Design Reporting Services Gateway..........................................11
To configure the XRS virtual directory for Reporting Services 2005.......................................11
Testing the Dashboard Design Reporting Services Gateway..................................................12
Uninstalling the Dashboard Design Reporting Services Gateway...........................................12
More Information...................................................................................................................15Appendix A
2010-11-053
Contents
2010-11-054
About this Guide
About this Guide
This guide is intended for business intelligence users who need to use Microsoft Reporting Services
reports with Dashboard Design.
For more information about features and capabilities, see the
Design User Guide
.
Dashboard Design and Presentation
2010-11-055
About this Guide
2010-11-056
Planning Installations
Planning Installations
2.1 Getting started
2.1.1 Overview of Dashboard Design Reporting Services Gateway
Dashboard Design is a data visualization tool that allows you to create dynamic, interactive dashboards.
These dashboards can access live data, and you can add them to web-based dashboards.
You must install the Dashboard Design Reporting Services Gateway on a Windows web server to be
able to connect to Reporting Services (RS) servers.
Related Topics
• Installing the Dashboard Design Reporting Services Gateway
• Testing the Dashboard Design Reporting Services Gateway
2.2 Naming conventions
2.2.1 Variables
This guide uses the following variables.
2010-11-057
Planning Installations
DescriptionVariable
<REPORTDIR>
<WWWROOTDIR>
The directory where Reporting Services files are located on the Dashboard Design
media.
D:\Connectivity\Reporting Services\
The web application root directory on your Reporting Services Server.
C:\Inetpub\wwwroot\
2010-11-058
Performing Installations
Performing Installations
3.1 Installing the Dashboard Design Reporting Services Gateway
You can install the Dashboard Design Reporting Services Gateway (XRS) on a Windows web server
connected to a Reporting Services (RS) server. You can also install the XRS on an RS server.
Note:
If you use Reporting Services 2005, you must configure the XRS virtual directory to point to an application
pool different from the Report and ReportServer virtual directories.
Related Topics
• To configure the XRS virtual directory for Reporting Services 2005
3.1.1 To install the Dashboard Design Reporting Services Gateway
Before you install the Dashboard Design Reporting Services Gateway (XRS), ensure that Microsoft
Reporting Services and the .NET Framework are installed, running, and configured to use a data source.
1.
Run <REPORTINGDIR>/setup.exe from the Dashboard Design media.
The interactive installation wizard appears.
2.
Proceed through the wizard to the "License Agreement" page, review the License Agreement, select
I accept the License Agreement, and click Next.
3.
Enter the virtual directory name into the "Virtual Directory Name" field.
4.
(Optional) To test system operation with other ports, enter a new port number into the "Port Number"
field.
Note:
Ensure that your IIS server configuration includes the same port.
5.
Click Next.
The installation begins.
6.
When the installation is complete, click Finish.
You can now configure the XRS.
2010-11-059
Performing Installations
Related Topics
• Variables
2010-11-0510
Post Installation
Post Installation
4.1 Configuring the Dashboard Design Reporting Services Gateway
4.1.1 To configure the Dashboard Design Reporting Services Gateway
After you install the Dashboard Design Reporting Services Gateway (XRS), you can configure it.
1.
On your Reporting Services Server, copy <WWWROOTDIR>\wss\<virtualdirecto
ry>\80\web.config to web.config.bak
2.
Open web.config in a text editor.
3.
Change localhost to new values for the following parameters:
New valueParameter
• ReportingServicesUrl
• ReportServerUrl
XrsServicesUrl
4.
Ensure that the authentication methods for the Report, ReportServer, and XRS virtual directories
match on the "Directory Security" tab of your IIS settings.
5.
Save and close web.config
Related Topics
• Variables
The name of the server on which Reporting
Services is installed.
The name of the server on which XRS is installed.
4.1.2 To configure the XRS virtual directory for Reporting Services 2005
2010-11-0511
Post Installation
After you install the Dashboard Design Reporting Services Gateway (XRS), you can configure the XRS
virtual directory.
Note:
You must configure the XRS virtual directory to point to an application pool different from the Report
and ReportServer virtual directories.
1.
In the Report directory, on the Virtual Directory tab, click the application pool list and note its value.
2.
Open the SRS virtual directory properties, and change the application pool to a value different from
the value used for the Report virtual directory.
4.2 Testing the Dashboard Design Reporting Services Gateway
To test the Dashboard Design Reporting Services Gateway, use a web browser to navigate to the
following URL on your Reporting Services Server, and log in using the information in the web.config
file.
http://<reporting_services_server>/xrs/srx.asmx/GetReports
Note:
If you run the test on a local machine, you may not be asked to log in.
If the test succeeds, XML-formatted output containing <param> and <report> tags appears. The
output may also contain additional messages:
SolutionMessage
License Key Failed - LogonUser failed
with error code: 87
License Key Failed - Could not find
file "C:\inetpub\wwwroot\xrs.xky".
The permissions granted to user
'<username>' are insufficient for
performing this operation.
Add the Administrator credential information to
the web.config file on the server.
Ensure that a valid license key exists in the correct location.
<username> does not have sufficient permissions to view reports in Reporting Services.
4.3 Uninstalling the Dashboard Design Reporting Services Gateway
You can use Add/Remove Programs or Programs and Features in "Control Panel" to repair, modify,
or remove your installation of the Dashboard Design Reporting Services Gateway.
2010-11-0512
Post Installation
Note:
If you have configured any virtual directories, copy <WWWROOTDIR>\wss\<virtualdirecto
ry>\80\web.config.bak to web.config for every virtual directory.
Related Topics
• Variables
2010-11-0513
Post Installation
2010-11-0514
More Information
More Information
LocationInformation Resource
SAP BusinessObjects product information
SAP Help Portal
SAP Service Marketplace
http://www.sap.com
Navigate to http://help.sap.com/businessobjects and on the "SAP BusinessObjects Overview" side panel click All Products.
You can access the most up-to-date documentation covering all SAP
BusinessObjects products and their deployment at the SAP Help Portal.
You can download PDF versions or installable HTML libraries.
Certain guides are stored on the SAP Service Marketplace and are not
available from the SAP Help Portal. These guides are listed on the Help
Portal accompanied by a link to the SAP Service Marketplace. Customers
with a maintenance agreement have an authorized user ID to access
this site. To obtain an ID, contact your customer support representative.
http://service.sap.com/bosap-support > Documentation
• Installation guides: https://service.sap.com/bosap-instguides
• Release notes: http://service.sap.com/releasenotes
The SAP Service Marketplace stores certain installation guides, upgrade
and migration guides, deployment guides, release notes and Supported
Platforms documents. Customers with a maintenance agreement have
an authorized user ID to access this site. Contact your customer support
representative to obtain an ID. If you are redirected to the SAP Service
Marketplace from the SAP Help Portal, use the menu in the navigation
pane on the left to locate the category containing the documentation you
want to access.
Docupedia
Developer resources
https://cw.sdn.sap.com/cw/community/docupedia
Docupedia provides additional documentation resources, a collaborative
authoring environment, and an interactive feedback channel.
https://boc.sdn.sap.com/
https://www.sdn.sap.com/irj/sdn/businessobjects-sdklibrary
2010-11-0515
More Information
LocationInformation Resource
SAP BusinessObjects articles on
the SAP Community Network
Notes
Forums on the SAP Community
Network
Training
Online customer support
https://www.sdn.sap.com/irj/boc/businessobjects-articles
These articles were formerly known as technical papers.
https://service.sap.com/notes
These notes were formerly known as Knowledge Base articles.
https://www.sdn.sap.com/irj/scn/forums
http://www.sap.com/services/education
From traditional classroom learning to targeted e-learning seminars, we
can offer a training package to suit your learning needs and preferred
learning style.
http://service.sap.com/bosap-support
The SAP Support Portal contains information about Customer Support
programs and services. It also has links to a wide range of technical information and downloads. Customers with a maintenance agreement
have an authorized user ID to access this site. To obtain an ID, contact
your customer support representative.
Consulting
http://www.sap.com/services/bysubject/businessobjectsconsulting
Consultants can accompany you from the initial analysis stage to the
delivery of your deployment project. Expertise is available in topics such
as relational and multidimensional databases, connectivity, database
design tools, and customized embedding technology.
2010-11-0516
Index
I
installation 7, 9
P
post-installation
configuring 11
testing 12
uninstallation 12
XRS virtual directories, configuring
12
R
Reporting Services files, location 7
T
testing 12
U
uninstallation 12
V
variables
Reporting Services files, location
7
web application, root directory 7
W
web application, root directory 7
X
XRS virtual directories, configuring 12
2010-11-0517
Index
2010-11-0518
Loading...