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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Display date as first day of the week for last 5 weeks
If the report is run today it should display,first day of the week for the current week and also first day of the week for last weeks.- c83user
- Thread
- Replies: 1
- Forum: Cognos solutions
-
display date for whole week on x-axis in chart
I used this filter for date. [Ls_DATe]>=(CASE (_day_of_week(current_date,1)) WHEN 1 THEN _add_days(current_date,1) WHEN 2 THEN _add_days(current_date,-2) WHEN 3 THEN _add_days(current_date,-3) WHEN 4 THEN _add_days(current_date,-4) WHEN 5 THEN _add_days(current_date,-5) WHEN 6 THEN...- c83user
- Post #2
- Forum: Cognos solutions
-
display date for whole week on x-axis in chart
I need to display summary of productlines for each product ,for the whole week.if today is thursday the xaxis should display count for producs(camping equipment,cookin gear)etc for mon ,tuesd and wednesday.if its start of the week .i need to display the product count for monday. How do i put in...- c83user
- Thread
- Replies: 1
- Forum: Cognos solutions
-
Union versus Aggregation
I have table A and Table B which has a date field in common.A has some inventory 1 and B has inventory 2.I need to add these inventory values to show up in the crosstab with separate filters on inventory 1 and 2.What could be used instead of union.Join on date instead of union does not give...- c83user
- Post #3
- Forum: Cognos solutions
-
Union versus Aggregation
When I use union the report performance is very slow.What is the workaround ?Can I still get the data I need and not use a union.I have too many union queries.(I'm using Union in Report Studio)- c83user
- Thread
- Replies: 3
- Forum: Cognos solutions
