Review bucket assignments and run bucketing

  • Release version: Xanadu
  • Updated August 1, 2024
  • 1 minute to read

    • After the data is in buckets, you can see the total amounts for each bucket and the individual general ledger expense records for each bucket.

    Before you begin

    Role required: cost_transparency_admin or cost_transparency_analyst

    Procedure

    1. Click the information icon (The information icon) on any bucket to display summary information about the bucket.
    2. Under Advanced Conditions, verify that the bucket filter condition is correct.
      1. Click the condition name to open the bucket filter condition form and make changes if necessary.
      2. Under Detailed Rows, click Show Details to show the expense records, which are saved in the General Ledger Cleansed Data [itfm_gl_data_cleansed] table, that are assigned to the bucket.
      3. To remove a bucket filter condition, click the delete icon (The delete icon).
    3. Under Accounts Assigned, verify that the correct accounts and all the expenses in them appear in the bucket.
      1. Click the account name to show the expense records from the General Ledger Cleansed Data table that are assigned to the bucket.
      2. To remove an account and all expenses that belong to the account from the bucket, click the delete icon (The delete icon).
    4. Under Fields to Keep, select the check boxes for fields you want to keep on the records in the bucket.
      Figure 1. Bucket summary
      Bucket summary
    5. Close the window when you are finished.
    6. When the data is correct, click Run Bucketing on the right pane.
      • When you run the bucketing engine, the data is saved in the Groomed General Ledger Data [itfm_gl_data_groomed] table.
      • The application deletes all existing allocation lines for the fiscal period you are working with when you click Run Bucketing.