BI Access Views

Information Sources and Dimensions support data access via On Line or Data Mart specific views. BI Access Views are created on top of these views, with the main purpose to server as general access views for BI purposes like a Data Warehouse or MS Cubes. Instead of building e.g. a MS Cube model based on On Line access views and one on the Data Mart access views, it is more convenient to be able to use only one access view name and that is where the BI Access Views come into play.

Use this page when you want to know more about how to create BI Access Views as well as about special BI Access View functionality.

Contents

Overview

BI Access Views represent an extra access layer and can be described like this:

  1. BI Access Views are used as the source for loading OLAP Cubes in SQL Server. They can also be used as the source for a Data Warehouse in SQL Server.
  2. BI Access Views are created in IFS Applications 8 via the Information Source feature. Please refer to Create BI Access Views section.
  3. A BI Access View references either an On Line or a Data Mart specific access view. An Information Source consists of a fact and one or more dimensions and each Information Source can support two access types, On Line or Data Mart, by providing different access type views.
  4. A BI Access View has the same name independent of the Information Source access type.

 

The functionality related to BI Access Views can be described with the following overview.

The starting point for creating the BI Access Views is an Information Source.

When the BI Access Views have been created they can be used as access views in a Data Warehouse definition and/or as the source reference in Data Source View in a MS OLAP Cube.

The following functionality is also available:

  1. Add Information Source specific criteria, with the purpose to control the amount of data retrieved by an Information Source specific BI View.
  2. Recreate a BI View based on the original source, a fact or a dimension view.
  3. Recreate a BI View with respect to current definitions.
  4. Validate a BI View in order to find out if changes have been made to the source view used when creating the BI View.
  5. Remove a BI View, e.g. remove the view from the database but not from the BI View entity.

 

Creating and Managing BI Access Views

For details about how to create and manage BI Access Views, please refer to the Creating and Managing BI Access Views page.