1.3 Overview

  • Article

This file format, which is used to store a tabular data model file within a spreadsheet file, can contain one or more of the following types of metadata:

  • A definition of a data source for data that is stored in a table. The data source can be a range of cells in a spreadsheet, one or more tables in a relational database, or a cube that is stored in an Online Analytical Processing (OLAP) database.

  • The relationships between the included tables, if any.

  • A user-defined, hierarchical relationship among the columns of a table.

  • Any calculated columns that are created as a function of other, existing columns.

This file format can also include connection strings and passwords for accessing external data sources. Any data that is entered directly into the tabular data model—for example, data that is entered manually or by means of a cut-and-paste operation—can also be stored by this file format.