Copy data from one member to many

Summary

Copy data from one member to many

Content

Hi Team,

Could you please help me on below query,

just wanted to write calc script to copy data from No_Dep to (Dep1, Dep2...(level0 members).) --> Dep dim has 5 levels of hierarchy

 

Source	Jan	FY17	No_Dep	10
Target	Jan	FY17	Dep1	10
Target	Jan	FY17	Dep2	10
Target	Jan	FY17	Dep3	10
Target	Jan	FY17	Dep4	10