Is there any possibility that we could create a pinned thread for common questions and issues?
One example could be regarding date filters and providing some common ones for a new user to reference.
Filter for previous month:
[Date] between _first_of_month (_add_months (current_date, -1)) and _last_of_month (_add_months (current_date, -1))
Filter to always look back one day:
[Date] = _add_days(current_date,-1)
Filter to look back one business day with a Tuesday to Saturday run schedule:
(_day_of_week(current_date,1) =2 and [Date] between _add_days(current_date, -3) and _add_days(current_date, -1)) or [Date] = _add_days(current_date,-1)
Filter to look back one business day with a Monday to Friday run schedule:
(_day_of_week(current_date,1) = 1 and [Date] = _add_days(current_date,-3)) or (_day_of_week(current_date,1) =2 and [Date] between _add_days(current_date, -3) and _add_days(current_date, -1)) or [Date] = _add_days(current_date,-1)
Filter for a Date Prompt Range:
[Date] between ?[Date]? and ?[Date]?
Filter for a specific Date Prompt Value:
[Date] = ?[Date]?
I just know how potentially frustrating it could be to either be an end user seeing repeat questions or be a new user trying to search through old threads where the question has been posted multiple times.
Some other examples could be how to design a case statement, what aggregation does, etc.
Just a thought that might be beneficial and occurred to me when attempting to train some individuals to use Cognos.
sjdig
Quote from: sjdig on 28 Dec 2018 10:13:24 AM
Is there any possibility that we could create a pinned thread for common questions and issues?
One example could be regarding date filters and providing some common ones for a new user to reference.
Filter for previous month:
[Date] between _first_of_month (_add_months (current_date, -1)) and _last_of_month (_add_months (current_date, -1))
Filter to always look back one day:
[Date] = _add_days(current_date,-1)
Filter to look back one business day with a Tuesday to Saturday run schedule:
(_day_of_week(current_date,1) =2 and [Date] between _add_days(current_date, -3) and _add_days(current_date, -1)) or [Date] = _add_days(current_date,-1)
Filter to look back one business day with a Monday to Friday run schedule:
(_day_of_week(current_date,1) = 1 and [Date] = _add_days(current_date,-3)) or (_day_of_week(current_date,1) =2 and [Date] between _add_days(current_date, -3) and _add_days(current_date, -1)) or [Date] = _add_days(current_date,-1)
Filter for a Date Prompt Range:
[Date] between ?[Date]? and ?[Date]?
Filter for a specific Date Prompt Value:
[Date] = ?[Date]?
I just know how potentially frustrating it could be to either be an end user seeing repeat questions or be a new user trying to search through old threads where the question has been posted multiple times.
Some other examples could be how to design a case statement, what aggregation does, etc.
Just a thought that might be beneficial and occurred to me when attempting to train some individuals to use Cognos.
sjdig
Hi,
There is already a pinned FAQs thread in this board - https://www.cognoise.com/index.php/topic,27563.0.html
We're always on the lookout for new content to add - if you want to create something that matches the form of what's already in the thread, I would be happy to add it in for you.
Cheers!
MF.
QuoteHi,
There is already a pinned FAQs thread in this board - https://www.cognoise.com/index.php/topic,27563.0.html
We're always on the lookout for new content to add - if you want to create something that matches the form of what's already in the thread, I would be happy to add it in for you.
Cheers!
MF.
Good to know and I appreciate the prompt response. Could you add in those date filters? I'm sure I'm probably missing a couple that could also be added.
sjdig