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 / naresh
Yes it is possible, drag and drop the measures what ever you want into under Year column. now it is working fine..
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the themes in a data warehouse?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
Name the types of report?
What junk dimension contains?
i have one file i saved in csv how can i take these file into framework manager
What is defined as Query studio?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
What do you mean by query studio?
What is looping and how to avoid it in framework manager?
Can you explain the advantage of using shortcuts?
What do you understand by ‘ibm predictive maintenance and quality’?
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 cognos reporting tool?
Explain what is the difference between native sql and cognos sql?