EnterpriseDW_SSAS
 MdxScript (Commands Index)
  Command Text
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 DYNAMIC SET CURRENTCUBE.[Application Campus Filter]
 AS {
 [Application].[Home Campus].Members
  [Application].[Home Campus].&[N/AA]
 };  
CREATE DYNAMIC SET CURRENTCUBE.[Application Type Filter]
 AS {
 [Application].[Credit Vocational Bachelor Application].Members
  [Application].[Credit Vocational Bachelor Application].&[N/AA]
 };  
CREATE DYNAMIC SET CURRENTCUBE.[Admission Type Filter]
 AS {
 [Application].[Initial Or Readmit Application].Members
  [Application].[Initial Or Readmit Application].&[N/AA]
 };    
CREATE SET CURRENTCUBE.[Application Terms]
 AS Extract
 (
  {
    NONEMPTY
    (
        {
        ORDER([Application].[Application Term Title].[Application Term Title].Members
        ,[Application].[Application Term Title].CURRENTMEMBER.MEMBER_KEY, BDESC)
        }
        ,[Measures].[Application Status Count]
    )
  }
  ,[Application].[Application Term Title]
 );    
CREATE SET CURRENTCUBE.[Application Award Programs]
 AS Extract
 (
  {
    NONEMPTY
    (
        {
        ORDER([Application].[Application Award Program].Members
        ,[Application].[Application Award Program].CURRENTMEMBER.MEMBER_KEY)
        }
        ,[Measures].[Application Status Count]
    )
  }
  ,[Application].[Application Award Program]
 );                       
