Integrated Financials
 FiscalYearDateFiscalYear (Report Data Set)
Home  Diagrams  Documents  Images  Integrated Financials  Reports  Data Sources 
Current Path:  Integrated Financials   TopVendors.rdl   Data Sets   FiscalYearDateFiscalYear
  Properties
Property Value
DataSetName FiscalYearDateFiscalYear
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 
    [Fiscal Year Date].[Fiscal Year].CurrentMember.Member_Caption 
  MEMBER [Measures].[ParameterValue] AS 
    [Fiscal Year Date].[Fiscal Year].CurrentMember.UniqueName 
  MEMBER [Measures].[ParameterLevel] AS 
    [Fiscal Year Date].[Fiscal Year].CurrentMember.Level.Ordinal 
SELECT 
  {
    [Measures].[ParameterCaption]
   ,[Measures].[ParameterValue]
   ,[Measures].[ParameterLevel]
  } ON COLUMNS,
  ORDER(
 {[Fiscal Year Date].[Fiscal Year].Children},[Measures].[ParameterCaption], DESC
 ) ON ROWS
FROM 
(
  SELECT 
      {
   ([Fiscal Year Date].[Fiscal Year].[Fiscal Year].Members
   ,[Fiscal Year Date].[Is Current Fiscal Year].&[Y]
   ,[Fiscal Year Date].[Is Available For Finance].&[Y])
  ,
   ([Fiscal Year Date].[Fiscal Year].[Fiscal Year].Members
   ,[Fiscal Year Date].[Is Current Fiscal Year].Children
   ,[Fiscal Year Date].[Is Available For Finance].&[Y]
   )
  }  ON COLUMNS
  
FROM [PayablesPurchaseOrder]
)
  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
Buyer
System.String
County
System.String
Date_Name
System.String
Encumbered_Balance
System.Int32
Fact_Purchase_Order_Amounts_Count
System.Int32
Fiscal_Year
System.String
Fiscal_Year
System.String
ImageLocation
System.String
ImageType
System.String
Is_Minority
System.String
Number_Of_Change_Orders
System.Int32
Number_Of_Items
System.Int32
Paid_Amount
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaption
System.Int32
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterCaptionIndented
System.String
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterLevel
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
ParameterValue
System.Int32
Payee_Id
System.String
Payee_Name
System.String
Payee_Sequence
System.String
Po_Status
System.String
Po_Type
System.String
Purchase_Order_Amount
System.Int32
Purchase_Order_Key
System.String
State
System.String
SuggestedImageSize
System.String
  Query Parameters
Parameter Name Parameter Value
FiscalYearDateFiscalYear
=Parameters!FiscalYearDateFiscalYear.Value
PayeeIsMinority
=Parameters!PayeeIsMinority.Value
ZipCountyCounty
=Parameters!ZipCountyCounty.Value
ZipCountyState
=Parameters!ZipCountyState.Value
ZipCountyState
=Parameters!ZipCountyState.Value
Powered by BI Documenter