Skip to Content
avatar image
Former Member

Maintenance of Same Account member for Different Stores entity

Hello BPC Experts,

I am working for SAP BPC 10.1 NW ...

I am having one requirement for that in Account dimension one Income Item is common for more then ten Stores, Now i am having problem to get that where i have maintain this kind of Hierarchy in account or need to create one user defined dimension .

As you can see in my account dimension ID INCESTORE, which is common for Store 1,Store 2, STORE 3 ...STORE9.


Note:- I have not given any id for repeated INCESTORE because i do not want to have repeated value in my account dimension and the image is from Excel sheet which is having this account dimension.

Now for for my report there is requirement that if user is selecting Store 1 on that case All related INCOME item should appear in the report with value like below ..


SO now my problem is how to maintain this kind of hierarchy to have repeated Income for different Stores and where i have to maintain ? In a separate User defined dimension or in Account dimension.

Happy Learning ..

Regards,

ANDO

account.jpg (70.8 kB)
account-report.jpg (36.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Mar 04, 2017 at 06:45 PM

    Please read my new detailed blog about many-to-many relationship!

    https://blogs.sap.com/2017/03/04/report-or-input-form-with-many-to-many-relationship-between-2-dimensions/

    Perform the described steps!

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 26, 2017 at 01:50 PM

    Can you clearly explain what is StoreX - member of what dimension?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Vadim Kalinin

      Hi Vadim,

      Sure it's strange, But think that no other option that is why i have asked this question here in SCN.

      I need a Input Template where .

      If user is selecting Store1

      and id user is selecting Store2 then on the same Input template ,

      But the problem is how to map this as INCESTORE(Maintenance Prof enty) is common in between Store 1 and Store 2 that is why i have created Parent H2 and used Unique id as

      INCESTORE1, INCESTORE2, INCESTORE3, INCESTORE4 ,INCESTORE5 INCESTORE6, INCESTORE7, INCESTORE8, INCESTORE9

      But description is same ..Any way to avoid this repetition ?

      Here again providing the dimension member snap ..

      Regards,

      ANDO

      1.jpg (18.1 kB)
      2.jpg (13.1 kB)
      filter.jpg (94.7 kB)
  • Feb 26, 2017 at 01:16 PM

    Hi Ando,

    You can have another Hierarchy in the same account dimension and there you can maintain Store ID for respective unique account id, but on that case your id will be unique but it will repeat for the same Income description.

    Thanks,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Ravi,

      But it will repeat the same account type with having different id and same description more then 2 times ..and more over i do not thing so that in account maintaining a Store related Hierarchy is good option.

      Regards

      ANDO

  • Mar 01, 2017 at 09:04 PM

    Can't comment under your last comment!

    Unfortunately I am UNABLE to understand your requirements... Looks like you are doing something basically wrong

    Add comment
    10|10000 characters needed characters exceeded