Hi,
I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...



Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me.....

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

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Cognos Interview Questions

what is your project workflow and your role in the project?

5 Answers   Syntel,


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,


how to improve the report performance?

1 Answers  


if u generate a cube r pakage then its published we open in cc its ask every time for username &pass word?what we do?the pak r cube was not asking the password? what we do for this problem?pls ans me.............

1 Answers  


Main Differnce between Cognos7 and Cognos8

1 Answers   IBM,






WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?

2 Answers   ABC Infotech, Virtusa,


WHAT ARE THE TYPES OF LIST REPORTS?

4 Answers   Patni,


What is the difference between filter & Condition?

3 Answers   MetLife, TCS,


actually we are migrating one project to ACTUATE business intelligence solution to COGNOS REPORTNEt? why the client want to migrate from ACTUATE to COGNOS REPORTNEt? what are the special features in COGNOS REPORTNEt?

1 Answers  


im having a value prompt, in that value prompt im having the values as ABC and CDF, i want to hide the select box in that value prompt? is it possible in cognos?

1 Answers   IBM,


How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.

5 Answers   HSBC,


How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?

4 Answers  


Categories