SQL Server Analysis Services
Hi,
I created IS package for cube processing and if I execute this task , then execute result is successful.
But I don't see any update information through BIDS when I browse the cubes.
Why it happens and how can I check it
Connection string is fine and i've also checked the processing configuration and I don't see any problem.
Any kinds of advice would be appreciated.
Thanks in advance.
You could try running profiler to see what activities the server is performing.
You don't happen to have any of the automatic unknown member handling switched on do you If you have not updated your dimensions it might be possible that your new data is appearing under an unknown member somewhere, rather than where you expect it to be.
You could also try running the same processing operation through SSMS or BIDS where you can watch the progress to double check that there are no errors occurring.
Just a guess... if you have multiple databases, changing the connection manager won't cause the Analysis Services Processing Task to target a different database because the database ID is hardcoded in the XMLA that's saved when you configure that task.
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=251934
As for troubleshooting, I would echo Darren's suggestions.
Hi,
I've looked at this issue several times but I couldn't solve this problem.
Here is the situation:
I only have 1 data source and deploy and process cubes to local machine and another target server with same database name.
( SalesCube > Local Server and target Server)
I tried to create AS processing package in 2 ways:
Package in Local
Package in Target Server
When I run these 2 packages it reads the data and processing is successful.
(I run the sql profiler and check it)
But the problem is data or dimension /cube structure is not updated.
In management studio of two servers (local and target) , if I try to process cubes processing succesful but not updated also.
So. I'm manually processing the cubes through BIDS but is there anything that I'm missing
Please advice me.
Thanks in advance.
The processing commands sent from BIDS and SSMS should be identical so I can't see why it would work from one and not the other. You chould be able to capture the XMLA using profiler and confirm that the same commands are being sent.
But the problem is data or dimension /cube structure is not updated. Are you talking about processing or deploying BIDS can do both. SSMS and SSIS only do processing, they do not deploy changes to the cube/dimension structure.
Thanks.
I've got confused the SSAS processing task in ssis that only works for processing.
if I change something cube structure and add attributes then I need to deploy it to the target server and then I can use processing task in ssis.
Thanks for the valueable answer. 