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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I test reports in cagonos?

556


What is difference between data mart and data warehouse?

548


how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?

1873


A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.

1633


What is the difference between drill through, drill across?

577






what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

1703


How can create users and permissions in cognos?

562


describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

1901


what are the special features in cognos reportnet?

619


What is a Framework manager?

561


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

527


How to join multiple db in catalog?

573


What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

3919


What are the roles defined by cognos platform?

566


What junk dimension contains?

542