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.by DonJ at 2013-01-15 14:49:32
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?
Yet for all my dimensions ‘State’ is “Processed”, while ProcessingState is “Unprocessed”.
Can anyone shed some light on this?
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.