can we join 2 different queries? One has 10 columns and
other has 5+ columns?
Answer Posted / 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 |
Post New Answer View All Answers
What are the batches and it’s details?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
What is a Folder?
What is the enterprise class platform architecture of cognos 8?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
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!
Write some methods to apply securities in framework manager model?
hi friends pls forward impropmtu interview question
what is catalog and types of catalogs in cagnos and which is better?
Mention the difference between ‘macros’ and ‘prompt’?
Can you define snapshot?
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
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
What are the methods by which it non-durable model could be changed into the durable model?