COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: sdf on 01 Jan 2018 06:38:14 PM

Title: FM labels
Post by: sdf on 01 Jan 2018 06:38:14 PM
 Currently query items are in codes. So I'm looking for a way to name them (label) for users to understand using business names.
Is there a functionality in FM to do this? This is for relational source.

I remember when we used cubes, we just created an attribute for the business names and in report we used this attribute as the label source.


any input will be appreciated

thanks a bunch!
Title: Re: FM labels
Post by: Invisi on 03 Jan 2018 07:43:21 AM
It is very simple to change it. During the course you were told how to do it. Did you take a course on Framework Manager?
Title: Re: FM labels
Post by: sdf on 03 Jan 2018 10:48:42 PM
Hi Invinsi,

I am not referring to changing the names of the query items to business names. Sorry for my previous post, I wasn't clear.
What I'm looking for is to having a label associated with my query items preserving the original names from db (in codes).

Ex:
quey item name : XXDOCT

Name        Label
XXDOCT    Expense Document

I am not sure if I am clear enough.
Title: Re: FM labels
Post by: Invisi on 05 Jan 2018 02:07:41 AM
I fail to see what you really want to achieve. To me it sounds something you do by using the different layers. You have a database layer where the query items have the database names and then a logical and/or business layer where the query items are named in business terms. Then definition in the second layer(s) show the underlying database names.

Is this what you want to achieve really for the framework or are you talking about some kind of lineage that is also visible in reports?