COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: Aamir on 14 Dec 2006 11:14:44 AM

Title: Query item Captions and Desc from SQL server In FM
Post by: Aamir on 14 Dec 2006 11:14:44 AM
Hi
Is it possible to get captions and descriptions of sql server table field into framework manager?
In my table, descriptions exist for each filed and when i checked knowledge base, it says "Framework Manager automatically assigns a description to the Query Items and Query Subjects if one exists in the data source." but when i bring the  datasource , it doesnt bring the descriptions. Anyone can tell me what should i do to bring the description from datasource.
Thanks in advance.
Aamir
Title: Re: Query item Captions and Desc from SQL server In FM
Post by: sir_jeroen on 20 Dec 2006 04:43:11 PM
Can you export the DB descriptions to a file? If so then you could trying to import them in FM the same way as you would do for alternative languages.
I haven't tried this but I would give it a try...

Good luck