/
Financial Warehouse - Access Request

Financial Warehouse - Access Request

Purpose: If you need direct access to the Financial Warehouse and associated depreciated DWHOUSE GOFAST tables.

Application or Personal Access

Access to the Financial Warehouse will be through SQL Authentication where a user is added to the appropriate active directory security group.

For requesting this type of access, submit a ticket to it-analytics@usf.edu with the following information included:

  • Data Product: Financial Warehouse

  • Reason for Access: Provide a reason for user gaining access

  • Account Name: Your USF Forest account - example johndoe@usf.edu

How to Connect

Once access has been granted by the data owners, connect to the servers listed below:

  • Server

    • Test (UAT): 333rw5hf4lpundlhqjqh36o6vi-i4rfopccvohehpi6dxhqrd72eu.datawarehouse.fabric.microsoft.com

    • Prod: 333rw5hf4lpundlhqjqh36o6vi-hvv6g655nfme7mlwfzsuvjgila.datawarehouse.fabric.microsoft.com

  • Database: FinancialReporting

 

Recommended application(s) to connect:

Connect using SSMS:

image-20251024-102537.png

 

Financial Reporting Objects

Reporting Views

The following views represent the dimensions and facts available in the warehouse.

Warehouse Object

Description

DWHOUSE Equivalent Mapping

Warehouse Object

Description

DWHOUSE Equivalent Mapping

[dim].[vwFastAccount]

This dimension holds the accounts table information. Only USFSI records are loaded in this table (i.e. WHERE SETID = USFSI).

GOFAST_GL_ACCOUNT_TBL

[dim].[vwFastFund]

This dimension holds the fund source table information. Only USFSI records are loaded in this table (i.e. WHERE SETID = USFSI).

GOFAST_FUND_TBL

[dim].[vwFastInitiative]

This dimension holds the Initiative table information. Only USFSI records are loaded in this table (i.e. WHERE SETID = USFSI).

GOFAST_CHARTFIELD1_TBL

[dim].[vwFastOperatingUnit]

This dimension holds the operating unit table information. Only USFSI records are loaded in this table (i.e. WHERE SETID = USFSI).

GOFAST_OPER_UNIT_TB

[dim].[vwFastProduct]

This dimension holds the product table information. Only USFSI records are loaded in this table (i.e. WHERE SETID = USFSI).

GOFAST_PRODUCT_TBL

[dim].[vwFastProject]

This dimension holds the project information. 

GOFAST_PROJECT

[dim].[vwFastDepartment]

This dimension holds the department table information. Only USFSI records are loaded in this table (i.e. WHERE SETID = USFSI).

GOFAST_DEPT_TBL

[fact].[vwBalanceSheet]

Presents a snapshot of financial position,

GOFAST_DL_BS

[fact].[vwRevenueExpense]

Lists individual revenue/expense transactions.

GOFAST_DL_REVEXP

[fact].[vwRevenueExpense]

This fact holds the actual transaction details information from FAST source system.

GOFAST_PEND_ACT

[fact].[vwRevenueExpense]

This fact holds the actual transaction details information from FAST source system.

GOFAST_DL_REVEXP_PEND_ACT_V

[fact].[vwPayroll]

Displays payroll transactions by employee.

GOFAST_LEDGER

Other Financial Reporting Tables

[fact].[vwBudget]

Displays remaining spending authority. RSA Formulas: RSA = Budget – Requisition – Encumbrance – Pending Actual – Actual % of RSA = RSA / Budget Amt * 100

 

[fact].[vwEncumbrance]

Summarizes outstanding financial commitments.

 

 

 

 

[dim].[vwFastSource]

This dimension holds the source data table information. Only USFSI records are loaded in this table (i.e. WHERE SETID = USFSI).

 

[dim].[vwActivity]

This dimension holds the activity table information. Only USFSI records are loaded in this table (i.e. WHERE SETID = USFSI).

 

[dim].[vwTableRefresh]

This dimension contains the date of the last refresh of each of the other tables.