=Sum(Fields!CreditHours_1_3.Value, "dsCreditLoad")true="Number of Students: "
& Sum(Fields!CreditHours_1_3.Value, "dsCreditLoad")Output1-3 HrsShapeExplodedPiePrimaryPrimaryBlack0pt=Sum(Fields!CreditHours_4_6.Value, "dsCreditLoad")true="Number of Students: "
& Sum(Fields!CreditHours_4_6.Value, "dsCreditLoad")Output4-6 HrsShapeExplodedPiePrimaryPrimaryBlack0pt=Sum(Fields!CreditHours_7_9.Value, "dsCreditLoad")true="Number of Students: "
& Sum(Fields!CreditHours_7_9.Value, "dsCreditLoad")Output7-9 HrsShapeExplodedPiePrimaryPrimaryBlack0pt=Sum(Fields!CreditHours_10_12.Value, "dsCreditLoad")true="Number of Students: "
& Sum(Fields!CreditHours_10_12.Value, "dsCreditLoad")Output10-12 HrsShapeExplodedPiePrimaryPrimaryBlack0pt=Sum(Fields!CreditHours_13_15.Value, "dsCreditLoad")true="Number of Students: "
& Sum(Fields!CreditHours_13_15.Value, "dsCreditLoad")Output13-15 HrsShapeExplodedPiePrimaryPrimaryBlack0pt=Sum(Fields!HigherThan15.Value, "dsCreditLoad")true="Number of Students: "
& Sum(Fields!HigherThan15.Value, "dsCreditLoad")Output16+ HrsShapeExplodedPiePrimaryPrimaryBlack0pt
Axis Title
False0.5NaNNaNNaN
Axis Title
False0.5NaNOppositeNaNNaN
Axis Title
0.5NaNNaNNaN
Axis Title
0.5NaNOppositeNaNNaNtrue
BlackBlack
Student Enrollment Credit Hours
BrightPastel
No Data Available
dsCreditLoad3.33333in5.52083inWhiteNone3.33333in5.52083in1in1in1in1in0RSDS_EnterpriseDW_SSASNonee1c70983-bd7e-44cd-a67e-ce78aec5d062RSDS_EnterpriseDW_SSAS=Parameters!CurriculumCampus.Value=Parameters!TermTermTitle.Value SELECT NON EMPTY { [Measures].[Credit Hours] } ON COLUMNS, NON EMPTY { ([Student Term].[Student Id].[Student Id].ALLMEMBERS * [Student Term].[Term].[Term].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])) WHERE ( IIF( STRTOSET(@TermTermTitle, CONSTRAINED).Count = 1, STRTOSET(@TermTermTitle, CONSTRAINED), [Term].[Term Title].currentmember ), IIF( STRTOSET(@CurriculumCampus, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCampus, CONSTRAINED), [Curriculum].[Campus].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSMDXExecutive_Dashboard[Term].[Term Title][Term].[Term Title].&[20121]true[Curriculum].[Campus][Curriculum].[Campus].[All]true SELECT NON EMPTY { [Measures].[Credit Hours] } ON COLUMNS, NON EMPTY { ([Student Term].[Student Id].[Student Id].ALLMEMBERS * [Student Term].[Term].[Term].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@CurriculumCampus, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])) WHERE ( IIF( STRTOSET(@TermTermTitle, CONSTRAINED).Count = 1, STRTOSET(@TermTermTitle, CONSTRAINED), [Term].[Term Title].currentmember ), IIF( STRTOSET(@CurriculumCampus, CONSTRAINED).Count = 1, STRTOSET(@CurriculumCampus, CONSTRAINED), [Curriculum].[Campus].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSTermTermTitle[Term].[Term Title].&[20121]
Term.Term Title
[Term].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM [Executive_Dashboard]trueCurriculumCampus[Curriculum].[Campus].[All]
Campus
[Curriculum].[Campus]WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])WITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])TermTermTitletrue<?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 Term].[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 Term].[Term].[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="Measure" UniqueName="[Measures].[Credit Hours]" />System.Int32=iif(Fields!Credit_Hours.Value > 0 and
Fields!Credit_Hours.Value <= 3,1,0)=iif(Fields!Credit_Hours.Value > 3 and
Fields!Credit_Hours.Value <= 6,1,0)=iif(Fields!Credit_Hours.Value > 6 and
Fields!Credit_Hours.Value <= 9,1,0)=iif(Fields!Credit_Hours.Value > 9 and
Fields!Credit_Hours.Value <=12 ,1,0)=iif(Fields!Credit_Hours.Value > 12 and
Fields!Credit_Hours.Value <= 15,1,0)=iif(Fields!Credit_Hours.Value > 15,1,0)RSDS_EnterpriseDW_SSAS=Parameters!TermTermTitle.ValueWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])MDXQueryExecutive_DashboardWITH MEMBER [Measures].[ParameterCaption] AS [Curriculum].[Campus].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Curriculum].[Campus].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Curriculum].[Campus].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Curriculum].[Campus].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@TermTermTitle, CONSTRAINED) ) ON COLUMNS FROM [Executive_Dashboard])TermTermTitle[Term].[Term Title].&[20121]
Term.Term Title
[Term].[Term Title]WITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM [Executive_Dashboard]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_SSASWITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM [Executive_Dashboard]MDXQueryExecutive_DashboardWITH MEMBER [Measures].[ParameterCaption] AS [Term].[Term Title].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Term].[Term Title].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Term].[Term Title].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Term].[Term Title].ALLMEMBERS ON ROWS FROM [Executive_Dashboard]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.StringString[Term].[Term Title].&[20121]trueTerm.Term TitleTermTermTitleParameterValueParameterCaptionIndentedString[Curriculum].[Campus].[All]trueCampusCurriculumCampusParameterValueParameterCaptionIndentedtrueInchdfa73e13-37c7-4519-80e1-1dfec54b7183