Summary

Data models provide the building block for creating and building queries in Interactive Reporting. The goal of this chapter was to prove the business analyst with the knowledge to create and edit a data model, including the ability to modify joins, manage meta topics, combine data from multiple queries, and import external content. The chapter began with an introduction on creating a data model and the steps to add tables from the Elements window. The chapter continued with an introduction to joins and the steps to create and edit join conditions between tables. The chapter provided information on creating and editing a meta topic as well as the steps to refresh the table definitions in the data model. The chapter concluded with an overview of using local results, derivable queries, and importing external content for use within the document.