Presentation Model for Noetix Analytics in Noetix Search

Noetix Analytics for Oracle E-Business Suite (Noetix Analytics) leverages a three-tier logical architecture to separate the presentation model from the physical data model. This allows us to provide a simplified view of the data warehouse for report developers while the underlying physical structures maximize system performance.

The data warehouse consists of two main schemas/databases that contain the Operational Data StoreThe Operational Data Store (ODS) is an integrated set of tables that contain near real-time information sourced from multiple transaction systems. The ODS consists of master (MAS), detail (DET), and reference (REF) tables. The ODS is usually populated more frequently than the DM. (ODS) and Data MartThe Data Mart (DM) is an integrated set of star schemas that enable enterprise-wide reporting and analysis. Specifically, the DM contains fact tables, such as detailed fact (DFACT), aggregate fact (AFACT), snapshot fact (SFACT), and conformed dimension (DIM). The DM can be configured to be populated multiple times a day. (DM) physical tables. These tables are organized into relationship setsA relationship set is a logical business model layer consisting of a collection of related data warehouse tables with their join definitions., a logical layer that describes how the tables are related through join definitions. In the presentation tier, fields across all the tables in a relationship set are organized into field definition folders corresponding to fact and dimension tables. Fields are identified as metrics, calculated fields, attributes, and identifiers.

NOTE: Noetix Search does not display fields that are not used in a relationship set.