• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 689
  • Last Modified:

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
0
ScottParker
Asked:
ScottParker
  • 3
1 Solution
 
grzegorzsCommented:
It seems that your target Analysis Services database doesn't exists on your server, or exists but doesn't contains any processed cubes.
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
 
0
 
grzegorzsCommented:
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
0
 
grzegorzsCommented:
Another thing to check...

Check your Analysis Services Connection Manager MA35. You probably didn't set Initial Catalog.
See attached image.

best regards
Grzegorz



InitialCatalog.jpg
0
 
ScottParkerAuthor Commented:
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.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now