Export :: Profitbase Help

Export

Expand the <//Solution : name / Data Warehouse Output / Export Container : name> folder and select the Export to be configured.
Select the table to present the editor used to edit Export scripts.

The Procedure
Right click any Export Container node. Click New Export.
Define the fields presented then click Finish.

Export - Right Click Options

New Script	Click to open the form that allows for definition of a script.
Copy	A Data Source Table can be copied to clipboard by clicking.
Delete	Click to delete the selected Data Source Table. An "Are you sure?" dialog requiring a confirmation is displayed before the delete is performed.

Export - Command Buttons

Save	Click to save the information defined in the Details and the Column Mapping panes to the Solution database.
Reset	Click to undo any edits and or deletes and redisplays the original configuration as of the most recent Save.
Tasks and Data	Execute Script -> Perform Export

Main Settings

Name	Name of the Export item
Description	Optional
Comments	Optional

Export Script - Buttons

Edit Source Query

Click the button to display the Edit SQL Expression Editor. See SQL Expression Editor below for details.

Source query editor

The Script Expression Editor is accessed by clicking the "Edit source query" button.

The Script Expression Editor is a very powerful tool for customizing the export script.

The Editor has three (3) functional Panes. They are the Expression Pane, Preview Pane and Objects Pane.

Expression Pane

The Expression Pane displays the SQL Expression that retrieves information from the Data Source and updates the Dimension Table in the Data Warehouse. Expressions are automatically constructed by the system when one table is the target. When more complex expressions are required the user can create the expression in the editor, or copy and paste expressions from other editors. The Expression Pane includes the following commands:

Save and Close	Saves the expression and closes the editor display.
Execute	Executes the script and displays the log in the log pane.
View Replacement Values	Display the actual data for the Tags in the script.
Show / Hide	Shows or hides the Editor panes.

Preview Pane

The Preview Pane displays the SQL Expression results or displays Data Source Table-Column data when browsing. Column headers can be selected, dragged and dropped into the Column Mapping table.

Objects Pane

The Object Pane is used to browse the Tables and Columns of a Data Source.

Script Tab

The Script Tab lists scripts.

General

For Name, Description, Comments editing click here.

For use of status tab click here.

For shortcut keys click here.