SSAS dimension processingstate vs state

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

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

  • Author
  • #6377

    Points: 0
    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.

The topic ‘SSAS dimension processingstate vs state’ is closed to new replies.