I have to create a package which process the analysis services cube and its partitions,and dimensions.
This package should run every 15 minutes to process the cube.
I have a procedure which creates the database in analysis services db and relational db for the current month.
I have another procedure which creates daily tables in relational db and daily cubes in analysis services.
I have to process the cube using the current day date using current day relational db table. (The relational db tables are populated by a different process which is fine.)
EX: Current day : 09-11-08, i have to process the cube using the data in table 09-11-08 days data.
For tomorrow : 10-11-08, i have to process the cube using the data in table 10-11-08 days data. and so on....
If the month changes, it has to take that particular day and process the cube.
The package should process only the past 7 days data from the current date and the current dates data.
How can i do this using ssis package.? (Dont want to implement Proactive caching)
How can i check the connection string for each day in the package and how it can be managed in the connection string.?
How can i manage the Analysis Services Processing Task (Checking the partitions and measures)
How can I manage the connection string dynamically if the month changes
Any ideas are helpful.
Sql version: 2008