Appendices

Appendix A: General Troubleshooting

Issues

Numbers are not getting pushed to Hubble from the model or you are receiving validation errors

• Remember the Apply Model rules and Precedence. Manually entered amounts will not be updated by the results of an Apply Model. Hold Ctrl + Shift when clicking Enter Budget, to view the source of each cell.
• If using pivot tables in Excel, check that the lookups are using the correct values. For example, if it’s a hardcoded model, verify that the correct business unit/object account is used to look up the value depending on the level of detail the pivot table is on.
• When using wildcards, set the wildcarded columns format as Text; otherwise, your model and lookups may not work because some of the wildcarded columns will be re-formatted as numbers. For example, Company 000001 would be formatted as 1.0 in Excel during the replacement of the wildcard.
• If there are complex formulas, try inputting a simple number and see if that is properly uploaded to Hubble. If it is, verify the formulas are correct.

Your budget form is approved at all levels but does not appear in the Upload dialog.

• The budget data for an account/ledger combination in the approved form has been superseded by more recent data for the same account/ledger combination entered either on a different form or by a different user.
• Solution: In Cycle Status, highlight the contributor/form combination that has the issue and using Status Override, reset the status back to Not Submitted. Open the Form and go into Enter Budget Mode. Click Enter Budget and then Finish. Finalize and then approve the form. Upload form.
• To prevent this situation from occurring:
  1. Create a separate Upload Form using the Hubble Ledger to be uploaded and capable of accessing all accounts and periods to be uploaded.
  2. Create a separate Upload Cycle with Controllers, Approvers and Contributors limited to those responsible for the final upload process. The only form attached to this cycle is the above Upload Form and the only Hubble Ledger is the one to be uploaded.
  3. Perform the upload: Close all input cycles. Open the Upload cycle. Open the Upload form and go through the Enter Budget and Finish process. Open Cycle Status for the Upload Cycle and approve the contributor/form combination. Click Upload, preview and save if necessary, click OK and note the upload file name.

Appendix B: GL Budgeting Examples

Example 1: Zero-Based Input Form

This example will demonstrate the ability to create an Input Form popular when deploying a zero-based budgeting methodology. Zero-based budgeting (ZBB) is a method of budgeting in which all expenses must be justified for each new period. As such, this Input Form will not reference prior actuals or budgets, allowing Contributors to focus only on the Budgeting year and Hubble Ledger.

Prerequisite Steps

• A Cycle has been setup underneath an Activity where you are a Contributor.
• A Hubble Ledger has been created and associated to that Cycle.
• The Missing Balances capability has been enabled.

Steps to Create

1. Open a GL Balances Template: File > New > GL General Ledger > GL Balances.
2. Save as “Zero-Based Input Form” in the desired folder.

3. Filter for the following:
   1. Period: 1,2,3,4,5,6,7,8,9,10,11,12,CE12
   2. Fiscal Year: [Your Budget Year]
   3. Ledger Types: [Your Hubble Ledger]
4. Filter the accounts of the inquiry as desired.
5. If the selected Hubble Ledger does not contain any amounts, the report will return zero rows. To show all accounts regardless of previous activity, enable Zero Balances and Missing Balances
   1. Check the Zero Balances and Missing Balances options from the Design Menu.

      

6. Press Save, to save your Progress.
7. Assign the Input Form to the appropriate Cycle.
   1. Budgeting Menu > Activities > Select the Cycle > Close Cycle > Edit Cycle.
   2. Select the Forms tab > Add New > Browse to and Select Annual Budget Input Form > Click Open.
8. Check the box next to Annual Budget Input Form > Click OK > Open the Cycle.
9. Test Enter Budget Mode:
   1. Open the Zero-Based Input Form, click Enter Budget from the Budgeting menu.
   2. Populate some budget amounts.

      

   3. Click Finish.

9. The Zero-Based Input Form is now complete. Remember to save your progress.

Example 2: Input Form – Annual Budget with Prior Year Comparison

This example will demonstrate the ability to create an Annual Budget Input Form from the GL Balances Template. The Input Form will utilize a single Time Series to bring in the Cumulative of Prior Year Actuals alongside 12 Months of the Budgeting Year. A Hubble Calculation will also be created to compare the Prior Year Actuals to the Total of the Budgeting Year.

Prerequisite Steps

• A Cycle has been setup underneath an Activity where you are a Contributor.
• A Hubble Ledger has been created and associated to that Cycle.

