240 likes | 435 Views
Finance Data Ed: FixedAsset DUG-2005. 2. . . Understanding Fixed Asset data. Finance Data Ed: FixedAsset DUG-2005. 3. Fixed Asset Data
E N D
1. Fixed Assets Detailed Universe Guide December 2005
2. Finance Data Ed: FixedAsset DUG-2005 2 Understanding Fixed Asset data
3. Finance Data Ed: FixedAsset DUG-2005 3 Fixed Asset Data – General information Banner Finance data began in July 2003
There is not a guaranteed one-to-one relationship between former UFAS accounts and Banner CFOAPAL’s.
Remember that the Banner Fixed Asset module works in partnership with PCard purchase data, FabWeb (the property accounting system) and other feeding systems.
4. Finance Data Ed: FixedAsset DUG-2005 4 Fixed Assets Concepts [Review Slide][Review Slide]
5. Finance Data Ed: FixedAsset DUG-2005 5 Fixed Assets Concepts [Review Slide][Review Slide]
6. Finance Data Ed: FixedAsset DUG-2005 6 Fixed Assets Concepts [Review Slide][Review Slide]
7. Finance Data Ed: FixedAsset DUG-2005 7 EDW – Finance Fixed Assets [Review the slide]
Questions?
[Review the slide]
Questions?
8. Finance Data Ed: FixedAsset DUG-2005 8 Business Objects Sample Reports:
9. Finance Data Ed: FixedAsset DUG-2005 9 Finance Fixed Assets - Description
This Universe contains:
Fixed Assets by Otag & Ptag
Primary & Component relationships
Fixed Asset attributes
Fixed Asset funding sources
Fixed Asset depreciation [Review Slide][Review Slide]
10. Finance Data Ed: FixedAsset DUG-2005 10 Finance Fixed Assets – Intended Uses Intended use(s) of this Universe:
Listings of Fixed Assets and related details
Analysis of Fixed Asset funding sources
Depreciation by Asset by Fiscal Year
[Review Slide][Review Slide]
11. Finance Data Ed: FixedAsset DUG-2005 11 Tips for Combining Objects in the Universe [Review the slide]
Now do the fiscal periods and “buckets” make sense? Questions?
Would you like me to show you these ideas with a Business Objects report?[Review the slide]
Now do the fiscal periods and “buckets” make sense? Questions?
Would you like me to show you these ideas with a Business Objects report?
12. Finance Data Ed: FixedAsset DUG-2005 12 Tips for Understanding Objects in the Universe [Review the slide]
Now do the fiscal periods and “buckets” make sense? Questions?
Would you like me to show you these ideas with a Business Objects report?[Review the slide]
Now do the fiscal periods and “buckets” make sense? Questions?
Would you like me to show you these ideas with a Business Objects report?
13. Finance Data Ed: FixedAsset DUG-2005 13 EDW - Finance Fixed Assets Universe Example Query: Business Question: I would like a listing of Fixed Assets in my unit
14. Finance Data Ed: FixedAsset DUG-2005 14 Finance Fixed Asset Universe Example:
15. Finance Data Ed: FixedAsset DUG-2005 15 Finance Fixed Asset Universe Example:
16. Finance Data Ed: FixedAsset DUG-2005 16 Finance Fixed Assets Universe Sample Objects
17. Finance Data Ed: FixedAsset DUG-2005 17 EDW Finance Fixed Asset Universe:
18. Finance Data Ed: FixedAsset DUG-2005 18 EDW Finance Fixed Asset Universe:
19. Finance Data Ed: FixedAsset DUG-2005 19
20. Finance Data Ed: FixedAsset DUG-2005 20 What is QCH? DS Query Clearinghouse
A place to share report templates
Any EDW user can post Business Objects files for others to use as a starting point
Share and work together!
Query Clearinghouse link: https://www.ds.uillinois.edu/Reports/Authentication/Login.aspx?ReturnUrl=%2freports%2fQCH%2fQCHBrowser.aspx
21. Finance Data Ed: FixedAsset DUG-2005 21 Query Clearinghouse
23. Finance Data Ed: FixedAsset DUG-2005 23 Resources for Data Warehouse Users DS Monthly Practice Labs
Monthly, on each physical campus
FAC from Student, Finance, and HR present to answer questions and provide hands on assistance in creation of custom reports
View Practice Lab dates: http://www.ds.uillinois.edu/events.asp
24. Finance Data Ed: FixedAsset DUG-2005 24 Resources for Data Warehouse Users
25. Finance Data Ed: FixedAsset DUG-2005 25 How to Contact DS By filing an on-line Help Desk case http://onlinesupport.uillinois.edu/ds.html. To complete the form:
Authenticate via Bluestem
Click "Start Here" on the left-hand margin
Select "New Case"
Be sure "Decision Support" is listed on Help Desk line (first line of New Case entry form). If it does not, click "Change Help Desk" and select Decision Support from the list of options.
Enter your contact information and the nature of your problem
Click "Create Case" to submit the case to Decision Support for response
Create a Help Desk Ticket
Phone the AITS Help Desk:
Chicago: (312) 996-4806
Urbana: (217) 333-3102
Springfield: (217) 333-3102
Email the AITS Help Desk:
helpdesk2@uillinois.edu (one address for all 3 campuses to use)
If you have access to Clarify,
Send a Clarify Ticket directly to the ‘Decision Support’ Queue—we’ll take it from there; the appropriate person will respond.