Engineering

Qiwk Reports 2 Qiwk® Reports is an easy-to-use Self Service Reporting and Analytics application which is tightly integrated with PLM systems. It enables enterprises to transform PLM data into actionable knowledge which can be used to address business questions. It provides exceptional visibility to enterprise business processes that are based on PLM data.

It serves enterprises to establish better information structure that helps them to generate Quick Reports, Analysis and Performance metrics. It offers data presentation in variety of formats like Customizable Graphical Dashboards, Data Tables/ Grids with rich filters and search capabilities

Key Components

  • Multithreaded ETL layer to export, transform and load data from PLM system to a staging database in near real time.
  • PLM Data warehouse supports integration with MicroStrategy, Business Objects, Tableau, QlikView and other major business intelligence tools.
  • Report Designer to design reports on an ad-hoc basis by the Business Users.
  • Rich and interactive User Interface and data export in excel pdf and various other formats.
 

Benefits

  • Provides a common platform to collate data from across PLM and other enterprise applications to form a “single view of data” timely decision-support
  • Able to perform actionable analyses via KPIs, Dashboards, detailed reports, and ad-hoc reports
  • Utilize the staging area to interface data to other enterprise applications.
  • Improve operational excellence.
 

Key Features

  • Highly Scalable and SOA based open Archite
  • Platform and database independentcture
  • Tight integration with PLM application
  • Visual and intuitive mapping of “cubes” from one or multiple data sources
  • Seamless integration with PLM system. Single Sign on End User interaction from within PLM
  • "Cubes" can be represented as Charts or detailed reports or both
  • Connects to Enterprise Applications (PLM, ERP, CRM) via native APIs
  • Export all the entities from PLM system in a de-normalized reporting data model.
  • Configurable role-based access privileges to core features and functionality.
  • Hierarchical data presentation with drill-down flexibility
  • Flexible ad hoc report generation
  • Output analysis in HTML, XML, Excel, PDF and email formats
  • Open, flexible data input formats, including application-specific APIs, relational database, XML, flat file, Excel and “star-schema” data
  • Dashboard containing charts and graphs to give a bird’s eye view of information.
  • Report scheduling, email notifications, sorting and configurable filter criteria.


Use Cases

  • Over 25 out of the box report templates provided.
  • Change Management / Promotion Reports
  • Change and Promotion Dashboards
    • Change Process Efficiency comparison across the contexts
    • Identify the bottlenecks in the change process
    • Type based change matrices in a multiple change process environment
    • Time taken for change processes to move between difference stages
  • Business Process Performance Reports
    • Performance comparison of business workflow process
    • Min / Max / Avg time taken by the process for completion
    • Time spent by the process in rework loops
    • Comparison of the process in different containers
  • Task / User Efficiency Reports
    • Process activities that take longer time for completion
    • Overloaded / under-utilized available user efforts
  • Team Membership Reports
  • Generate team role and participant report across different context
 

PLM Applications Supported

Qiwk reports is a platform agnostic reporting solution. Currently the tool is offered for PTC’s Windchill PLM solution. Available on request for other PLM solutions including - Aras, Siemens Teamcenter, Dassault Enovia PLM and Oracle Agile PLM.

 

Architecture

  • Enterprise Ready: Tiered secure services oriented for scalability and security with connection to the Windchill PLM Server instance.
  • High Availability: Scaled for high availability, supports a load balanced environment
  • Security: Device communication can be configured to use SSL. Authentication requires LDAP credentials, and registered devices. Secure viewing of attachment content and automatic deletion of contents on exit from App. Allows remote enabling and disabling of devices.