net.pricefx.formulaengine

Interface DatamartContext

public interface DatamartContext

Provides an API to query and load PA data from a formula context.

Nested Class Summary

Nested Classes

Modifier and Type	Interface and Description
static interface	DatamartContext.Calendar Helper class mainly, but not solely, for working with dates and time periods as used in the PA module.
static interface	DatamartContext.DataLoader API for DataFeed loading from a formula context.
static interface	DatamartContext.DataSlice A DataSlice defines a set of filters to be applied to a PA DataSet (Datamart, DataSource...).
static interface	DatamartContext.Query API for building a PA query in a formula context.

Method Summary

Modifier and Type	Method and Description
DMCalendar	calendar() Instantiate a PA Calendar utility object.
Table	createDWTable(String tableName, Table table)
Table	createDWTableFromCustomerExtension(String tableName, String cxName)
Table	createDWTableFromCustomerMaster(String tableName)
Table	createDWTableFromLookupTable(String tableName, Long tableLookupId)
Table	createDWTableFromProductExtension(String tableName, String pxName)
Table	createDWTableFromProductMaster(String tableName)
Table	createDWTableFromQuery(String tableName, DatamartContext.Query query)
Object	dimFilterEntry(String entryName, Column column) DimFilter input parameter: renders a selection of all possible values for the given dimension field, in the FC which the column's table represents.
Object	dimFilterEntry(String entryName, Column column, String defaultValue) DimFilter input parameter: renders a selection of all possible values for the given dimension field, in the FC which the column's table represents.
DatamartQueryResult	executeQuery(DatamartContext.Query query) Executes the given DatamartContext.Query.
Object	fieldSelectionEntry(String entryName, Table table, String sType) FC field selector, optionally limited to fields of a given type.
Object	fieldSelectionEntry(String entryName, Table table, String sType, Boolean multiple) FC field selector, optionally limited to fields of a given type.
Table	getDataFeed(String name) Get a table object representing the DataFeed with the given name.
Table	getDatamart(String name) Get a table object representing the Datamart with the given name.
Table	getDataSource(String name) Get a table object representing the DataSource with the given name.
Table	getDWTable(String name) Get a table object representing the DWTable with the given name.
Table	getFieldCollection(String sourceName) Get a table object representing the FC with the given source name.
DatamartContext.DataLoader	newDataLoader(Table feedTable) Instantiate a new DatamartContext.DataLoader to load rows with data for all the feed's attributes.
DatamartContext.DataLoader	newDataLoader(Table feedTable, List<String> headerFieldNames) Instantiate a new DatamartContext.DataLoader to load rows with data for the named fields.
DatamartContext.DataSlice	newDatamartSlice() Creates a new DatamartSlice, which allows for setting filter criteria along the Time, CustomerGroup, ProductGroup any any other dimensions in a Datamart.
Object	newDatamartSlice(String dateFieldName, Object... timePeriodsAndProductAndCustomerGroups) Creates a new DatamartSlice, which allows for setting filter criteria along the Time, CustomerGroup, ProductGroup any any other dimensions in a Datamart, intiialized with the name of the time dimension field, and an optional set filter criteria.
DatamartContext.Query	newQuery(DatamartContext.Query otherQuery) Create a new query from an existing one.
DatamartContext.Query	newQuery(DatamartContext.Query query1, DatamartContext.Query query2, LinkedHashMap<String,String> joinFieldsMap)
DatamartContext.Query	newQuery(DatamartContext.Query query1, DatamartContext.Query query2, LinkedHashMap<String,String> joinFieldsMap, boolean rollup)
DatamartContext.Query	newQuery(Table table)
DatamartContext.Query	newQuery(Table table, boolean rollup) Build a new query on the given table.
StreamResults	streamQuery(DatamartContext.Query query) Executes the given DatamartContext.Query and return so that it can be examined one row at the time.

Method Detail

calendar

DMCalendar calendar()

Instantiate a PA Calendar utility object.

