...
The Build Model job entry can be used to create Data Source Wizard data sources, which which includes both a Metadata and a Mondrian model. It works by searching upstream for a table output step to base the model on, or you can select an existing DSW or Analysis model from the BA Server to base your model on.
After you have run this job entry, a data model is created and can be published to the BA Server for the creation of Analysis reports in the Pentaho User Console. Business users will also be able to refine the data model with the Data Model Editor. If you selected an Analysis model to build from, the Build Model step will only create an Analysis model.
TBD workaround Note- If you are using Impala instead of Vertica as the source for building your model, you will have to create a dummy table output step and leave it disconnected from the main flow of the transformation so that the Build Model step picks up the correct information.
...
Option | Description |
|---|---|
Entry Name | Type to enter the name of the job entry here. |
Output Step | Enter the output step here. You can use the drop-down menu to select the output step that you want to use. |
Published Model Name | Enter the name for the model here. You can click in this field and enter CTRL-Space to get a list of variables for this. |
Modeling Method: Auto Model or Use Existing | Select the Auto Model option if you want to build a new model.Select the Use Existing option if you want to base your model on one that already exists in the BA Server. |
Help | Provides a link to the Help documentation. |
OK | Click to publish the model and close the window. |
Cancel | Click Cancel to discard entries and close the window. |
...
Option | Description |
|---|---|
URL | Enter the URL to the BA Server. |
User Name | Type the user name for the BA Server. |
Password | Enter the password. |
Connect | Establishes a connection to the BA Server to retrieve a list of available data models for the Choose Model menu. |
Existing Model | Populates with a list of available models. |
Create model if not found | Generates an auto model, if unable to find an existing model with the entered name. |
Help | Provides a link to the Help documentation. |
OK | Click to publish the model and close the window. |
Cancel | Click Cancel to discard entries and close the window. |
...