SSAS Report not populating at SSRS server

Jan 16, 2012 at 5:56 AM

I am getting the following errors while stopping the data collection:

 

 

SSAS_perf

 

After that If I try to start the data collection the following message appears:

 

From SSAS_perf

 

 

Can you help me out, what am I doing wrong? I am analyzing SSAS on same server.

 

Regards

Ashik(scornik)

Jan 16, 2012 at 7:13 AM

Hi,

I found the root cause of the above problem: I hadn't enabled "Data Collection" and after enabling the above error goes away.

But, while stopping the collection I am encountering the following error:

 

From SSAS_perf

 

Any one have any idea?

 

regards

scornik

Jan 16, 2012 at 7:38 AM

Hi ,

 

I was able to get rid of 'SSASServerSSASInstanceName' scripting variable not defined." refencing from ">http://sqlsrvanalysissrvcs.codeplex.com/workitem/14885".

But still stuck in "Msg 208, Level 16, State 1, Server DACW0072\SQL2K8R2, Line 2
Invalid object name 'MDW.snapshots.performance_counters'." error.

 

Regards

Ashik(scornik)

 

Jan 16, 2012 at 8:21 AM
Edited Jan 17, 2012 at 9:57 AM

Hi all,

Finally I have get rid off the final error also by "re-configuring" MDW database.

But finally I got stuck in SSAS Report generation.  The reports are not populating... showing empty.

From SSAS_perf

 

any idea?

 

Regards

Ashik(scornik)