About abhi1017

Hi Nick,   The data is available in the model already.  1. Use SYS02 Account Details module for mapping country and segment to the Accounts in the TAR 02 Account review module. (Note: Time dimension is not required while populating data for country and segment, from SYS02 Account details) 2. To calculate  the detailed account targets:- create a separate module with dimension of Segment and G2 country lists and use SUM to pull targets data from TAR 02 Account review.   Hope it helps. ~Abhi ... View more

@Misbah    True that. Just gave him another solution wherein the module I have mentioned can be in the hub that would be updated via import from source and then  this would flow into the spoke models as a hierarchy list starting at the top and going down.   ~Abhi ... View more

Hi, 1. Assuming hierarchy as- L1 Cost Center, L2 Account code and L3 Cost pool. 2. Now, try to find a unique code in the source data or create one. Use this unique code to create a numbered list.     P..S: The entire hierarchical data should be present in one excel sheet based on the unique code. 3. Create a module with the dimension of the above-numbered list and import the excel sheet data into a module by creating the respective line items. 4. Create three more line items in the module to find the first occurrence of Cost center, Account Code, Cost Pool. 5. Create saved views. a.) select cost center line item and its code, and add cost center first occurrence in the filter. Import this into the L1 Cost Center list.                                      b.) Similarly for Account Code and Cost Pool, by also adding respective parent lists in the saved views.    Hope this helps.     ~Abhi   ... View more