Administrators use Smart Lists to create custom drop-down lists that users access from data form cells. When clicking in cells whose members are associated with a Smart List (as a member property), users select items from drop-down lists instead of entering data. Users cannot type in cells that contain Smart Lists. Smart Lists display in cells as down arrows that expand when users click into the cells.
Perform these tasks to create and administer Smart Lists:
Define Smart Lists, described here.
Associate Smart Lists with members.
Select dimensions for which Smart Lists are displayed.
Optionally:
Turn Smart Lists on or off for data forms.
Use Smart List values in member formulas.
Set how #MISSING cells associated with Smart Lists display in data forms.
Synchronize Smart Lists in reporting applications
To create or work with Smart Lists:
To create a Smart List, click Create, enter the name, and click OK.
To change a Smart List, select it and click Edit.
To delete Smart Lists, select them, click Delete and OK. Deleting Smart lists also deletes any associated mappings with dimension members and reporting applications.
Data cells can display only one Smart List. If multiple Smart Lists intersect at cells, set which one takes precedence.
Optional: Synchronize Smart Lists between a Classic Planning application and reporting application by clicking Synchronize. See Synchronizing Smart Lists in Reporting Applications.