Page 1 of 1

Building Consolidated Sales Plan

Posted: Tue Jun 07, 2011 8:42 pm
by 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
MD_Sales_Plan.jpg (67.89 KiB) Viewed 2691 times
MD_Disposable_Sales_Revenue.jpg
MD_Disposable_Sales_Revenue.jpg (63.67 KiB) Viewed 2691 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
Medical Devices Sales Plan.jpg (102.06 KiB) Viewed 2691 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

Re: Building Consolidated Sales Plan

Posted: Wed Jun 08, 2011 2:43 am
by 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.

Re: Building Consolidated Sales Plan

Posted: Fri Jun 10, 2011 6:59 pm
by cardantim
That was it. I need rules within the target cube and feeders in the source cubes. All working nicely now. Thanks.