You can create a Business View for the target to categorize the columns into measures and dimensions. This view of the data is used by Designer for creating reports and charts.
Right-click the target and select Edit Business View. The Synonym Editor opens, as shown in the following image.
Once a data flow contains all of the fields you need, you can load it to a target data store.
A file picker opens, so you can select the existing target.
You can add multiple sources in a data flow as joins or unions.
You can add new fields or replace existing fields by creating expressions. You can do this by right-clicking a field in the query, or by using the menu for a field in the sample data panel.
Each field in the sample data panel has a menu icon (
)
The menu provides the following options:
To edit the fields in the flow, right-click the SQL object, and click Edit. The Metadata and Query panes open.
When a data source in a flow has a large volume of data, you can enable sampling for better response time. You can make decisions based on a sample, provided that sample is representative of the entire data set. Data Prep has a built-capability to automatically generate a random sample (with a 99% confidence level and +/- 1% margin of error).
To enable sampling:
You can use the URL feature in combination with the Workbench preset to place the Workbench page inside your Designer portal. This page can add flexibility to your portal application and serve as a launchpad for running content and navigating domains and folders within your repository.
Creating the Workbench portal page is done in three stages:
You can use keyboard commands to navigate through the initial Get Data page, so that all options can be performed from the keyboard without requiring a mouse, using a combination of the Tab key, Shift+Tab key, and arrow key actions. Pressing the Enter key performs the primary action of the selected element. Pressing the Esc key closes a panel.
You can jump to areas of the page that are not near each other by pressing the key combination Shift+Ctrl+F10. This opens an accessible context menu, as shown in the following image.
When you are finished using the Retail Samples workspace, you can delete or unpublish this workspace. Deleting the Retail Samples workspace will also delete the Retail Samples groups and BI Portal, but not the retail_samples application folder on the WebFOCUS Reporting Server.
The following image shows the Delete Workspace - Retail Samples dialog box.
If you are licensed for WebFOCUS Mobile products, then you can use the Mobile Viewer to access content from any folder in your WebFOCUS repository from a simple, touch-based interface.
Access the following URL from your mobile device:
http://yourserver:port/ibi_apps/mv/path_to_your_folder
where:
Is the host name or IP address of the system that is hosting WebFOCUS.
Is the port number used by WebFOCUS on the deployed system.