Steps to Create

1. Open a GL Balances Template: File > New > GL General Ledger > GL Balances.
2. Save as “Annual Budget Input Form” in the desired folder.
3. Filter the accounts of the inquiry as desired.
4. Create an Annual Budget Time Series:
   1. Select Time Series from the Inquiry Objects Menu.

      

   2. Select New from the Time Series dialog.

      

   3. The Time Series wizard is now shown. Click Next.

      

   4. Name the Series “12 Month Budget.” Click Next.

      

   5. Select the following dimensions and list in this order: Period, Ledger Types, and Fiscal Year. Click Next.

      

   6. Select the following periods and list in this order: 1,2,3,4,5,6,7,8,9,10,11,12, CE12. Click Next.
   7. Select the following ledger types, and list in this order: [Your Hubble Ledger], AA.
   8. Select the Fiscal Years to be included in the Time Series, listing them chronologically. Be sure to include the year of prior year actuals, and year of the budget Input. Click Next.
   9. Define the following Common Calculation:
      1. Current Item – to generate the time series marker column (first period of budget year)
      2. Next Item (12 Steps) – to generate columns for the next 11 periods and CE12.
      3. Previous Item (1 Step) – to generate a column for CE12 of the prior year.
   10. Once complete, click Next, and then Finish to complete the Time Series wizard.
5. Add the Time Series to the Filter Layout:
   1. Select Filter Layout on the Configurator Menu.
   2. 
   3. From the Available Filters & Controls, expand the Time Series section and Select “12 Month Budget” and drag it to an empty space in the workspace area.
   4. When finished, click OK.
6. Adjust the 12 Month Budget Time Series dropdowns on the filter layout to the first period of the budget year.
7. Utilize the query assist to remove previous selections from the Period, Year, and Ledger Types filter boxes.
   1. Once completed, these should all denote “Series Only” and there will only be 14 amount columns, all generated from the Time Series.
8. Press Save to save your Progress.
9. Assign the Input Form to the appropriate Cycle.
   1. Budgeting Menu > Activities > Select the Cycle > Close Cycle > Edit Cycle.
   2. Select the Forms tab > Add New > Browse to and Select Annual Budget Input Form > Click Open.
   3. Check the box next to Annual Budget Input Form > Click OK > Open the Cycle.
10. Test Enter Budget Mode.
    1. Open the Annual Budget Input Form, click Enter Budget from the Budgeting menu.
    2. Populate some budget amounts.
    3. Click Finish.
11. Create a Budget vs Prior Year Calculation.
    1. Click Calculations on the Inquiry Object Menu.Click New.
       1. Name: BUDGETVSPY.
       2. Caption: Budget vs Prior Year.
       3. Click Define, to define the Default Calculation:
          1. View the TimeSeries calculations by selection calculations in the drop down.
             1. CUR12MONTHBUDGET+12 is CE12 of the Budget Year and Hubble Ledger.
             2. CUR12MONTHBUDGET-1 is CE12 of Prior Year and Actuals Ledger.
          3. Double click on CUR12MONTHBUDGET+12.
          4. Click the “-“ symbol.
          5. Double click on CUR12MONTHBUDGET-1.
          6. Press OK, and OK again.
    2. Check the box next to activate the newly created calculation.

Run the report and verify the calculation is working as desired.

Appendix C: Strategic Planning Example

Payroll Forecasting Example

The below example shows how you can now use Strategic Planning functionality to utilize data stored in your ERP to quickly forecast next year’s payroll. In this example, the Budgeting Contributor would enter an Employee #, and the form will return the Employee’s Business Unit, Name, and Current wages directly from your ERP. The example also includes a Model that calculates a New Wage and 12 months of wage forecasts that based on Current Wages, % Increase, and Effective Month of that change.

Prerequisite Steps

• A Cycle has been setup underneath an Activity where you are a Contributor.

Steps to Create

1. Open the Designer Express Template Designer:
2. a.  From the backstage view, click New > Designer Express > New Template.
3. Add the following tables:
   • ISBPAYROLL (Strategic Planning Data Entry Table)
   • F060116 – Employee Master Information (JD Edwards)

3. Join the Tables:
4. a. ISBPAYOLL.BUAN8 to F060116.YAAN8 (Left Outer).

