Not getting cascading values

[podaralla]

Dear Experts,

I have two parameters, Sector and security, based on sector value security values under will be displayed.so, i given cascade source as sector to security value prompt, its working fine. but when i am using logical condition in filter its not affecting.

please find the attachment and kindly guide me.

Best Regards
Amar

[cognos810]

Hello Podaralla,
Change your filter expression as such:

if
(?sector? in ('PARALLEL MARKET IXP','KSX 15','MARKET IXP'))
then
([Business View].[Securities].[SEC_SHORT_NAME])
else
([Business View].[Sectors].[DESC_EN])
=?sector?

Basically first evaluate the left side of the filter expression to either SEC_SHORT_NAME OR DESC_EN using the IF condition, and then evaluate the resulting expression to ?sector?

Let me know if it worked for you.

-Cognos810