Answer / kumar

Hi Friends,

in Prompt page add a filter like

Treat Ship Date as a Date Column,

ANS: day_of_week(Ship Date,0) not in (5,6)

Here 0-Monday
1- Tues Day
..................


Thank You
Kumar

Explain what is the difference between native sql and cognos sql?

0 Answers  

---

How can you create prompts in framework manager?

4 Answers   Tech Mahindra,

---

What is the use of Excel files in Cognos8?

1 Answers  

---

What is Report item

1 Answers   TCS,

---

What is model filter and query filter?

2 Answers   Wipro,

---

what are the enhancements in cognos reportnet ?

9 Answers   IBM, TCS,

---

what is dash board?

2 Answers   Syntel,

---

i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records. How is it possible?

4 Answers   Tech Mahindra,

---

diff b/w layout calculation and query calculation

2 Answers   Cap Gemini,

---

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

0 Answers   IBM,

---

is it possible to display the column names in first page but not in remaining pages i.e if a report contains 10 pages column names should be displayed in 1st page but not remaining pages ( 2 to 10)

2 Answers  

---

Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?

7 Answers   Blue Cross Blue Shield Association, TCS,

---