Example: Data Import File - Overrides
If you are using a multi-currency application, you can load different override rates or amounts to different source members. You use the following system members, which are automatically created for a multi-currency application in the Consolidation dimension:
-
FCCS_Rate Override
-
FCCS_Amount Override
A data import file could have these different amounts:
Entity, Jan, Point-of-View, Data Load Cube Name
E03, 100,"Actual,FY14,FCCS_Periodic,USD,FCCS_Common Stock,FCCS_No Intercompany,FCCS_Mvmts_IssueOfStock,No Product, FCCS_Data Input,FCCS_Local GAAP, FCCS_Amount Override",Consol
E03, 200,"Actual,FY14,FCCS_Periodic,USD,FCCS_Common Stock,FCCS_No Intercompany,FCCS_Mvmts_IssueOfStock,No Product, FCCS_Managed Data,FCCS_Local GAAP, FCCS_Amount Override",Consol
E03, 300,"Actual,FY14,FCCS_Periodic,USD,FCCS_Common Stock,FCCS_No Intercompany,FCCS_Mvmts_IssueOfStock,No Product, FCCS_Other Data,FCCS_Local GAAP, FCCS_Amount Override",Consol