Object Creation

[Former Member]

I have a formula field that need to convert to Dimension Objects. Please correct me where I am missing.

Crystal Formula Field

if isnull({LOCATION.LOC_ID}) then "Unk Location" else

if isnull({LOCATION.LOC_NAME}) then "No Name Of Loc # " + totext({LOCATION.LOC_ID},0,"") else

{LOCATION.LOC_NAME}

Dimension Object in Universe

CASE WHEN ISNULL (LOCATION.LOC_ID,'NULL') = 'NULL' then 'Unk Location' else

CASE WHEN ISNULL (LOCATION.LOC_NAME,'NULL') = 'NULL' then 'No Name of Loc # ' + convert(varchar(40),LOCATION.LOC_ID) else {LOCATION.LOC_NAME} END

Please help me out . SQL is Sql server 2008

Thanks

Reddy

[Former Member · Accepted solution]

I believe you have been given a correct answer here on BOB:

http://www.forumtopics.com/busobj/viewtopic.php?t=164521

[Former Member · Accepted solution]

Issue got resolved,

The error is converting the data type varchar to numneric

CASE WHEN ISNULL (convert(varchar(40),Location.LOC_ID),'NULL') = 'NULL' then 'Unk Loc'

WHEN ISNULL (Location.LOC_NAME,'NULL') = 'NULL' then 'No Name for Loc # ' + convert(varchar(40),Location.LOC_ID) else Location.LOC_NAME END

Thanks

Reddy

[Former Member]

The error is converting the data type varchar to numneric