Setting the Sales Budget data set

Solution:

  1. In DWD Designer, click the Data Sources tab.
  2. Go to All Data Sources > M3_15_1_X > schema.
  3. Right-click "LBI1 (#Sales_Budget_Dataset_Name)" and select Properties.
  4. In the Overview panel, select Compilation & categorization.
  5. Click Modify Categorization.
  6. In the Table View Name in database, specify the M3 Sales Budget Data Set created in M3. Click OK.
  7. Right-click LBI1 and select Uncompile > Delete SSIS package .
  8. After object is uncompiled, right-click LBI1 again and select Compile.