SAP Dashboard Design Reporting Services Gateway INSTALLATION GUIDE

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 in­stalled.
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 cor­rect location.
<username> does not have sufficient permis­sions 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 infor­mation
SAP Help Portal
SAP Service Marketplace
http://www.sap.com
Navigate to http://help.sap.com/businessobjects and on the "SAP Busi­nessObjects 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 in­formation 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...