Using a data model in a data object
You can use a data model to provide data for a report. You can create a data model, using data from a data set, or you can use a predesigned data model in the data object. The option you choose depends on how familiar you are with creating data models, whether you want modifications to the original data model to propagate to the report, or whether you need control over the data model data. You cannot edit a data model from a data object.
How to use a data model in a data object
1 Create a report.
2 Create a data source using the data object that contains the data model.
3 In Data Explorer, right-click Data Models and Data Cubes and choose Use Data Object Data Model.
4 In Use Data Model, in Available Data Models, select the appropriate data model. Choose OK.
5 Expand Data Models and Data Cubes, as shown in Figure 4‑3.
Figure 4‑3 Data Explorer showing a data model
6 Drag the appropriate report elements from the Palette to the layout pane. For example, to create a cross tab report, drag a Cross Tab element into the layout pane.
7 Drag the appropriate fields from the data model in Data Explorer to the element in the layout pane.