Print Page - Column names in the Package and Report should be different

Title: Column names in the Package and Report should be different
Post by: meeecog on 24 Jun 2014 12:12:21 PM

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

Title: Re: Column names in the Package and Report should be different
Post by: Lynn on 24 Jun 2014 12:30:17 PM

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.

Title: Re: Column names in the Package and Report should be different
Post by: meeecog on 24 Jun 2014 12:37:54 PM

Thanks Lynn

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

Title: Re: Column names in the Package and Report should be different
Post by: Lynn on 24 Jun 2014 01:06:06 PM

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

Title: Re: Column names in the Package and Report should be different
Post by: meeecog on 24 Jun 2014 02:43:50 PM

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

Title: Re: Column names in the Package and Report should be different
Post by: Raghuvir on 25 Jun 2014 08:22:56 AM

hi meeecog,

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

Regards

Title: Re: Column names in the Package and Report should be different
Post by: meeecog on 25 Jun 2014 12:23:41 PM

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

Title: Re: Column names in the Package and Report should be different
Post by: Cognos.Developer on 25 Jun 2014 11:11:07 PM

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

Title: Re: Column names in the Package and Report should be different
Post by: meeecog on 27 Jun 2014 01:50:24 PM

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 ..

Title: Re: Column names in the Package and Report should be different
Post by: Cognos.Developer on 01 Jul 2014 11:23:17 PM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: meeecog on 24 Jun 2014 12:12:21 PM