Integrated Financials
 TermTermTitle (Report Data Set)
  Properties
Property Value
DataSetName TermTermTitle
Data Source Reference
Collation
Case Sensitivity
Accent Sensitivity
Is MDX True
Query Command Type MDX
Query Data Source Name RSDS_EnterpriseDW_SSAS
Query Timeout
Use Generic Designer
Kanatype Sensitivity
Width Sensitivity
Integrated Security
  Query Command Text
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 [Student_Financials]
  Fields
Field Name Field Type Field Value
BackgroundAlternateColor
System.String
BackgroundColor
System.String
Band1Color
System.String
Band2Color
System.String
Band3Color
System.String
Band4Color
System.String
Band5Color
System.String
Band6Color
System.String
CurrentPercentage
=IIF(IsNothing(Fields!Fact_Student_Total_Fees_Count.Value),0,
(Fields!Fact_Student_Total_Fees_Count.Value / Fields!EOT_Headcount.Value))
EOT_Headcount
System.Int32
Fact_Student_Total_Fees_Count
System.Int32
ParameterCaption
System.Int32
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterLevel
System.Int32
ParameterValue
System.Int32
Payment_Category_Code
System.String
Payment_Category_Label
System.String
Payment_Source_Code
System.String
Payment_Source_Label
System.String
Prior_2Year_HeadCount
System.Int32
Prior_2Year_Term_Student_Total_Fee_Count
System.Int32
Prior_Year_HeadCount
System.Int32
Prior_Year_Term_Student_Total_Fee_Count
System.Int32
Prior2Percentage
=IIF(IsNothing(Fields!Prior_2Year_Term_Student_Total_Fee_Count.Value),0,
(Fields!Prior_2Year_Term_Student_Total_Fee_Count.Value / Fields!Prior_2Year_HeadCount.Value))
PriorPercentage
=IIF(IsNothing(Fields!Prior_Year_Term_Student_Total_Fee_Count.Value),0,
(Fields!Prior_Year_Term_Student_Total_Fee_Count.Value / Fields!Prior_Year_HeadCount.Value))
Term_SK
System.String
Term_Title
System.String
  Query Parameters
Parameter Name Parameter Value
TermTermTitle
=Parameters!TermTermTitle.Value
Powered by BI Documenter