Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Integration Services - Issues when using the Analysis Services Processing task. It doesnt seen to be processing the dimensions Expand / Collapse
Author
Message
Posted Monday, June 11, 2012 9:23 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 6:35 AM
Points: 426, Visits: 639
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
Post #1313915
Posted Monday, June 11, 2012 11:23 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:28 AM
Points: 13,630, Visits: 11,501
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1314200
Posted Tuesday, June 12, 2012 2:16 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 6:35 AM
Points: 426, Visits: 639
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
Post #1314266
Posted Tuesday, June 12, 2012 2:21 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:28 AM
Points: 13,630, Visits: 11,501
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1314271
Posted Tuesday, June 12, 2012 2:28 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 6:35 AM
Points: 426, Visits: 639
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
Post #1314273
Posted Tuesday, June 12, 2012 4:53 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 6:35 AM
Points: 426, Visits: 639
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.
Post #1314336
Posted Tuesday, June 12, 2012 5:01 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:28 AM
Points: 13,630, Visits: 11,501
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1314338
Posted Tuesday, June 12, 2012 5:20 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 6:35 AM
Points: 426, Visits: 639
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?
Post #1314345
Posted Tuesday, June 12, 2012 5:24 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:28 AM
Points: 13,630, Visits: 11,501
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1314347
Posted Tuesday, June 12, 2012 8:12 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 6:35 AM
Points: 426, Visits: 639
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
Post #1314457
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse