TableSource

Package: model.database.source

References a CWM NamedColumnSet (Table or View) as the data source. May carry optimization hints, an optional SQL WHERE pre-filter, aggregation-table references and aggregation-exclude rules.

Extends

• RelationalSource 🔗

Attributes

Name	Id	Type	Lower	Upper	Default

References

Name	Type	Lower	Upper	Containment
table	NamedColumnSet🔗	1	1	false
The backing CWM table or view.
optimizationHints	TableQueryOptimizationHint🔗	0	∞	true
Optional optimization hints (e.g. index-usage, access-plan overrides).
sqlWhereExpression	SqlStatement🔗	0	1	true
Optional SQL WHERE clause expression that filters the table data before processing by the OLAP engine.
aggregationExcludes	AggregationExclude🔗	0	∞	true
Rules that specify when aggregation tables must not be used for this source.
aggregationTables	AggregationTable🔗	0	∞	true
Pre-computed aggregation tables available to accelerate queries against this source.

Used by

• ParentChildLink🔗 → table

ClassDiagramm