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

Extract from session Parameter

Started by cogboy, 16 Oct 2007 07:33:14 PM

Previous topic - Next topic

cogboy

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

rockytopmark

This works for me:

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

cogboy

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


rockytopmark

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.

cogboy


rockytopmark

#inside this symbol is macro# outside is not

cogboy

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

Thanks

Cogboy


rockytopmark

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.