Process all tabular cubes at once

Question

Process all tabular cubes at once

richardmgreen1

SSChampion

Points: 10356
More actions
March 6, 2018 at 3:19 am

#151545

Hi all
We've got a few tabular cubes and we'll be adding more as time goes by.
We want to be able to process them all using an SSIS package (as that forms part of the Data Warehouse load anyway) but we can;'t see a way of processing all the tabular cubes together.
We can process the multidimensional cubes together.
As we're using SSIS, can anyone point me to an idiots guide for setting this up please?

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

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

xsevensinzx One Orange Chip Points: 25560 More actions · Answer 1

I believe the issue most run into is trying to setup parallel loading as separate batches with the parallel features enabled. Then they try to run them all in parallel (separate transactions). What I think you have to do is run multiple batches as the same batch (i.e.: same transaction) with the parallel features enabled. But I am no expert in SSAS mind you. 🙂

richardmgreen1 SSChampion Points: 10356 More actions · Answer 2

With multidimensional cubes, you can point at the top level database and process all the cubes at once.

It would appear that ,with tabular, each cube is it's own database.
In this case, I need a way to loop through the databases and process each cube in turn.

Any help would be appreciated.

richardmgreen1 SSChampion Points: 10356 More actions · Answer 3

Has anyone managed to come up with a way to do this?

Sue_H SSC Guru Points: 90860 More actions · Answer 4

richardmgreen1 - Monday, April 30, 2018 8:41 AM
Has anyone managed to come up with a way to do this?

Check this article:
The practice of processing in SSAS Tabular

Sue

richardmgreen1 SSChampion Points: 10356 More actions · Answer 5

Thanks sue

As the number of cubes grow (especially tabular ones), I wanted to somehow write a loop to process them all together rather than having several tasks in our SSIS package to process them (because we're bound to forget one at some point).