SysQuery::addDimensionDataSource Method [AX 2012]

Adds the appropriate joins to the query to pivot the specified dimension information as a column on the query.

Syntax

client server public static QueryBuildDataSource addDimensionDataSource(
    Query _query, 
    str _dataSourceName, 
    str _dimensionFieldName, 
    DimensionComponent _dimensionComponent, 
   [str _dimensionAttributeName])

Run On

Called

Parameters

• _query
  Type: Query Class
  The query to update.

• _dataSourceName
  Type: str
  The name of the data source that contains the dimension information.

• _dimensionFieldName
  Type: str
  The name of the field on the data source that contains the dimension information.

• _dimensionComponent
  Type: DimensionComponent Enumeration

• _dimensionAttributeName
  Type: str
  The name of the dimension attribute to pivot.

Return Value

Type: QueryBuildDataSource Class
The QueryBuildDataSource data source that contains the pivoted column.

Remarks

If no dimension attribute is specified and the dimension information is a ledger dimension, the denormalized combination string will be pivoted instead of individual dimension values.

See Also

Reference

SysQuery Class