I need help in order to optimize time needed for a report to run in Cognos.
Cognos report shows specific action items of users.
i have used Teams in order to group users per department. Also in each team, there is one manager.
The report now filters the action items based on who is running the report. Therefore, Manager A have as results the users that are within the team where the Manager A belongs to.
as you may understand, this filtering is done in Cognos, after brought the action items for all users which it takes too much time.
Below are the queries and joins in Cognos :
BWTUser gets the action items
Manager gets the participant in role Manager in Teams
Dep gets the participants in role Department User in Teams
DepManager join based on Team Name and shows Team - Department User - Manager
Query1 join based on Action Item Owner and Department User
Query1 is filtered based on:
How to do all that in Windchill query without using Cognos?