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
Quote from: sunny bachan prasad on 13 Mar 2015 06:30:03 AM
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.
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.
Quote from: sunny bachan prasad on 13 Mar 2015 03:14:32 PM
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.
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.
Quote from: sunny bachan prasad on 14 Mar 2015 01:03:00 AM
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.
Thanks for your help MFGF.
i put both idea infornt of client and they are ok with your idea.
Sunny