Defining ETL Parameters in the Financials Warehouse

This chapter provides an overview of Financials Warehouse extract, transform, and load (ETL) parameters and discusses how to define Financials Warehouse ETL parameters.

Understanding Financials Warehouse ETL Parameters

Before you use extract, transform and load (ETL) to populate warehouse tables for the Financials Warehouse, you must define certain ETL parameters. The ETL functionality then uses these parameters to populate the warehouse tables. The parameters define such areas such as load strategy and criteria to select rows from the source table.

Defining Financials Warehouse ETL Parameters

This section discusses:

Defining Payables Mart aging parameters.
Defining Receivables Mart aging parameters.
Defining Financials account parameters.
Defining Global Consolidations Cledger parameters.
Defining Financial Mart GC flow parameters.
Defining Financials asset item parameters.
Defining Financial Rolling Average fact parameters.

Pages Used to Define Financials Warehouse ETL Parameters

Page Name	Object Name	Navigation	Usage
AP Mart Aging Setup	PF_FIN_AP_SETUP	EPM Foundation, EPM Setup, ETL Map Parameters, AP Mart Aging Setup, AP Mart Aging Setup	Enter values that are used in calculating the AP Aging process.
AR Mart Aging Setup	PF_FIN_AR_SETUP	EPM Foundation, EPM Setup, ETL Map Parameters, AR Mart Aging Setup, AR Mart Aging Setup	Enter values that are used in calculating the AR Aging process.
Financial Mart Account Setup	PF_FIN_ACCT_SETUP	EPM Foundation, EPM Setup, ETL Map Parameters, Financial Mart Account Setup, Financial Mart Account Setup	Enter tree and node details that represent accounts on which Profitability analysis is performed.
Financial Mart GC Cled Setup	PF_FIN_CLED_SETUP	EPM Foundation, EPM Setup, ETL Map Parameters, Financial Mart GC Cled Setup, Financial Mart GC Cled Setup	Enter values such as Business Unit, Scenario, and Period that determine the rows to be deleted from Multidimensional Warehouse table PS_F_CLEDGER and reloaded from PS_GC_CLED_MGT_F00. in the MDW table F_CLEDGER.
Financial Mart GC Flow Setup	PF_FIN_FLOW_SETUP	EPM Foundation, EPM Setup, ETL Map Parameters, Financial Mart GC Flow Setup, Financial Mart GC Flow Setup	Enter values such as Business Unit, Scenario, and Period that determine the rows to be deleted from MDW table PS_F_FLOWS and reloaded from PS_GC_FLOW_MGT_F00
Financial Asset Item Setup	PF_FIN_AST_SETUP	EPM Foundation, EPM Setup, ETL Map Parameters, Financial Asset Item Setup, Financial Asset Item Setup	Enter the setID for the rows to be deleted in the OWE table PS_BP_ASSET_ITEMS and reloaded from BD_ASSET_ITEMS.
Financial Rolling Average Setup	PF_FIN_RAVG_SETUP	EPM Foundation, EPM Setup, ETL Map Parameters, Financial Rolling Avg. Setup, Financial Rolling Average Setup	Enter values that are used to determine rolling averages for loading PS_F_LEDGER.

Defining Payables Mart Aging Parameters

Access the AP Mart Aging Setup page.

SetID	Enter the setID associated with data to be used for the Aging process
Aging ID	Enter the aging ID, for example MONTH.
Calendar ID	Enter the calendar ID.
Accounting Period	Enter the accounting period.
Incl Draft flag (Include Draft flag)	Check to include drafts in AP Aging process.
Aging Date Type	Enter the Aging Date Type. Values are: A: The application uses the Accounting Date. T: The applications uses Invoice Date.
Fiscal Year	Enter the fiscal year.
Incl PrePay flag (Include PrePay flag)	Enter the value to indicate whether to include prepay in the AP Aging process. Values are: Y: Include prepay. N: Do not include prepay.
Unrecord Liab Ind (Unrecorded Liability Indicator)	Enter the value to indicate whether to include unrecorded liability in the AP Aging process Values are: Y: Include unrecorded liability. N: Do not include unrecorded liability.
Effective Date	Enter the effective date of the record.
Source System Identification	Enter the name of the source system.

Defining Receivables Mart Aging Parameters

Access the AR Mart Aging Setup page.

SetID

Enter the setID for the data used for the AR Aging process.

Aging ID

Enter the number of days used for days sales outstanding (DSO) in the form of a band, for example 30–60.

Fiscal Year

Enter the fiscal year.

Incl Grace Days (Include Grace Days)

Enter the value to indicate whether to include grace days in the AR Aging process Values are:

Y: Include grace days.

N: Do not include grace days.

DSO Fiscal Year (Days Sales Outstanding Fiscal Year)

