/
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: SQL Server Management Studio (SSMS) Visual Studio Code Additional supported applications refer to Connect to Synapse SQL - Azure Synapse Analytics Connect using SSMS:

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.