4. Click Column Definitions on the Template Designer Menu.
5. For the following fields, set the Source to Customer Default and Category to Amount (Domestic).
   • ISBPAYROLL.BUAN01 through ISBPAYROLL.BUAN12
   • ISBPAYROLL.BURH02
   • ISBPAYROLL.BUSAL
   • F060116.YASAL
   • Press OK when finished.
6. Press OK to exit Template Designer.
7. Add the Values filter, under Main Filters, to the Filter Layout. Click OK to continue.

8. Add the following Amount columns to the Values Filter box.
   • ISBPAYROLL.BUAN01 through ISBPAYROLL.BUAN12 – caption as ‘1’ through ‘12’ respectively
   • ISBPAYROLL.BURH02 – caption as ‘Forecast FTE’
   • ISBPAYROLL.BUSAL – caption as ‘New Wages’
   • F060116.YASAL – caption as ‘Current Wages’
9. Add the following Columns to the new template via Columns, Sorting, and Grouping.
   • ISBPAYROLL.BUSEQ
   • ISBPAYROLL.BUAN8 – caption as ‘Employee #’
   • ISBPAYROLL.BUPCMU – caption as ‘% Increase’
10. Set User Defined Captions for Items and Fields as specified above.

1. Items:

2. Fields:

11. Add a Calculation for Total Wages.

1. Name: TOTALWAGES.
2. Caption: Total Wages.
3. Define Default Calculation:
   1. Add all Values AN01.ISBPAYROLL through AN12.ISBPAYROLL.

4. Result:

12. Adjust the column display order and sorting to your preferences via Columns, Sorting, and Grouping.

1. Consolidation:

2. Sorting & Grouping:
   1. The example is sorted by Business Unit – Home (Ascending) and Employee Name (Ascending).

2. The example includes totals for each Business Unit – Home, and a Grand Total.

13. Save Input Form as “01 Payroll Forecast Entry” in the required location.
14. Assign the Input Form to the appropriate Cycle.

1. Budgeting Menu > Activities > Select the Cycle > Close Cycle > Edit Cycle.
2. Select the Forms tab > Add New > Browse to and Select “01 Payroll Forecast Entry” > Click Open.

3. Check the box next to Annual Budget Input Form > Click OK > Open the Cycle.

15. Insert Rows via 01 Payroll Forecast Entry.

1. Copy a listing of Employee #’s (ANAN8) to insert into the ISBPAYROLL Data Entry Table.
2. Click Enter Budget on the Budgeting Menu.
3. Click Insert New Row on the Enter Budget Menu.

4. Right click on the newly inserted row underneath Employee #, select Insert from Clipboard.

5. Note that the appropriate number of rows have been inserted and populated with the contents of your clipboard.

16. Populate additional fields, note you must populate at least one amount field on each record you wish to retain.

17. Press Save and Continue to save the newly inserted rows. Note that data will populate where a match is found from the Join to F060116 – Employee Master Information on Employee #.

18. Complete information in fields that we will reference when defining the Model, such as % Increase and Effective Month.

Leave New wages, and the Period 01 through 12 Amounts empty as the model will populate these amounts. This will make writing the calculations easier once we are in Excel. Include multiple scenarios, as the example below does.

19. Press Finish to save the entry and exit Enter Budget Mode.
20. Press Create on the Budgeting Menu to Create a Model from 01 Payroll Forecast Entry.

21. Browse and Save the workbook to a desired location.
22. Define the Model Formulas in Microsoft Excel:

1. New Wages = Current Wages * (1+ % Increase / 100).
2. Monthly Wage Amounts:
   1. If Current Month greater or equal to Effective Month, then = New Wages / 12.

2. All else, then Current Wages /12.

23. Save the Excel Workbook.
24. Within Hubble, press Upload on the Budgeting Menu to upload the Workbook into Hubble as a Model. Select the desired location and click Save.

25. Assign the uploaded Model to 01 Payroll Forecast Entry.

1. Budgeting Menu > Forms > Select 01 Payroll Forecast Entry Form > Edit.
2. Click the ellipsis ‘…’ on the Model line > Browse to and select 01 Payroll Forecast Entry.

3. Press OK.

26. Enable Enter Budget Mode once again on the 01 Payroll Forecast Entry Form.

27. Press Apply Model on the Enter Budget Menu.

28. Review the results of the Apply Model. Experiment with changing inputs, pressing Apply Model to generate new results.

29. Press Finish to save your entry. Be sure to save the Form as well.