Enter the fiscal year used as input to DSO.

Bad Debt Reason

Enter the reason code for bad debt.

Tot AR Specialist (Total Accounts Receivable Specialist)

Enter the number of AR specialists.

Effective Date

Enter the effective date of the record.

Accounting Period

Enter the accounting period.

Sales History ID

Enter the customer sales history ID.

DSO Acct Period (Days Sales Outstanding Accounting Period)

Enter the accounting period used as input to DSO.

Tot Credit Analyst (Total Credit Analyst)

Enter the number of credit analysts.

Tot Collect Analyst (Total Collect Analyst)

Enter the number of collection analysts.

Source System Identification

Enter the name of the source system.

Defining Financials Account Parameters

Access the Financial Mart Account Setup page.

Use this page to enter details of nodes that belong to the Account tree. Only accounts created under these nodes are loaded by the ETL process into the PS_F_PROFITABILITY table.

SetID	Enter the setID for the source data.
Tree Name	Enter the name of the Account tree.
Revenue Node	Enter the Account tree node that relates to revenue accounts.
Dir. Expense Node (Direct Expense Node)	Enter the Account tree node that relates to direct expense accounts.
Indir. Exp Node (Indirect Expense Node)	Enter the Account tree node that relates to indirect expense accounts.

Defining Global Consolidations Cledger Parameters

Access the Financial Mart GC Cled Setup page.

The sequence number on this page indicates that the process accepts multiple sets of business unit, scenario, fiscal year, and accounting period as input. The ETL job processes each set of input data in the sequence indicated.

Load Sequence	Enter the sequence in which the ETL job processes the input parameters. The ETL process accepts multiple sets of business unit, scenario, fiscal year and accounting period as input. The ETL job processes each set of input data in the sequence indicated.
Business Unit	Enter the performance business unit.
Scenario ID	Enter the scenario ID.
Fiscal Year	Enter the fiscal year.
Accounting Period	Enter the accounting period.

Defining Financial Mart GC Flow Parameters

Access the Financial Mart GC Flow Setup page.

Load Sequence	Enter the sequence in which the ETL job processes the input parameters. The ETL process accepts multiple sets of business unit, scenario, fiscal year and accounting period as input. The ETL job processes each set of input data in the sequence indicated.
Business Unit	Enter the performance business unit.
Scenario ID	Enter the scenario ID.
Fiscal Year	Enter the fiscal year.
Accounting Period	Enter the accounting period.

Defining Financial Asset Item Parameters

Access the Financial Asset Item Setup page.

SetID

Enter the setID associated with the asset data.

Del. Flag (Y/N) [Delete Flag (Y/N)]

Check to indicate that the rows in the target table PS_BP_ASSET_ITEMS that match the setID on this page are to be deleted.

Defining Financial Rolling Average Fact

Access the Financial Rolling Average Setup page.

Basis for Rolling Avg. Fact (Basis for Rolling Average Fact)

Select the basis for the Rolling Average fact. Values are:

Beginning Period Amount: The ETL process uses the Beginning Amount from the PS_F_LEDGER table to calculate the rolling average.

Ending Period Amount: The ETL process uses the End Amount from the PS_F_LEDGER table to calculate the rolling average.

Net Period Amount: The ETL process uses the Net Amount from the PS_F_LEDGER table to calculate the rolling average.

Rolling Average Periods

Enter the number of periods used in calculating the average value.

SetID	Enter the setID for the data used for the AR Aging process.
Aging ID	Enter the number of days used for days sales outstanding (DSO) in the form of a band, for example 30–60.
Fiscal Year	Enter the fiscal year.
Incl Grace Days (Include Grace Days)	Enter the value to indicate whether to include grace days in the AR Aging process Values are: Y: Include grace days. N: Do not include grace days.
DSO Fiscal Year (Days Sales Outstanding Fiscal Year)	Enter the fiscal year used as input to DSO.
Bad Debt Reason	Enter the reason code for bad debt.
Tot AR Specialist (Total Accounts Receivable Specialist)	Enter the number of AR specialists.
Effective Date	Enter the effective date of the record.
Accounting Period	Enter the accounting period.
Sales History ID	Enter the customer sales history ID.
DSO Acct Period (Days Sales Outstanding Accounting Period)	Enter the accounting period used as input to DSO.
Tot Credit Analyst (Total Credit Analyst)	Enter the number of credit analysts.
Tot Collect Analyst (Total Collect Analyst)	Enter the number of collection analysts.
Source System Identification	Enter the name of the source system.

SetID	Enter the setID associated with the asset data.
Del. Flag (Y/N) [Delete Flag (Y/N)]	Check to indicate that the rows in the target table PS_BP_ASSET_ITEMS that match the setID on this page are to be deleted.