What's wrong with the ProcessAdd column mapping?

 

in the dataflowtask of  ssis, process dimention component, found problem.

i use processadd dimention.

everything ok when there's not caculate column. in fact if we had built some caculation columns in dsv of dimention, , have properties of dimention based on these caculation columns, there's big problem.

in process dimention component's config form, second option needed set columns mapping properties of dimention. properties based on caculation columns there!!  but, properties based on caculation columns, no real columns here mapping them correctly. tried leave them not mapping, give out mistake @ run time. if fact, give mistake if leave of properties not mapping here.

could me ?

thanks!

 

 

 

it indeed problem.

and there several solutions.

the easiest 1 define trasformations in ssis package create additional columns follow same logic have in dsv.

another solution define view in relational database , use to implement calculations need instead of using dsv.

edward.
--
this posting provided "as is" no warranties, , confers no rights.

SQL Server  >  SQL Server Analysis Services