unable to write more than 10 case statements in an object in designer

[Former Member]

unable to write more than 10 case statements in an object in designer

XI 3.0 and XI 3.1

Please let me know, any known issues.

[Former Member · Accepted solution]

Hi,

yes this is the limitation you cant write more that 10 case statments but you can reduce the number of time you use the case in your object.

For ex:

If you are writing few conditions on one field then you can add the login in one case only.

case when SAL between 100 and 1000 then 'lowsal'

when SAL between 1000 and 2000 then 'medsal'

when sal between 2000 and 3000 then highsal

else

case when ...then ....

else

end

end

by following the above ex you can solve your problem.

But if you are writing case statement based on dofferent columns then write 10 case statements and remaining conditions you can add at the report level.

using if else condition.

Hope this will help you....

Cheers,

Ravichandra

[Former Member]

Hi

Are you getting this error only when you use 11th case statement or if you modify some of the characters for the SQL in the object definition from lower case to upper case (or vice-versa),

For the later one you can follow these steps:

- Test the connection in your universe and click Details.

- From Details, copy and run the path for the PRM file used by your connection which will open the relevant PRM file in Notepad.

- Modify the following parameter (or add to the PRM file if it does not exist) as follows:

<Parameter Name="CASE_SENSITIVE">N</Parameter>

- Save the PRM file.

- Close and relaunch Designer.

Hope this helps!!!

Regards

Sourashree

[Former Member]

I have already added the parameter to the prm file. But no use.

This issue is only with XI3.0 specific with more than 10 statements.

I came to know this is a limitation, I need the ADAPT ID.

[Former Member]

thanks,