Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Cognos 8 Reporting - Dynamic Date Parameter
Hello, I have created a report that has a date value in one of the fields. I want to schedule this to run on a daily basis. But have the date change dynamically with the current sysdate less 7 days. I do not know the syntax to add into the detail filters. Any ideas? Thank you in advance.- axl169
- Thread
- Replies: 1
- Forum: Cognos solutions
-
Joining a Table to itself... with a twist
We are using Oracle, forget what version, but it does not allow full outer joins on views. I think I found a work around. Thank you for everyone's help regardless. -
Joining a Table to itself... with a twist
Hello, I am working on a union with two views created from a join. Due to a bug in out db, we are unable to do full outer joins. Anyway, I have one table with 4 fields I am interested in. Sales_Rep, Month, Year, and amount. I am trying to created a view that will pull back selected year...
