COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: kulkarni on 30 Jun 2010 11:18:55 AM

Title: Concatenate 2 dlist items in Analyst/Contributor
Post by: kulkarni on 30 Jun 2010 11:18:55 AM
Is it possible to concatenate 2 d-list items that are formatted as text?  I am unable to find any BIF that supports it.  Using plus '+' operator or the pipe '|' does not work.

Is this a limitation?  A KB article on IBM mentioned to do such kind of concatenation in Framework Package.  However, the items in the KB were coming from DB and hence it makes sense.  Unfortunately in our case, users will be entering in the 2 fields.

The reason we are trying to enter them seperately is for reporting purposes.  The data then needs to be transferred to a different d-cube in another app.
Title: Re: Concatenate 2 dlist items in Analyst/Contributor
Post by: kulkarni on 08 Jul 2010 01:10:02 PM
I raised a case with Cognos and they confirmed what I suspected, it is NOT possible to caoncatenate 2 or more text fields in Analyst.  It needs to be done outside of analyst (excel, database, etc)!  There is an ehancement request for the same.