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_Overrides

  • 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