Answer / krishna

Database only: All queries are processed by Database instead of Cognos. If it is failed.you can get an error and Report won’t run.

Limited Locally: Cognos is allowed to process the Queries, which cannot process completely on the database.

Answer / arul

if it is database only cognose eveluate the query and execute in database.
in the case of limited locale cognos do not evaluate the query database evaluate and execute the query id database through error same will be displayed in cognos.

How many fact tables and dimension tables in your project?

3 Answers   IBM,

---

what is view? types of views?

3 Answers   HCL,

---

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

5 Answers  

---

-----------Types of Fact Tables?

6 Answers   Bank Of America, CTS,

---

write the sql query to display 5th and 10th row in a table?

5 Answers   CTS, IBM,

---

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

0 Answers  

---

how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls

2 Answers   Patni,

---

How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?

0 Answers  

---

hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

0 Answers  

---

3. What was the size of your cube?

1 Answers   IBM,

---

What is an open session command in cognos connection?what is it meant for?

1 Answers   Infosys,

---

Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!

5 Answers   HCL, Wipro,

---