The IBM® Sterling Warehouse Management System Business Intelligence Framework (YNA) views are the foundation for the IBM Sterling Warehouse Management System Business Intelligence metadata model. They provide flexibility when exposing the underlying table changes in the database. These views also hide some of the complex table joins and the "where" clauses that are specific to the design of the IBM Sterling Selling and Fulfillment Foundation system. If you extend the basic Data Model to include other tables from the IBM Sterling Selling and Fulfillment Foundation Database, it is recommended to follow the same methodology. Column names of the views are usually identical to the underlying table field name.
Most of the views span one table. Others span multiple related tables, providing a list of columns containing important transactional information. Some views contain denormalized information that help reduce the complexity of the Data Mode , for example, the YFS_PERSON_INFO table has been denormalized in all the related views.
IBM Sterling Warehouse Management System Business Intelligence provides two sets of views: WithHistory and WithoutHistory. WithHistory views contain IBM Sterling Warehouse Management System Business Intelligence view set and run against the historical and non-historical data. WithoutHistory views contain the IBM Sterling Warehouse Management System Business Intelligence view set but only run against non-historical data.