Examples

This table shows which fact tables will have data erased, according to the selected currency and options.

Scenarios that result in no data being erased are not presented in the table. For example, local, year-to-date intercompany data.

Currency Data Type Option Accumulation Method Option Data Option Fact *_BASE Tables Affected
Local Financial Periodic and Year-to-Date Adjusted and Unadjusted FinLoc FinLocAdj FinLocAud FinLocNet FinPer FinPerAdj FinPerAud FinPerAudSource FinPerNet FinPerStdNet FinYTD FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet
Local Financial Periodic and Year-to-Date Adjusted FinLocAdj FinLocAud FinLocNet FinPerAdj FinPerAud FinPerAudSource FinPerNet FinPerStdNet FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet
Local Financial Year-to-Date Adjusted and Unadjusted FinYTD FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet
Local Financial Year-to-Date Adjusted FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet
Local Intercompany Periodic and Year-to-Date Adjusted and Unadjusted ICRepPer ICTransPer ICAdjustment ICAdjTrans
Local Intercompany Periodic and Year-to-Date Adjusted ICTransPer ICAdjustment ICAdjTrans
Translated Financial Periodic and Year-to-Date Adjusted and Unadjusted FinPer FinPerAdj FinPerAud FinPerAudSource FinPerNet FinPerStdNet FinYTD FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet
Translated Financial Periodic and Year-to-Date Adjusted FinPerAdj FinPerAud FinPerAudSource FinPerNet FinPerStdNet FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet
Translated Financial Year-to-Date Adjusted and Unadjusted FinYTD FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet
Translated Financial Year-to-Date Adjusted FinYTDAdj FinYTDAud FinYTDAudSource FinYTDNet
Translated Intercompany Periodic and Year-to-Date Adjusted and Unadjusted ICTransPer ICAdjustment ICAdjTrans
Translated Intercompany Periodic and Year-to-Date Adjusted ICTransPer ICAdjustment ICAdjTrans