Building Consolidated Sales Plan
Posted: Tue Jun 07, 2011 8:42 pm
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.
I want to now take the revenue numbers from these two cubes and bring them over to a consolidated sales cube (see below).
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
I want to now take the revenue numbers from these two cubes and bring them over to a consolidated sales cube (see below).
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