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

Can you define a datastore in cognos?

0 Answers  


What is the advantage of using shortcuts?

0 Answers  


what is physical layer and presentation layer?

2 Answers   Zensar,


what are typees of dimensions

11 Answers   HCL,


can any one explain about blue prints&performance tuning in cognos? 

1 Answers   TCS,






What are the differences between Cognos ReportNet 1.1, Cognos 8? and enhancements in cognos 8?

1 Answers   IBM, iFlex, TCS,


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 do you improve the performance of the Cognos Analytics report

0 Answers  


-------------What is Coditional Prompting?

0 Answers   IBM,


What is the use of Tree Prompt? Where it is used?Pls give me a real time example?

1 Answers  


Can you define transformer?

0 Answers  


What actually a project contains?

0 Answers  


Categories