Returns:

Calendar

getDataFeed

Table getDataFeed(String name)

Get a table object representing the DataFeed with the given name. A reference to this table can then be used when building a DatamartContext.Query or DataFeedLoad}.

Parameters:

name - The sourceName, uniqueName or label of the DF.

Returns:

Table representing the DF in the DataContext.

getDataSource

Table getDataSource(String name)

Get a table object representing the DataSource with the given name. A reference to this table can then be used when building a DatamartContext.Query on that DataSource.

Parameters:

name - The sourceName, uniqueName or label of the DS.

Returns:

Table representing the DS in the DataContext.

getDatamart

Table getDatamart(String name)

Get a table object representing the Datamart with the given name. A reference to this table can then be used when building a DatamartContext.Query on that Datamart.

Parameters:

name - The sourceName, uniqueName or label of the DM.

Returns:

Table representing the DM in the DataContext.

getDWTable

Table getDWTable(String name)

Get a table object representing the DWTable with the given name. A reference to this table can then be used when building a DatamartContext.Query on that DWTable

Parameters:

name - The sourceName, uniqueName or label of the DWT.

Returns:

Table representing the DWT in the DataContext.

getFieldCollection

Table getFieldCollection(String sourceName)

Get a table object representing the FC with the given source name. A source name consists of two parts, separated with a '.': - 'DMF', 'DMDS', 'DM' or 'DMSIM', i.e. the typeCode of DataFeed, DataSource, Datamart and Sim-Datamart resp. - the FC's uniqueName A reference to this tbale can then be used when building a DatamartContext.Query on that FC.

Parameters:

sourceName - The sourceName of the FC.

Returns:

Table representing the FC in the DataContext.

newQuery

DatamartContext.Query newQuery(Table table)

Parameters:

table - The table representing the FC to query.

Returns:

DatamartContext.Query builder.

newQuery

DatamartContext.Query newQuery(Table table,
                               boolean rollup)

Build a new query on the given table.

Parameters:

table - Represents the FC to query.

rollup - Line level or rollup query.

Returns:

DatamartContext.Query builder.

newQuery

DatamartContext.Query newQuery(DatamartContext.Query otherQuery)

Create a new query from an existing one. This pattern can be used to build a base or template query, and then instantiate several variants, for example each for a different DataSlice (this year's sales data vs. last year's, etc.).

Parameters:

otherQuery - Query to use as a basis for this new query.

Returns:

DatamartContext.Query builder.

newQuery

DatamartContext.Query newQuery(DatamartContext.Query query1,
                               DatamartContext.Query query2,
                               LinkedHashMap<String,String> joinFieldsMap)

newQuery

DatamartContext.Query newQuery(DatamartContext.Query query1,
                               DatamartContext.Query query2,
                               LinkedHashMap<String,String> joinFieldsMap,
                               boolean rollup)

executeQuery

DatamartQueryResult executeQuery(DatamartContext.Query query)

Executes the given DatamartContext.Query. If for a rollup query the internal row limit, set by means the 'datamart.query.internalRowLimit' Price f(x) instance param, is exceeded, then a null is returned. The rationale for this behaviours is that a rollup, or so called analytical, query result is unreliable if not all data in scope could be examined. This is different to a fetch, or paging, query, which can safely request one page at the time.

Parameters:

query - DatamartContext.Query to execute.

Returns:

DatamartQueryResult providing data in Matrix2D form and summary information in map form.

streamQuery

StreamResults streamQuery(DatamartContext.Query query)

Executes the given DatamartContext.Query and return so that it can be examined one row at the time. This is different to executeQuery, which always return the full data set in scope of the query. When a row is retreived, and moved onwards from, it is no longer available to the client code. The typical usage is to consume the result row by row, processing it into some accumulating data structure.

Parameters:

query - DatamartContext.Query to execute.

Returns:

StreamResults Similar to a JDBC ResultSet, but only implementing next(), get() and close().

newDatamartSlice

