h1

REPORT PROPERTIES – COLUMNS(FIELDS)

August 17, 2010

In the properties window, within the columns tab, hit the ‘Add’ button to add columns to the list.

ADDING COLUMNS – The columns available to you are limited to those in the source container. To add columns (fields) to the source container so that additional columns are available in this window, the Connector module is required.

REMOVE A COLUMN – In the ‘columns’ tab, select the field to be deleted and select the ‘Remove’ button. This action removes the field from the report but retains it in the associated container found in the Connector module.

MOVE THE POSITION OF A COLUMN – A column can be moved by dragging and dropping or by selecting a column and clicking the ‘Move up’ or ‘Move down’ button to the right of the window. Moving the position of a column in the list also moves it in the position in which it is placed when the data is dumped into the Excel template.

COLUMN PROPERTIES – As per the screen shot below, an aggregate function may be applied to a field by right clicking on a field and selecting ‘properties’ and then selecting the aggregate function to apply as per below.  Because agregation reurns less records, it is used when returning large datasets to Excel and the users of the report do not require much detail.

Note: Aggregation can only be applied to a ‘measure’ field which in turn groups the ‘dimension’ fields accordingly.

Intelligence – SAI training in Western Canada

Advertisements

2 comments

  1. […] Intelligence Just another WordPress.com site « REPORT PROPERTIES – BASICS REPORT PROPERTIES – ADDING COLUMNS » REPORT PROPERTIES – COLUMNS August 17, 2010 The ‘columns’ tab in […]


  2. […] Blog Just another WordPress.com site « REPORT PROPERTIES – BASICS REPORT PROPERTIES – COLUMNS(FIELDS) » REPORT PROPERTIES – COLUMNS August 17, 2010 The ‘columns’ tab in […]



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: