on 05-25-2016 3:14 AM
Hi
As our consolidation report, we need choose the dimension "Scope" and the corresponding dimension "Entity" member. Like below:
Scope: ENTITY:
World World
Asia Europe Africa Asia Europe Africa
The Scope and Entity have the same strucure, if user want to see "Asia" report, it need choose Scope-Asia and Entity-Asia twice. In order to reduce user manual activity, by using macro, when user choose Scope-Asia, Entity's member automatically be changed to "Asia".
Now, we found the solution make many troubles.
I think our problem is common, so do you have the best practice for it. Thanks.
Regards,
Hi,
In simple way, you can create a property in Entity dimension for SCOPE and refer that property while creating report.
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rahul
Thank your input again.
Now we also use macro [EPM.SetContextMember CONNE, "ENTITY", strMemID"'] to achieve the requirement. But we do not want to use macro for it.
I think the requirement is very common for consolidation project, why the SAP does not provide the standard solution?
Regards
VBA macro?? What for?
If member ID's in scope and entity are different - create property ENTITY in scope dimension and fill it with entity member ID
Put ENTITY dimension in page axis
ENTITY formula has to be:
= EPMOlapMemberO(EPMMemberProperty(;"[SCOPE].[PARENTH1].["&EPMContextMember(;"SCOPE")&"]";"ENTITY");"[ENTITY].[PARENTH1].[Asia]";"Asia";"";"000")
Hi,
If you have one to one relation between entity and scope, then you will not require the Macro, the solution suggested by vadim will work (assign the property directly to page axis ), but if you have one to many relation (one scope is linked to multiple entities- which is common in consolidation scenraio), then you will require Macro.
Regards,
Rahul
Hi DC Consultant,
Could you try to lock and hide Entity dimension as "World" member, then let users to use Scope only.
I believe there is no data on other intersections with Scope: Asia except Entity: Asia.
Best regards,
Oleksandr
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
As what I said before, I just tested in my system, it still not work.
Test process below:
1. I locked the dimension Entity as "World"
2. User BPC01 has not the access authority for entity member "World"
3. BPC01 open the report, the dimension Entity is unlocked automatically and changed to one random member
4. So the report result is incorrect
Regards
Hi Vadim
Thank your input,
I just tested, but found some problems.
In the English language environment, it work, but in the Chinease language environment, it not work, because the system says " it cannot recognize the Entity member XXXXX, so the entity dimension is losed from page axis. I am digging out the root cause.
Regards
Then, the solution suggested by vadim will work.
Once again, highlighing the solution:
1. Create scope property in entity dimension.
2. Keep scope dimension in context.
3. refer the scope dimension member to get the entity details (epmmemberproperty) will work
4. refer the entity with entity dimension in page axis.
Regards,
Rahul
First in some cell (B2) create a formula: =EPMMemberProperty(;"[SCOPE].[PARENTH1].["&EPMContextMember(;"SCOPE")&"]";"ENTITY")
Then activate member recognition
In the cell where you have ENTITY dimension page axis formula - manually type "=B2"
Member recognition will create:
= EPMOlapMemberO(B2;"[ENTITY].[PARENTH1].[Asia]";"Asia";"";"000")
Disable member recognition.
Then change B2 to EPMMemberProperty(;"[SCOPE].[PARENTH1].["&EPMContextMember(;"SCOPE")&"]";"ENTITY")
Clear cell B2
Vadim
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.