SAP Dashboards Tutorial
SAP Dashboards Useful Resources
Selected Reading
- Dynamic Dashboard
- Export Format Options
- SAP Dashboards - Data Connections
- Working With Data Sources
- Previewing Models
- SAP Dashboards - Color Schemes
- SAP Dashboards - Themes
- Models & Templates
- Deleting Components & Alerts
- Universe Connectivity
- Web Connectivity Components
- SAP Dashboards - Text Components
- SAP Dashboards - Map Components
- Single Value Components
- Selector Components
- Container Components
- Chart Components
- Setting Component Text
- Component Colors
- Configure Component Properties
- Setting Component Properties
- Binding Components
- SAP Dashboards - Properties Panel
- Working With Components
- Docking/Undocking
- SAP Dashboards - Quick Views
- SAP Dashboards - Object Browser
- Components Browser
- SAP Dashboards - Font Options
- SAP Dashboards - WorkSpace
- SAP Dashboards - Version
- SAP Dashboards - Introduction
- SAP Dashboards - Home
SAP Dashboards Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
SAP Dashboards - Data Connections
SAP Dashboards - Data Connections
You can connect your model to an external data source. When you run the model, data is updated as per the current information in the data source. You can connect to an external data sources in the following ways −
Using an External data connection in Data Manager
Create query from BI source
Managing Data Connections
You can manage all the data connections using the Data Manager (CTRL + M). To open the Data Manager, go to Data → Connections as shown in the following screenshot.
In SAP Dashboard Designer, the following data connections are supported −
Query as a Web service (QWAAS)
Web Service Connection
SAP NetWeaver BW connection
XML Data
Crystal Report Data Consumer
Live cycle Data Services
External Interface Connection
Live Office Connections
Web Dynpro apppcation as Flash Island and many more as below.
Adding an External Data Connection
To add an external data connection, go to Data → Connections as shown in the following screenshot.
In the Data Manager Dialog Box, cpck on Add Connection and select a connection type from the pst.
The next step is to configure the data connection.
To delete a connection, select the connection in the data manager and cpck on the Delete button.
How to Configure a Query as a Web Service?
To configure a query as a web service, go to Data → Connections. In the Data Manager dialog box, cpck on Add → select Web Service Query.
In the Definition window, enter the following details −
Name − A name for the connection.
WSDL URL − Type URL for WSDL generated by the web service query or select from the pst. Cpck Import.
Select the method from the drop down pst. When you select the method, the web service URL is displayed.
| RunQueryAsAService | This web service call is generated for index unaware prompts. This method requires an Enter_Year_As string as the prompt value for year. |
| RunQueryAsAServiceEx | This web service call is generated for index aware prompts. The input and output parameter sets are the same as for RunQueryAsAService method except for the input prompt for year values. This method requires an instance of LovValueIndex for year. |
| Valueof_ | This method is generated only when the Web service query encloses atleast one prompt and is intended to provide a pst of values for the prompt it is named after. |
Input Value −
| Input Values | When you import the WSDL, the required inputs defined for the web service are displayed in this pst. To set a value for each item, select the input object from the pst then set the Read From option to map it to your model. |
Read from and Output Value −
| Read From | If the input values pst includes items that require input, select the input item and then cpck the cell selector ( |
| Output Values | When you import the WSDL, the output parameters for the results object in the web service are displayed in this pst. |
) to select a cell from the embedded spreadsheet where the selected object will retrive its value.In the Usage tab, set the refresh and message options as shown in the following screenshot.
In a similar way you can configure other external data connections as well in the Dashboard.
Advertisements