how to create a condition ?

[nicer]

Hi all
I new with Cognos

I have created a report with a project creation date
I want to create a condition which alow the user to only projects that created the day before (yesterday date)
and of course it should be dynamic date

how can I do that ?

Thank you

[Lynn]

Welcome to the wonderful world of Cognos.

Take a moment to look at the Forum Etiquette thread to help guide you on how to best provide the details that will allow forum members to assist, in particular item 1 (c).

http://www.cognoise.com/index.php/topic,24030.0.html

Assuming it is a relational package, perhaps you just need a detail filter such as

Code Select Expand


[Your Project Create Date Item] = _add_days( current_date, -1 )


[nicer]

Thank you
but I really don't know if i'm using the relational package or not
how can I check it ?

[Lynn]

If you answer (a) to both questions below then you have a dimensional package such as a cube or DMR package. If you answer (b) to both then you have a relational package.

1) Within Report Studio do you see
     a) A section at the top between the page area and the toolbar area for page layers and context filters
     b) Nothing in between the page area and the toolbar area

1) Within Report Studio at the top of the source pane do you see
     a) An option to view the member tree or the meta data tree plus icons to control set behavior and insertion of children, etc.
     b) Only options to change the package source or refresh the package tree

There are different reporting techniques and functions depending on which style of reporting is involved so it is an important thing to know.