Adding a new cube to a SSAS DB w/o re-processing all?

Question

Adding a new cube to a SSAS DB w/o re-processing all?

Mike Austin-398977

Say Hey Kid

Points: 697
More actions
December 8, 2010 at 6:29 pm

#232346

All,
I've been asked to create some new cubes. I understand that this has to be done in BIDS. Do I create a new project/solution and point it to the existing SSAS DB or add the cubes to an existing solution?
Can I add just the new cube(s) to the DB without having to process all the existing cubes?
I've created cubes in 2005, but it was all done in Management Studio (I think).
Any help appreciated.
TIA,
Mike

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Brandie Tarvin SSC Guru Points: 173045 More actions · Answer 1

Management Studio allows for the creation of SSAS databases, but not the cubes themselves.

As far as processing cubes, I thought they only processed one at a time. But I never had multiple cubes pointed to the same database.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

darth_vodka Default port Points: 1489 More actions · Answer 2

Mike Austin-398977 (12/8/2010)
All,
I've been asked to create some new cubes. I understand that this has to be done in BIDS. Do I create a new project/solution and point it to the existing SSAS DB or add the cubes to an existing solution?
Can I add just the new cube(s) to the DB without having to process all the existing cubes?
I've created cubes in 2005, but it was all done in Management Studio (I think).
Any help appreciated.
TIA,
Mike

you can get the xml to create a cube from one database, then run it on another database...

still have to reprocess though, but you can reprocess in SSMS

Scott Murray-240410 SSCarpal Tunnel Points: 4649 More actions · Answer 3

You can process each cube within a Solution/Database individually.... also by having more than one cube within a database you can share common dimensions between them.

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 4

You'll want to review the processing architecture/flow (link - it's 2005 specific but holds true for 2008) when doing this as a lot of people simply select 'Process Full' as their processing option, and if you share dimensions between cubes, this can perform a full process on your dims which will in turn invalidate any other cubes that reference/use these dimensions. You can probably achieve what you want, you just need to plan out the sequence and processing options for each object (keeping in mind, that you can process one [or more] partitions in a cube, you don't have to Full Process the entire cube every time).

Steve.