Forum Discussion

Mustafa_A's avatar
Mustafa_A
Contributor II
4 years ago

TimeStamp when data load is complete

Dear Community - 

 

Is there a way to know when the last load was completed? We have multiple cubes (account recs, mgmt, rept), and it would be helpful if our end user could know when the last  process-load was completed. 

I know we have task activity manager, but if I could filter only the process load tasks, retrieve the time when data load was completed, and display in a table. 

I'm wondering if I need to write a business rule, and integrate that into dashboard/cube. Any idea or examples will be appreciated. Thank you!

 

 

 

 

 

 

Reports
  • TheJonG's avatar
    TheJonG
    Contributor III
    4 years ago

    Hi there - 

    You can create a simple dashboard that contains a SQL Table Editor component which references the TaskActivity Table (accessed in System > Database > System Database > Tables).  The TaskActivityType column is filtered to only show the Load/Load & Process tasks.

     

    The task activity types are stored as integers and 7001 and 7002 refer to Load and Load & Process.

     

     

    You can add that SQL Table component to dashboard and take it from there. 

     

     

     

    • ckattookaran's avatar
      ckattookaran
      VIP
      4 years ago

      If you are using a SQL editor component. Please make sure to change the Allow Inserts and Allow Deletes to False. Otherwise, you run into the danger of trying to write into system tables. (although I do have a feeling that the platform does this automatically)

    • Jared's avatar
      Jared
      New Contributor II
      3 years ago

      Do you happen to have this Task Activity Dashboard as an XML File I could import for testing?