It is possible to give 2 query items has measures in cross
tab?for ex:row as products,column as year and measure as
revenue,sales year....like that.It is possible r not ?If it's
possible pls tel me the process....

Answer Posted / rao

Yes it is possible, we can drop many measures in cross as many we want.
For this, you can drop revenue under year and after this you can drop sales (2nd measure) on right side or left side of revenue when black cursor blinks.
you can drop other measures also in this way.
Hopes it will help.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

1766


------------------What is Inline Query?

1782


How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2151


Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.

4814


What is the difference between low affinity and high affinity connections?

545






What is cognos reporting tool?

602


Define cognos report net?

552


What are the components of the report studio?

632


what is the role of cognos comsultant?what actually it means?pls reply

1876


how to create measures and dimensions?

605


Explain difference between powerplay transformer and power play reports?

535


Can you explain cognos planning?

651


What do you understand by ‘ibm predictive maintenance and quality’?

561


Is it possible to join multiple Databases in a Catalog?

635


How to deploy from one server to another server?

2009