Filtered budget
Last updated
Was this helpful?
Last updated
Was this helpful?
User permissions: Budgets & Forecasts and Manage Budgets & Forecasts
The creation of filtered budget workbooks gives you a lot of flexibility in how you approach your budgeting process. You can use filters alongside the copy workbook feature to quickly create multiple budgets from the same database, where the only difference is the filter that is applied. You can then work on each of those budget workflows separately, then publish them all into the same stream, without overwriting any data.
For example, in the following image, three separate budget workbooks were created using a budget filter on the Country dimension. Each of those budgets was then published into the same stream.
A dimension is a level in your budget hierarchy and an entity is a value within a dimension. For example, a dimension is Country and the entities are Australia, the UK and the USA.
A filtered budget filter is only one to filter the data that is displayed in a budget and it poses a risk - see the troubleshooting section below. Learn about the other filtering methods to see if another one better meets your budgeting needs.
In the budget setup, there are two filtering options that relate to the dimensions and entities in the underlying database.
The budget filter, sometimes called the budget-wide filter, applies a filter to one dimension entity. As a result, the whole budget is filtered to display only the data for the selected entity, which is easy to see when you expand a row. The filter is displayed at the top of the worksheet for reference purposes.
In the following example, a budget filter is applied to create a budget workbook for the UK.
A budget filter is suitable when:
You want to create a simple budget for an entity, such as in the above examples.
You are budgeting on a project basis. You can create multiple budgets of the same budgeting model, one for each project.
Your organization acquires a new business during the year. You can create a separate budget for that business unit based on your current budget.
You can use comparison rows to bring additional information into a filtered budget. For example, if you create a budget for Australia, you might want to add data from the UK or USA for reference or comparative proposes.
The level filter applies a filter to one or more entities in a specific dimension level. As a result, the level is displayed in the budget as usual, but only the selected entities are displayed underneath.
In the following example, a level filter is applied to create a budget workbook for the UK.
As you can see, the above example uses the same scenario as that in the budget filter example above, but the use of a different filtering option leads to different visual results.
A level filter is suitable when you want to select a subset of entities. For example, suppose you have a Regional Manager who is responsible for four branches. You could create a budget just for that manager.
You can use comparison rows to bring additional information into the budget. For example, if you create a budget for the UK using a budget filter, you might want to add data from Australia for reference or comparative purposes.
If you apply a budget filter, when you clone the workbook, the Select budget filter setting allows you to select a different budget filter (dimension and/or entity) to apply to the new workbook.
If you apply a level filter, after you copy the workbook as usual, the new workbook will have the same level filter applied. You can then edit the setup of the new workbook to change the filter.
When you publish a budget workbook as a stream, only the relevant filtered dimension will populate (or overwrite) with new data. If you publish an unfiltered version of a budget workbook, you will overwrite all filtered uploads that you already made.
After you complete the workflow for each filtered budget and are ready to publish the budget data:
Publish the first budget into a new stream, for example, Financial Budgets 2025.
Publish the other budgets into the same stream that you created for the first budget (Financial Budgets 2025).
Review the published budget data in Financial Statements. You need to customize your statement view to see the data.
While budget filters are a great way to focus on selected dimension entities in a budget, you are effectively removing all the other entities from the budget. As a result, you run the risk of inadvertently filtering out data, which causes problems later on.
For example, suppose you have four warehouses but one of them is not in use. When you create a Sales budget you apply a filter to stop that unused warehouse from being displayed in that budget. In other words, you are saying, "I just want warehouse 1, 2 and 3". Later in the year, if you open a new warehouse (5), it won't show up in the budget, as it has effectively been filtered out.
Problem:
Something is missing from the budget, such as a particular branch, product, or customer.
Resolution:
If you've already started budgeting, edit the filter in the budget setup to include the new item in the budget.
If you haven't started budgeting yet:
A budget filter mightn't be the best solution for your scenario. Consider using an alternative filtering method (see below).
Delete the dimension entity from the budget. It can then be easily added back in later.
