Dynamic Group Properties

Business Data Analysis Adapter

Dynamic Group Properties

The following Dynamic Group Properties are available. Click on a link to jump to that section.

• Delete Extra Data

• Expression for Analysis

• Group Column Name

• Group Filter Template

• Group Gantt End

• Group Gantt Sort

• Group Gantt Start

• Store Extra Variables

Delete Extra Data

Use this property if there is content that you want to have deleted from the finished data table. Each element stored will look for the matching column name and value and delete that row from the data table.

Example:

<ColumnName>Group Value</ColumnName>

</Delete>

</DeleteExtraData>

ColumnName (Required) - String

The name of the column to search within.

ColumnValue (Required) – String

The value to search for. For null, enter nothing.

Expression for Analysis

The expression(s) to be used for analysis.

Example: Count(Title)

Example:

<Expression>Sum(Amount)</Expression>

<ExpressionType>System.Int32</ExpressionType>

</Expressions>

</ExpressionSetup>

ExpressionType (Required) – String

The column type that will be used when storing data analysis.

ExpressionValue (Required) – String

The expression used for analysis.

Group Column Name

The name of the group to be referenced for a count/average/sum/minimum/maximum. If you want to group on a Parent and Child column, that can be specified within an XML setup. Only one parent and child can be specified.

Example: Status

Example:

<ChildGroupName>Status</ChildGroupName>

</PCGColumnName>

</PCGColumns>

ChildGroupName

The name of the column from the external data source that will be used as the child group and analyzed.

ParentGroupName

The name of the column from the external data source that will be used as a parent group. No analysis is completed against the parent, only the child.

Group Filter Template

Used to specify the filter that will be used when dynamically retrieving content. Use variables if you do not want to specify static column content.

Example: [<%Group%>]='<%GroupName%>'

Example: ([<%Group%>]='<%GroupName%>' AND [<%ChildGroup%>]='<%ChildGroupName%>')

<%ChildGroup%>

Used to identify the Child Group Name specified in the Group Column Name property.

<%ChildGroupName%>

As data is collected, this variable will be replaced with the content that is dynamically found. For instance, for each status, this variable will be replaced with each status, and analysis will be completed against the filtered content.

For external documentation about Expressions, see Add Column XML.

<%Group%>

Used to identify the Group Name specified in the Group Column Name property.

<%GroupName%>

Supported Variables

• %ME% – The currently logged in user

• %Today% – Today's date

• %CurrentWeekStart% – The first day in the current week

• %CurrentWeekEnd% – The last day in the current week

• %CurrentMonthStart% – The first day in the current month

• %CurrentMonthEnd% – The last day in the current month

• %CurrentYearStart% – The first day in the current year

• %CurrentYearEnd% – The last day in the current year

• %Quarter1Start% – The first day in the first quarter of the current year

• %Quarter1End% – The last day in the first quarter of the current year

• %Quarter2Start% – The first day in the second quarter of the current year

• %Quarter2End% – The last day in the second quarter of the current year

• %Quarter3Start% – The first day in the third quarter of the current year

• %Quarter3End% – The last day in the third quarter of the current year

• %Quarter4Start% – The first day in the fourth quarter of the current year

• %Quarter4End% – The last day in the fourth quarter of the current year

• %OneWeekAgoStart% – The first day of the previous week

• %OneWeekAgoEnd% – The last day of the previous week

• %TwoWeeksAgoStart% – The first day of the week before last

• %TwoWeeksAgoEnd% – The last day of the week before last

• %OneWeekFromNowStart% – The first day of next week

• %OneWeekFromNowEnd% – The last day of next week

• %TwoWeeksFromNowStart% – The first day of the week after next

• %TwoWeeksFromNowEnd% – The last day of the week after next

• %OneMonthAgoStart% – The first day of last month

• %OneMonthAgoEnd% – The last day of last month

• %OneMonthFromNowStart% – The first day of next month

• %OneMonthFromNowEnd% – The last day of next month

Group Gantt End

Contains the Date field used for Gantt End Date analysis.

Example: Due Date

Group Gantt Sort

The sort order for content when a Gantt Analysis is created. Use variables when you don’t want to statically specify column names.

Default: [<%Group%>], [<%GroupGanttStart%>], [<%GroupGanttEnd%>]

<%Group%>

Used to identify the Group Name specified in the Group Column Name property.

<%GroupGanttEnd%>

Used to identify the Group Gantt End date specified in the Group Gantt End property (above).

<%GroupGanttStart%>

Used to identify the Group Gantt Start specified in the Group Gantt Start property (below).

Group Gantt Start

Contains the Date field used for Gantt Start Date analysis.

Example: Start Date

Store Extra Variables

Used to store content that will not be analyzed. It will be stored after each analysis row created within the data table.

Example:

<ColumnName>Group name</ColumnName>

<ColumnType>System.String</ColumnType>

<ColumnValueName>Title</ColumnValueName>

</ExtraVariable>

</StoreExtraVariables>

ColumnName (Required) – String

The name of the column that will be created within the data table.

ColumnType (Required) – String

The type of column created within the data table.

For help with column types, see Convert XML/Column Type.

ColumnValueName (Optional) – String

The name of the column that will be used when storing content.