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 the steps involved in migrating CRN enviroment to Cognos 8?

3 Answers   BMW, Goyal Group, Mersan,

---

I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?

6 Answers  

---

what is an sid (surrogate key)?

2 Answers   IBM, Oracle,

---

What are the different types of OLAP. Which one is Cognos Powercube?

2 Answers   HSBC,

---

----------------What is meant by DSS?

1 Answers   Bank Of America,

---

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

0 Answers   IBM,

---

1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

0 Answers  

---

What is the use of Excel files in Cognos8?

1 Answers  

---

What is the function of model design accelerator?

0 Answers  

---

What is Render Variable? where u can use?

3 Answers  

---

Hi is any one having link to download books on datawarehouse tool kit by ralph kimball or any other authors books.

5 Answers  

---

can anybody send me interview questions with answers on IBM cognos-FM and Report studio. My mail ID is: cskcognos@gmail.com

1 Answers  

---