Report Data Set - dsClassCapacityDetails

Property	Value
DataSetName	dsClassCapacityDetails
Data Source Reference
Collation
Case Sensitivity
Accent Sensitivity
Is MDX	True
Query Command Type	MDX
Query Data Source Name	RSDS_EnterpriseDW_SSAS
Query Timeout
Use Generic Designer
Kanatype Sensitivity
Width Sensitivity
Integrated Security

SELECT
  {[Measures].[Enrollment]} ON COLUMNS
,{
      [Curriculum].[Reference Number].[Reference Number].ALLMEMBERS*
      [Curriculum].[Course Id].[Course Id].ALLMEMBERS*
      [Curriculum].[Class Title].[Class Title].ALLMEMBERS*
      [Curriculum].[Campus].[Campus].ALLMEMBERS*
      [Curriculum].[Session].[Session].ALLMEMBERS*
      [Curriculum].[Class Status].[Class Status].ALLMEMBERS*
      [Curriculum].[Maximum Class Size].[Maximum Class Size].ALLMEMBERS
  }
  DIMENSION PROPERTIES
    MEMBER_CAPTION
   ,MEMBER_UNIQUE_NAME
   ON ROWS
FROM
(
  SELECT
    StrToSet
    (@CurriculumCoursePrefix
     ,CONSTRAINED
    ) ON COLUMNS
  FROM
  (
    SELECT
      StrToSet
      (@CurriculumDeliveryMethod
       ,CONSTRAINED
      ) ON COLUMNS
    FROM
    (
      SELECT
        StrToSet
        (@CurriculumDivDept
         ,CONSTRAINED
        ) ON COLUMNS
      FROM
      (
        SELECT
          StrToSet
          (@CurriculumSession
           ,CONSTRAINED
          ) ON COLUMNS
        FROM
        (
          SELECT
            StrToSet
            (@CurriculumCampus
             ,CONSTRAINED
            ) ON COLUMNS
          FROM
          (
            SELECT
              StrToSet
              (@CurriculumTerm
               ,CONSTRAINED
              ) ON COLUMNS
            FROM
            (
              SELECT
                StrToSet
                (@CurriculumCreditNonCreditVocationalTest
                 ,CONSTRAINED
                ) ON COLUMNS
              FROM
              (
                SELECT
                  StrToSet
                  (@CurriculumCreditType
                   ,CONSTRAINED
                  ) ON COLUMNS
                FROM [Executive_Dashboard]
              )
            )
          )
        )
      )
    )
  )
)
WHERE
  (
    IIF
    (
      StrToSet(@CurriculumTerm,CONSTRAINED).Count = 1
     ,StrToSet
      (@CurriculumTerm
       ,CONSTRAINED
      )
     ,[Curriculum].[Term].CurrentMember
    )
   ,IIF
    (
      StrToSet(@CurriculumDivDept,CONSTRAINED).Count = 1
     ,StrToSet
      (@CurriculumDivDept
       ,CONSTRAINED
      )
     ,[Curriculum].[Div Dept].CurrentMember
    )
   ,IIF
    (
      StrToSet(@CurriculumDeliveryMethod,CONSTRAINED).Count = 1
     ,StrToSet
      (@CurriculumDeliveryMethod
       ,CONSTRAINED
      )
     ,[Curriculum].[Delivery Method].CurrentMember
    )
   ,IIF
    (
      StrToSet(@CurriculumCoursePrefix,CONSTRAINED).Count = 1
     ,StrToSet
      (@CurriculumCoursePrefix
       ,CONSTRAINED
      )
     ,[Curriculum].[Course Prefix].CurrentMember
    )
   ,IIF
    (
      StrToSet(@CurriculumCreditNonCreditVocationalTest,CONSTRAINED).Count = 1
     ,StrToSet
      (@CurriculumCreditNonCreditVocationalTest
       ,CONSTRAINED
      )
     ,[Curriculum].[Credit Non Credit Vocational Test].CurrentMember
    )
   ,IIF
    (
      StrToSet(@CurriculumCreditType,CONSTRAINED).Count = 1
     ,StrToSet
      (@CurriculumCreditType
       ,CONSTRAINED
      )
     ,[Curriculum].[Credit Type].CurrentMember
    )
  )
CELL PROPERTIES
  VALUE
,BACK_COLOR
,FORE_COLOR
,FORMATTED_VALUE
,FORMAT_STRING
,FONT_NAME
,FONT_SIZE
,FONT_FLAGS;

Field Name	Field Type	Field Value
Campus	System.String
Class_Status	System.String
Class_Title	System.String
Course_Id	System.String
Enrollment	System.Int32
Maximum_Class_Size	System.String
Reference_Number	System.String
Session	System.String

Parameter Name	Parameter Value
CurriculumCampus	=Parameters!CurriculumCampus.Value
CurriculumCoursePrefix	=Parameters!CurriculumCoursePrefix.Value
CurriculumCreditNonCreditVocationalTest	=Parameters!CurriculumCreditNonCreditVocationalTest.Value
CurriculumCreditType	=Parameters!CurriculumCreditType.Value
CurriculumDeliveryMethod	=Parameters!CurriculumDeliveryMethod.Value
CurriculumDivDept	=Parameters!CurriculumDivDept.Value
CurriculumSession	=Parameters!CurriculumSession.Value
CurriculumTerm	=Parameters!CurriculumTerm.Value
OccupancyRange	=Parameters!OccupancyRange.Value