Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

parallel processing not supported by analysis services processing task 1

Status
Not open for further replies.

aparmar

Programmer
Mar 18, 2011
5
GB
I'm getting the following warning in SSIS when using the Analysis Services processing task: parallel processing not supported by analysis services processing task

SQL version I'm using
Edition: Enterprise Edition
PatchLevel: 10.2.4000.0
SP: 2
Version: 10.2.4000.0

In SSIS, my Analysis Services Processing Task has a version of: 10.0.1600.22. Could this be the issue?

 
The exact warning message is the following, even though I'm using Enterprise Edition:

Parallel processing not supported on Standard edition of Analysis Services

 
Could it be that your SQL/SSIS instance is installed as Enterprise Edition, whereas your SSAS instance is installed as Standard?
 
I'm processing all the Dimensions related to the Cube through SSIS. I process the Cube separately once all the Dimensions have been processed.

I use the SSIS component "Analysis Services Processing Task":

- In the editor, I add the required Dimensions with the Process Options as : Process Update

- I then click "Change Settings", in the Processing Order, as soon as I select Parallel the following warning appears, even though I'm using the Enterprise Edition of SQL Server:

"Parallel processing not supported on Standard edition of Analysis Services"



BIDS Cube Project to design and deploy:

- The Deployment mode is "Enterprise"

- Parallel Processing works correctly through this project when deploying - there is no warning

There are also no warning's if Processing (Cubes/Dimensions) directly through SSAS, using SSMS.

Any ideas or further settings to ensure SSIS is recognising SQL Server Enterprise Edition?

 
No ideas. I am able to successfully perform parallel processing in SSIS. However, I am on SP1 for both SQL/SSIS and SSAS. Maybe your initial idea was correct.
 
Can you check the component "Analysis Services Processing Task", Click "Change Settings", with Parallel checked, do you see a warning?

The component itself executes successfully, but I'm seeing a warning, so I don't think it's doing it in Parallel.

If I run the same Parallel processes through SSMS and compare to SSIS - SSIS is taking longer, and there's no warning in SSMS, so thought the Parallel is not working.

 
I see a warning at the bottom that says "Parallel processing is not supported on standard edition of Analysis Services." My guess is that it's just for informational purposes. SSIS/BIDS probably does not know ahead of time which version this will be run against. This is especially true if one were to dynamically change the SSAS connection string at run time.
 
Thanks for confirming this - very helpful.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top