/AWS1/CL_CRMAGGRTHRESHOLD

Specifies the minimum number of distinct identities that each query output group must represent.

CONSTRUCTOR

IMPORTING

Required arguments:

it_identitycolumns TYPE /AWS1/CL_CRMALYRULECOLUMNLST_W=>TT_ANALYSISRULECOLUMNLIST TT_ANALYSISRULECOLUMNLIST

The identity column, such as user_id, whose distinct values Clean Rooms counts to enforce minimum aggregation thresholds. Currently, you can specify only one column, and its data type must be string, varchar, or char.

iv_minimumidentitycount TYPE /AWS1/CRMINTEGER /AWS1/CRMINTEGER

The minimum number of distinct identities that each query output group must represent. This threshold applies to all output columns in the table. To override this threshold for a specific column, use outputColumnThresholds.

iv_type TYPE /AWS1/CRMAGGRTHRESHOLDTYPE /AWS1/CRMAGGRTHRESHOLDTYPE

The type of aggregation that the threshold enforces. Currently, the only supported value is COUNT_DISTINCT, which counts the distinct values in the identity column.

iv_allowedaggregatexprsntype TYPE /AWS1/CRMALLOWEDAGGXPRSNTYPE /AWS1/CRMALLOWEDAGGXPRSNTYPE

Specifies whether a query can aggregate a transformed column. This applies to the arguments of both aggregate and window functions. Valid values are:

COLUMNS_ONLY – A query can aggregate only a direct column reference, such as SUM(amount), or a constant. Clean Rooms rejects a query that transforms a column and then aggregates it, such as SUM(amount * 2) or SUM(ROUND(amount)).

ANY_EXPRESSION – A query can aggregate any expression. This includes arithmetic, such as SUM(price * quantity); a cast, such as SUM(CAST(amount AS DECIMAL)); a nested function call, such as SUM(COALESCE(amount, 0)); and a conditional, such as SUM(CASE WHEN region = 'EU' THEN amount ELSE 0 END).

Optional arguments:

it_outputcolumnthresholds TYPE /AWS1/CL_CRMOUTPUTCOLUMNTHRESH=>TT_OUTPUTCOLUMNTHRESHOLDLIST TT_OUTPUTCOLUMNTHRESHOLDLIST

The per-column overrides of minimumIdentityCount. An output column without an override uses minimumIdentityCount.

---

Queryable Attributes

identityColumns

The identity column, such as user_id, whose distinct values Clean Rooms counts to enforce minimum aggregation thresholds. Currently, you can specify only one column, and its data type must be string, varchar, or char.

Accessible with the following methods

Method	Description
GET_IDENTITYCOLUMNS()	Getter for IDENTITYCOLUMNS, with configurable default
ASK_IDENTITYCOLUMNS()	Getter for IDENTITYCOLUMNS w/ exceptions if field has no val
HAS_IDENTITYCOLUMNS()	Determine if IDENTITYCOLUMNS has a value

minimumIdentityCount

The minimum number of distinct identities that each query output group must represent. This threshold applies to all output columns in the table. To override this threshold for a specific column, use outputColumnThresholds.

Accessible with the following methods

Method	Description
GET_MINIMUMIDENTITYCOUNT()	Getter for MINIMUMIDENTITYCOUNT, with configurable default
ASK_MINIMUMIDENTITYCOUNT()	Getter for MINIMUMIDENTITYCOUNT w/ exceptions if field has n
HAS_MINIMUMIDENTITYCOUNT()	Determine if MINIMUMIDENTITYCOUNT has a value

type

The type of aggregation that the threshold enforces. Currently, the only supported value is COUNT_DISTINCT, which counts the distinct values in the identity column.

Accessible with the following methods

Method	Description
GET_TYPE()	Getter for TYPE, with configurable default
ASK_TYPE()	Getter for TYPE w/ exceptions if field has no value
HAS_TYPE()	Determine if TYPE has a value

outputColumnThresholds

The per-column overrides of minimumIdentityCount. An output column without an override uses minimumIdentityCount.

Accessible with the following methods

Method	Description
GET_OUTPUTCOLUMNTHRESHOLDS()	Getter for OUTPUTCOLUMNTHRESHOLDS, with configurable default
ASK_OUTPUTCOLUMNTHRESHOLDS()	Getter for OUTPUTCOLUMNTHRESHOLDS w/ exceptions if field has
HAS_OUTPUTCOLUMNTHRESHOLDS()	Determine if OUTPUTCOLUMNTHRESHOLDS has a value

allowedAggregateExpressionType

Specifies whether a query can aggregate a transformed column. This applies to the arguments of both aggregate and window functions. Valid values are:

COLUMNS_ONLY – A query can aggregate only a direct column reference, such as SUM(amount), or a constant. Clean Rooms rejects a query that transforms a column and then aggregates it, such as SUM(amount * 2) or SUM(ROUND(amount)).

ANY_EXPRESSION – A query can aggregate any expression. This includes arithmetic, such as SUM(price * quantity); a cast, such as SUM(CAST(amount AS DECIMAL)); a nested function call, such as SUM(COALESCE(amount, 0)); and a conditional, such as SUM(CASE WHEN region = 'EU' THEN amount ELSE 0 END).

Accessible with the following methods

Method	Description
GET_ALLOWEDAGGXPRSNTYPE()	Getter for ALLOWEDAGGREGATEXPRSNTYPE, with configurable defa
ASK_ALLOWEDAGGXPRSNTYPE()	Getter for ALLOWEDAGGREGATEXPRSNTYPE w/ exceptions if field
HAS_ALLOWEDAGGXPRSNTYPE()	Determine if ALLOWEDAGGREGATEXPRSNTYPE has a value

Public Local Types In This Class

Internal table types, representing arrays and maps of this class, are defined as local types:

TT_AGGREGATIONTHRESHOLDLIST

TYPES TT_AGGREGATIONTHRESHOLDLIST TYPE STANDARD TABLE OF REF TO /AWS1/CL_CRMAGGRTHRESHOLD WITH DEFAULT KEY
.