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
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