Oracle® Business Intelligence Web Services Guide > Description of Structures in Oracle BI Web Services >
SAColumn Structure
Use this structure to represent the logical column in the Subject Area. This structure is used in the MetadataService Service. Table 24 lists the fields in this structure.
Table 24. SAColumn Structure Fields
|
|
String name |
Specifies a column name used in SQL statements. |
String displayName |
Specifies a localized name, used in Oracle BI Answers. |
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. For more information, read SADataType Values. |
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. For more information, read AggregationRule Values. |
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 SADataType specifies the default aggregation rule for the column. For details on aggregation functions, read Oracle Business Intelligence Presentation Services Administration Guide. 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
|