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 p...
Forum Discussion
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.
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)