CREATE SET CURRENTCUBE.[Cohort Term]
 AS Extract
 (
  {
    /* The first term in the list should be the latest term with any first year snapshot data. */
    TOPCOUNT(
        NONEMPTY(
            {
            ORDER([Student Success Cohort].[Cohort Term Title].[Cohort Term Title].Members
            ,[Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_KEY, BDESC)
            }
            ,[Measures].[Student Success First Year Snapshot Count]
        )
        ,1  /* Top 1 = Latest */
    )
    ,
    /* Then all the other cohort terms that have any end of term snapshot data. */
    NONEMPTY
    (
        {
        ORDER([Student Success Cohort].[Cohort Term Title].[Cohort Term Title].Members
        ,[Student Success Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_KEY, BDESC)
        }
        ,[Measures].[Student Success Term Snapshot Count]
    )
  }
  ,[Student Success Cohort].[Cohort Term Title]
 );                            
CREATE SET CURRENTCUBE.[Grade Terms]
 AS EXTRACT
 (
  {
    NONEMPTY
    (
        {
        ORDER([Curriculum].[Term Title].[Term Title].Members
        ,[Curriculum].[Term Title].CURRENTMEMBER.MEMBER_KEY, BDESC)
        }
        ,[Measures].[Students Enrolled and Withdrawn]
    )
         ([Curriculum].[Term Title].&[N/AA])
  }
  ,[Curriculum].[Term Title]
 ) ;                            
CREATE SET CURRENTCUBE.[Grade Years]
 AS EXTRACT
 (
  {
    NONEMPTY
    (
        {
        ORDER([Term].[Term Year].[Term Year].Members
        ,[Term].[Term Year].CURRENTMEMBER.MEMBER_KEY, BDESC)
        }
        ,[Measures].[Students Enrolled and Withdrawn]
    )
         ([Term].[Term Year].&[N/AA])
  }
  ,[Term].[Term Year]
 ) ;            
CREATE SET CURRENTCUBE.[Inst Retention Cohort Year]
 AS Extract
 (
  {
    NONEMPTY
    (
        {
        ORDER([Institutional Retention Cohort].[Cohort Year].[Cohort Year].Members
        ,[Institutional Retention Cohort].[Cohort Year].CURRENTMEMBER.MEMBER_KEY)
        }
        ,[Measures].[Institutional Retention Snapshot Count]
    )
  }
  ,[Institutional Retention Cohort].[Cohort Year]
 );         
CREATE SET CURRENTCUBE.[Pgm Retention Cohort Terms]
 AS Extract
 (
  {
    NONEMPTY
    (
        {
        ORDER([Program Retention Cohort].[Cohort Term Title].[Cohort Term Title].Members
        ,[Program Retention Cohort].[Cohort Term Title].CURRENTMEMBER.MEMBER_KEY)
        }
        ,[Measures].[Program Retention Snapshot Count]
    )
  }
  ,[Program Retention Cohort].[Cohort Term Title]
 );                            
CREATE SET CURRENTCUBE.[State Reporting Years]
 AS Extract
 (
  {
    NONEMPTY
    (
        {
        ORDER([Term].[State Reporting Term Year].[State Reporting Term Year].Members
        ,[Term].[State Reporting Term Year].CURRENTMEMBER.MEMBER_KEY, BDESC)
        }
        ,[Measures].[Students Enrolled and Withdrawn]
    )
  }
  ,[Term].[State Reporting Term Year]
 );                         
CREATE SET CURRENTCUBE.[Grad State Reporting Years]
 AS Extract
 (
  {
    NONEMPTY
    (
        {
        ORDER([Term].[State Reporting Term Year].[State Reporting Term Year].Members
        ,[Term].[State Reporting Term Year].CURRENTMEMBER.MEMBER_KEY, BDESC)
        }
        ,[Measures].[Student Graduation Count]
    )
  }
  ,[Term].[State Reporting Term Year]
 );                            
CREATE SET CURRENTCUBE.[Grad Award Programs]
 AS Extract
 (
  {
    NONEMPTY
    (
        {
        ORDER([Student Objective].[Objective Award Program].Members
        ,[Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_KEY)
        }
        ,[Measures].[Student Graduation Count]
    )
  }
  ,[Student Objective].[Objective Award Program]
 );                        
CREATE SET CURRENTCUBE.[Cohort Award Programs]
 AS Extract
 (
  {
    NONEMPTY
    (
        {
        ORDER([Student Success Cohort].[Cohort Award Program].Members
        ,[Student Success Cohort].[Cohort Award Program].CURRENTMEMBER.MEMBER_KEY)
        }
        ,[Measures].[Student Success Term Snapshot Count]
    )
  }
  ,[Student Success Cohort].[Cohort Award Program]
 );            
CREATE SET CURRENTCUBE.[Inst Retention Award Programs]
 AS Extract
 (
  {
    NONEMPTY
    (
        {
        ORDER([Institutional Retention Cohort].[Inst Ret Award Program].Members
        ,[Institutional Retention Cohort].[Inst Ret Award Program].CURRENTMEMBER.MEMBER_KEY)
        }
        ,[Measures].[Institutional Retention Snapshot Count]
    )
  }
  ,[Institutional Retention Cohort].[Inst Ret Award Program]
 );          
CREATE SET CURRENTCUBE.[Pgm Retention Award Programs]
 AS Extract
 (
  {
    NONEMPTY
    (
        {
        ORDER([Program Retention Cohort].[Pgm Ret Award Program].Members
        ,[Program Retention Cohort].[Pgm Ret Award Program].CURRENTMEMBER.MEMBER_KEY)
        }
        ,[Measures].[Program Retention Snapshot Count]
    )
  }
  ,[Program Retention Cohort].[Pgm Ret Award Program]
 );                            
CREATE SET CURRENTCUBE.[Home Campuses]
 AS {
 [Student].[Home Campus].[Home Campus].Members
  [Student].[Home Campus].&[N/AA]
 };                            
CREATE DYNAMIC SET CURRENTCUBE.[Home Campus Filter]
 AS {
 [Student].[Home Campus].Members
  [Student].[Home Campus].&[N/AA]
 };                          
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].[Average Terms To Graduate]
 AS [Measures].[Num Terms To Graduate] /  [Measures].[Student Graduation Count], 
FORMAT_STRING = "#,##0.00;-#,##0.00", 
VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Student Graduation';                      
CREATE MEMBER CURRENTCUBE.[Measures].[24 Credits]
 AS [Measures].[Meets24 Credits Requirement] /  [Measures].[Student Success First Year Snapshot Count], 
FORMAT_STRING = "#,##0.0 %;-#,##0.0 %", 
VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Student Success First Year Snapshot';                      
CREATE MEMBER CURRENTCUBE.[Measures].[GPA Cum >= 2.0]
 AS [Measures].[Meets GPA Requirement] /  [Measures].[Student Success First Year Snapshot Count], 
FORMAT_STRING = "#,##0.0 %;-#,##0.0 %", 
VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Student Success First Year Snapshot';                      
CREATE MEMBER CURRENTCUBE.[Measures].[College Exp. Course]
 AS [Measures].[Completed College Exp Course] /  [Measures].[Student Success First Year Snapshot Count], 
FORMAT_STRING = "#,##0.0 %;-#,##0.0 %", 
VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Student Success First Year Snapshot';                      
CREATE MEMBER CURRENTCUBE.[Measures].[67% Completed]
 AS [Measures].[Meets67 Pct Completed Requirement] /  [Measures].[Student Success First Year Snapshot Count], 
FORMAT_STRING = "#,##0.0 %;-#,##0.0 %", 
VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Student Success First Year Snapshot';                      
CREATE MEMBER CURRENTCUBE.[Measures].[Gateway Course]
 AS [Measures].[Completed Gateway Course] /  [Measures].[Student Success First Year Snapshot Count], 
FORMAT_STRING = "#,##0.0 %;-#,##0.0 %", 
VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Student Success First Year Snapshot';                      
CREATE MEMBER CURRENTCUBE.[Measures].[Attended Summer]
 AS [Measures].[Attended Summer Term] /  [Measures].[Student Success First Year Snapshot Count], 
FORMAT_STRING = "#,##0.0 %;-#,##0.0 %", 
VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Student Success First Year Snapshot';                      
CREATE MEMBER CURRENTCUBE.[Measures].[Did not meet any]
 AS [Measures].[Did Not Meet Any1st Year Success Factors] /  [Measures].[Student Success First Year Snapshot Count], 
FORMAT_STRING = "#,##0.0 %;-#,##0.0 %", 
VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Student Success First Year Snapshot';                            
CREATE MEMBER CURRENTCUBE.[Measures].[Course Withdrawal Rate]
 AS [Measures].[Withdrawn] /  [Measures].[Students Enrolled and Withdrawn], 
FORMAT_STRING = "#,##0.0 %;-#,##0.0 %", 
VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Student Grades';                            
CREATE MEMBER CURRENTCUBE.[Measures].[Course Failure Rate]
 AS [Measures].[Fail] /  [Measures].[Students Enrolled and Withdrawn], 
FORMAT_STRING = "#,##0.0 %;-#,##0.0 %", 
VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Student Grades';                            
CREATE MEMBER CURRENTCUBE.[Measures].[2nd or More Attempts Percentage]
 AS [Measures].[Attempt2 Or More] /  [Measures].[Students Enrolled and Withdrawn], 
FORMAT_STRING = "#,##0.0 %;-#,##0.0 %", 
VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Student Grades'; 
Powered by BI Documenter