I have a number of dimensions and cubes, and I have scheduled them to be processed every week through a SQL Server Agent Job. I want it to be independent of how many dimensions I have, so I created a table with the dimension nameId, and a stored procedure that reads the name from that table and executes the dimension.
The problem is the following:
I need it to be completely automatic, without the need to write the dimension nameId into the table. So, how can I do it?
I would like to say, process all the dimensions and cubes from that folder. Is it possible? Can I do it from a DTS, from a stored procedure?