Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

  
  UPDATES
Current Load Status
Regular Availability
  
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
  
  DATA COLLECTIONS
Advancement
Assets
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Student
Travel Expense Management
Tuition Distribution
Cross-Collection

FINQUERY Template Universe Repository Reports

Previous Comparison

This report uses a simple crosstab, along with the Business Objects Previous function and categories from RCM_OBJECT_TREE to present a crosstab of RCM categories compared to previous periods.

The three tabs of the report show the progression from raw data, to a simple crosstab (columns sorted by fiscal year and fiscal month, rows by RCM summary and category sequences), to the final crosstab including a column with variable comparing the data to the previous period.

Note that the Previous function allows for comparison to the previous row (in a standard table format), or the previous column (in a crosstab format). So, the comparison could be between anything that occurs in consecutive rows or columns - this query just uses it to compare accounting periods year to year.

Query 1 with FINQUERY Template Universe (FINQRCM)

  • Result Objects:

    BALANCES: Fiscal Year, Fiscal Month Seq, Accounting Period, Actual_Fytd

    RCM_OBJECT_TREE: RCM Category, RCM Category Description, RCM Summary, RCM Summary Description

  • Conditions:

    BALANCES:

    
            Fiscal Month Seq = prompt : ('Enter month seq (ie, 01 for JUL):')
    Ficsal Year = prompt : ('Fiscal Year greater than or equal to:')
    COA CNAC = prompt : ('Enter CNAC:')
    COA Fund = prompt : ('Enter Fund:')
    RCM Summary < 1610

Report Variables

  • previous Actual FYTD=Previous(<SUM Actual Fytd (BAL)>)
  • Change vs Prior Year ==<SUM Actual Fytd (BAL)>-<previous Actual FYTD>

To import this file for your own use:

  1. Log on to Business Objects.
  2. From the File menu, click "Retrieve From", and then "Corporate Documents".
  3. Click on the name of the file you'd like to retrieve, and then click the Retrieve button (or, right-click and select Retrieve into to save the file in another location than the default UserDocs directory).
  4. You may choose whether to open the document upon retrieval.
top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania