Skip to Content

How to Group Account dimension members on the basis OF Entity dimension Members ..

Hi Experts

I am having Entity dimension,

And Having Account dimension as ..

Now i need Input Template like below ..

So if user is selecting AFRICA then Retained Earnings and Long Term Debt should come and when user is selecting CHINA then Third Party Sales should come dynamically.

can any one help me tell that where i have to link this entity to account ..

I know by Parent H1 we can have Hierarchy but in my case where i can create it in account dimension or in entity, which is advisable or i can say best best practices ?

Thanks,

Ravi

en.jpg (39.4 kB)
ac.jpg (104.6 kB)
report22.jpg (28.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 04, 2017 at 08:12 AM

    Hi Ravi,

    I do not understand the reason to ask the same question number of times.

    Hierarchy has no relation to this case.

    It's a question about relationship between Account and Entity. I suspect that it's many-to-many: one account can be related to more then one entity. Then read about solution (not perfect but working) in https://archive.sap.com/discussions/thread/3654090

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 04, 2017 at 06:15 PM

    Please read my fresh blog with detailed explanation: https://blogs.sap.com/2017/03/04/report-or-input-form-with-many-to-many-relationship-between-2-dimensions/

    Looks like this question will be asked number of times in the next days...

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 07, 2017 at 07:31 AM

    Theoretical case: one-to-one relationship between entity and account:

    Create in ENTITY dimension property ACCOUNT and fill it with required account id.

    In the report you can get this property in some cell using EPMMemberProperty (assuming ENTITY is in the page axis of the report)

    Then use EPMDimensionOverride for ACCOUNT dimension in row axis with the value from cell with property...

    Add comment
    10|10000 characters needed characters exceeded