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 MEMBER CURRENTCUBE.[Measures].[Credit And Clock Hours Combined  Current 2]
                  AS (
                  ParallelPeriod
                  ([Relative Day].[TermYearTypeRelativeDay].[Term Year]
                  ,2
                  ,[Relative Day].[TermYearTypeRelativeDay].CurrentMember
                  )
                  ,[Measures].[Credit And Clock Hours Combined]
                  ),
                  FORMAT_STRING = "#,##0.00;-#,##0.00",
                  VISIBLE = 1 ,  DISPLAY_FOLDER = 'Credit Hours' ,  ASSOCIATED_MEASURE_GROUP = 'Enrollment Snapshot';
                  CREATE MEMBER CURRENTCUBE.[Measures].[Credit And Clock Hours Combined  Current 1]
                  AS (
                  ParallelPeriod
                  ([Relative Day].[TermYearTypeRelativeDay].[Term Year]
                  ,1
                  ,[Relative Day].[TermYearTypeRelativeDay].CurrentMember
                  )
                  ,[Measures].[Credit And Clock Hours Combined]
                  ),
                  FORMAT_STRING = "#,##0.00;-#,##0.00",
                  VISIBLE = 1 ,  DISPLAY_FOLDER = 'Credit Hours' ,  ASSOCIATED_MEASURE_GROUP = 'Enrollment Snapshot';
                  CREATE MEMBER CURRENTCUBE.[Measures].[Credit Hours  Current  1]
                  AS (
                  ParallelPeriod
                  ([Relative Day].[TermYearTypeRelativeDay].[Term Year]
                  ,1
                  ,[Relative Day].[TermYearTypeRelativeDay].CurrentMember
                  )
                  ,[Measures].[Credit Hours]
                  ),
                  FORMAT_STRING = "#,##0.00;-#,##0.00",
                  VISIBLE = 1 ,  DISPLAY_FOLDER = 'Credit Hours' ,  ASSOCIATED_MEASURE_GROUP = 'Enrollment Snapshot';
                  CREATE MEMBER CURRENTCUBE.[Measures].[Credit Hours  Current  2]
                  AS (
                  ParallelPeriod
                  ([Relative Day].[TermYearTypeRelativeDay].[Term Year]
                  ,2
                  ,[Relative Day].[TermYearTypeRelativeDay].CurrentMember
                  )
                  ,[Measures].[Credit Hours]
                  ),
                  FORMAT_STRING = "#,##0.00;-#,##0.00",
                  VISIBLE = 1 ,  DISPLAY_FOLDER = 'Credit Hours' ,  ASSOCIATED_MEASURE_GROUP = 'Enrollment Snapshot';
                  CREATE MEMBER CURRENTCUBE.[Measures].[Headcount  Current  1]
                  AS (
                  ParallelPeriod
                  ([Relative Day].[TermYearTypeRelativeDay].[Term Year]
                  ,1
                  ,[Relative Day].[TermYearTypeRelativeDay].CurrentMember
                  )
                  ,[Measures].[Headcount]
                  ),
                  FORMAT_STRING = "#,##0;-#,##0",
                  VISIBLE = 1 ,  DISPLAY_FOLDER = 'Headcount' ,  ASSOCIATED_MEASURE_GROUP = 'Enrollment Snapshot DC';
                  CREATE MEMBER CURRENTCUBE.[Measures].[Headcount  Current  2]
                  AS (
                  ParallelPeriod
                  ([Relative Day].[TermYearTypeRelativeDay].[Term Year]
                  ,2
                  ,[Relative Day].[TermYearTypeRelativeDay].CurrentMember
                  )
                  ,[Measures].[Headcount]
                  ),
                  FORMAT_STRING = "#,##0;-#,##0",
                  VISIBLE = 1 ,  DISPLAY_FOLDER = 'Headcount' ,  ASSOCIATED_MEASURE_GROUP = 'Enrollment Snapshot DC';