DatamartContext.DataSlice newDatamartSlice()

Creates a new DatamartSlice, which allows for setting filter criteria along the Time, CustomerGroup, ProductGroup any any other dimensions in a Datamart.

Returns:

The instantiated, empty, DatamartContext.DataSlice object.

newDatamartSlice

Object newDatamartSlice(String dateFieldName,
                        Object... timePeriodsAndProductAndCustomerGroups)

Creates a new DatamartSlice, which allows for setting filter criteria along the Time, CustomerGroup, ProductGroup any any other dimensions in a Datamart, intiialized with the name of the time dimension field, and an optional set filter criteria.

Parameters:

dateFieldName - Name of the time dimension field.

timePeriodsAndProductAndCustomerGroups - TimePeriod, CustomerGroup, ProductGroup filters.

Returns:

The initialized DatamartContext.DataSlice object.

dimFilterEntry

Object dimFilterEntry(String entryName,
                      Column column)

DimFilter input parameter: renders a selection of all possible values for the given dimension field, in the FC which the column's table represents.

Parameters:

entryName - Input param name.

column - Columns from the table representing the FC to get a dimension field value from.

Returns:

The selected dim field value.

dimFilterEntry

Object dimFilterEntry(String entryName,
                      Column column,
                      String defaultValue)

DimFilter input parameter: renders a selection of all possible values for the given dimension field, in the FC which the column's table represents.

Parameters:

entryName - Input param name.

column - Columns from the table representing the FC to get a dimension field value from.

defaultValue - Value to use if no value has been selected yet.

Returns:

The selected dim field value, or default value if not yet set.

fieldSelectionEntry

Object fieldSelectionEntry(String entryName,
                           Table table,
                           String sType)

FC field selector, optionally limited to fields of a given type.

Parameters:

entryName - Input param name.

table - Table that represents the FC to select a field from.

sType - Type of the field to allow the user to select: NUMBER QUANTITY TEXT DATE MONEY CURRENCY UOM LOB DATETIME

Returns:

The selected FC field.

fieldSelectionEntry

Object fieldSelectionEntry(String entryName,
                           Table table,
                           String sType,
                           Boolean multiple)

FC field selector, optionally limited to fields of a given type.

Parameters:

entryName - Input param name.

table - Table that represents the FC to select a field from.

multiple - Allow one field or multiple fields selection.

Returns:

The selected FC fields' names.

createDWTable

Table createDWTable(String tableName,
                    Table table)

createDWTableFromQuery

Table createDWTableFromQuery(String tableName,
                             DatamartContext.Query query)

createDWTableFromProductMaster

Table createDWTableFromProductMaster(String tableName)

createDWTableFromCustomerMaster

Table createDWTableFromCustomerMaster(String tableName)

createDWTableFromProductExtension

Table createDWTableFromProductExtension(String tableName,
                                        String pxName)

createDWTableFromCustomerExtension

Table createDWTableFromCustomerExtension(String tableName,
                                         String cxName)

createDWTableFromLookupTable

Table createDWTableFromLookupTable(String tableName,
                                   Long tableLookupId)

newDataLoader

DatamartContext.DataLoader newDataLoader(Table feedTable)

Instantiate a new DatamartContext.DataLoader to load rows with data for all the feed's attributes.

Parameters:

feedTable - Table representing the DataFeed to load data in.

Returns:

DataFeedLoad instance providing an API to add (buffer) and flush (commit to the DB) rows to a DataFeed table.

newDataLoader

DatamartContext.DataLoader newDataLoader(Table feedTable,
                                         List<String> headerFieldNames)

Instantiate a new DatamartContext.DataLoader to load rows with data for the named fields.

Parameters:

feedTable - Table representing the DataFeed to load data in.

headerFieldNames - The fields for which values will be loaded. Defaults to all (persisted) fields in the DataFeed if not set.

Returns:

DataFeedLoad instance providing an API to add (buffer) and flush (commit to the DB) rows to a DataFeed table.