I am on a project that demands some feature for automating the uploads of excel files used as data cache.
In our environment, we will generate excel worksheets with BO WebIntelligence and use them as Data Cache. But we don't want to upload each one of the reports mannualy, because it would spend a lot of time.
In our tests, through a SQL stored procedure (that we build) we could record a file directly in the DM tables. But we are not sure that this is the correct way to do it.
Is there another (better) way?
Thanks in advance.