cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

Change Dynamic Reporting Functionality

Change Dynamic Reporting Functionality

Status: Archived Submitted by 15-Moonstone on ‎May 19, 2016 08:52 AM
4 Comments (4 New)

I'm going to put this out there because I'm interested to see if people agree or not. Feel free to up/downvote as you see fit.

I am suggesting PTC get rid of Cognos for a better tool for dynamic reporting, or improve the capabilities around Query builder to allow more dynamic reporting (multi-level BOM type scenarios, multiple data sources in one report, etc.) Something better integrated and easier to use. Would really like to see something an advanced end user could use to build reports without having to do anything physically on the server.

A lot of people I've talked to don't use Cognos at all except the out of the box reports. It can't just be us.

Updating Windchill builds is also a painful process.

See more ideas labeled with:
4 Comments
JeffZemsky
17-Peridot
17-Peridot
‎May 23, 2016 04:45 PM
‎May 23, 2016 04:45 PM

Steve,

Can you describe the types of Reports you are looking for - in general there are two broad categories we looked at.  This is a broad generalization - but it would be good to know where your needs are focused

1 - Formatted reports like the Change Notice Summary Report

cnsummary.png

2 - Tabular reports

CN graphs.png

slapha
15-Moonstone
15-Moonstone
‎May 23, 2016 05:40 PM
‎May 23, 2016 05:40 PM

Really I'm looking for both, but closer to the first type.

Lately we've run into a lot of hierarchical data needs. Everyone wants all the data in 1 page. Reports similar to multi-level BOM structures or a variable number of levels. Not all can be done in Query Builder. We also have no skillset in Cognos and that seems to be a trend of other companies using Windchill.

For tabulated the only problem we've had with Query Builder is where it doesn't match up to SQL capabilities, that and the scattered documentation on how to connect all the tables to get the data. Things I can create in an access database I can't create in query builder. The presentation is also frequently lacking more from a UI side than the report output.

tgudobba
14-Alexandrite
14-Alexandrite
‎May 25, 2016 08:04 AM
‎May 25, 2016 08:04 AM

Hello,

We started with COGNOS, but we could never get it implemented and working properly. Our business forced us to use SAP's Business Objects & we have been pretty successful with that so far. Implemented about 5 months ago, so just a few reports so far.

olivierlp
Community Manager
Community Manager
‎Jan 05, 2022 10:27 AM
‎Jan 05, 2022 10:27 AM
Status changed to: Archived

Hello,

We are archiving your idea as part of a general review. This action is based on the age of your idea and the total number of votes received, as per this announcement.

You can always post a new idea with all the details required in the form.

Thank you for your participation.