How to:
Reference: |
By defining a Business View of a Master File, you are creating an alternative view of the Master File and can limit the fields available or create a subset of fields from the original Master File. Fields can be grouped into meaningful folders. Field names, titles, and descriptions can be customized for each Business View.
Fields in a Business View are organized into folders. Each folder contains a group of fields. The fields in a folder can come from different segments in the original Master File. The Business View may contain existing fields and can include existing custom fields for DEFINE, COMPUTE, and Filters. Custom fields are associated with a specific segment in the original Master File and are subject to the same rules as real fields. A report can reference fields from multiple folders if they all lie along a single path in the original Master File.
When opening a Master File in the Synonym Editor and clicking the Business View button on the toolbar, a Business View pane opens inside the Synonym Editor where Business View attributes can be added. Adding Business View attributes at this point would update the Master File by inserting the Business View attributes at the end of the file, and once the file is saved, the Business View becomes the active view when the file is used for reporting.
If you do not wish to turn your Master File into a Business View, it is recommended that you save the Business View using a different name or preferably start by creating a new Master File by selecting New, then Synonym via Synonym Editor. Then, insert a reference to an existing synonym and continue to build the Business View. In this case, the Business View points to the cross-referenced Master File, and all of the actual fields and security information comes from the referenced file when the Business View is used in WebFOCUS tools (such as Joins and Defines) and in reports.
Note: Impact Analysis searches Business Views in addition to FOCUS procedures. This enables you to see if changes in the original Master File will impact fields used in the Business View. For detailed information on Impact Analysis, see Analyzing Metadata and Procedures.
You may create a Business View for an existing Master File by using the Synonym Editor.
The referenced file is added to the new synonym and its fields are visible in the left frame.
Note: A Business View Master File may contain only one root folder.
Tip: Select Properties from the Tools menu to open the Properties pane and view additional information for items selected in the Business View pane. Use the Properties pane to change titles, descriptions, or field names. Items that cannot be edited are grayed out.
The Create Default Business View option duplicates the segments and fields that are available in the Master File. You can reorganize the view as necessary. The New Folder option creates a root folder to which you can add fields from the Master File on the left pane by selecting them and then dragging them inside the folder. You can create additional folders to create the structure you want.
Note: Multiple subfolders can be created and folders may be empty for organizational purposes.
Note: If needed, fields may be duplicated by placing them in multiple folders, but any given folder may contain a field only once.
The selected fields appear in the Business View pane.
Note: The Business View Master File may be saved in a different application than the main files.
It is recommended that you create a Business View using the Synonym Editor as outlined in How to Create a Business View Using the Synonym Editor. However, the following is an alternative way to create a Business View using the Synonym Editor.
Note: You may create a Business View anywhere that you can select a Master File.
The Master File opens to the Field View tab in the Synonym Editor.
Note: When opening a Master File in the Synonym Editor, the tool opens to the last tab selected when the Synonym Editor was last accessed.
The Business View pane opens.
Note: A Business View Master File may contain only one root folder.
Tip: Select Properties from the Tools menu to open the Properties pane and view additional information for items selected in the Business View pane. Use the Properties pane to change titles, descriptions, or field names. Items that cannot be edited are grayed out.
The Create Default Business View option duplicates the segments and fields that are available in the Master File, and you can reorganize the view as necessary. The New Folder option creates a root folder to which you can add fields from the Master File on the left pane by selecting them and then dragging and dropping them inside the folder. You can create additional folders to create the structure you want.
Note: Multiple subfolders can be created and folders may be empty for organizational purposes.
The selected fields appear in the Business View Tree tab.
Note: If needed, fields may be duplicated by placing them in multiple folders, but any given folder may contain a field only once.
When you use the Save As option and you are working with FOCUS files, you will need to specify a DATASET in the Master File that points to the data file.
If you use the Save option, the Business View will be saved inside the current Master File and the Business View will be visible when the Master File is opened in reporting tools.
Note: The Business View Master File may be saved in a different application than the main files.
When you use the Business View Master File with WebFOCUS tools and reports, the field formats, descriptions, and titles will be retrieved from the original Master File, unless they are customized and a title and description is available through the Business View.
You may access the Business View Master Files from all development areas of Developer Studio.
In the Projects, Data Servers, or Repository area:
The Table List shows all available Master Files, including the Business Views that are available. The Description column shows a description from the Master File or the Business View file.
The following image is an example of a Business View Master File in the WebFOCUS Table List, that appears when creating a report in the Data Servers area.
This is also available in the Projects area, however, the Table List does not show remarks in the Projects area.
In Report Painter:
When using a Business View Master File in Report Painter, only fields from the Business View are shown in the Fields list.
The following image is an example of a Business View Master File in Report Painter.
In InfoAssist:
When using a Business View Master File in InfoAssist, only fields from the Business View are shown in the Fields list.
The following image is an example of a Business View Master File in InfoAssist.
WebFOCUS |