Skip to Content
avatar image
Former Member

Define a dimension automatically macth two dimensions

Hello Experts,

I have 2 dimensions GL Account and Cost Center and I need to classify each combination for a group. Example:

GL Account          Cost Center          Group

780100                   4110341               Labor

780100                   4110341               Manufacturing

780290                   4110341               Others

For each GL Account + Cost Center I have one group. I just have the dimensions GL Account and Cost Center created in my Model but my user needs reports by Group.

I thought to create a new dimensios Group. One member of this dimension will be Not Defined. All data saved by Input will used this member. And I would like to have a Package that re-classify this Not Defined Group for a validade one. I could have a file with the GL Account Cost Center and the Group.

Is it possible?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 10, 2014 at 02:40 PM

    Hi Ariane,

    "For each GL Account + Cost Center I have one group" - not clear! Can you describe the business case in more details? What do you mean by Group in business terms?

    Another question: where you want to store the relation between Group and combination of Account and Cost Center?

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 10, 2014 at 03:30 PM

    Hi Ariane,

    I think your requirement is - you have Costcenter and GL Account dimensions and in your report you want to show GL Account, Cost Center and Group (for which you don't have Group dimension). But for every record you want to send "Not Defined" Group, which later on get changed to the corresponding Group of CostCenter and GL Account.

    If my understanding is correct then, check in CostCenter and GL Account dimension there should be a property which is describing Group. Create a local member in the report to show that value.

    Regards,

    Meenu Bansal

    Add comment
    10|10000 characters needed characters exceeded

    • Yes Vadim, the property will work with one to one relation.

      Ariane, Can you explain your requirement??.... as same Costcenter and GL Account cannot have 2 Group's as shown in your example.

      GL Account          Cost Center          Group

      780100                   4110341               Labor

      780100                   4110341               Manufacturing

      780290                   4110341               Others

      Regards,

      Meenu Bansal