Two level in same column

[sunny bachan prasad]

Hi Cognos Guru,

General information: Package:Dimensional cube(built from cognos transformer).
                                           
                                Data base: Netezza

I am using dimensional package for the first time and have a question may be very easy.

I have ID as  ID1 and ID2 and these are coming as two level in a single hierarchy user want to see these two ID in one column in the output of the report.How i can achieve this?Can any body give any suggestion.

Example of Report output:

ID1/ID2
1234/12345
Thanks in advance
 

[MFGF]

Hi Cognos Guru,

General information: Package:Dimensional cube(built from cognos transformer).
                                           
                                Data base: Netezza

I am using dimensional package for the first time and have a question may be very easy.

I have ID as  ID1 and ID2 and these are coming as two level in a single hierarchy user want to see these two ID in one column in the output of the report.How i can achieve this?Can any body give any suggestion.

Example of Report output:

ID1/ID2
1234/12345
Thanks in advance

Hi,

Is this a list report?

If so, you can drag them in as separate columns, unlock the structure of the report (press the padlock button on the toolbar), drag the ID1 value from the ID1 column into the ID2 column in the list, drag in a text item from the toolbox and drop it between ID1 and ID2 and enter a /, then re-lock the structure and delete the empty ID1 column.

Cheers!

MF.

[sunny bachan prasad]

Hi MFGF,
Thanks for your time.
Ya it was a list report.I tried it and it is working fine.
Just want to know if there is any other way to do it.

[MFGF]

Hi MFGF,
Thanks for your time.
Ya it was a list report.I tried it and it is working fine.
Just want to know if there is any other way to do it.

Why? You have a simple, elegant solution. Why would you want another way of doing it when you have a solution that is efficient and easy?

MF.

[sunny bachan prasad]

Hi MFGF,
Thanks again for your time.
Yes i have a reason for that.One of my senior told me that if i will used this method then it will give performance hit as in this case cognos server has to do the work.So he is insisting me to write some coding or to use netezza function so that iit can be done at database level.

Thanks.

[MFGF]

Hi MFGF,
Thanks again for your time.
Yes i have a reason for that.One of my senior told me that if i will used this method then it will give performance hit as in this case cognos server has to do the work.So he is insisting me to write some coding or to use netezza function so that iit can be done at database level.

Thanks.

Hi,

Sadly, (or perhaps happily?) your senior is wrong here. There is no performance hit - it's simply a layout change. No calculations are being performed. If you tried to do this with a calculation - even one that is pushed back to Netezza - it would involve extra work and more complexity in the query and would be less efficient than the technique outlined here.

Cheers!

MF.

[sunny bachan prasad]

Thanks for your help MFGF.

i put both idea infornt of client and they are ok with your idea.

Sunny