MDX Script - MdxScript Commands Index

Calculations Command Script

                  /*
The CALCULATE command controls the aggregation of leaf cells in the cube.
If the CALCULATE command is deleted or modified, the data within the cube is affected.
You should edit this command only if you manually specify how the cube is aggregated.
*/
                  CALCULATE;
                  CREATE SET CURRENTCUBE.[ActiveTerms]
                  AS Extract
                  (
                  {
                  ([Term].[Term Title].[Term Title].Members
                  ,[Term].[Default Term].&[Yes]
                  ,[Term].[Active Term].&[Yes])
                  ,
                  ([Term].[Term Title].[Term Title].Members
                  ,[Term].[Default Term].Children
                  ,[Term].[Active Term].&[Yes]
                  )
                  }
                  ,[Term].[Term Title]
                  );
                  CREATE SET CURRENTCUBE.[Campuses]
                  AS {
                  [Curriculum].[Campus].[Campus].Members
                   [Curriculum].[Campus].&[N/AA]
                  };
                  CREATE DYNAMIC SET CURRENTCUBE.[CampusFilter]
                  AS {
                  [Curriculum].[Campus].Members
                   [Curriculum].[Campus].&[N/AA]
                  };
                  CREATE MEMBER CURRENTCUBE.[Measures].NotPaidEnrollment
                  AS [Measures].[Enrollment]  [Measures].[Paid Enrollment],
                  FORMAT_STRING = "#,##0;-#,##0",
                  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Active Enrollment Snapshot';
                  CREATE MEMBER CURRENTCUBE.[Measures].PriorNotPaidEnrollment
                  AS [Measures].[Prior Enrollment]  [Measures].[Prior Paid Enrollment],
                  FORMAT_STRING = "#,##0;-#,##0",
                  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Prior Enrollment Snapshot';
                  CREATE MEMBER CURRENTCUBE.[Measures].EOTNotPaidEnrollment
                  AS [Measures].[EOT Enrollment]  [Measures].[EOT Paid Enrollment],
                  FORMAT_STRING = "#,##0;-#,##0",
                  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'EOT Enrollment Snapshot';
                  CREATE MEMBER CURRENTCUBE.[Measures].HeadcountDifference
                  AS [Measures].[Headcount]  [Measures].[Prior Headcount],
                  FORMAT_STRING = "#,##0;-#,##0",
                  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Active Headcount';
                  CREATE MEMBER CURRENTCUBE.[Measures].EnrollmentDifference
                  AS [Measures].[Enrollment]  [Measures].[Prior Enrollment],
                  FORMAT_STRING = "#,##0;-#,##0",
                  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Active Enrollment Snapshot';
                  CREATE MEMBER CURRENTCUBE.[Measures].PaidDifference
                  AS [Measures].[Paid Enrollment]  [Measures].[Prior Paid Enrollment],
                  FORMAT_STRING = "#,##0;-#,##0",
                  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Active Enrollment Snapshot';
                  CREATE MEMBER CURRENTCUBE.[Measures].CreditHourDifference
                  AS [Measures].[Credit Hours]  [Measures].[Prior Credit Hours],
                  FORMAT_STRING = "#,##0.00;-#,##0.00",
                  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Active Enrollment Snapshot';
                  CREATE MEMBER CURRENTCUBE.[Measures].ContactHourDifference
                  AS [Measures].[Contact Hours]  [Measures].[Prior Contact Hours],
                  FORMAT_STRING = "#,##0.00;-#,##0.00",
                  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Active Enrollment Snapshot';
                  CREATE MEMBER CURRENTCUBE.[Measures].FTEDifference
                  AS [Measures].[Full Time Equivalent]  [Measures].[Prior Full Time Equivalent],
                  FORMAT_STRING = "#,##0.0000;-#,##0.0000",
                  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Active Enrollment Snapshot';
                  CREATE MEMBER CURRENTCUBE.[Measures].PaidFTEDifference
                  AS [Measures].[Paid Full Time Equivalent]  [Measures].[Prior Paid Full Time Equivalent],
                  FORMAT_STRING = "#,##0.0000;-#,##0.0000",
                  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Active Enrollment Snapshot';
                  CREATE MEMBER CURRENTCUBE.[Measures].[Credit Hours  Current]
                  AS Case
                  When IsEmpty([Measures].[Credit Hours  Enrollment Activity]) THEN 0
                  ELSE [Measures].[Credit Hours  Enrollment Activity]
                  End,
                  FORMAT_STRING = "#,##0.00;-#,##0.00",
                  VISIBLE = 1 ,  DISPLAY_FOLDER = 'Credit Hours' ,  ASSOCIATED_MEASURE_GROUP = 'Enrollment Activity';
                  CREATE MEMBER CURRENTCUBE.[Measures].[Credit Hours  Current  1]
                  AS (
                  ParallelPeriod
                  ([Relative Day].[TermYearTypeRelativeDay].[Term Year]
                  ,1
                  ,[Relative Day].[TermYearTypeRelativeDay].CurrentMember
                  )
                  ,[Measures].[Credit Hours  Current]
                  ),
                  FORMAT_STRING = "#,##0.00;-#,##0.00",
                  VISIBLE = 1 ,  DISPLAY_FOLDER = 'Credit Hours' ,  ASSOCIATED_MEASURE_GROUP = 'Enrollment Activity';
                  CREATE MEMBER CURRENTCUBE.[Measures].[Credit Hours  Current  2]
                  AS (
                  ParallelPeriod
                  ([Relative Day].[TermYearTypeRelativeDay].[Term Year]
                  ,2
                  ,[Relative Day].[TermYearTypeRelativeDay].CurrentMember
                  )
                  ,[Measures].[Credit Hours  Current]
                  ),
                  FORMAT_STRING = "#,##0.00;-#,##0.00",
                  VISIBLE = 1 ,  DISPLAY_FOLDER = 'Credit Hours' ,  ASSOCIATED_MEASURE_GROUP = 'Enrollment Activity';