Clarity

  • 1.  Action Item reporting

    Posted Dec 13, 2017 12:38 PM

    Our company wants to see reporting based on action items. In Jaspersoft Studio, what is the correct table to use for creating a report for action items. We are using Saas 15.2



  • 2.  Re: Action Item reporting
    Best Answer

    Broadcom Employee
    Posted Dec 13, 2017 04:40 PM

    Here is the table/Views.

     

    BPM_DEF_PROCESSES_V

    BPM_RUN_PROCESSES

    BPM_RUN_OBJECTS

    BPM_RUN_STEPS

    BPM_DEF_STEPS_V

    BPM_RUN_STEP_ACTION_RESULTS

    BPM_DEF_STEP_ACTIONS_V

    CAL_ALL_ACTION_ITEMS_V

     

    Thanks

    Senthil



  • 3.  Re: Action Item reporting

    Posted Dec 14, 2017 10:27 AM

    I am not seeing these tables/views available to me in Jaspersoft Studio



  • 4.  Re: Action Item reporting

    Posted Dec 14, 2017 12:56 PM

    Sentil's solution works, but only until the point where processes are deleted.  If you have same requirement as defined on other idea you commented on (Action item in data warehouse), then this won't work.

     

    Once processes are deleted, their associated action items are also deleted.  If you need an auditable record of action items retained after processes are deleted, you'll need to copy the action item data to another destination before processes are deleted.

     

    Copying to a custom object ought to preserve the data, make it available in UI and transportable to Jaspersoft DWH using standard Load DWH job.

     

    If you don't need to retain action items from deleted processes, Sentil's solution will work.  It requires an SQL based report built in Jaspersoft Design Studio.  You won't get this using ad-hoc views/reports. 



  • 5.  Re: Action Item reporting

    Broadcom Employee
    Posted Dec 14, 2017 10:32 AM

    You need to build the jasper reports and retrieve the information from transnational database