I am realy new to SQL 2008 and well really new to the whole "Cube" thing also so forgive me if I ask something silly.
I am working in SQL Server 2008. I am loged on to the server itself and not trying to do this at all remotely.
I have created an Integration Services Project in "BIDS".
I have a number of steps that update some tables. I have this set up and running on a daily schedual now and its working fine.
The last "Step" that I want to include is to "Process" a "Cube".
I add the Analysis Services Processing Task to the Control flow and then double click it in order to set it up.
The connection manager is set to <localhost>
I then click on the "Processing Settings" option, I click the "Add" button under the Object List box.
This is where the problem is.
The only Analysis Service project that is listed there is a test one I did when I built a test cube.
Our "Main" BI cube is not listed... and well I need it to be..I want to be able to "re-Process" the cube because the data in the tables has been updated.
Any ideas on how I make it show up? I attached a screen shot of where I am talking about.