SSAS dimension processingstate vs state

This topic contains 0 replies, has 1 voice, and was last updated by  Forums Archives 5 years, 10 months ago.

  • Author
    Posts
  • #6377

    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.

You must be logged in to reply to this topic.