Make sure the Mondrian Database is available (e.g. through ODBC).

Add a JDBC DataSource called Stores and choose the appropriate driver and URL for your database. If you are using Mondrian through JDBC/ODBC (as described in the section called “Using the JDBC/ODBC bridge driver”) then enter the URL as "jdbc:odbc:MondrianFoodMart".

Click the Next button. Enter the following SQL query in the SQL tab window.

SELECT DISTINCT
store.store_id, store.store_country AS Country, 
store.store_state AS State, store.store_city AS City, 
store.meat_sqft, store.grocery_sqft, store.frozen_sqft, 
store.store_sqft FROM store Where store_city like '${Enter City}';

Click the Next button and choose Infer Schema. On the Dynamic parameter dialog, enter any city name and click the Finish button. The schema will be displayed. Click the Finish button to add the data source to the repository.

Now add a Composite DataSource called Dynamic-Comp On clicking the Finish button the Composite data source is added to the repository and opened.

Drag and drop the Stores.ds file onto the Composite diagram and connect it directly to the Result.

Open the Stores Properties from the shape on the diagram and click the Next button to see the DataSource Properties Screen. You will see the "Enter City" parameter. Enter the value as "Salem" (without the quotes) and click the Finish button.

Select the Result, and choose View from the popup menu. The output is displayed as shown in the fig A1.9. This is similar to that of passing dynamic parameters where Enter City=Salem;

Go back to the Stores DataSource Properties screen and change "Salem" to "${City1}".

Select the Result, and choose View from the popup menu. This time, the "Dynamic Parameters" dialog appears.

Enter "Salem" in the City1 text field and click on the Finish button. The Result output is the same as when the value "Salem" was hardcoded.

Repeat the process, replacing "${City1}" with "${City1}${City2}".

When you view the Result, the "Dynamic Parameters" dialog appears again, this time with two fields. Enter "Sal" in the City1 text box and "em" in the City2 text box. The text values from City1 and City2 are concatenated by the "${City1}${City2} substitution, so the records corresponding to "Salem" are fetched again.