SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Integration Services - Issues when using the Analysis Services Processing task. It doesnt seen to be...


Integration Services - Issues when using the Analysis Services Processing task. It doesnt seen to be processing the dimensions

Author
Message
Debbie Edwards
Debbie Edwards
SSC Eights!
SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)

Group: General Forum Members
Points: 806 Visits: 696
I have an Integration Services package and in it I have Analysis Services Processing Tasks

I have a task for each dimension rather than have them all in one package to update the dimensions

Then 2 Procesing tasks for the cube updates.

The dimensions run successfully. But the two cubes fail due to the Attribute keys can’t be found etc. It is as if the cubes have been run within the dimensions being processed first, which is incorrect because I have run the dimensions.

I then run it in Analsis Services. Dimensions first, then the cubes and it is successful.
I then try again in the IS package and its also successful. Presumably because its been processed in Analysis Services.

So clearly even through Integrated Services says that the dimensions have run successfully isnt true.

Can anyone give me any tips on this? Unless I manually process the cubes and dimensions I cant be sure its working. I cant do overnight processing which is… well rubbish.

BTW Everything is on Processing Options = Update. I took this to be process updates only to save time. I am really at a loss here at the moment.

Debbie
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28577 Visits: 13268
Change the dimensions to Process Full, that way you'll be sure they have the latest data.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Debbie Edwards
Debbie Edwards
SSC Eights!
SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)

Group: General Forum Members
Points: 806 Visits: 696
Thats what I was thinking,

The only thing that worries me is the extra time it will take to process everything.

Annoying that Process Updates is so flaky.

Thanks for the advice :-)

Debbie
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28577 Visits: 13268
Debbie Edwards (6/12/2012)
Thats what I was thinking,

The only thing that worries me is the extra time it will take to process everything.

Annoying that Process Updates is so flaky.

Thanks for the advice :-)

Debbie


I recently had issues myself with Process Update, and I changed everything to Process Full. Not really sure why Process Update behaves so clunky.

If your dimensions aren't too large, it shouldn't really be a problem.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Debbie Edwards
Debbie Edwards
SSC Eights!
SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)

Group: General Forum Members
Points: 806 Visits: 696
At least its not me then.

I will get that updated and pop a note in my guidance about Processs updates in Integration Services

Thank you

Debbie
Debbie Edwards
Debbie Edwards
SSC Eights!
SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)

Group: General Forum Members
Points: 806 Visits: 696
This just gets worse....

I changed everything to full process and ran and 1 dimension and both cubes failed again (Like an idiot I didnt check the reasons for the fail)

I processed it in Analysis Services and it ran successfully.

I am really beginning to dislike Integration Services. Its very hit and miss. Blink
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28577 Visits: 13268
That's odd.
When something happens like that, I'd check if everything is configured correctly in SSIS.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Debbie Edwards
Debbie Edwards
SSC Eights!
SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)

Group: General Forum Members
Points: 806 Visits: 696
Might have found something,

I process Updates in analysis Services but I changed the problem dimension to Process FULL and it failed and it looks like there is Some issues.... E.g.

Attribute relationship [School Name] -> [School DFEE] is not valid because it results in a many-to-many relationship.

so At least I have somethint actually sort out now.

Does this mean that its best to always process FULL because the Update is hit and miss?
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28577 Visits: 13268
Normally Process Update shouldn't be hit & miss.

I stumbled across this blog post on MSDN:
Different Kinds of SSAS Processing in simple words…

This particular line is interesting:
ProcessUpdate is inherently slower than ProcessFull since it is doing additional work to apply the changes.


This means there is no actual reason to do Process Update instead of Process Full, so I would just stick with the last one.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Debbie Edwards
Debbie Edwards
SSC Eights!
SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)SSC Eights! (806 reputation)

Group: General Forum Members
Points: 806 Visits: 696
Here was I thinking that just doing the updates would speed things up.

One other question.

I have broken my Analysis Services update into seperate tasks. So each dimension sits in its on task. Then a cube and then then last cube.

Is this the best way to do it?

OR should you have everything in one Analysis Services package. When I had it that way I kept running out of space.

is there a reccomended practice for this?

Debbie
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search