Physical Layer

The Physical layer defines the data sources to which the BI Server submits queries and the relationships between physical databases and other data sources used to process multiple data source queries. Each physical hierarchy in a physical dimension contains the columns from the physical database, or cube.

In FinancialManagementAnalytics.rpd, three data sources define the data and metadata. Financial Management, Tax Provision, and Financial Close Management, which must contain unique data sources. These data sources contain the connection string and user credentials that allow you to connect to product database to retrieve tables, facts, and views.