Cognos 8.4 starts with syntax

[CrystalLion]

what is wrong with this statement?

If([Database View].[A_HISTORY_VW].[DIM_ACCT_NAME]
STARTS WITH 'AL_HE_ARM')
then 'HELOANS'


Thanks

 

[blom0344]

If
[Database View].[A_HISTORY_VW].[DIM_ACCT_NAME]
like
'AL_HE_ARM%'
then
'HELOANS'
else null

Wrong use of ( and ) by the way..

Ties Blom

 

[CrystalLion]

doesn't work. No matter what I try I get a parsing error. Your suggestion generates:

QE-DEF-0459 CCLException
QE-DEF-0260 Parsing error before or near position: 18of "if[database..etc.....
QE-DEF-0261 QFWP - Parsing text: if[Database View...etc...

I've been at this all day to no avail. Could it be a model issue I am not aware of. My role is report writer.

Thanks

 

[blom0344]

Other suggestion:

CASE
WHEN
SUBSTRING([Database View].[A_HISTORY_VW].[DIM_ACCT_NAME],1,9)
= 'AL_HE_ARM'
THEN
'HELOANS'
ELSE (NULL)
END

possibly SUBSTR instead of SUBSTRING (check in Cognos)

Ties Blom