HYP_REVEXP Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home

HYP_REVEXP Table

Explanation
Contains revenue and expense budget and forecast information from Hyperion Planning (PennPln1, PennPln2 and PennPln3 applications).

Common Uses
Displaying budget or forecast balances, by account and time period, for a given Planning version.

ACCOUNT
ACCOUNTING_PERIOD
SCENARIO
VERSION

ACCOUNT
CNAC
CREF
FISCAL_YEAR
FUND
OBJECT
ORG
PERIOD
PLAN_CREF
PLAN_FUND
PLAN_OBJ
PLAN_ORG
PLAN_PROGRAM
PROGRAM
RESP_ORG
SCENARIO
VERSION
YEAR

BALANCES (DWADMIN)
CENTER_REF_CODES (DWADMIN)
CNAC_CODES (DWADMIN)
OBJECT_CODES (DWADMIN)
ORG_CODES (DWADMIN)
PROGRAM_CODES (DWADMIN)

Cautions

• Contains budget and forecast data as entered into Hyperion Planning; throughout most of the planning cycle, this data will be available only in HYP_REVEXP, as budget data isn't fed to the General Ledger until just before the beginning of the new fiscal year.
• You can access HYP_REVEXP data for an only if you authorized to access data for the account Org or Responsible_Org.
• If you are using Business Objects Desktop Intelligence, you can find this data in the "Planning Rev Exp" class in the FINQUERY Template universe.
• The HYP_REVEXP table is stored in the DWHYP schema in the Data Warehouse..

HYP_REVEXP Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home