Lookup Drivers

Lookup Drivers enable you to utilize values stored in XFC tables (any table with the prefix XFC_) within OneStream for formula and plan creation. Users often store ad hoc data in XFC tables to avoid unnecessary data inclusion in a cube or the Register. Lookup Drivers provide the ability to match column names in the Register with the column names in the Lookup table applied. The data points that match between the Register data and Lookup table within those columns provide a preview based on the return values drop-down selection that is available via the Lookup table.

If more than one Register field is populated in the Lookup Driver column, the values in the preview will concatenate the values of the Register Fields and display the Return Value based on those combinations.

NOTE: When you import a configuration, Lookup Driver values won't display in the preview table until you add Register data and preview the new data. Your Lookup Driver is trying to compare values that are in the Register against values that are in a Lookup table so data needs to exist in the Register for that comparison to happen.

IMPORTANT: Any attribute named in the solution, such as Register Field Names, Accounts, Global Drivers, Cube Drivers, Lookup Drivers and Formula Names, must be unique from each other.