|
|
|
You can define new views and modify/delete existing views in this page.
Select the “Define View” link under the “DCube” business component.
The “Define View” page appears.
The system displays the following:
|
View Owner |
The name of the user who created the view. |
Enter the following fields:
|
View Name |
The name of the view (Alphanumeric, 255). Mandatory. |
Note: You cannot modify the view name for an existing view.
|
View Display Name |
The name of the view, as it appears in the “Inquiries” activity (Alphanumeric, 255). Mandatory. |
Click the “Get” pushbutton to retrieve the details of the existing view. You can modify the details of the existing view or enter the following fields for creating a new view:
|
Display Row Count |
The number of rows to be displayed in the view result grid (Integer). The value specified here overrides the value specified for “Default Display Row Count for View Result Grid” in the “DCube Settings” activity. |
|
Population Procedure Name |
The unique population procedure that should be associated with the view (Alphanumeric, 255). This procedure would be executed before the values appear in the view. |
|
Deletion Procedure Name |
The deletion procedure associated with the view (Alphanumeric, 255). This procedure would be executed after the values appear in the view. It cleans the values filtered for the view. Data entry in this field is mandatory, if you have specified the population procedure. |
|
Scratch Table Name |
The name of the table used internally by Dcube, for storing values defined for horizontal partitioning and data alarm conditions (Alphanumeric, 255). |
|
View Type |
Use the drop-down list box to specify the view type. Mandatory. The system lists the following options: § Adhoc – Select this option to retrieve adhoc views. § Audit – Select this option to retrieve audit views. § Report – Select this option to retrieve report views. |
|
Component |
Use the drop-down list box to select the business component with which the view would be associated. Mandatory. The system lists all the available business components . |
Check one or more of the following boxes:
|
Drill Down View |
Check this box if the view should appear in “Inquiries” activity. This box should be checked for all standalone views and first level view in a drill down chain. |
|
Public Access |
Check this box to allow users other than the view owner, to access the view definition. Only views created with this public access appear as existing views for other users. If you do not check this box, the view is visible only to the user who created it. This check box setting is applicable only in “Define Views” activity. The view will be available for the end user in “Inquiries” activity, irrespective of this setting. |
|
Inherit View Rights for New Columns |
Check this box to grant view rights for columns that have been newly added to the existing view. This setting is applicable only during view modification. If this box is checked and if there exists at least another column in the view for which rights has been granted for a particular role, then rights will be automatically granted for the new columns added to that role. |
|
User Can modify Filter Conditions |
Check this box to allow the user to modify the filter conditions. If this box is unchecked, then the user can change only “Value” and “Enumerated Value” columns of the “Filter Inputs” multiline, in the “Dynamic Filters” page. |
|
Has Horizontal Partitioning |
Check this box to configure the view for horizontal partitioning. |
|
Has Data Alarm |
Check this box to configure the view for data alarm conditions. |
To save the view details
Click the “Save” pushbutton to save the specified view details.
Note: The system ensures that the “Scratch Table Name” is entered, if horizontal partitioning and/or data alarm are enabled for the view.
To create a new view
Click the “New View” pushbutton to create a new view.
The system clears the fields and allows you to enter the view details for a new view.
To delete the view
Click the “Delete” pushbutton to delete the view details.
To copy view details
Select the “Copy View” link, to copy the details of the existing view to a new view.
To specify the publish details for the view
Enter the following field:
|
Publish View |
Use the drop-down list box to specify whether the view must be published or not. The system lists the options “Yes” and “No”. |
Click the “Save Publish Status” pushbutton to save the publish status of the view.
If the publish status is set as “Yes”, or if the publish status is changed from “No” to “Yes”, the system ensures the following:
Tables and columns must have been defined for the view using “Specify Tables” and “Specify Columns” pages.
Procedure parameters must have been defined for the view, if “Population Procedure” and “Deletion Procedure” are specified for the view.
Data alarms must have been defined using “Define Data Alarms” page, if data alarm feature is enabled for the view.
Horizontal partitions must have been defined using “Define Horizontal Partitions” page, if horizontal partition feature is enabled for the view.
If the publish status is changed from “Yes” to “No” and the view currently being used is in “Inquiries” activity, the you cannoy un-publish the view. In such cases you can use “Un-Publish View Forcefully to un-publish the view.
Click the “Un-Publish View Forcefully” pushbutton to un-publish the view.
To proceed, carry out the following
Select the “Specify Procedure Parameters” link to specify the procedure parameters.
Note: This page will be invoked only for views, for which population procedure has been defined.
Select the “Specify Filters” link to specify the filter criteria for executing views.
Select the “Define Data Alarms” link to define data alarms for the view.
Note: This page will be invoked only if data alarm is enabled for the view.
Select the “Generate Scripts” link to generate the scripts.
Select the “Specify Tables” link to specify the tables.
Select the “Specify Joins” link to specify joins for relating the SQL tables.
Note: This page will be invoked only if more than one table is specified for the view.
Select the “Define Horizontal Partitions” link to define the horizontal partitioning of the records in the view result.
Note: This page will be invoked only if horizontal partitioning is enabled for the view.
Select the “View SQL” link to specify the SQL statements for the view.
Select the “Specify Columns” link to specify the columns in the view output.
Note: This page will be invoked only if tables are specified for the view, using the “Specify Tables” page.
Select the “Specify Procedure Inputs” link to specify the procedure parameter inputs.
Note: This page will be invoked only for views, for which population procedure has been defined.
Select the “Define External Links” link to define the external links to be launched from each page.
Select the “Execute View” link to execute the view results.
“DCube Settings” activity. The necessary options must have been set for DCube.