SQL Server 2008 BIDS Cube not showing up in an Integration Services Project

Posted on 2010-01-08
Last Modified: 2012-05-08

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.

Question by:ScottParker
    LVL 5

    Expert Comment

    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
    LVL 5

    Expert Comment

    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
    LVL 5

    Accepted Solution

    Another thing to check...

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

    best regards

    LVL 3

    Author Closing Comment

    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.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now