I have been tasked with creating a functionality which will allow stakeholders to compare the change in data values across multiple dates.
The plan of action is to have the comparative fields pulled from the tables to custom archive tables every night. I have coded some sql to extract the data but Sisense does not seem to allow Custom Tables to be built by append rather than overwriting all the data.
Has anyone had any experience with this and what was their approach to creating this data warehouse.
Please sign in to leave a comment.