Add Simple Columns, Constant, Expression Type Columns
You can add a simple column, a constant, or an expression type column to a view from the tables available in the view.
To add a simple column, constant, or expression type column
On the NoetixViews Workbench home page, clickModify a View. TheModify Viewpage appears.
Select a view, and then click Modify. For information, see Select a View. The Modify View » view label> page appears.
Under Columns, click Add, modify & suppress columns, and then click Next. The Modify View » <view label> » Add, modify & suppress columns page appears showing the list of columns available in the view.
In the Add Column list, select the Simple column, constant or expression column type, and click Add Column. The Add Column page appears.
In the Column label box, type a label for the column that you want to add to the view.
In the Description box, provide a description, which can contain a maximum of 200 characters.
Identify the query in which you want to add the column. If the view contains multiple queries, a tab will appear for each query, and the Apply to all queries check box will be available. Select the Apply to all queries check box if you want to add the column with the same settings to all queries. Each query tab also displays the following information:
The profile condition associated with the column. You cannot specify a profile option for a column that is being added because the functionality is not presently supported by the NoetixViews Workbench.
Text indicating that the query is used in at least in one form of the view.
Text indicating that the query pertains to the version of your Oracle E-Business Suite instance.
For all queries or a selected query, select one of the following:
Pick a column: Creates a simple column.
Enter an expression: Creates an expression type column.
Enter a constant: Creates a constant type column.
If you have selected the Pick a column option, perform the following:
In the Select a table from this view list, click a table from which you want to select a column.
In the Select a column from the selected table list, select a column from which you want to derive the new column.
IMPORTANT: If you select a table with a profile option, the subsequent generation of the view will fail if the profile condition is not met.
If you have selected the Enter an expression option, in the Column expression box, type an expression for the column to be added. The expression can contain a maximum of 4,000 characters.
If you have selected the Enter a constant option, in the Column constant box, enter an appropriate constant value for the column to be added. The constant can contain a maximum of 4,000 characters.
If you have multiple queries, and if you are adding the same column individually to other queries, repeat steps 8 through 11.
After you add the column to one or more queries, configure additional column properties as follows:
In the Format class list, click a format for the column being added. The available formats are NONE, STRING, NUMERIC INTEGER, DATETIME, TIME, DATE, NUMERIC AMOUNT, and NUMERIC REAL. By default, the STRING format is selected. The format class of a column indicates the format to be used when data is displayed in business intelligence (BI) tools. For optimal results, the format class and data type of the column must match.
If you want to define the column being added as a parameter column in BI tools, and if you want to provide a list of values (LoV) for the column, in the LOV view label list, click an LoV view. The LoV views listed will depend on the modules of Noetix Views (NoetixViews) available in your NoetixViews instance.
If you have selected an LoV view in the previous step, in the LOV column label list, click an LoV column that you want to associate with the column being added. The LoV column provides values for the column being added when it is defined as a parameter column in BI tools.
In the Search by this column list, click Yes if you want to generate a search-by (A$) column for the column being added. By default, the value No is selected.
Click OK. The Modify View » <view label> » Add, modify & suppress columns page appears with the new simple column, constant, or expression type column that is appended to the list of columns in the view with the state "ADDED".
Repeat steps 4 to 14 to add more columns. You can also perform other customizations on view columns, such as addition or modification of columns of any type. For information about these tasks, see the respective topics under Manage View Columns.
In the Customization comments box, provide a summary of the customizations that you have performed. The customization comments can contain a maximum of 200 characters.
Click Save. The customizations are saved, and the Modify View» <view label> page appears.
IMPORTANT: The column label can contain a maximum of 30 characters, must begin with a letter, and can contain only letters, numbers, and underscores. If you want to generate a search-by (A$) column for this column, the length of the column label must not exceed 28 characters. The column label must be unique. However, the label can match with that of an existing key flexfield or descriptive flexfield column with different capitalization.
IMPORTANT: When you add a column to a view that contains multiple queries, you must add the column with the same data type to all queries in the view. If you have selected the Apply to all queries check box, and the table that you have selected from the view is not part of one or more queries, a placeholder column of the same data type will be added to the view by the NoetixViews Workbench.
Now, you can choose to perform any other customizations on the same view or go to the home page.