Eventually, we are going to tie the Budget data together with the Amount data in the existing Sales Cube via the Period Table dimensions.
As you may recall, the Sales Invoice Line table is connected to the Period table via the [Sales Invoice Line].[Posting Date] -> [Period Table].[TheDate] foreign key / primary key relationship.
Likewise, we will need the BudgetData table to be connected to the Period Table with a similar foreign/primary key relationship.
Since the BudgetData table does not hold any full Date column yet, we will need to add one with a script:
This script will concatenate the Year and Month information in the table – as well as the first date (01) of every month – into a single full date column.