COGNOiSe.com - The IBM Cognos Community

Hi Everyone

I am a metadata developer.

I have a problem in my project.

I have to extract first three letters from the session parameter.

For example:   
     session Parameter:   account.personalinfo.username
             value:                FTW23838


I want only FTW from this.(only first three letters.

I tried to substring but it dint work can any one help me

question:   should i use substring/  make custom session parameters in LDAP.

Thanks

Regards

Cogboy

This works for me:

substring(#sq($account.personalInfo.userName)# ,1,4)

Hi First I like to Thank you for replying

I tried this code in creating a query item i got the result.

When i am trying to use in parameter map its showing error.


For example:

[querysubject][queryitem] =#$New_Parameter_Map{'substring(#sq($account.personalInfo.userName)# ,1,4)'}#


note:i tried using with and with out single quotes.

Please tell your opinon

Thanks

cogboy

You have to work out the usage of the # qualifiers.  I would say that you may not be able to do what you want in a single Query Item.

Can you be more detail please

#inside this symbol is macro# outside is not

I tried that also its giving error.
Is there any work around

Thanks

Cogboy

Not sure what you mean by "tried that"

ust exlpaining what the # symbol indicates...  it is a qualifier for when macro language starts and ends.

Workaround?  No, you need to use Macro Languauge.

My guess is you just haven't typed the syntax in correctly.