0.59375in0.84375in0.59375in0.55208in2.04167in0.85417in0.82292in0.83333in0.73958in0.25intruetrueCountTextbox402pt2pt2pt2pttruetrueStudent IdTextbox22pt2pt2pt2pttruetrueAwardTextbox42pt2pt2pt2pttruetrueProgramTextbox62pt2pt2pt2pt2truetrueGraduation TermTextbox142pt2pt2pt2pttruetrueGraduation AgeTextbox182pt2pt2pt2pttruetrueAge RangeTextbox152pt2pt2pt2pttruetrueTerms To GraduateTextbox212pt2pt2pt2pt0.25intruetrue=RowNumber("dsGraduatesDetail")Textbox412pt2pt2pt2pttruetrue=Fields!Student_Id.ValueStudent_Id2pt2pt2pt2pttruetrue=Fields!Award_Type_Code.ValueAward_Type_Code2pt2pt2pt2pttruetrue=Fields!Program_Code.ValueProgram_Code2pt2pt2pt2pttruetrue=Fields!Program.ValueProgram2pt2pt2pt2pttruetrue=Fields!Actual_Graduation_Term.ValueActual_Graduation_Term2pt2pt2pt2pttruetrue=Fields!Graduation_Age.ValueGraduation_Age2pt2pt2pt2pttruetrue=Fields!Graduation_Age_Range.ValueGraduation_Age_Range2pt2pt2pt2pttruetrue=Fields!Num_Terms_To_Graduate.ValueNum_Terms_To_Graduate2pt2pt2pt2ptAftertruedsGraduatesDetail0.5in7.875in0.5in7.875in1in1in1in1in0RSDS_EnterpriseDW_SSASNone0ee13c5f-eaef-402e-8cff-cf6ce299f533RSDS_EnterpriseDW_SSAS=Parameters!TermStateReportingTermYear.Value=Parameters!TermStateReportingTermSequence.Value=Parameters!StudentHomeCampus.Value=Parameters!StudentObjectiveObjectiveAwardProgram.Value=Parameters!StudentInitialPrepStatus.Value=Parameters!StudentStudentAthlete.Value=Parameters!StudentVeteranStudent.Value=Parameters!StudentInternationalStudent.Value SELECT NON EMPTY { [Measures].[Num Terms To Graduate], [Measures].[Student Graduation Count] } ON COLUMNS, NON EMPTY { ([Student Objective].[Student Id].[Student Id].ALLMEMBERS * [Student Objective].[Award Type Code].[Award Type Code].ALLMEMBERS * [Student Objective].[Program Code].[Program Code].ALLMEMBERS * [Student Objective].[Program].[Program].ALLMEMBERS * [Student Objective].[Expected Graduation Term].[Expected Graduation Term].ALLMEMBERS * [Student Objective].[Expected Graduation Term Title].[Expected Graduation Term Title].ALLMEMBERS * [Student Objective].[Actual Graduation Term].[Actual Graduation Term].ALLMEMBERS * [Student Objective].[Actual Graduation Term Title].[Actual Graduation Term Title].ALLMEMBERS * [Student Objective].[Graduation Age].[Graduation Age].ALLMEMBERS * [Student Objective].[Graduation Age Range].[Graduation Age Range].ALLMEMBERS * [Student].[Home Campus].[Home Campus].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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED).Count = 1, STRTOSET(@TermStateReportingTermSequence, CONSTRAINED), [Term].[State Reporting Term Sequence].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[Term].[State Reporting Term Sequence][Term].[State Reporting Term Sequence].&[1]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].[Num Terms To Graduate], [Measures].[Student Graduation Count] } ON COLUMNS, NON EMPTY { ([Student Objective].[Student Id].[Student Id].ALLMEMBERS * [Student Objective].[Award Type Code].[Award Type Code].ALLMEMBERS * [Student Objective].[Program Code].[Program Code].ALLMEMBERS * [Student Objective].[Program].[Program].ALLMEMBERS * [Student Objective].[Expected Graduation Term].[Expected Graduation Term].ALLMEMBERS * [Student Objective].[Expected Graduation Term Title].[Expected Graduation Term Title].ALLMEMBERS * [Student Objective].[Actual Graduation Term].[Actual Graduation Term].ALLMEMBERS * [Student Objective].[Actual Graduation Term Title].[Actual Graduation Term Title].ALLMEMBERS * [Student Objective].[Graduation Age].[Graduation Age].ALLMEMBERS * [Student Objective].[Graduation Age Range].[Graduation Age Range].ALLMEMBERS * [Student].[Home Campus].[Home Campus].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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED).Count = 1, STRTOSET(@TermStateReportingTermSequence, CONSTRAINED), [Term].[State Reporting Term Sequence].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]trueTermStateReportingTermSequence[Term].[State Reporting Term Sequence].&[1]
State Reporting Term Sequence
[Term].[State Reporting Term Sequence]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartrueStudentHomeCampus[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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYearTermStateReportingTermSequencetrueStudentObjectiveObjectiveAwardProgram[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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))TermStateReportingTermYearTermStateReportingTermSequenceStudentHomeCampustrueStudentInitialPrepStatus[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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))TermStateReportingTermYearTermStateReportingTermSequenceStudentHomeCampusStudentObjectiveObjectiveAwardProgramtrueStudentStudentAthlete[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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))TermStateReportingTermYearTermStateReportingTermSequenceStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatustrueStudentVeteranStudent[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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))TermStateReportingTermYearTermStateReportingTermSequenceStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatusStudentStudentAthletetrueStudentInternationalStudent[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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))))TermStateReportingTermYearTermStateReportingTermSequenceStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatusStudentStudentAthleteStudentVeteranStudenttrue<?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].[Student Id].[Student Id]" />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 Objective].[Award Type Code].[Award Type Code]" />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 Objective].[Program Code].[Program Code]" />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 Objective].[Program].[Program]" />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 Objective].[Expected Graduation Term].[Expected Graduation Term]" />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 Objective].[Expected Graduation Term Title].[Expected Graduation Term Title]" />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 Objective].[Actual Graduation Term].[Actual Graduation Term]" />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 Objective].[Actual Graduation Term Title].[Actual Graduation Term Title]" />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 Objective].[Graduation Age].[Graduation Age]" />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 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="Level" UniqueName="[Student].[Home Campus].[Home Campus]" />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].[Num Terms To Graduate]" />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].[Student Graduation Count]" />System.Int32=Fields!Actual_Graduation_Term.ValueNotEqualNULLRSDS_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 [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])MDXQueryStudentSuccessWITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].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!TermStateReportingTermSequence.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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS 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(@TermStateReportingTermSequence, 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]trueTermStateReportingTermSequence[Term].[State Reporting Term Sequence].&[1]
State Reporting Term Sequence
[Term].[State Reporting Term Sequence]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].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!TermStateReportingTermSequence.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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, 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]trueTermStateReportingTermSequence[Term].[State Reporting Term Sequence].&[1]
State Reporting Term Sequence
[Term].[State Reporting Term Sequence]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartrueStudentHomeCampus[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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYearTermStateReportingTermSequencetruetruetrue<?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!TermStateReportingTermSequence.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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, 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]trueTermStateReportingTermSequence[Term].[State Reporting Term Sequence].&[1]
State Reporting Term Sequence
[Term].[State Reporting Term Sequence]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartrueStudentHomeCampus[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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYearTermStateReportingTermSequencetrueStudentObjectiveObjectiveAwardProgram[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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))TermStateReportingTermYearTermStateReportingTermSequenceStudentHomeCampustruetruetrue<?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!TermStateReportingTermSequence.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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, 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]trueTermStateReportingTermSequence[Term].[State Reporting Term Sequence].&[1]
State Reporting Term Sequence
[Term].[State Reporting Term Sequence]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartrueStudentHomeCampus[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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYearTermStateReportingTermSequencetrueStudentObjectiveObjectiveAwardProgram[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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))TermStateReportingTermYearTermStateReportingTermSequenceStudentHomeCampustrueStudentInitialPrepStatus[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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))TermStateReportingTermYearTermStateReportingTermSequenceStudentHomeCampusStudentObjectiveObjectiveAwardProgramtruetruetrue<?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!TermStateReportingTermSequence.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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, 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]trueTermStateReportingTermSequence[Term].[State Reporting Term Sequence].&[1]
State Reporting Term Sequence
[Term].[State Reporting Term Sequence]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartrueStudentHomeCampus[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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYearTermStateReportingTermSequencetrueStudentObjectiveObjectiveAwardProgram[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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))TermStateReportingTermYearTermStateReportingTermSequenceStudentHomeCampustrueStudentInitialPrepStatus[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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))TermStateReportingTermYearTermStateReportingTermSequenceStudentHomeCampusStudentObjectiveObjectiveAwardProgramtrueStudentStudentAthlete[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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))TermStateReportingTermYearTermStateReportingTermSequenceStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatustruetruetrue<?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!TermStateReportingTermSequence.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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, 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]trueTermStateReportingTermSequence[Term].[State Reporting Term Sequence].&[1]
State Reporting Term Sequence
[Term].[State Reporting Term Sequence]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])WITH MEMBER [Measures].[ParameterCaption] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[State Reporting Term Sequence].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[State Reporting Term Sequence].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])TermStateReportingTermYeartrueStudentHomeCampus[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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))TermStateReportingTermYearTermStateReportingTermSequencetrueStudentObjectiveObjectiveAwardProgram[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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))TermStateReportingTermYearTermStateReportingTermSequenceStudentHomeCampustrueStudentInitialPrepStatus[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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))TermStateReportingTermYearTermStateReportingTermSequenceStudentHomeCampusStudentObjectiveObjectiveAwardProgramtrueStudentStudentAthlete[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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess])))))TermStateReportingTermYearTermStateReportingTermSequenceStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatustrueStudentVeteranStudent[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(@TermStateReportingTermSequence, 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(@TermStateReportingTermSequence, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermStateReportingTermYear, CONSTRAINED) ) ON COLUMNS FROM [StudentSuccess]))))))TermStateReportingTermYearTermStateReportingTermSequenceStudentHomeCampusStudentObjectiveObjectiveAwardProgramStudentInitialPrepStatusStudentStudentAthletetruetruetrue<?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.StringString[Term].[State Reporting Term Year].&[2012]Term.State Reporting Term YearTermStateReportingTermYearParameterValueParameterCaptionIndentedString[Term].[State Reporting Term Sequence].&[1]Term.State Reporting Term SequenceTermStateReportingTermSequenceParameterValueParameterCaptionIndentedString[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 StudentStudentInternationalStudentParameterValueParameterCaptionIndentedInchc6a11bdc-b04a-4a06-99b2-4f6dd4fe7326