com.sap.sl.sdk.authoring.datafoundation

Interface DerivedTable

All Superinterfaces:

Identifiable, Inheritable, Nameable, Table

public interface DerivedTable
extends Table

A representation of the model object 'Derived Table'.

A derived table is a virtual table in the data foundation that combines other tables using calculations and functions. See the Information Design Tool User Guide for more information.

Use:

• DataFoundationFactory.createDerivedTable(String, String, DataFoundation) to instantiate a derived table for a data foundation.
• DataFoundationFactory.createDerivedTable(String, String, String, MultiSourceDataFoundation) to instantiate a derived table for a multisource-enabled data foundation.

The following features are supported:

• Expression
• Source Short Name

Method Summary

Modifier and Type	Method and Description
java.lang.String	getExpression() Returns the value of the 'Expression' attribute.
java.lang.String	getSourceShortName() Returns the value of the 'Source Short Name' attribute.
void	setExpression(java.lang.String value) Sets the value of the 'Expression' attribute.
void	setSourceShortName(java.lang.String value) Sets the value of the 'Source Short Name' attribute.

Methods inherited from interface com.sap.sl.sdk.authoring.datafoundation.Table

getColumns, getDataFoundation, getDescription, setDescription

Methods inherited from interface com.sap.sl.sdk.authoring.commons.Identifiable

getIdentifier

Methods inherited from interface com.sap.sl.sdk.authoring.commons.Nameable

getName, setName

Methods inherited from interface com.sap.sl.sdk.authoring.commons.Inheritable

getInheritedData

Method Detail

getExpression

java.lang.String getExpression()

Returns the value of the 'Expression' attribute.

This is the SQL expression of the derived table.

Returns:

the value of the 'Expression' attribute.

See Also:

setExpression(String)

setExpression

void setExpression(java.lang.String value)

Sets the value of the 'Expression' attribute.

This is the SQL expression of the derived table. The list of columns will be recalculated only if it has been emptied using Table.getColumns().clear().

Parameters:

value - the new value of the 'Expression' attribute.

See Also:

getExpression()

getSourceShortName

java.lang.String getSourceShortName()

Returns the value of the 'Source Short Name' attribute. The default value is "".

This string identifies the data source on which the query must be executed. In the case of a single-source data foundation, the methods returns an empty string. Use this method only for multisource-enabled data foundations:

• In the case of a derived table built from tables of multiple data sources, the method returns an empty string. Its SQL expression uses the standard SQL-92 syntax.
• In the case of a derived table built from tables of one data source that uses a database-specific SQL syntax, the method returns DataFederatorSourceInfo.getShortName()

Returns:

the value of the 'Source Short Name' attribute.

See Also:

setSourceShortName(String)

setSourceShortName

void setSourceShortName(java.lang.String value)

Sets the value of the 'Source Short Name' attribute.

Use this method to change the data source on which the derived table is based.

Parameters:

value - the new value of the 'Source Short Name' attribute.

See Also:

getSourceShortName()