|
|
|
BI - Member Subject Area
Note: This topic applies to OBI having licenses OPB_<version number> OBI Enterprise (OBIEE - Multiple Properties), or OPI_BUIP_<version number> OBI Standard (Single) using OLAP technology and data cubes. This topic does not apply to standalone S&C Advanced Reporting whose data is accessed directly from OPERA tables via OLTP.
The MEMBER_BI cube will address the most common reporting needs in the loyalty program management area in OCIS. The following requirements must be met:
The Member subject area contains revenue information at a daily level for each membership summarized by Membership Level, Membership Status, Enrollment Group, Age, Country, Gender, Language and Expiry.
The BI - Member Subject Area is available in an 11g environment and it is accessed through OBI>New>Analysis.
When the BI - Member Subject Area is selected, the following columns are available to build reports in OBI.
Note: In OBIEE OPB_<version number> OBI Enterprise (Multiple Properties), when users hover the mouse cursor over any attribute or measure of a Subject Area, a tooltip displays that describes the column. If applicable, a description of how the values are calculated is also included.
To prepare for data collection for the BI - MEMBER Subject Area, set up and activate the MEMBER_BI Cube in OPERA. This cube uses the local tables in the BI schema. These tables are populated from OPERA Data. The following Export File types are needed to populate the Local Dimension and Fact tables in BI.
Access Configuration>Setup>Opera Business Intelligence Setup>MEMBER_BI. Other tables in OPERA are combined to build the subject area requests and reports. For more information on cube setup and maintenance, see the following help topics: OBI Setup and OBI Cube Maintenance.
See Also
