Data Project Explorer window
The Data Project Explorer window lists your accelerator projects. When you expand the node that represents an accelerator project, the data marts that are defined in that project come into view.
Menus
When you right-click on a object in theData Project Explorer window, the menu that appears depend on the object that you selected:- An accelerator project
- When you right-click an accelerator project, the following choices
are available from the menu:
- New
- Opens a submenu, from which you can select:
- Accelerator Project
- To create another accelerator project
- Data Mart
- To create a data mart in the selected accelerator project
- Starts a wizard to import a data mart definition file (xml file) into the selected accelerator project. This function is useful, for example, if you have a working data mart in a test system and want to use that data mart in a production system. An import results in a new data mart that is added to the Data Project Explorer window. An import does not modify a data mart that you are editing.
- Starts a wizard to save the data mart definition of the selected
data mart to an XML file in a local or remote file system. This function
is useful to:
- Import data mart definitions into other accelerator projects
- Back up data mart definitions
- Reuse data mart definitions in other applications
- Edit a data mart definition with an external application, such as an XML editor
- Validate
- To validate the structural and referential integrity of the selected data mart.
- Data Marts
- When you right-click on the Data Marts folder,
the following choices are available from the menu:
- New Data Mart
- To create a data mart in the current accelerator project.
- Starts a wizard to import a data mart definition file (xml file) into the selected accelerator project. This function is useful, for example, if you have a working data mart in a test system and want to use that data mart in a production system. An import results in a new data mart that is added to the Data Project Explorer window. An import does not modify a data mart that you are editing.
- Starts a wizard to save the data mart definition of the selected
data mart to an XML file in a local or remote file system. This function
is useful to:
- Import data mart definitions into other accelerator projects
- Back up data mart definitions
- Reuse data mart definitions in other applications
- Edit a data mart definition with an external application, such as an XML editor
- An existing data mart
- When you right-click an existing data mart, the following choices
are available from the menu:
- New
- Opens a submenu, from which you can select:
- Accelerator Project
- To create another accelerator project
- Data Mart
- To create a data mart in the selected accelerator project
- Set Database
- Opens the Select Connection window, in which you can select another database connection profile for the selected data mart. Changing the connection profile associates the data mart with another database, which provides a different set of source tables and schemas for the data mart.
- Deploy Data Mart
- Opens the Deploy Data Mart window, in which you can choose the accelerator to deploy the selected data mart to.
- Refresh Database Cache
- Uses the database catalog to refresh the list of tables and their size in the cache.
- Validate
- Validates the structural and referential integrity of the data mart that is currently displayed on the canvas.
- Save As Image
- Generates an image that displays the graphical view of the data mart and saves it to a file.
- Generate Report
- Generate an HTML report of the data mart including details about the data mart and the image.
- Starts a wizard to import a data mart definition file (xml file) into the selected accelerator project. This function is useful, for example, if you have a working data mart in a test system and want to use that data mart in a production system. An import results in a new data mart that is added to the Data Project Explorer window. An import does not modify a data mart that you are editing.
- Starts a wizard to save the data mart definition of the selected
data mart to an XML file in a local or remote file system. This function
is useful to:
- Import data mart definitions into other accelerator projects
- Back up data mart definitions
- Reuse data mart definitions in other applications
- Edit a data mart definition with an external application, such as an XML editor