Building Consolidated Sales Plan

[cardantim]

Hoping to pick your collective brains. I'm building a sales plan and currently in the model I have two primary cubes; MD_Sales_Plan and MD_Disposable_Sales_Revenue.

MD_Sales_Plan.jpg (67.89 KiB) Viewed 2685 times

MD_Disposable_Sales_Revenue.jpg (63.67 KiB) Viewed 2685 times

I want to now take the revenue numbers from these two cubes and bring them over to a consolidated sales cube (see below).

Medical Devices Sales Plan.jpg (102.06 KiB) Viewed 2685 times

Still learning TM1 nd not exactly sure what to do next. In the MD_Disposable_sales_revenue cube I have the following as a test feeder;
['Liver Transplant']=>DB('Medical Devices Sales Plan',!MD_Accounts,!MD_PrimaryGPO,!MD_Regions,'Liver Transplant','Sales Revenue',!MD_SalesExecutive,!MD_Time,!MD_Versions);

But when I recalculate I still have $0's.

Thanks

[Andy Key]

You say you have a feeder in your MD_Disposable_sales_revenue cube, but you don't say what your rule is in the Medical Devices Sales Plan cube.

[cardantim]

That was it. I need rules within the target cube and feeders in the source cubes. All working nicely now. Thanks.