Data Service

An element that provides access to data, such as that in a query, BAPI, or stored procedure, from one of different types of systems configured on the portal.

Group: N/A

Model level: iView

Restrictions: The list of available systems depends on what is configured in the portal and how it is configured. For example, SAP BW systems 3.1C configured as OLAP systems using the BI XMLA Connector are displayed as OLAP query data services in the workspace. SAP BW systems 3.5 and higher configured with the SAP Java Connector, however, are displayed as BI queries in the workspace. See the SAP NetWeaver Visual Composer Installation & Configuration Guide for more information about preparing your back-end systems.

Structure

The following table describes the properties and attributes available in different types of systems:

Data Service	Property	Attribute	Description
SAP Data Service	Service name		Name of the data service as referred to in Visual Composer
	System alias		The alias defined for the system in the portal system landscape
	System type		Formal name of the back-end system
	Technical name		Technical name assigned to the data service
	Auto commit		For function modules that modify the database, a second "commit" call is automatically sent to confirm the database update
	Auto convert		Indicates that a conversion BAPI is required, for values in one unit of measurement to another
SAP Web service	Service name		Name of the web service as referred to in Visual Composer
	System alias		The alias defined for the system in the portal system landscape
	System type		Formal name of the web service system
	Technical name		Technical name assigned to the data service
	Auto commit		For function modules that modify the database, a second "commit" call is automatically sent to confirm the database update
	Auto convert		Indicates that a conversion BAPI is required, for values in one unit of measurement to another
BI Query	Name		Name of the data service as referred to in Visual Composer
	System		BI system name, which you can edit in case you move the model to a different system environment
	Provider		Technical name of the InfoProvider (not editable)
	Query		Technical name of the query (not editable)
	View		Technical name of the query view, if applicable (not editable)
	Maximum rows		Display limit of the query's result as deployed to the portal, to avoid unintentionally returning a very large result
	Suppress sum		Indicates that the result rows should not be displayed in the query result
Characteristic	Name		Name of the data service as referred to in Visual Composer
	System		BI system name, which you can edit in case you move the model to a different system environment
	Provider		Technical name of the InfoProvider (not editable)
	Technical name		Technical name of the characteristic (not editable)
	Read mode	Master Data Table	Offers all values of the selected characteristic that appear in the master data table. Since InfoCubes may be quite sparsely populated, this will yield many selections that show no results, but the logic involved is simple and hence the performance is optimal.
	Read mode	Dimension Table	Performs a SELECT on the dimension table to retrieve the list of characteristic values. This calculation is more time-consuming than Master Data Table, but with better chances of yielding applicable results.
Relational Query	Name		Name of the data service as referred to in Visual Composer
	System		System name, which you can edit in case you move the model to a different system environment
	Maximum rows		Display limit of the query's result as deployed to the portal, to avoid unintentionally returning a very large result
OLAP Query	Name		Name of the data service as referred to in Visual Composer
	System		System name, which you can edit in case you move the model to a different system environment
	Maximum rows		Display limit of the query's result as deployed to the portal, to avoid unintentionally returning a very large result