CRIS Funding Trend - ARS Sponsored - by Portfolio

Trend of reported expenditures for projects sponsored by the Agricultural Research Service (ARS), reported by Portfolio for the 5 latest available fiscal years.

Data derived from the Current Research information System (CRIS).

Keywords: CRIS, ARS, Funding, Portfolios
    Sponsoring Agency
    includes only
    >
    WITH MEMBER [Measures].[*FORMATTED_MEASURE_0] AS '[Measures].[Reported Expenditure Dollars Sum]', format_string = '$#,###;$-#,###;$0;$0', SOLVE_ORDER=400 SET [*BASE_MEMBERS_Time] AS { [Time].[2017], [Time].[2018], [Time].[2019], [Time].[2020], [Time].[2021] } SET [*BASE_MEMBERS_Sponsoring Agency] AS { [Sponsoring Agency].[Sponsoring Agency].[ARS] } SET [*BASE_MEMBERS_Backend Portfolio] AS { { [Backend Portfolio].[Backend Portfolio].Members }, { [Backend Portfolio].[Knowledge Area].Members } } SET [*NATIVE_MEMBERS_Time] AS 'Generate([*NATIVE_CJ_SET], [Time].CurrentMember)' SET [*NATIVE_MEMBERS_Sponsoring Agency] AS 'Generate([*NATIVE_CJ_SET], [Sponsoring Agency].CurrentMember)' MEMBER [Sponsoring Agency].[*SLICER_MEMBER] AS 'Aggregate({ [Sponsoring Agency].[Sponsoring Agency].[ARS] })', SOLVE_ORDER=-400 SET [*NATIVE_CJ_SET] AS 'Crossjoin([*BASE_MEMBERS_Time], Crossjoin([*BASE_MEMBERS_Sponsoring Agency], [*BASE_MEMBERS_Backend Portfolio]))' SET [*SORTED_ROW_AXIS] AS 'UNION(Hierarchize(Order([*CJ_ROW_AXIS], [Backend Portfolio].CurrentMember.OrderKey, BASC)), [TOTAL])' SET [*SORTED_COLUMN_AXIS] AS 'Order([*CJ_COLUMN_AXIS], [Time].CurrentMember.OrderKey, BASC)' SET [*CJ_ROW_AXIS] AS 'Generate([*NATIVE_CJ_SET], [Backend Portfolio].CurrentMember)' SET [*CJ_COLUMN_AXIS] AS 'Generate(Descendants([*NATIVE_MEMBERS_Time], [Time].[Time]), { Ancestor([Time].CurrentMember, [Time].[Time]) })' SET [TOTAL] AS '{[Backend Portfolio].[Total]}' SELECT [*SORTED_COLUMN_AXIS] ON columns, [*SORTED_ROW_AXIS] ON rows FROM [Projects] WHERE ([Measures].[*FORMATTED_MEASURE_0], [Sponsoring Agency].[*SLICER_MEMBER])
    Reported Expenditure Dollars - Sum
    Mdx 
    Portfolios / Knowledge Areas 2017 2018 2019 2020 2021 Trend graph
    Total $1,136,621,521 $1,146,725,437 $1,220,578,128 $0 $1,375,507,073
    Visualize information as
    20172018201920202021$0$100,000,000$200,000,000$300,000,000$400,000,000$500,000,000$600,000,000$700,000,000$800,000,000$900,000,000Portfolios0: (Portfolio Not Assigned)1: Bioenergy2: Climate Change3: Education and Multicultural Systems4: Environmental Systems5: Family and Consumer Sciences6: Food Safety7: Human Nutrition8: International Programs9: Sustainable Agricultural Systems10: Youth Development11: Supports All Portfolios