Interested to Buy Any Domain ? << Click Here >> for more details...
can we join 2 different queries? One has 10 columns and
other has 5+ columns?
- 2 Answers
- 6953 Views
- IBM, I also Faced
- E-Mail Answers
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 an sid (surrogate key)?
Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?
How can I convert a list report/Cross tab Report in Cognos EP series into a bar chart or pie chart etc.
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?
What is called cognos reporting tool?
how to change the colour of the bar in charts...?
How do you call a store procedure within a transformation?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
what is Cognos Visualizer?
What is conditional styling? a.format applied based on filter b.format applied based on user c.format applied based on on condition d.all the above 2. For a company X, actual revenue and budgeted revenue are captured in two tables Fact_Ac_Rev and Fact_Bud_rev. Both are at diff levels of granularity (Fact_Act is month and budget @ quarter leve )and there is one common Time dimension, A report is created to show the actual and budgeted revenue 2gther but the data for budgeted is wrong. Which should be doing for rectifing the error? a. create determinants for month and quarter b. join the two table facts into a single fact c. Create 2 time dimensions @ FM d. Need to create 2 separate reports as the required info cant be shown using a single report. 3. Template in a Query Studio? a. sample Data set b. CSS c. A standard that applies for all reports d. None of the listed options 4.you are a report author @ the Company, which sells sporting equipment 5. Sales person in different regions each need a report showing sales target for each country. which of the following is the best way to distribut? a. Email b. Bursting c. storing in public folders d. All the above. 6. I)A query subject behave as a dimensional in one query and fact in other query. ii) Queries with more than one fact results in stitched query. iii) Cognos identifies a query subject as Fact based only on the measure a. ii only b. i only c. both i and ii d. iii only 7. what is meant by pivoting? a. making a stacked set b. swapping rows into columns c. making column as filter d. none of the above 8. A report cant be viewed in which? a. CSV b. XML c. ASCII d. Excel 9.A user wants to retriv all products which are not sold for last X days. Which prompt is used? a. Time b. Value c. Text d. Interval 10. Dispatcher? a.routes request to appropriate services and start services b. routes request to appropriate services c.starts all service d. none of the abv Frenz Please help me out !!! :) Thanks in Advance
how to hide a particular pages at time if you get blank pages
Teradata 
