After you create an alias set (as described in Creating Alias Sets), you can add bindings to it. Bindings specify the columns in the data source that hold alias information for an alias set.
In this procedure, you create the bindings by inspection. You can also create bindings manually. See Creating Bindings Manually for an Alias Set .
To create bindings by inspection for an alias set:
If have not already done so, in the Metadata Navigator, right-click the alias set to which you want to add bindings and select Edit to launch the Alias Set dialog box.
Note: | Before you can add bindings to an alias, you must have created an alias set, as described in Creating Alias Sets. If you have already created an alias set, proceed to step 2. |
To the right of the Bindings box, click Create bindings by inspection.
In Create Aliases, locate Pattern for alias columns, and enter a string that represents all or part of a column name that you will use to base bindings.
For example, if each table in a database contains a column named in the format, <language>_alias, enter this search pattern:
*alias
Select data source connections that you want to inspect for alias bindings.
Essbase Studio inspects the selected data source connections for alias bindings and lists them under Bindings in the Alias Set dialog box.
Review the alias set bindings presented in the Alias Set dialog box, editing or deleting them as necessary.
When reviewing the bindings created for the alias set, click OK to close the Alias Set dialog box.