Extended Properties for Data Marts

When you are creating a data mart report instance, you can set one or more of the extended properties listed below. To do this, you first use the getProperties method of the WebDatamart interface to create an instance of a Web property set. You then create separate Web property instances, using the property names shown in bold below, and give each instance a value.

Governing properties:

Maximum Execution Time

Lets you set the maximum number of seconds the data mart can take to execute.

Maximum Rows

Lets you set the maximum number of rows to insert into the Analytical Engine at one time when the table is created.

Table-creation properties:

Table Qualifier

Lets you specify keywords to be placed before TABLE in the CREATE TABLE statement.

Table Descriptor

Lets you specify a table descriptor to be created after the CREATE TABLE statement.

Table

Lets you specify a table option to be created after the table name in the CREATE TABLE statement.

Create Table Post String

Lets you specify a table post string to be created after the CREATE TABLE statement.

Table Space

Lets you specify a table space name for the table.

Table Prefix

Lets you specify a prefix for the table.

SQL execution properties:

Pre SQLs

Lets you specify SQL to be executed before the CREATE TABLE statement.

Post SQLs

Lets you specify SQL to be executed after the CREATE TABLE statement.

Cache Pre and Post SQLs

Lets you specify that the SQL executed before and/or after the CREATE TABLE statement should be cached

Insert SQLs

Lets you specify SQL to be executed after the CREATE TABLE statement and before the INSERT statement.

Sample Code for Setting Extended Properties for a Data Mart

//define other extended properties

WebPropertySet extendedProperties = datamart.getProperties();

WebProperty maxRows = extendedProperties.getItemByName("Maximum Rows");

maxRows.setValue("100");

WebProperty tablePrefix = extendedProperties.getItemByName("Table Prefix");

tablePrefix.setValue("test_");

...