Error : Member 'D-T-D' in the Period dimension has no value for the Period Type property
Posted
by RahulS
on Oracle Blogs
See other posts from Oracle Blogs
or by RahulS
Published on Thu, 6 Dec 2012 08:45:42 +0000
Indexed on
2012/12/06
11:15 UTC
Read the original article
Hit count: 761
Filed under:
/Lifecycle Management
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.
© Oracle Blogs or respective owner
