...
| Info |
|---|
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. |
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.
Create a filtered budget
In the budget setup, there are two filtering options that
...
...
1 Budget filter
The budget filter, sometimes called the budget-wide filter, applies a filterto
...
Budget filter - This option, known as a budget-wide filter, applies a filter to the whole budget. It is suitable when you want to budget for one entity only. Budget filters are handy when you want to create a simple budget for a project.
The two filtering options give you a lot of flexibility in how you approach your budgeting process. For example, suppose you operate in three countries in which you have a total of nine branches.
...
one entity in one dimension.
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.
| Tip |
|---|
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. |
2 Level filter
The level filter applies a filterto one or more entities in that dimension level. As a result, the level is displayed in the budget 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.
The level filtering option is more 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 example, create a budget for the United States, which includes four branches.
There are two filtering options in the budget setup:
| Note |
|---|
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. |
2 creat budget for UK without having to add a level for country . UK f
dimension you are not going to use in your hierarchy
dimension you are not using in hierarchy
simple budget, project by project
Apply a filter to a level
In the setup of each budget, you filter the same dimension level but select a different entity. For example, suppose your organization operates in three countries. You want to budget for each one separately but ultimately view all the budgets in the same stream.
Create the budget workbooks, filtering the same dimension (Country) but selecting a different entity (Australia, United Kingdom and United States) in each one.
Copy a filtered workbook
After you create one budget workbook, using either filter method, you can copy that workbook and change the applied filter to quickly create the other workbooks.
...
for that manager.
Use session filters
An alternative to creating a filtered budget is for your team to use session filters. They allow for a similar output to the budget filters described above, however, there are some key differences:
Users:
All users can apply session filters but budget filters must be set by the budget owner and administrators.
Session filters only apply to the user who applied them, whereas budget filters apply to all users.
Time: Session filters are temporary but budget filters are not. Session filters last for the session only, so you can change them without impacting the structure of the workbook. If you reload the budget or close and reopen a budget, you’ll lose the filters and see all the original data again.
Use comparison rows in a filtered budget
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.
Copy a filtered budget
If you apply a budget filter, when you copy 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.
Publish a filtered budget
| Note |
|---|
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.
...
Apply a budget-wide filter
The option to apply a budget-wide filter is a suitable option if you are budgeting on a project basis, as you can filter by project, set up the budget as required, then make several copies of the budget for use in other projects. It is also a great option if your organization acquires a new business during the year, as you can create a separate budget for that business unit based on your current budget.
The filter applies to one entity, in one dimension*, in the underlying database. When you publish the budget, the data is published back to that one entity in the underlying database.
For example, suppose you are setting up your budget workbook to budget by Country, and as a result, the workbook contains multiple countries. However, you are only responsible for the UK budget, so you do not need to see the other countries. You can create a filtered workbook to budget for the UK only. The name of the filter (UK) displays at the top of the grid.
Create the first budget workbook, applying a filter to a dimension (Country) and selecting a specific entity (United Kingdom).
Copy the budget, selecting a different entity (United States).
...