i found the right expression , it should be more like :

([dim_country].[hierarchy_Zone_setofcountry_country], [dim_branch].[hierarchy_branch_brand], [Measures].[Amount])/sum({[dim_country].[hierarchy_Zone_setofcountry_country].[All].children}, ([dim_branch].[hierarchy_branch_brand].[All], [Measures].[Amount]))

regards.

Yes i tried the expression that you suggested before, but then i got an error saying : too much arguments for the function "SUM", the maximum number of agruments for...

Hi,

Thank you all for your help.

Yes i did try everything you have suggested before but it didn't fix my problem.

Finally, i added a script task executing the following script...

Thank you for ur answer Alvin, i tried the delay option before and it didn't work, still getting the same error...

i thought maybe it's something related to the package parameters...

Yeah i can tell that it's used by another process thank u, but when i checked i found that it's only used by one process which is DtsDebugHost.exe ( and...