duplicated line EPM

[amine_lamkaissi]

Hi guys,

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

Thanks.

Amine

[former_member186338]

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!

[amine_lamkaissi]

Ok Thanks Vadim.

[former_member186338]

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!

[amine_lamkaissi]

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

[amine_lamkaissi]

Hi Vadim,

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

[former_member186338]

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!

[former_member186338]

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

[amine_lamkaissi]

The selection is done dynamically, can you please explain?

[former_member186338]

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

[amine_lamkaissi]

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.

[former_member186338]

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!

[amine_lamkaissi]

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?

[former_member186338]

Something meaningless!

[former_member186338]

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 :)?

[amine_lamkaissi]

Vadim,

I tried to remove this:

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

[amine_lamkaissi]

Here is the formula:

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

[former_member186338]

Nothing wrong with this formula, the selection is incorrect!