SAColumn Structure

Use the SAColumn structure to represent the logical column in the Subject Area.

The SAColumn structure is used in the MetadataService Service.

SAColumn Structure Fields

Fields Description

String name

Specifies a column name used in SQL statements.

String displayName

Specifies a localized name, used in an Oracle Analytics analysis.

String description

Specifies a string to contain the description of the column name.

boolean nullable

If set to TRUE, then the column can be null.

String dataType

Specifies the type of data that a column contains.

boolean aggregateable

If set to TRUE, then the column can be aggregated.

String aggrRule

If the column contains aggregated data, this value specifies the type of aggregation used.

SADataType Values

The SADataType indicates the type of data that a column contains.

The following list shows the data types available:

  • BigInt

  • Binary

  • Bit

  • Char

  • Coordinate

  • Date

  • Decimal

  • Double

  • Float

  • Integer

  • Invalid

  • LongVarBinary

  • LongVarChar

  • Numeric

  • Real

  • SmallInt

  • Time

  • TimeStamp

  • TinyInt

  • Unknown

  • VarBinary

  • VarChar

AggregationRule Values

The AggregationRule specifies the default aggregation rule for the column.

The following list shows the aggregation functions available:

  • Avg

  • BottomN

  • Complex

  • Count

  • CountDistinct

  • CountStar

  • DimensionAggr

  • First

  • Last

  • Max

  • Min

  • None

  • Percentile

  • Rank

  • ServerDefault

  • SubTotal

  • Sum

  • TopN