SSAS dimension processingstate vs state

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

Viewing 0 reply threads
  • Author
    Posts
    • #6377
      Participant
      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?
      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.

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