Data Warehouse Center Application Integration Guide

BusinessViewInputTable.tag

Use this template to define a relationship between a business view and its source table. You can relate multiple source tables to the business view by reusing the template for each unique instance of a source table.

You must include this template for the following types of business views:

Append editions (*BVType is ISV_BVType_EditionedAppend)
Replace existing data (*BVType is ISV_BVType_Full_Replace)
Append data without editions (*BVType is ISV_BVType_Uneditioned_Append)

This template is optional for business views that use a Visual Warehouse program (*BVType is ISV_BVType_VWP_Population).

Tokens

Table 132 provides information about each token in the template.

Table 132. BusinessViewInputTable.tag tokens

This template contains only relationship parameters.
Token Description Allowed values Window or notebook: field
*BVName Name of the business view.
The name must be unique within the Visual Warehouse control database.
This token is required.
A text string, up to 80 bytes in length. Business View: Business Name
*DatabaseName Name of the database that contains the table.
This token is required.
A text string, up to 80 bytes in length. Information resource: Database
*TableOwner Owner, high-level qualifier, collection, or schema of the table.
The owner must be a valid qualifier by the rules of ODBC.
This token is required.
A text string, up to 15 bytes in length. Table: Name
Business View: Table Name Qualifier
*TablePhysicalName Physical table name as defined to the database manager or file system.
This token is required.
A text string, up to 80 bytes in length. Table: Name
Business View: Database Table Name
*CurrentCheckPointID++ Index, starting with 0, that increases each time it is substituted in a token.
This token is required.
A numeric value. None

This template contains only relationship parameters.
Token	Description	Allowed values	Window or notebook: field
`*BVName`	Name of the business view. The name must be unique within the Visual Warehouse control database. This token is required.	A text string, up to 80 bytes in length.	Business View: Business Name
`*DatabaseName`	Name of the database that contains the table. This token is required.	A text string, up to 80 bytes in length.	Information resource: Database
`*TableOwner`	Owner, high-level qualifier, collection, or schema of the table. The owner must be a valid qualifier by the rules of ODBC. This token is required.	A text string, up to 15 bytes in length.	Table: Name Business View: Table Name Qualifier
`*TablePhysicalName`	Physical table name as defined to the database manager or file system. This token is required.	A text string, up to 80 bytes in length.	Table: Name Business View: Database Table Name
`*CurrentCheckPointID++`	Index, starting with 0, that increases each time it is substituted in a token. This token is required.	A numeric value.	None

Examples of values

Table 133 provides example values for each token to illustrate the kind of metadata you might provide for each token.

Table 133. Example values for BusinessViewInputTable.tag tokens

Token Example value
*BVName Revenue_by_Geography_1
*DatabaseName Operational_system_files
*TableOwner ISV_DEFAULTVALUE
*TablePhysicalName z:\geography\regions\geo1.file
*CurrentCheckPointID++ 13

Token	Example value
`*BVName`	Revenue_by_Geography_1
`*DatabaseName`	Operational_system_files
`*TableOwner`	ISV_DEFAULTVALUE
`*TablePhysicalName`	z:\geography\regions\geo1.file
`*CurrentCheckPointID++`	13

[ Top of Page | Previous Page | Next Page ]