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.