If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report studio filter query-Help

Started by KANUL, 26 Jun 2009 05:36:06 AM

Previous topic - Next topic

KANUL

Please help me out in applying this filter for Query in Report studio:-

case when ?Local\Import?='Local' then [PAID LOGIC SCHEMA].[DIM_SUPPLIER_FOR_DM_PAID].[Country]='IND'
else [PAID LOGIC SCHEMA].[DIM_SUPPLIER_FOR_DM_PAID].[Country]<>'IND'
end

Thank You

KANUL

Hey it worked.... ::)

if (?Local\Import?='Local') then
( [PAID LOGIC SCHEMA].[DIM_SUPPLIER_FOR_DM_PAID].[Country]='IND')
else ( [PAID LOGIC SCHEMA].[DIM_SUPPLIER_FOR_DM_PAID].[Country]<>'IND')