Environment : Production
Description
Understading BI3 views in Zuora Revenue
Resolution
Zuora Revenue BI views can be used for modelling, extraction, and development of your own analytical business intelligence for your organization. Zuora Revenue BI views do not have any security filtering applied. When you use the BI views, you should determine the best method to secure and segregate the data in your organization.
The following table lists the data entities and the physical tables on which Zuora Revenue BI views are based. Account Summary (RPRO_BI3_LN_ACCT_SUMM_V) and Waterfall (RPRO_BI3_WF_SUMM_V) are derived which needs to build on customer warehouse systems.
|
Data entity |
Physical table |
|
Account Type |
RPRO_BI3_ACCT_TYPE_V |
|
Accounting Pre-Summary |
RPRO_BI3_RI_ACCT_SUMM_V |
|
Acct Summary (Derived) |
RPRO_BI3_LN_ACCT_SUMM_V |
|
Approvals |
RPRO_BI3_APPR_DTL_V |
|
Bill |
RPRO_BI3_RC_BILL_V |
|
Book |
RPRO_BI3_BOOK_V |
|
Calendar |
RPRO_BI3_CALENDAR_V |
|
Cost |
RPRO_BI3_RC_LN_COST_V |
|
Deleted Schedules |
RPRO_BI3_RC_SCHD_DEL_V |
|
Header |
RPRO_BI3_RC_HEAD_V |
|
Holds |
RPRO_BI3_RC_HOLD_V |
|
Lines |
RPRO_BI3_RC_LNS_V |
|
MJE |
RPRO_BI3_MJE_V |
|
Org |
RPRO_BI3_ORG_V |
|
Period |
RPRO_BI3_CALENDAR_V |
|
POB |
RPRO_BI3_RC_POB_V |
|
Schedules |
RPRO_BI3_RC_SCHD_V |
|
Waterfall (Derived) |
RPRO_BI3_WF_SUMM_V |
|
Contract Mod Details |
RPRO_BI3_CT_MOD_DETAIL_V |
|
Lines Stage History |
RPRO_BI3_LINE_STAGE_HIST_V |
|
POB Release Actions |
RPRO_BI3_POB_ACTIONS_V |
|
RC Contract Mod Details |
RPRO_BI3_RC_CT_MOD_DET_V |
|
Lines Version History |
RPRO_BI3_RC_LNS_VERSION_V |
Related Knowledge Centre Documents for reference :
BI3 view basic Details :
https://knowledgecenter.zuora.com/Zuora_Revenue/Zuora_Revenue_BI_views/Basic_concept
BI3 view column details and data entry details :
https://knowledgecenter.zuora.com/Zuora_Revenue/Zuora_Revenue_BI_views/Data_entry_details
Sample queries :
https://knowledgecenter.zuora.com/Zuora_Revenue/Zuora_Revenue_BI_views/Sample_queries