How to stores archived data (lag1, lag2 etc) in Demantra DM?

I wanted to understand our options if we need to store 12 historic version of the Key outputs of Demantra and the Csutom Metrics in Demantra DM.

Questions:-

1) Can we store multiple lag1, lag2 , ..Lag12 in Sales_data..will this not cause issues with the performance?

2) How many columns can be stored in Sales data ? Any guidelines--900 columns ?

3) Can we store the lag1..lag11 in Demantra tables other than SALES_DATA..any know workarounds?

We are on R12.2.4.X

I am aware of exporting the Demantra results outside to Data Marts / APCC. But wanted to check out if anybody has experience with stroing hundreds of columns inside Demantra DM.