Skip to Content
0

duplicated line EPM

Sep 21, 2017 at 12:57 PM

40

avatar image
Former Member

Hi guys,

I don't understand why in my report the line is dupliacted. Is something wrong in my member selector parameters?

Thanks.

Amine

sans-titre.png (98.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Vadim Kalinin Sep 21, 2017 at 01:48 PM
1

Sorry, looks like you playing with the report developed not by you!

Please start from the very beginning:

1. Create a new, simple report.

2. Use some cell for =EPMContextMember("OVERHE";"OH_ORGA")

3. Use this cell for report - no idea how do you want to use it!

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Ok Thanks Vadim.

0
avatar image
Former Member Sep 21, 2017 at 01:00 PM
0

Here is the formula:

= EPMOlapMemberO("[OH_ORGA].[PARENTH1].[SOSA_200004]";"";"SOSA_200004";"";"000")

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

Nothing wrong with this formula, the selection is incorrect!

0
avatar image
Former Member Sep 21, 2017 at 01:07 PM
0

Hi Vadim,

Thanks for your answer. I selected only one, may be there is a problem in my EPM formula?


sans-titre2.png (51.8 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Please, don't change anything in EPMOlapMemberO function manually!

As I already told you, remove selection for OH_ORGA dimension at all, then select a single member!

0
avatar image
Former Member Sep 21, 2017 at 02:47 PM
0

Hi Vadim,

I think i founfd the source of my problem.

I found a cell with this formula :=EPMDimensionOverride("000";"OH_ORGA";"SELF("&$A$2&"),BAS("&$A$2&")")

Thanks.

Amine

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Sep 21, 2017 at 01:03 PM
0

First of all - incorrect tag:

SAP Business Planning and Consolidation, version for SAP NetWeaver

Please change to:

EPM Add-In for Excel

Second - "I don't understand why in my report the line is dupliacted" - you managed to select the same member twice!

It's possible! Simply remove selection and select again. I do not understand what do you want to select...

Show 8 Share
10 |10000 characters needed characters left characters exceeded
Former Member

The selection is done dynamically, can you please explain?

0

First of all please explain yourself, what do you want to select! Have to ask second time!

0
Former Member

I want to select a member of my hierarchy. All levels are possible to select.

But when i select the last level, i have duplicated lines.

0

Sorry, but absolutely not clear what are you doing!

Can you explain step by step (starting from nothing selected)? On your screenshots I see some absolutely strange selection!

0

Something meaningless!

0
Former Member
Vadim Kalinin

Vadim,

I tried to remove this:

Even when i click on OK, when i come back, the screen is the same as before.

0
Former Member

Ok Vadim.

Here is the formula of the cell where i select my company level : =EPMContextMember("OVERHE";"OH_ORGA")

Let say my hierarchy of company is like this:

Company1

Company1a

Company1aa

When i select company 1, i have one line in my report

Same when select Company 1a

but when i select the last level, i have dupliacted line.

Is that clear?

0

Still not clear!

"Here is the formula of the cell where i select my company level : =EPMContextMember("OVERHE";"OH_ORGA")" - how this cell is related to your report???

Do you thing I can spy on your PC :)?

0
Vadim Kalinin Sep 21, 2017 at 03:21 PM
0

For sure if $A$2 is a base member you will get two identical lines because in this case:

BAS($A$2)=$A$2

Use:

=EPMDimensionOverride("000";"OH_ORGA";"SELF("&$A$2&")"&IF(EPMMemberProperty(;$A$2;"CALC")="Y";",BAS("&$A$2&")";""))

If CALC =N then BAS(A2) will not be added!


Share
10 |10000 characters needed characters left characters exceeded