Print      Open PDF Version of Online Help

Analytics > Designing an Analysis > Step 1: Defining Criteria in Analytics > Adding Columns to Analyses

Adding Columns to Analyses

When creating or modifying an analysis, you add columns until your analysis contains all the data that you want. You can add columns to an analysis in the Criteria tab of the analysis editor and in the Results tab. This topic describes how to add columns in the Criteria tab.

NOTE: The periods in your analyses might be based on your company's fiscal calendar, which might be different from a standard calendar. For example, your company's fiscal year might begin on 1 June of each calendar year. If your company has recently changed its fiscal calendar year in Oracle CRM On Demand, then you must review historical analyses carefully if they span multiple years. Data in reports that is based on your previous fiscal calendar cannot be aligned with data using a new fiscal calendar.

About Excluding New Columns from Existing Views

If your analysis already contains views in the Results tab, then you might not want any new columns that you add to the analysis in the Criteria tab to be displayed in the existing views by default. You can configure the properties of the analysis so that the columns that you add to the criteria are excluded from the existing views.

NOTE: If you want to exclude the new columns from the existing views, then you must configure the analysis properties accordingly before you add the columns in the Criteria tab.

To specify whether new columns are to be displayed in existing views

1. In the Results tab or the Criteria tab of the analysis editor, click the Edit Analysis Properties icon in the toolbar.
2. In the Analysis Properties dialog box, click the Data tab.
3. In the Display of Columns Added in Criteria Tab field, select the option that you want:
   • Display in existing and new views. The columns that you add are displayed by default in existing views as well as in new views.
   • Exclude from existing views, but display in new views. The columns that you add are displayed by default in new views only. In existing views, the columns appear in the Excluded drop target in the view editors. For information about drop targets, see About Drop Targets in View Editors.
4. Click OK to close the dialog box.

To add columns to your analysis

1. In the Criteria tab of the analysis editor, in the Subject Areas pane, expand the column lists to display the columns that you can include in the analysis.
2. Double-click the columns that you want to include in the analysis.

   NOTE: You can remove a column from the report by selecting Delete from the drop-down list of options for that column.

You can add custom fields as columns in analyses. For multilanguage deployments, you must translate custom fields into each language that is used, so that those fields are available to be added to reports and analyses. For example, if a custom field is created in English, it must be translated in to German, so that a German user can see, and then use the custom field in an analysis.