analysis services command agent job warning
SQL Server Agent job failure due to interpreting warning as error with Analysis Services Command job. The Command job actually complete successsfully with warning, but the agent job will fail. Running the same Command in SSMS will succeed with warning, Warning is not error and should not fail the Server Agent job.
Description="Cannot order '' by  because at least one value in  has multiple distinct values in . For example, you can sort [City] by [Region] because there is only one region for each city, but you cannot sort [Region] by [City] because there are multiple cities for each region." Source="Microsoft SQL Server 2019 Analysis Services Managed Code Module" HelpFile="" /></Messages></root></return>. The step failed.