0.75in0.70833in0.20833intruetrue=Parameters!TermStateReportingTermYear.Label + " Graduates"Textbox87LightGrey2pt2pt2pt2pt20.17709intruetrueTextbox882pt2pt2pt2pt20.17708intruetrue=Sum(Fields!Student_Graduation_Count.Value)Student_Graduation_Count22pt2pt2pt2pttruetrue=Sum(Fields!Student_Graduation_Count.Value) / Sum(Fields!Student_Graduation_Count.Value,"dsGender")Textbox1402pt2pt2pt2pt2.07292intruetrueDemographic CategoryTextbox85LightGrey2pt2pt2pt2pt2.07292intruetrueBy GenderTextbox692pt2pt2pt2pt0.28125intruetrueTextbox702pt2pt2pt2pt=Fields!Gender.Value=Fields!Gender.Value1.79167intruetrue=Fields!Gender.ValueGender22pt2pt2pt2ptdsGender0.0057in0.00002in0.5625in3.53125in0.75002in0.70833in0.1875intruetrueTextbox892pt2pt2pt2pt20.1875intruetrue=Sum(Fields!Student_Graduation_Count.Value)Student_Graduation_Count22pt2pt2pt2pttruetrue=Sum(Fields!Student_Graduation_Count.Value) / Sum(Fields!Student_Graduation_Count.Value,"dsEthnicity")Textbox1422pt2pt2pt2pt2.07292intruetrueBy EthnicityTextbox692pt2pt2pt2pt0.28125intruetrueTextbox702pt2pt2pt2pt=Fields!Ethnicity.Value=Fields!Ethnicity.Value1.79167intruetrue=Fields!Ethnicity.Value2pt2pt2pt2ptdsEthnicity0.63764in0.375in3.53127in10.75001in0.70833in0.1875intruetrueTextbox892pt2pt2pt2pt20.16667intruetrue=Sum(IIF(Fields!Race_African_American.Value = "Yes",Fields!Student_Graduation_Count.Value,0))2pt2pt2pt2pttruetrue=Sum(IIF(Fields!Race_African_American.Value = "Yes",Fields!Student_Graduation_Count.Value,0))
/ Sum(Fields!Student_Graduation_Count.Value,"dsRace")Textbox1442pt2pt2pt2pt0.16667intruetrue=Sum(IIF(Fields!Race_American_Indian.Value = "Yes",Fields!Student_Graduation_Count.Value,0))2pt2pt2pt2pttruetrue=Sum(IIF(Fields!Race_American_Indian.Value = "Yes",Fields!Student_Graduation_Count.Value,0))
/ Sum(Fields!Student_Graduation_Count.Value,"dsRace")Textbox1452pt2pt2pt2pt0.16667intruetrue=Sum(IIF(Fields!Race_Asian.Value = "Yes",Fields!Student_Graduation_Count.Value,0))2pt2pt2pt2pttruetrue=Sum(IIF(Fields!Race_Asian.Value = "Yes",Fields!Student_Graduation_Count.Value,0))
/ Sum(Fields!Student_Graduation_Count.Value,"dsRace")Textbox1472pt2pt2pt2pt0.16667intruetrue=Sum(IIF(Fields!Race_Pacific_Islander.Value = "Yes",Fields!Student_Graduation_Count.Value,0))2pt2pt2pt2pttruetrue=Sum(IIF(Fields!Race_Pacific_Islander.Value = "Yes",Fields!Student_Graduation_Count.Value,0))
/ Sum(Fields!Student_Graduation_Count.Value,"dsRace")Textbox1462pt2pt2pt2pt0.16666intruetrue=Sum(IIF(Fields!Race_White.Value = "Yes",Fields!Student_Graduation_Count.Value,0))2pt2pt2pt2pttruetrue=Sum(IIF(Fields!Race_White.Value = "Yes",Fields!Student_Graduation_Count.Value,0))
/ Sum(Fields!Student_Graduation_Count.Value,"dsRace")Textbox1482pt2pt2pt2pt0.17708intruetrue=Sum(IIF(Fields!Race_Unreported.Value = "Yes",Fields!Student_Graduation_Count.Value,0))2pt2pt2pt2pttruetrue=Sum(IIF(Fields!Race_Unreported.Value = "Yes",Fields!Student_Graduation_Count.Value,0))
/ Sum(Fields!Student_Graduation_Count.Value,"dsRace")Textbox1492pt2pt2pt2pt2.07292intruetrueBy Race (counts may be duplicated)Textbox692pt2pt2pt2pt0.28125intruetrueTextbox1002pt2pt2pt2pt1.79167intruetrueAfrican AmericanTextbox1012pt2pt2pt2pt=IIF(ReportItems!AfricanAmericanCount.Value=0,True,False)0.28125intruetrueTextbox1032pt2pt2pt2pt1.79167intruetrueAmerican IndianTextbox1042pt2pt2pt2pt=IIF(ReportItems!AmericanIndianCount.Value=0,True,False)0.28125intruetrueTextbox1092pt2pt2pt2pt1.79167intruetrueAsianTextbox1102pt2pt2pt2pt=IIF(ReportItems!AsianCount.Value=0,True,False)0.28125intruetrueTextbox1122pt2pt2pt2pt1.79167intruetruePacific IslanderTextbox1132pt2pt2pt2pt=IIF(ReportItems!PacificIslanderCount.Value=0,True,False)0.28125intruetrueTextbox1062pt2pt2pt2pt1.79167intruetrueWhiteTextbox1072pt2pt2pt2pt=IIF(ReportItems!WhiteCount.Value=0,True,False)0.28125intruetrueTextbox1152pt2pt2pt2pt1.79167intruetrueUnreportedTextbox1162pt2pt2pt2pt=IIF(ReportItems!UnreportedCount.Value=0,True,False)dsRace1.08556in0.00001in1.19792in3.53126in20.74999in0.70833in0.1875intruetrueTextbox892pt2pt2pt2pt20.1875intruetrue=Sum(Fields!Student_Graduation_Count.Value)Student_Graduation_Count22pt2pt2pt2pttruetrue=Sum(Fields!Student_Graduation_Count.Value) / Sum(Fields!Student_Graduation_Count.Value,"dsAgeGroup")Textbox1512pt2pt2pt2pt2.07293intruetrueBy Age Range At GraduationTextbox692pt2pt2pt2pt0.28126intruetrueTextbox702pt2pt2pt2pt=Fields!Graduation_Age_Range.Value=Fields!Graduation_Age_Range_Sort.Value1.79167intruetrue=Fields!Graduation_Age_Range.Value2pt2pt2pt2ptdsAgeGroup2.35292in0.00002in0.375in3.53125in30.75001in0.70833in0.1875intruetrueTextbox892pt2pt2pt2pt20.17709intruetrue=Sum(Fields!Student_Graduation_Count.Value)Student_Graduation_Count22pt2pt2pt2pttruetrue=Sum(Fields!Student_Graduation_Count.Value) / Sum(Fields!Student_Graduation_Count.Value,"dsPrepReq")Textbox1532pt2pt2pt2pt2.07293intruetrueBy Initial Prep RequirementsTextbox692pt2pt2pt2pt0.28126intruetrueTextbox702pt2pt2pt2pt=Fields!Initial_Prep_Status.Value=Fields!Initial_Prep_Status.Value1.79167intruetrue=Fields!Initial_Prep_Status.Value2pt2pt2pt2ptdsPrepReq2.78348in0.00002in0.36459in3.53127in43.14807in3.53129in1in1in1in1in0RSDS_EnterpriseDW_SSASNone2bb535a2-9253-4024-9232-b3ac76d3ad56RSDS_EnterpriseDW_SSASWITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Year].ALLMEMBERS ON ROWS FROM [StudentSuccess]MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Year].ALLMEMBERS ON ROWS FROM [StudentSuccess]truetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!TermStateReportingTermYear.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYear[Term].[State Reporting Term Year].&[2012]
State Reporting Term Year
[Term].[State Reporting Term Year]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Year].ALLMEMBERS ON ROWS FROM [StudentSuccess]truetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!TermStateReportingTermYear.Value=Parameters!StudentHomeCampus.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYear[Term].[State Reporting Term Year].&[2012]
State Reporting Term Year
[Term].[State Reporting Term Year]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Year].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartruetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!TermStateReportingTermYear.Value=Parameters!StudentHomeCampus.Value=Parameters!StudentObjectiveObjectiveAwardProgram.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))TermStateReportingTermYear[Term].[State Reporting Term Year].&[2012]
State Reporting Term Year
[Term].[State Reporting Term Year]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Year].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartrueStudentObjectiveObjectiveAwardProgram[Student Objective].[Objective Award Program].[All]
Objective Award Program
[Student Objective].[Objective Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYearStudentHomeCampustruetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!TermStateReportingTermYear.Value=Parameters!StudentHomeCampus.Value=Parameters!StudentObjectiveObjectiveAwardProgram.Value=Parameters!StudentInitialPrepStatus.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))TermStateReportingTermYear[Term].[State Reporting Term Year].&[2012]
State Reporting Term Year
[Term].[State Reporting Term Year]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Year].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartrueStudentObjectiveObjectiveAwardProgram[Student Objective].[Objective Award Program].[All]
Objective Award Program
[Student Objective].[Objective Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYearStudentHomeCampustrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramtruetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!TermStateReportingTermYear.Value=Parameters!StudentHomeCampus.Value=Parameters!StudentObjectiveObjectiveAwardProgram.Value=Parameters!StudentInitialPrepStatus.Value=Parameters!StudentStudentAthlete.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))TermStateReportingTermYear[Term].[State Reporting Term Year].&[2012]
State Reporting Term Year
[Term].[State Reporting Term Year]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Year].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartrueStudentObjectiveObjectiveAwardProgram[Student Objective].[Objective Award Program].[All]
Objective Award Program
[Student Objective].[Objective Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYearStudentHomeCampustrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramtrueStudentStudentAthlete[Student].[Student Athlete].[All]
Student Athlete
[Student].[Student Athlete]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatustruetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!TermStateReportingTermYear.Value=Parameters!StudentHomeCampus.Value=Parameters!StudentObjectiveObjectiveAwardProgram.Value=Parameters!StudentInitialPrepStatus.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))TermStateReportingTermYear[Term].[State Reporting Term Year].&[2012]
State Reporting Term Year
[Term].[State Reporting Term Year]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Year].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartrueStudentObjectiveObjectiveAwardProgram[Student Objective].[Objective Award Program].[All]
Objective Award Program
[Student Objective].[Objective Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYearStudentHomeCampustrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramtrueStudentStudentAthlete[Student].[Student Athlete].[All]
Student Athlete
[Student].[Student Athlete]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatustrueStudentVeteranStudent[Student].[Veteran Student].[All]
Veteran Student
[Student].[Veteran Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatusStudentStudentAthletetruetruetrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />System.Int32=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.ValueSystem.StringRSDS_EnterpriseDW_SSAS=Parameters!TermStateReportingTermYear.Value=Parameters!StudentHomeCampus.Value=Parameters!StudentObjectiveObjectiveAwardProgram.Value=Parameters!StudentInitialPrepStatus.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.Value=Parameters!StudentInternationalStudent.Value SELECT NON EMPTY { [Measures].[Student Graduation Count] } ON COLUMNS, NON EMPTY { ([Student].[Gender].[Gender].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))) WHERE ( IIF( STRTOSET(@TermStateReportingTermYear, CONSTRAINED).Count = 1, STRTOSET(@TermStateReportingTermYear, CONSTRAINED), [Term].[State Reporting Term Year].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED), [Student Objective].[Objective Award Program].currentmember ), IIF( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentInitialPrepStatus, CONSTRAINED), [Student].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXStudentSuccess[Term].[State Reporting Term Year][Term].[State Reporting Term Year].&[2012]true[Student].[Home Campus][Student].[Home Campus].[All]true[Student Objective].[Objective Award Program][Student Objective].[Objective Award Program].[All]true[Student].[Initial Prep Status][Student].[Initial Prep Status].[All]true[Student].[Student Athlete][Student].[Student Athlete].[All]true[Student].[Veteran Student][Student].[Veteran Student].[All]true[Student].[International Student][Student].[International Student].[All]true SELECT NON EMPTY { [Measures].[Student Graduation Count] } ON COLUMNS, NON EMPTY { ([Student].[Gender].[Gender].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))) WHERE ( IIF( STRTOSET(@TermStateReportingTermYear, CONSTRAINED).Count = 1, STRTOSET(@TermStateReportingTermYear, CONSTRAINED), [Term].[State Reporting Term Year].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED), [Student Objective].[Objective Award Program].currentmember ), IIF( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentInitialPrepStatus, CONSTRAINED), [Student].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSTermStateReportingTermYear[Term].[State Reporting Term Year].&[2012]
State Reporting Term Year
[Term].[State Reporting Term Year]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Year].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartrueStudentObjectiveObjectiveAwardProgram[Student Objective].[Objective Award Program].[All]
Objective Award Program
[Student Objective].[Objective Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYearStudentHomeCampustrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramtrueStudentStudentAthlete[Student].[Student Athlete].[All]
Student Athlete
[Student].[Student Athlete]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatustrueStudentVeteranStudent[Student].[Veteran Student].[All]
Veteran Student
[Student].[Veteran Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatusStudentStudentAthletetrueStudentInternationalStudent[Student].[International Student].[All]
International Student
[Student].[International Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatusStudentStudentAthleteStudentVeteranStudenttrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Student].[Gender].[Gender]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Student Graduation Count]" />System.Int32RSDS_EnterpriseDW_SSAS=Parameters!TermStateReportingTermYear.Value=Parameters!StudentHomeCampus.Value=Parameters!StudentObjectiveObjectiveAwardProgram.Value=Parameters!StudentInitialPrepStatus.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.Value=Parameters!StudentInternationalStudent.Value SELECT NON EMPTY { [Measures].[Student Graduation Count] } ON COLUMNS, NON EMPTY { ([Student].[Ethnicity].[Ethnicity].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))) WHERE ( IIF( STRTOSET(@TermStateReportingTermYear, CONSTRAINED).Count = 1, STRTOSET(@TermStateReportingTermYear, CONSTRAINED), [Term].[State Reporting Term Year].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED), [Student Objective].[Objective Award Program].currentmember ), IIF( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentInitialPrepStatus, CONSTRAINED), [Student].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXStudentSuccess[Term].[State Reporting Term Year][Term].[State Reporting Term Year].&[2012]true[Student].[Home Campus][Student].[Home Campus].[All]true[Student Objective].[Objective Award Program][Student Objective].[Objective Award Program].[All]true[Student].[Initial Prep Status][Student].[Initial Prep Status].[All]true[Student].[Student Athlete][Student].[Student Athlete].[All]true[Student].[Veteran Student][Student].[Veteran Student].[All]true[Student].[International Student][Student].[International Student].[All]true SELECT NON EMPTY { [Measures].[Student Graduation Count] } ON COLUMNS, NON EMPTY { ([Student].[Ethnicity].[Ethnicity].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))) WHERE ( IIF( STRTOSET(@TermStateReportingTermYear, CONSTRAINED).Count = 1, STRTOSET(@TermStateReportingTermYear, CONSTRAINED), [Term].[State Reporting Term Year].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED), [Student Objective].[Objective Award Program].currentmember ), IIF( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentInitialPrepStatus, CONSTRAINED), [Student].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSTermStateReportingTermYear[Term].[State Reporting Term Year].&[2012]
State Reporting Term Year
[Term].[State Reporting Term Year]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Year].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartrueStudentObjectiveObjectiveAwardProgram[Student Objective].[Objective Award Program].[All]
Objective Award Program
[Student Objective].[Objective Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYearStudentHomeCampustrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramtrueStudentStudentAthlete[Student].[Student Athlete].[All]
Student Athlete
[Student].[Student Athlete]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatustrueStudentVeteranStudent[Student].[Veteran Student].[All]
Veteran Student
[Student].[Veteran Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatusStudentStudentAthletetrueStudentInternationalStudent[Student].[International Student].[All]
International Student
[Student].[International Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatusStudentStudentAthleteStudentVeteranStudenttrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Student].[Ethnicity].[Ethnicity]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Student Graduation Count]" />System.Int32RSDS_EnterpriseDW_SSAS=Parameters!TermStateReportingTermYear.Value=Parameters!StudentHomeCampus.Value=Parameters!StudentObjectiveObjectiveAwardProgram.Value=Parameters!StudentInitialPrepStatus.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.Value=Parameters!StudentInternationalStudent.Value SELECT NON EMPTY { [Measures].[Student Graduation Count] } ON COLUMNS, NON EMPTY { ([Student].[Race African American].[Race African American].ALLMEMBERS * [Student].[Race American Indian].[Race American Indian].ALLMEMBERS * [Student].[Race Pacific Islander].[Race Pacific Islander].ALLMEMBERS * [Student].[Race Asian].[Race Asian].ALLMEMBERS * [Student].[Race Unreported].[Race Unreported].ALLMEMBERS * [Student].[Race White].[Race White].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))) WHERE ( IIF( STRTOSET(@TermStateReportingTermYear, CONSTRAINED).Count = 1, STRTOSET(@TermStateReportingTermYear, CONSTRAINED), [Term].[State Reporting Term Year].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED), [Student Objective].[Objective Award Program].currentmember ), IIF( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentInitialPrepStatus, CONSTRAINED), [Student].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXStudentSuccess[Term].[State Reporting Term Year][Term].[State Reporting Term Year].&[2012]true[Student].[Home Campus][Student].[Home Campus].[All]true[Student Objective].[Objective Award Program][Student Objective].[Objective Award Program].[All]true[Student].[Initial Prep Status][Student].[Initial Prep Status].[All]true[Student].[Student Athlete][Student].[Student Athlete].[All]true[Student].[Veteran Student][Student].[Veteran Student].[All]true[Student].[International Student][Student].[International Student].[All]true SELECT NON EMPTY { [Measures].[Student Graduation Count] } ON COLUMNS, NON EMPTY { ([Student].[Race African American].[Race African American].ALLMEMBERS * [Student].[Race American Indian].[Race American Indian].ALLMEMBERS * [Student].[Race Pacific Islander].[Race Pacific Islander].ALLMEMBERS * [Student].[Race Asian].[Race Asian].ALLMEMBERS * [Student].[Race Unreported].[Race Unreported].ALLMEMBERS * [Student].[Race White].[Race White].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))) WHERE ( IIF( STRTOSET(@TermStateReportingTermYear, CONSTRAINED).Count = 1, STRTOSET(@TermStateReportingTermYear, CONSTRAINED), [Term].[State Reporting Term Year].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED), [Student Objective].[Objective Award Program].currentmember ), IIF( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentInitialPrepStatus, CONSTRAINED), [Student].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSTermStateReportingTermYear[Term].[State Reporting Term Year].&[2012]
State Reporting Term Year
[Term].[State Reporting Term Year]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Year].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartrueStudentObjectiveObjectiveAwardProgram[Student Objective].[Objective Award Program].[All]
Objective Award Program
[Student Objective].[Objective Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYearStudentHomeCampustrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramtrueStudentStudentAthlete[Student].[Student Athlete].[All]
Student Athlete
[Student].[Student Athlete]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatustrueStudentVeteranStudent[Student].[Veteran Student].[All]
Veteran Student
[Student].[Veteran Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatusStudentStudentAthletetrueStudentInternationalStudent[Student].[International Student].[All]
International Student
[Student].[International Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatusStudentStudentAthleteStudentVeteranStudenttrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Student].[Race African American].[Race African American]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Student].[Race American Indian].[Race American Indian]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Student].[Race Pacific Islander].[Race Pacific Islander]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Student].[Race Asian].[Race Asian]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Student].[Race Unreported].[Race Unreported]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Student].[Race White].[Race White]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Student Graduation Count]" />System.Int32RSDS_EnterpriseDW_SSAS=Parameters!TermStateReportingTermYear.Value=Parameters!StudentHomeCampus.Value=Parameters!StudentObjectiveObjectiveAwardProgram.Value=Parameters!StudentInitialPrepStatus.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.Value=Parameters!StudentInternationalStudent.Value SELECT NON EMPTY { [Measures].[Student Graduation Count] } ON COLUMNS, NON EMPTY { ([Student Objective].[Graduation Age Range].[Graduation Age Range].ALLMEMBERS * [Student Objective].[Graduation Age Range Sort].[Graduation Age Range Sort].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))) WHERE ( IIF( STRTOSET(@TermStateReportingTermYear, CONSTRAINED).Count = 1, STRTOSET(@TermStateReportingTermYear, CONSTRAINED), [Term].[State Reporting Term Year].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED), [Student Objective].[Objective Award Program].currentmember ), IIF( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentInitialPrepStatus, CONSTRAINED), [Student].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXStudentSuccess[Term].[State Reporting Term Year][Term].[State Reporting Term Year].&[2012]true[Student].[Home Campus][Student].[Home Campus].[All]true[Student Objective].[Objective Award Program][Student Objective].[Objective Award Program].[All]true[Student].[Initial Prep Status][Student].[Initial Prep Status].[All]true[Student].[Student Athlete][Student].[Student Athlete].[All]true[Student].[Veteran Student][Student].[Veteran Student].[All]true[Student].[International Student][Student].[International Student].[All]true SELECT NON EMPTY { [Measures].[Student Graduation Count] } ON COLUMNS, NON EMPTY { ([Student Objective].[Graduation Age Range].[Graduation Age Range].ALLMEMBERS * [Student Objective].[Graduation Age Range Sort].[Graduation Age Range Sort].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))) WHERE ( IIF( STRTOSET(@TermStateReportingTermYear, CONSTRAINED).Count = 1, STRTOSET(@TermStateReportingTermYear, CONSTRAINED), [Term].[State Reporting Term Year].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED), [Student Objective].[Objective Award Program].currentmember ), IIF( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED).Count = 1, STRTOSET(@StudentInitialPrepStatus, CONSTRAINED), [Student].[Initial Prep Status].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSTermStateReportingTermYear[Term].[State Reporting Term Year].&[2012]
State Reporting Term Year
[Term].[State Reporting Term Year]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Year].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartrueStudentObjectiveObjectiveAwardProgram[Student Objective].[Objective Award Program].[All]
Objective Award Program
[Student Objective].[Objective Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYearStudentHomeCampustrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramtrueStudentStudentAthlete[Student].[Student Athlete].[All]
Student Athlete
[Student].[Student Athlete]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatustrueStudentVeteranStudent[Student].[Veteran Student].[All]
Veteran Student
[Student].[Veteran Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatusStudentStudentAthletetrueStudentInternationalStudent[Student].[International Student].[All]
International Student
[Student].[International Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatusStudentStudentAthleteStudentVeteranStudenttrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Student Objective].[Graduation Age Range].[Graduation Age Range]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Student Graduation Count]" />System.Int32<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Student Objective].[Graduation Age Range Sort].[Graduation Age Range Sort]" />System.StringRSDS_EnterpriseDW_SSAS=Parameters!TermStateReportingTermYear.Value=Parameters!StudentHomeCampus.Value=Parameters!StudentObjectiveObjectiveAwardProgram.Value=Parameters!StudentInitialPrepStatus.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.Value=Parameters!StudentInternationalStudent.Value SELECT NON EMPTY { [Measures].[Student Graduation Count] } ON COLUMNS, NON EMPTY { ([Student].[Initial Prep Status].[Initial Prep Status].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))) WHERE ( IIF( STRTOSET(@TermStateReportingTermYear, CONSTRAINED).Count = 1, STRTOSET(@TermStateReportingTermYear, CONSTRAINED), [Term].[State Reporting Term Year].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED), [Student Objective].[Objective Award Program].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXStudentSuccess[Term].[State Reporting Term Year][Term].[State Reporting Term Year].&[2012]true[Student].[Home Campus][Student].[Home Campus].[All]true[Student Objective].[Objective Award Program][Student Objective].[Objective Award Program].[All]true[Student].[Initial Prep Status][Student].[Initial Prep Status].[All]true[Student].[Student Athlete][Student].[Student Athlete].[All]true[Student].[Veteran Student][Student].[Veteran Student].[All]true[Student].[International Student][Student].[International Student].[All]true SELECT NON EMPTY { [Measures].[Student Graduation Count] } ON COLUMNS, NON EMPTY { ([Student].[Initial Prep Status].[Initial Prep Status].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@StudentInternationalStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))) WHERE ( IIF( STRTOSET(@TermStateReportingTermYear, CONSTRAINED).Count = 1, STRTOSET(@TermStateReportingTermYear, CONSTRAINED), [Term].[State Reporting Term Year].currentmember ), IIF( STRTOSET(@StudentHomeCampus, CONSTRAINED).Count = 1, STRTOSET(@StudentHomeCampus, CONSTRAINED), [Student].[Home Campus].currentmember ), IIF( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED).Count = 1, STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED), [Student Objective].[Objective Award Program].currentmember ), IIF( STRTOSET(@StudentStudentAthlete, CONSTRAINED).Count = 1, STRTOSET(@StudentStudentAthlete, CONSTRAINED), [Student].[Student Athlete].currentmember ), IIF( STRTOSET(@StudentVeteranStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentVeteranStudent, CONSTRAINED), [Student].[Veteran Student].currentmember ), IIF( STRTOSET(@StudentInternationalStudent, CONSTRAINED).Count = 1, STRTOSET(@StudentInternationalStudent, CONSTRAINED), [Student].[International Student].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSTermStateReportingTermYear[Term].[State Reporting Term Year].&[2012]
State Reporting Term Year
[Term].[State Reporting Term Year]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Year].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Year].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Year].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Year].ALLMEMBERS ON ROWS FROM [StudentSuccess]trueStudentHomeCampus[Student].[Home Campus].[All]
Home Campus
[Student].[Home Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Home Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Home Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Home Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Home Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartrueStudentObjectiveObjectiveAwardProgram[Student Objective].[Objective Award Program].[All]
Objective Award Program
[Student Objective].[Objective Award Program]WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))WITH MEMBER [Measures].[ParameterCaption] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student Objective].[Objective Award Program].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student Objective].[Objective Award Program].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYearStudentHomeCampustrueStudentInitialPrepStatus[Student].[Initial Prep Status].[All]
Initial Prep Status
[Student].[Initial Prep Status]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Initial Prep Status].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Initial Prep Status].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Initial Prep Status].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Initial Prep Status].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramtrueStudentStudentAthlete[Student].[Student Athlete].[All]
Student Athlete
[Student].[Student Athlete]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Student Athlete].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Student Athlete].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Student Athlete].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Student Athlete].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatustrueStudentVeteranStudent[Student].[Veteran Student].[All]
Veteran Student
[Student].[Veteran Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[Veteran Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[Veteran Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[Veteran Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[Veteran Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatusStudentStudentAthletetrueStudentInternationalStudent[Student].[International Student].[All]
International Student
[Student].[International Student]WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))WITH MEMBER [Measures].[ParameterCaption] AS [Student].[International Student].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Student].[International Student].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Student].[International Student].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Student].[International Student].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@StudentVeteranStudent, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentStudentAthlete, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentInitialPrepStatus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentObjectiveObjectiveAwardProgram, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@StudentHomeCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))TermStateReportingTermYearStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatusStudentStudentAthleteStudentVeteranStudenttrue<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Student].[Initial Prep Status].[Initial Prep Status]" />System.String<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Student Graduation Count]" />System.Int32String[Term].[State Reporting Term Year].&[2012]Term.State Reporting Term YearTermStateReportingTermYearParameterValueParameterCaptionIndentedString[Student].[Home Campus].[All]Home CampusStudentHomeCampusParameterValueParameterCaptionIndentedtrueString[Student Objective].[Objective Award Program].[All]Objective Award ProgramStudentObjectiveObjectiveAwardProgramParameterValueParameterCaptionIndentedtrueString[Student].[Initial Prep Status].[All]Initial Prep StatusStudentInitialPrepStatusParameterValueParameterCaptionIndentedString[Student].[Student Athlete].[All]Student AthleteStudentStudentAthleteParameterValueParameterCaptionIndentedString[Student].[Veteran Student].[All]Veteran StudentStudentVeteranStudentParameterValueParameterCaptionIndentedString[Student].[International Student].[All]International StudentStudentInternationalStudentParameterValueParameterCaptionIndentedInchbbb959a6-4477-436e-a18a-f7c97576d789