cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Windchill and Cognos report

Highlighted
Level 7

Windchill and Cognos report

Hello,

 

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 :

Queries.PNG

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:

Filter.PNG

 

How to do all that in Windchill query without using Cognos?

Tags (3)