Enrollment
 DimDate_IsCurrentDate_Date (Report Data Set)
Home  Diagrams  Documents  Images  Enrollment  Reports  Data Sources 
Current Path:  Enrollment   TotalDailyEnrollment.rdl   Data Sets   DimDate_IsCurrentDate_Date
  Properties
Property Value
DataSetName DimDate_IsCurrentDate_Date
Data Source Reference
Collation
Case Sensitivity
Accent Sensitivity
Is MDX False
Query Command Type
Query Data Source Name RSDS_EnterpriseDW
Query Timeout
Use Generic Designer
Kanatype Sensitivity
Width Sensitivity
Integrated Security
  Query Command Text
SELECT CAST(DateSK AS varchar(8)) AS IsCurrentDay_DateSK
FROM         DimDate
WHERE     (IsCurrentDay = 'Y')
  Fields
Field Name Field Type Field Value
BackgroundColor
System.String
Band1Color
System.String
Band2Color
System.String
Band3Color
System.String
Band4Color
System.String
Band5Color
System.String
Band6Color
System.String
Credit_and_Clock_Hours_Combined
System.Int32
Credit_And_Clock_Hours_Combined___Current__1
System.Int32
Credit_And_Clock_Hours_Combined___Current__2
System.Int32
Headcount
System.Int32
Headcount___Current___1
System.Int32
Headcount___Current___2
System.Int32
HeaderBackgroundColor
System.String
IsCurrentDay_DateSK
System.String
Relative_Day
System.String
RelativeDaySort
System.Int32
Term_Type_Code
System.String
Term_Year
System.String
  Query Parameters
Parameter Name Parameter Value
Campus
=Parameters!Campus.Value
CoursePrefix
=Parameters!CoursePrefix.Value
CreditNonCreditVocationalTest
=Parameters!CreditNonCreditVocationalTest.Value
CreditType
=Parameters!CreditType.Value
CurSession
=Parameters!CurSession.Value
DeliveryMethod
=Parameters!DeliveryMethod.Value
DivDept
=Parameters!DivDept.Value
RelativeDayTermYearTypeRelativeDay
="[Relative Day].[TermYearTypeRelativeDay].[Relative Day].&["
+ Left(StrReverse(Mid(StrReverse(Parameters!DimTerm_Title_MemberUniqueName.Value),2,5)),4)
+ "]&["
+ Mid(StrReverse(Parameters!DimTerm_Title_MemberUniqueName.Value), 2, 1)
+ "]&[" + Parameters!IsCurrentDate_Date.Value + "]"
Powered by BI Documenter