Error : Member 'D-T-D' in the Period dimension has no value for the Period Type property
- by RahulS
Workaround for LCM EPMA deploy errors:
Error : Member 'D-T-D' in the Period dimension has no value for the Period
Type property.
Error : Member name 'D-T-D' in the Period dimension is only valid when Period
Type is set to 'DTS Time Period'.
Error : Member 'W-T-D' in the Period dimension has no value for the Period
Type property.
Error : Member name 'W-T-D' in the Period dimension is only valid when Period
Type is set to 'DTS Time Period'.
Error : Member 'M-T-D' in the Period dimension has no value for the Period
Type property.
Error : Member name 'M-T-D' in the Period dimension is only valid when Period
Type is set to 'DTS Time Period'.
Error : Member 'Q-T-D' in the Period dimension has no value for the Period
Type property.
Error : Member name 'Q-T-D' in the Period dimension is only valid when Period
Type is set to 'DTS Time Period'.
Error : Member 'P-T-D' in the Period dimension has no value for the Period
Type property.
Error : Member name 'P-T-D' in the Period dimension is only valid when Period
Type is set to 'DTS Time Period'.
Error : Member 'S-T-D' in the Period dimension has no value for the Period
Type property.
Error : Member name 'S-T-D' in the Period dimension is only valid when Period
Type is set to 'DTS Time Period'.
Error : Member 'Y-T-D' in the Period dimension has no value for the Period
Type property.
Error : Member name 'Y-T-D' in the Period dimension is only valid when Period
Type is set to 'DTS Time Period'.
Error : Member 'H-T-D' in the Period dimension has no value for the Period
Type property.
Error : Member name 'H-T-D' in the Period dimension is only valid when Period
Type is set to 'DTS Time Period'.
Fix
1. Edit the Period dimension LCM artifact (Keep the back up of the file before editing.)
2. Delete the DTS members (for example as mentioned below) in the Period dimension hierarchy section.
#root|D-T-D|True||||||||||||||||
#root|W-T-D|True||||||||||||||||
#root|M-T-D|True||||||||||||||||
#root|Q-T-D|True||||||||||||||||
#root|P-T-D|True||||||||||||||||
#root|S-T-D|True||||||||||||||||
#root|Y-T-D|True||||||||||||||||
#root|H-T-D|True||||||||||||||||
3. Delete the DTS members (for example as mentioned below) in the Period member hierarchy section,
D-T-D|True||||||||||||||||
W-T-D|True||||||||||||||||
M-T-D|True||||||||||||||||
Q-T-D|True||||||||||||||||
P-T-D|True||||||||||||||||
S-T-D|True||||||||||||||||
Y-T-D|True||||||||||||||||
H-T-D|True||||||||||||||||
4. Then save the edited Period dimension LCM artifact.
5. Then try to import the Period dimension using LCM.
6. Then Validate/Deploy the Planning application still the same issue.
PS: This issue is fixed in 11.1.2.2.