Forum Discussion

zubairs's avatar
zubairs
Helper I
4 years ago

Multiple mapping for GL 7 Cost Center

Hi PQ frens,   So I am having an issue with multiple mapping.   We currently have two kinds of mapping for our reporting hierarchy.   One is for the internal management and one is for the group...
Need Help
Show and Tell
Tips and Tricks
KT_Bsmart2gethe's avatar
KT_Bsmart2gethe
Impactful Individual
4 years ago

Hi zubairs,

 

On the attached screenshot, I can see Cost element (I assumed it is GL code), but don't see the CC code. Also, there are two expense groups: GL Group and OPEX group. 

 

Would you mind explaining a bit more of your challenge?

 

I was wondering if the challenge you have is because of 1-to-many relationship mapping to cost group and required split?

 

Sorry for not understanding well of your challenge.

 

Regards

KT

 

  • zubairs's avatar
    zubairs
    Helper I
    4 years ago

    Hi KT_Bsmart2gethe,

     

    appreciate the response.

     

    Yes Cost Element is "GL Code"

     

    There are no codes for Cost Center when it comes to the group mapping. So it is currently being mapped based upon the submission source. The submission source has Cost Center mapping but that is used only for management reporting.

     

    For the expense groups, the hierarchy is as follows:

     

    Main Group = OPEX Group (BPC MIS) Marketing, selling & distribution expenses

             Sub Group= GL Group (BPC MIS) Others

    • KT_Bsmart2gethe's avatar
      KT_Bsmart2gethe
      Impactful Individual
      4 years ago

      Hi zubairs ,

       

      I am still a bit unclear about the challenge and desired outcome.

       

      Are you thinking of using one mapping table for both internal and group reporting?

       

      Would you be able to draft the desired outcome? say in excel?

       

      I am trying to visualise the use of the mapping and link to the star schema. What fields do you have in the source data (i.e. the GL Summary? GL detailed transactions? or?)

       

      Regards

      KT