SSAS dimension processingstate vs state

Welcome Forums General PowerShell Q&A SSAS dimension processingstate vs state

Viewing 0 reply threads
  • Author
    • #6377
      Topics: 1562
      Replies: 0
      Points: 1
      Rank: Member

      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?
      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.

Viewing 0 reply threads
  • The topic ‘SSAS dimension processingstate vs state’ is closed to new replies.