thank you im gonna try this but infortunaly i can skip this transformation because they dont need it this on reporting

but the table named dimension_time is essential for building a cube & analyse

once i have the scripts im gonna post it here to assist me

thank you to every one