LCM says Smart List import is complete but actually its not...Here are probable reasons
- by RahulS
First of all some basics of smart list:
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.
Below link will give you more information on Smart Lists:
http://download.oracle.com/docs/cd/E17236_01/epm.1112/hp_admin/enum_pg.html
I got a simple query today, "The LCM process generates and indicates a status of "Complete", however, the 3,018 records do not appear in the Planning application. No error exists in the log to identify the problem."
Things which can be checked in this case:
1. Spaces are not allowed in the Entry Name,
2. Spaces are allowed in the Entry Label,
3. The name must start with an alpha character or underscore,
4. Valid characters for the remaining part of the name must be alpha, numeric, or an underscore,
5. Enter a name that is unique within the smart list,
6. I am not sure about the limits but I have seen 22,000 members loaded fine,
7. ID for every entry should be unique,
8. IDs need not to be consecutive, Ex: It was go from 1 to 100 then 500 to 900 then 1900 to 4500 etc.
While import .xml file using LCM there were no errors in the foundation and LCM migration logs, but when checked in the HyS9PlanningSysErr.log, few errors were found:Ex:
The name Data_Coord_(Prod)_ACS is invalid,
The name Sr_Dir_b+Medcd_Gvt_Rel_Sls_Mkt is invalid,
The name entered is invalid. Enter a name that is unique within the smart list,
Also, we can Load Smart List dimensions and Smart List dimension entries using the /DS:HSP_SMARTLISTS parameter in outlineload utility:
OutlineLoad /A:acpt /U:admin /M /I:c:/smartlist_create1.csv /DS:HSP_SMARTLISTS /L:c:/OutlineLogs/outlineLoad.log /X:c:/OutlineLogs/outlineLoad.exc
SmartList Name, Operation, Label, Display Order, Missing Label, Use Form Missing Label, Entry ID, Entry Name, Entry Label
SL1,addsmartlist,SL1Label,,,,,,
SL1,addEntry,,,,,,entry1,entrylabel1
SL1,addEntry,,,,,,entry2,entrylabel2
Cheers..!!!
Rahul S.
http://www.facebook.com/pages/HyperionPlanning/117320818374228
