Column names in the Package and Report should be different

[meeecog]

Hello All

We have a requirement to show different column names the package business layer layout ..but when it's used in the report it should change to other name like below

In our package business layer we have like below


Business Layer
       Employee Info
                  EEID
                  BDAY
                  TERMDATE

When user use these items from the above package in a report they should look like this

Employee ID           Birth Date        Termination Date


Yes we can change the column names in FM ..but uses know these columns based on the Transaction system ..so they want same as in the Transnational system..

Please advice if any 1 has done this kind..

Rgds
J

[Lynn]

I would model with the business names and include the database column names in the screen tip along with the rest of the business definition.

[meeecog]

Thanks Lynn

Our Business users are not ok with Screen Tips ..Any other ideas/thoughts..

[Lynn]

First thought is that business users are annoying at times  ;)

Second thought is that you could model according to the proven practice for durable models and advise your authors to change their locale to the design language for building reports and then to the display language for running reports.

Links on durable models
http://www.ibm.com/developerworks/data/library/cognos/page60.html
and
http://www.ibm.com/developerworks/data/library/cognos/modeling/design/page496.html
and
see also Chapter 5 in the FM User guide

[meeecog]

Thanks Lynn

Yes we can't satisfy Business users with all their requirements.. I'm giving my best in this case..

I will check these links

[Raghuvir]

hi meeecog,

how about defining the labels in the report layout ? will that be useful in your case ?

Regards

[meeecog]

Thanks Raghu ..Business don't want to spend any time in report layout changing column names..

[Cognos.Developer]

Hi,

It is better add the Discription Column at Database Level and Update the Model & Publish the Package, In the Report Drag The Discription Column, it may give us expected result.

ThanksKumar

[meeecog]

Thanks.. Nice idea ..Unfortunately we don't have access to our Data Warehouse to edit tables or create ..we have to depend on our IT ..

[Cognos.Developer]

Hi,

at this point We must need the DB Access because we have alot of resrtinctions from Client side, So request them  "DB Access", and add the new column.

OR

Create a New Query Subject using the DataBase Query Subject & Modify the Query Items Names as per Business Requirement & Publish the Package & Create report with New Query Subject it will give us New Column names.

Thank YouHelp_Cognos