|
|
|
OIS Add-on Licenses for Datamart Views
Currently, two add-on licenses are available for clients to view Datamarts without using the OBI User-Interface. Clients can make queries with their own scripts and/or interface and view the results. The two add-on licenses are:
The OPI_BIDA add-on license gives access to Datamart views only. There are no application settings or parameters necessary with this license. Clients can access the following Datamart Views via their own scripts or interface so they can extract data for their reports.
OPI_BIDA Datamart Views (as of v5.0.03.01+) |
DM_BOOKINGPACE_VW VIEW |
DM_BOOKING_VW VIEW |
DM_CATERING_PRODUCTION_V VIEW |
DM_CATERING_SNAPSHOT_VW VIEW |
DM_FINANCIALEXTENDED_VW VIEW |
DM_FINANCIAL_ACTUAL_VW VIEW |
DM_FINANCIAL_BUDGET_VW VIEW |
DM_FINANCIAL_FORECAST_VW VIEW |
DM_FINANCIAL_VW VIEW |
DM_MANAGER_ACTUAL_VW VIEW |
DM_MANAGER_BUDGET_VW VIEW |
DM_MANAGER_FORECAST_VW VIEW |
DM_MANAGER_VW VIEW |
DM_RESERVATION_VW VIEW |
DM_ROOMS_SNAPSHOT_VW |
DM_ROOM_CAT_INVENTORY_VW |
DM_SC_BOOKING_PRODUCTION_VW |
DM_STAYEXTENDED_VW VIEW |
DM_STAY_VW VIEW |
OPI_BIEX is similar to having the OBI license, without the OBI User-Interface. With this add-on license, clients can configure the same application settings as if they had the BI license active (see OBI Setup); they have access to Datamart Utilities, and access to all Fact and Dimension Views as listed below. OPI_BIEX is available in both ORS and PMS, whether or not the OCIS or OBI license codes are active.
OPI_BIEX Fact Views (as of v5.0.03.01) |
OBI_ACC_STATS_FACT VIEW |
OBI_ALLOTMENT_FACT_VW VIEW |
OBI_CALENDAR_EVENTS_FACT VIEW |
OBI_COMPANY_FACT_VW VIEW |
OBI_FINANCIAL_FACT_VW VIEW |
OBI_FUTURE_RES_FACT_VW VIEW |
OBI_GUEST_FACT_VW VIEW |
OBI_MANAGERS_REPORT_FACT_VW VIEW |
OBI_REQUEST_LOG_FACT_VW VIEW |
OBI_RESERVATION_PACE_FACT_VW VIEW |
OBI_RESV_HISTORY_FACT_VW VIEW |
OBI_RHM_FACT_VW VIEW |
OBI_RPM_FACT_VW VIEW |
OBI_SC_ACTIVITY_FACT VIEW |
OBI_SC_BOOKING_STATUS_FACT VIEW |
OBI_SC_BUSBLOCK_INFO_FACT VIEW |
OBI_SC_CATERING_REVENUE_FACT VIEW |
OBI_SC_NAME_GOAL_FACT VIEW |
OBI_SC_ROOMBLOCK_FACT VIEW |
OBI_STAY_FACT_VW VIEW |
OBI_TRAVEL_AGENT_FACT_VW VIEW |
OBI_TURNAWAY_FACT_VW VIEW |
OPI_BIEX Dimension Views (as of v5.0.03.01) |
OBI_ACCOUNT_DIM VIEW |
OBI_ACCOUNT_INFO_DIM VIEW |
OBI_ACCOUNT_TYPE_DIM VIEW |
OBI_ACTIVITY_CLASS_DIM VIEW |
OBI_ACTIVITY_TYPE_DIM VIEW |
OBI_ALLOTMENT_DIM_VW VIEW |
OBI_ALLOT_LEAD_DIM VIEW |
OBI_BOOKING_METHOD_DIM VIEW |
OBI_BOOKING_STATUS_DIM VIEW |
OBI_CALC_MEAS_DIM VIEW |
OBI_CALENDAR_DATE_DIM VIEW |
OBI_CALENDAR_EVENT_DIM VIEW |
OBI_CAT_OWNER_DIM VIEW |
OBI_CAT_STATUS_DIM VIEW |
OBI_CHANNEL_DIM VIEW |
OBI_CM_ACCOUNT_TYPE_DIM VIEW |
OBI_CM_MARKET_DIM VIEW |
OBI_CM_RATE_DIM VIEW |
OBI_CM_RESORT_DIM VIEW |
OBI_CM_RES_INS_SRC_DIM VIEW |
OBI_CM_ROOM_TYPE_DIM VIEW |
OBI_CM_RTC_DIM VIEW |
OBI_CM_SOURCE_DIM VIEW |
OBI_CM_TIME_DIM VIEW |
OBI_COMPANY_DIM_VW VIEW |
OBI_COMPANY_REL_HIER_DIM VIEW |
OBI_CONTACT_DIM VIEW |
OBI_COUNTRY_DIM VIEW |
OBI_CURRENCY_DIM VIEW |
OBI_CUSTOM_DIM_NAMES VIEW |
OBI_EVENT_DIM VIEW |
OBI_EVENT_DIM_BASE VIEW |
OBI_EVENT_TYPES_DIM VIEW |
OBI_FR_CHANNEL_DIM VIEW |
OBI_FR_COUNTRY_DIM VIEW |
OBI_FR_MARKET_DIM VIEW |
OBI_FR_RATE_DIM VIEW |
OBI_FR_RES_INS_SRC_DIM VIEW |
OBI_FR_ROOM_TYPE_DIM VIEW |
OBI_FR_SOURCE_DIM VIEW |
OBI_GUEST_DIM_BASE VIEW |
OBI_GUEST_DIM_VW VIEW |
OBI_HOUR_DIM VIEW |
OBI_MARKET_DIM VIEW |
OBI_MEAL_TYPES_DIM VIEW |
OBI_MEETING_ROOM_DIM VIEW |
OBI_NEW_DIM_ATTRIBUTES VIEW |
OBI_PASTDATES_DIM VIEW |
OBI_PD_ACCOUNT_TYPE_DIM VIEW |
OBI_PD_CHANNEL_DIM VIEW |
OBI_PD_COUNTRY_DIM VIEW |
OBI_PD_MARKET_DIM VIEW |
OBI_PD_RATE_DIM VIEW |
OBI_PD_RES_INS_SRC_DIM VIEW |
OBI_PD_ROOM_TYPE_DIM VIEW |
OBI_PD_RTC_DIM VIEW |
OBI_PD_SOURCE_DIM VIEW |
OBI_PMS_ROOM_DIM VIEW |
OBI_PROMOTION_DIM VIEW |
OBI_PROMOTION_DIM_BASE VIEW |
OBI_PROPERTY_OWNER_DIM VIEW |
OBI_RATE_CODE_DIM VIEW |
OBI_RATE_DIM VIEW |
OBI_RATE_DIM_BASE VIEW |
OBI_RESORT_DIM VIEW |
OBI_RESV_STATUS_DIM VIEW |
OBI_RES_INS_SRC_DIM VIEW |
OBI_REVENUE_GROUPS_DIM VIEW |
OBI_REVENUE_TYPES_DIM VIEW |
OBI_RHM_CHANNEL_DIM VIEW |
OBI_RHM_COUNTRY_DIM VIEW |
OBI_RHM_MARKET_DIM VIEW |
OBI_RHM_RATE_DIM VIEW |
OBI_RHM_RES_INS_SRC_DIM VIEW |
OBI_RHM_ROOM_TYPE_DIM VIEW |
OBI_RHM_RTC_DIM VIEW |
OBI_RHM_SOURCE_DIM VIEW |
OBI_RH_CHANNEL_DIM VIEW |
OBI_RH_COUNTRY_DIM VIEW |
OBI_RH_MARKET_DIM VIEW |
OBI_RH_RATE_DIM VIEW |
OBI_RH_RES_INS_SRC_DIM VIEW |
OBI_RH_ROOM_TYPE_DIM VIEW |
OBI_RH_RTC_DIM VIEW |
OBI_RH_SOURCE_DIM VIEW |
OBI_ROOMCLASS_DIM VIEW |
OBI_ROOM_DIM VIEW |
OBI_ROOM_OWNER_DIM VIEW |
OBI_ROOM_SETUP_DIM VIEW |
OBI_ROOM_TYPE_DIM VIEW |
OBI_RPM_EVENT_DIM VIEW |
OBI_RPM_MARKET_DIM VIEW |
OBI_RPM_RATE_DIM VIEW |
OBI_RPM_ROOM_TYPE_DIM VIEW |
OBI_RPM_SNAPSHOT_DIM VIEW |
OBI_RQ_ARRIVAL_DATE_DIM VIEW |
OBI_RQ_DATE_DIM VIEW |
OBI_RQ_INSERT_USER_DIM VIEW |
OBI_RQ_RESORT_DIM VIEW |
OBI_RQ_RES_INS_SRC_DIM VIEW |
OBI_RQ_TYPE_DIM VIEW |
OBI_RTC_DIM VIEW |
OBI_SC_ACTIVITY_DIM VIEW |
OBI_SC_ALLOTMENT_DIM VIEW |
OBI_SC_EVENT_DIM VIEW |
OBI_SC_LEADS_DIM VIEW |
OBI_SC_PERIOD_DIM VIEW |
OBI_SC_RESORT_DIM VIEW |
OBI_SC_ROOM_DIM VIEW |
OBI_SNAPSHOT_DIM VIEW |
OBI_SOURCE_DIM VIEW |
OBI_SOURCE_REL_HIER_DIM VIEW |
OBI_STAYDATE_DIM VIEW |
OBI_STAY_DIM_VW VIEW |
OBI_STAY_REC_TYPE_DIM VIEW |
OBI_ST_MARKET_DIM VIEW |
OBI_ST_RATE_DIM_VW VIEW |
OBI_ST_RES_INS_SRC_DIM VIEW |
OBI_ST_REV_BUCK_DIM VIEW |
OBI_ST_ROOM_TYPE_DIM VIEW |
OBI_ST_SOURCE_DIM VIEW |
OBI_ST_TIME_DIM VIEW |
OBI_TA_ACCOUNT_TYPE_DIM VIEW |
OBI_TA_MARKET_DIM VIEW |
OBI_TA_RATE_DIM VIEW |
OBI_TA_REL_HIER_DIM VIEW |
OBI_TA_RESORT_DIM VIEW |
OBI_TA_RES_INS_SRC_DIM VIEW |
OBI_TA_ROOM_TYPE_DIM VIEW |
OBI_TA_RTC_DIM VIEW |
OBI_TA_SOURCE_DIM VIEW |
OBI_TA_TIME_DIM VIEW |
OBI_TIME_DIM VIEW |
OBI_TIME_EVENT_DIM VIEW |
OBI_TIME_MONTHS_DIM VIEW |
OBI_TRAVEL_AGENT_DIM_VW VIEW |
OBI_TRXCODE_DIM VIEW |
OBI_TR_ADATE_DIM VIEW |
OBI_TR_CDATE_DIM VIEW |
OBI_TR_HOUR_DIM VIEW |
OBI_TR_INSERT_USER_DIM VIEW |
OBI_TR_MARKET_DIM VIEW |
OBI_TR_RATE_DIM VIEW |
OBI_TR_RESORT_DIM VIEW |
OBI_TURNAWAY_DIM VIEW |
OBI_TURNAWAY_DIM_BASE |
