Skip to Content
0

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

Mar 04, 2017 at 07:34 AM

83

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Vadim Kalinin Mar 04, 2017 at 08:12 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Vadim,

For this requirement there is no many many relation it one to one even for one to one also i can not use H1, H2 ? Hierarchy.

Thanks,

Ravi

0

Hierarchy is not related to this requirement. Forget about hierarchy!

Please provide FULL list of relationship between Entity and Account ID's.

In the provided sample I can see one to many.

0
Vadim Kalinin Mar 04, 2017 at 06:15 PM
0

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...

Show 6 Share
10 |10000 characters needed characters left characters exceeded

Hi Vadim,

Good Blog, But i am having one question, this approch is for many to many ...but what if there will be One to One ..relation in between Account and entity dimension ? on that case also we need to have this approach ?

Thanks,

Ravi

0

P.S. Please show FULL required relationship table!

0

One-to-one means that each ENTITY is related to SINGLE ACCOUNT. And each ACCOUNT is related to SINGLE ENTITY. Are you 100% sure? In the original question AFRICA entity is related to 2 accounts!

0

HI Vadim,

Please find below images ..

Store Dimension ..

Account Dimension..

And report is . were user will select the stores and accordingly he will get the account ... to enter the budget ..

and here there is one to one mapping ..

Thanks,

Ravi

st.jpg (27.2 kB)
one.jpg (42.1 kB)
reportone.jpg (26.6 kB)
0

Hi Vadim,

Yes, Please let me know what if there is a one to one mapping ? One entity map to one account ...

Thanks

Ravi

0

Looks like it's some unreal test case - one entity to one account! One entity have to be budgeted for MULTIPLE accounts in the real life!

0
Vadim Kalinin Mar 07, 2017 at 07:31 AM
0

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...

Share
10 |10000 characters needed characters left characters exceeded