Pinned Thread for Common Questions and Issues?

[sjdig]

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:

Code Select Expand

[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:

Code Select Expand

[Date] = _add_days(current_date,-1)

Filter to look back one business day with a Tuesday to Saturday run schedule:

Code Select Expand

(_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:

Code Select Expand

(_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:

Code Select Expand

[Date] between ?[Date]? and ?[Date]?

Filter for a specific Date Prompt Value:

Code Select Expand

[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

[MFGF]

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:

Code Select Expand

[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:

Code Select Expand

[Date] = _add_days(current_date,-1)

Filter to look back one business day with a Tuesday to Saturday run schedule:

Code Select Expand

(_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:

Code Select Expand

(_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:

Code Select Expand

[Date] between ?[Date]? and ?[Date]?

Filter for a specific Date Prompt Value:

Code Select Expand

[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.

[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.

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