Answer / m m naidu

JOIN: A join is a query using which we can query data from
more than one table

TYPES OF JOINS:

1.EQUI JOIN
2.SELF JOIN
3.OUTER JOIN
a.left outer join
b.right outer join
c.full outer join
4.cartesian join

Answer / uma

What about inner join?is it not included?

Answer / arkchowdary

Join----------------- Ajoin is fetch the data 1 or more
tables this is known as join.

Types of Joins-------------- Equi Join,
Nonequi join,
Self Join,
Cartesoin Join,
Outer Joins
Leftouter Join,
Rightouter join,
Full outer Join.

Answer / abd hfz

Inner join is also called as Equi Join.

Answer / palzkumar

Both are right.. but slight changes... joins is used to
fetch the records/data item from two or more queries (no
tables in cognos) using
type of joins like...

1.EQUI / SIMPLE JOIN (eg. 1:1 = 1:n)
2.SELF JOIN
3.OUTER JOIN
a.left outer join (eg. 1:0 = 1:n)
b.right outer join (eg. 1:1 = 1:0)
c.full outer join (eg. 1:0 = n:0)

In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.

4 Answers   Accenture, HCL, IBM,

i am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....

2 Answers  

i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?

1 Answers   JPMorgan Chase,

how to change the colour of the bar in charts...?

3 Answers   IBM,

1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?

1 Answers  

what is hints in cognos and where we use it.

0 Answers   Satyam,

pls any body give the cognos 8 versions release year.

3 Answers  

hi Cognos Experts Pls Expalin me what is the diffence between list report query and crosstab report query?pls explain me.....

1 Answers   HCL,

4. How many dimensions did you use in your reports?

0 Answers   IBM,

how can you set the image in the report

1 Answers   HSBC,

Can you define dimension?

0 Answers  

Guys... which difficult you faced in your projects that should be difficult to you not to others... any one can explain but should be clear steps... and with examples... how you handle that......?

0 Answers   CTS,