checked the variance and re-trigger the sales & product dim but the product dim refresh encountered an issue some corrupted staging table I repair it and re-trigger the refresh then validate again the report if this is now resolved the variances of the two reports.