How to load to Accounts with Smartlists setup via data file?
In Planning, you can load a data file via Administration menu \ Import Data From File \ Choose Native Essbase and Cube \ Load Data File as long as all dimensions are accounted for.
For example, this loaded successfully for me where we have Period, Scenario, Version, Year, Account, Cost Center, Currency, Entity, UD1, UD2, Amount
"Jan" "Actual" "Working" "FY14" "830..420" "C10653" "Local_Curr" "120" "P1" "PV0" "100"
Question is, how do you load to an account that has a smartlist?
For example, I have an account called 'Employee Type' with Smartlist values of 'Exempt' and 'Non-Exempt'.
How do I load 'Exempt' or 'Non-Exempt' to this account via data load file?