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
What is a Datastore in Cognos?
Can you define slice?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
Can you define set to be cardinality?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
How do you call a store procedure within a transformation?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
What are all types of Batches?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
What is the enterprise class platform architecture of cognos 8?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
Give me any example of semi and non additive measures?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What is the use of powerhouse?