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.

what are slowly changing dimensions? Why we are used scd?

0 Answers   IBM,

---

17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?

3 Answers   TCS,

---

What are the Ways to Import Data into Catalong?

1 Answers   Cognos, IBM,

---

How can you link a query to a data container manually in Report Studio?

0 Answers  

---

Can we create reports using OLTP database?How?

3 Answers  

---

Which service handles requests for cognos connection,query studio and event studio.

3 Answers   HCL,

---

How to create users and permissions in cognos?

4 Answers   IBM,

---

------------- How to identify the Revenue Column in Report?

0 Answers  

---

What is Report item

1 Answers   TCS,

---

Hi Friends, What is the Max no.of rows in a report & a page? If we have Master, Detail Reports, I have define drill through, Requirement is When i run Master Report it should run in HTML, when i drill through to detailed report it should get into PDF is it Possible in Cognos? Thank You Kumar

2 Answers  

---

Explain the different stages in creating a report in cognos report net?

3 Answers   IBM,

---

Give me any example of semi and non additive measures?

0 Answers  

---