1 Reply Latest reply on Jun 19, 2013 2:39 PM by JeffJon

    Metadata/dataload for Concatenated Segments to Dimension in ERPI

    896901

      Hi All,

          We need to map 2 segments (EBS) to one dimension(EPMA Planning Application) using ERPI. Dimension needs to look something like this after metadata load:

       

      Segment1              Segment2                                                                                     Dimension

            1                           100                       metadata load                                                     1_Total                               

            2                           101              ----------------------------------------->>>                                    1_100

                                         200                                                                                                          1_101

                                         201                                                                                                    2_Total

                                                                                                                                                         2_200

                                                                                                                                                         2_201

       

       

      In other words Segment 1 members are getting contatenated with Segment 2 members separated by underscore.


      I know ERPI can handle concatenation for Segment1+Segment2--->Concatenated Dimension but I need 1_Total, 2_Total parents in the Dimension. These members are currently defined in the Dimension.

       

      My question is when I execute the metadata load, will these parents stay?

       

      How do I define dataload for this contactenated segment?


      Thanks Everyone