SQL Server 2008 BIDS Cube not showing up in an Integration Services Project
Greetings,
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.
AnalysisServices.JPG
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.
AnalysisServices.JPG
One correction.
If Analysis Services Database exists but contains no cubes - it should be visible in Processing Task Properties dialog.
So the most possible reason is that your database isn't deployed to Analysis Server.
best regards
Grzegorz
If Analysis Services Database exists but contains no cubes - it should be visible in Processing Task Properties dialog.
So the most possible reason is that your database isn't deployed to Analysis Server.
best regards
Grzegorz
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The screen shot you provided was exactly what I needed to see. Once I re-did that connection, and selected the correct innitial database, everything showed up as it should.
Thank you.
Thank you.
Run Management Studio and connect to Analysis Services on localhost. Check if you database exists under Databases node. If not you must open your Analysis Services database project and deploy it to server.
If you see your database under the Databases node expand it, expand Cubes and check if exists "Main" cube. If not - you maybe have problem with project. You should re-deploy your project.
best regards
Grzegorz