Author Posts

January 1, 2012 at 12:00 am

by Klaas at 2013-01-14 03:09:10

I browse to the dimensions in my SSAS Database and I find they have both a 'State' and 'ProcessingState' Property.
Get-ChildItem SQLSERVER:\SQLAS\MyServer\MyInstance\Databases\Mydatabase\dimensions | Select *
To find out the difference, I read on MSDN that the 'State' property returns the AnalysisState. In the description of this AnalysisState I read that this is the ProcessingState. So it's just a complicated way of returning the same property twice?
http://msdn.microsoft.com/en-us/library/ms165068.aspx
Yet for all my dimensions 'State' is "Processed", while ProcessingState is "Unprocessed".

Can anyone shed some light on this?

by DonJ at 2013-01-15 14:49:32

I cannot. Unfortunately, this isn't really a PowerShell question, although you're using PowerShell to retrieve the data. This is about Analysis Services – you might try a forum dedicated to that technology.