Previewing a Model Store

To preview a deployed model store, select it from the list of model stores, click Preview, and run the required SQL query. The preview result displays a maximum of 50 records.

Note: An un-deployed model store cannot be previewed.
  1. Click Modeling.
  2. Click the Model Store tab.
  3. From the list of model stores displayed, select the model store that you want to preview, and click the Preview icon .
    The Preview Model Store - <name of the model> page is displayed.
  4. In the SQL query textbox, type in the query to retrieve the desired data from the selected model store. Enclose the table name within double-quotes.
    select * from "EMPLOYEE_SALARY";
    Note: If the same table name exists in two different physical models, you need to provide the <physicalmodelname>.table name to run the query successfully.
  5. Click Preview.
    A preview of the data fetched from the constituent physical and logical models is displayed.