can we join 2 different queries? One has 10 columns and
other has 5+ columns?
Answers were Sorted based on User's Feedback
Answer / the_xxx
yes you can join two diff queries based on common key data
item, you cannot union them ( for union both queries must
have similar data items and order of the items)..hope this
helps.
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / pavan kumar
Suppose if u have common column We use Master Detailed
RelationShip.
| Is This Answer Correct ? | 1 Yes | 2 No |
what is surrogate key give example?
My report output is showing data as 1 11 111 2 22 222 3 33 333 How can I sort this to 1 2 3 11 22 33 111 222 333
What are the steps to import the two data sources in framework manager?
How the Bursting happens in same report and how to Print the bursting Report?
Can you explain a cognos controller?
how many types of keys are there i.e primary key and foreign key etc..?
In framework Manager, what is a stitch query and is it good or bad?
What are all types of Batches?
Hi everyone, In my report i have ten pages like page1,page2, upto page10, i have textbox prompt when i enter 1 page1 should display,when i enter 2 page2 should display,can anyone suggest the answer.
How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?
7 Answers Genpact, iFlex, TCS,
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!
Can we create reports using OLTP database?How?