Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Add (inject) rows into a Database tab to budget for items that didn’t have any activity in the baseline period. For example, you might be doing your Sales budgeting and have a new Sales Rep or product that you want to budget against. As this is a new budget item, it doesn’t display in the baseline of this driver tab. You add the data, you need to manually add it in. Add a row at the lowest level in the data, which might be a budget item, such as a Sales Rep or Product in an operational database driver tab or an account in a financial database driver tab.

If you have additional measures in the driver database tab, any new rows you add will get these additional measures by default.

  1. On the Database tab, expand the rows to the applicable dimension, for example, UK > Sales Rep.

  2. Hover over the entity row (UK), then click the blue Add button that displays.

  3. Add the entity. The new row displays in the budget with an Unmapped button (icon) next to its name.

  4. Click the Unmapped button to open the mapping window for that dimension, then map (match) the dimensions in the driver new database to the dimensions in the main budget database and click Save and Finish. The budget reloads and the new row is no longer marked as unmapped.

Inject rows.mp4

Related pages