TimeStamp when data load is complete

[Mustafa_A]

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!

[TheJonG]

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]

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]

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