Answer / rashmi

Cognos connection to Oracle Datasource(JDBC Connction)
1. Go to IBM COgnos Administration
2. Go to 'Configuration' tab
3. Data Source COnnection
4. Top right cotner click on 'New data source connection'
5. Provide Name for your connection
6. Click next
7. From type select 'Oracle'
8. Select check box 'JDBC COnnction'
9. CLick Next
10. Provide connection string ***Get this detail from tnsname.ora file
11. crete signon (Provide database id & password)
12. Click next
13. In the next screen select 'Oracle Net descriptor'
14. Drive type 'thin'
15. Provide Database connction string value in the box for 'Oracle Net
Descripor'
16. Test the connection

Answer / madhavi

Cognos is a reporting tool so oracle is connected before
publishing the package in FM. Their is the connectivity to
oracle and the link is given after that the package which
is linked to oracle is published to report author then
after reports are generated which has got a link with the
oracle. Its simple.....

Answer / sunil

I think when during the ETL process ETL people will do the
connections to the required RDBMS in the form of ODBC
connections in taht way they can import the tables from
data source to target table (i.e in data ware house) data
warehouse acts as a data source to the BI modelers for
creating the interface.the project contains query
subjects .which contains the SQL statements.so ETL people
do the odbc connections during ETL process.

How to deploy from one server to another server?

0 Answers  

---

what is meant by roll up and roll back in dataware housing????

4 Answers   Covansys, IBM, Wipro,

---

Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!

1 Answers   Wipro,

---

How to connect three fact tables?

11 Answers   L&T, TCS,

---

What are the different type of securities can we apply in framework manager?

1 Answers  

---

what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull

2 Answers   IBM,

---

WHAT ARE THE TYPES OF LIST REPORTS?

4 Answers   Patni,

---

Explain the different types of views used in cognos.

0 Answers  

---

can you apply grouping on crosstab?

1 Answers   CTS,

---

What is the difference between set functions and filter function in dimensional data?

0 Answers  

---

what is cube size?

4 Answers   IBM,

---

which table we load first in DW. dimension or fact? why?

4 Answers   IBM, JPMorgan Chase,

---