Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: CognosMarson on 05 Nov 2019 10:14:24 AM

Title: Hierarchy comparison
Post by: CognosMarson on 05 Nov 2019 10:14:24 AM
Hi,

Can anyone tell me how to compare two hierarchies, e.g. in an if statement, "If hierarchy1 = hierarchy1 then hierarchy1 else hierarchy2"

Thanks
Title: Re: Hierarchy comparison
Post by: CognosPaul on 05 Nov 2019 10:51:00 PM
MDX generally disallows hierarchical and set comparisons like that. Can you describe in more detail what you're trying to do?
Text only | Text with Images