• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups
    New Idea
    4 Kudos

    Formatting with Reports on PLM360

    Status: Accepted
    by Asingh5 ‎03-01-2013 07:12 AM - edited ‎03-01-2013 07:33 AM

    Currently when generating a report, PLM360 provides a plain excel output which is not very practical dealing with a large amount of information for over 1000 items.

     

    When exporting the report to Excel, the report should be formatted similarly as the HTML version.

     

    Below are some features to make reports on PLM more practical. 

     

    • Freeze Panes - Top Row
    • Filters on column headings
    • Bordering lines to show column separation
    • Colored rows

    To illustrate and example of what I mean...

     

    Example.png

    This is how a regular excel exported report looks.        This is how it should ideally look.

     

    Status: Accepted
    7 Kudos

    A new report type for Planners

    Status: Accepted
    by ACapuzzo on ‎09-19-2012 09:11 AM

    Both for Service Requests and Sales Meetings planning would be usefull to have a kid of report called

    something like Planning report showing Dates on columns(for visits, meeting, events, etc) and being able to select another field for rows and cell contents.

     

    It would be something like what MS Excel calls Pivot Tables.
    I understand it may be not trivial to develop but, from the management point of view, the applications would be many.
    Time management is an high priority issue for all.

     

    For instance, think about a report with dates in columns titles, technicians names on rows titles and the the scheduled customer's name, with contact's phone number and Service Request descriptions inside the cells.

    Status: Accepted
    I too like this idea... I think to build on this, we should expand the reporting engine to allow for lots more configuration. The hopper is always full, but I'd like to have enhancements to the reporting engine to be a focus point for us in the future. I would love to hear more ideas/thoughts, images, of the types of reporting capability folks would like to see.
    0 Kudos

    Make data effectivity available through API

    Status: New Idea
    by cruzj on ‎06-04-2013 12:08 PM
    Our product data and processes are very dependent on effectivity dates. We need to be able to deliver effectivity dates for data downstream for integration with other systems and reporting.

    0 Kudos

    In PLM360, the history of an item is available through a change log, however, the change log is not available through the API for each record in order to enable historical reporting on the actions for an item.

    Use Case: changes to Product Name as it moves from temporary to legal versions.

    Previously we had problems with product name changes over time because we were communicating to customers about products they didn’t buy.

     

    Possible workarounds:

    We could write on every transaction into the ODS

     

    For Ad hoc we could clone records into another workspace and store them for a historical view

    0 Kudos

    The default text box in the initial view should be customizable or auto size to the text in it. I realize you can hover over it and see the fill value but it would be handy to see the whole thing to start

    0 Kudos

    Reports Graph total

    Status: New Idea
    by james.n.tennent on ‎04-28-2013 12:09 AM

    Hi All,

    i am not sure if i am just missing something or the fuction is not available

    when i create a graph (Line Graph) i want to be able to agrogate the last value with the next value.

     

    so if i have a graph with date on the X axis and item count on the Y

    day 1 i create 4 items

    day 2 i create 3 items

    day 3 i create 0 items 

    the graph should be day 1 = 4, day 2=7, day 3 = 7

     

    again, i may have missed something, i just cant see it.

     

    Thanks

    James

    0 Kudos
    obourne

    Overlaying Report Types

    Status: New Idea
    by Valued Contributor obourne on ‎11-16-2012 08:26 AM

    I want to overlay two report types - Stacked and Line charts. My reason is that I want to create a chart of "hours needed" for all projects company wide by month for an entire year (hence a stacked chart) but I want to overlay available man hours on top of that so I can visually see where I'm short workers.

     

    Having visibility into future labor needs is critical for senior management as our hiring cycle can take months.

    0 Kudos

    A Tenant may have 100-1000 buildings managed by a large property management group or builder etc.

     

    Owner/Operator/Vendor groups to have access to View/create/update Accident/Service/Maintenance or other workspace requests and interact with Project schedules/tasks related to specific Buildings.

     

    Owner/Operator/Vendor groups are linked to Buildings ( currently groups have access to roles which are linked to workspaces ) This feature is related to data within specific Facilities Management Workspaces.

     

    Possible Solution

     

    Configurable Picklist based on Owner/Operator/Vendor groups assigment to only present specific values e.g.Buildings

     

    On Item creation, allow a script to add all Groups assigned to the Building which is required field to be added  as Additonal Owners

     

     

    Status: Solution Provided
    John, I think we'll cover this in the Divide tenant into "Project" areas ideaStation post. I think these issues are very similar, so let's consolidate them.
    0 Kudos

    It would be useful to allow users to directly export a Workspace Item listing to Excel.  You can set-up a report to do this, but for basic users it would help to directly export from the listing screen.

    Status: Comments Requested
    Paul, could you expand on this a little more. Also, an image of what you're thinking would be helpful also. Thanks for this idea and the others you've listed!
    0 Kudos
    obourne

    Be Able to Project "Labor Hours Needed" Easily

    Status: Accepted
    by Valued Contributor obourne on ‎08-21-2012 02:57 PM

    When creating a project that with multiple levels of tasks and subprojects I want to be able to get a chart for labor hours projected/need. I realize that this currently can be done using multiple apps combined but I would prefer a way to do this simply with a purpose built app or report.

     

    I say this because in Excel I was able to build a project, assign labor hours and see a graph of projected labor (therfore costs) for a myriad of projects all in a single (albiet huge) spreadsheet. It's a tough sell to get a project manager to switch to 360 when Excel seems easier to use and presents richer data in a single interface than 360 which would need multiple items.

     

    In all fairness I did not actually configure 360 to perform the above mentioned function. I spoke to Trung Nguyen out of SF who explained to me that it would take 3 items to replace my spreadsheet.

     

    It would seem to me that a purpose built app/function/capability within a single item would make more sense than having multiple items to perform an equivelant function as Excel.

     

    The more 360 can displace MS project and spreadsheets for project sheduling and management the better.

    Status: Accepted
    This is another topic that's been on the discussion block. We look for a solution for this in a future release.
    Announcements
    IdeaStation Guidelines
    Review guidelines and best practices
    before posting a new idea


    PLM 360 Survey