Skip to Content
author's profile photo Former Member
Former Member

Local member

Hello everybody,

I am currently working on SAP BPC 10 MS and I have a trouble with a local member.

I have 2 reports in 1 sheet.

As you can see on the screenshot, the columns "P_INTERCO" and "CONTROLE" are part of the first report.

This is a static one. Then, you have the second one, which is dynamic. The green cells correspond to the entity code.

The red ones are the headers and correspond to the description of the entity (using epmmemberdesc()).

In the second screenshot, you can see my local member ("EN_TETE_COL") formula.

Everything works fine except that the header of the ENTITY 1 keep the same header as P_INTERCO (not represented here).

The issue is that the local member begins from scratch in the 2nd report (column ENTITY 1).

P_INTERCO = I45

CONTROLE = J45

P_S0008 = K45

So the test of the cell K47 is IF(I45="P_INTERCO","Total à ventiler",epmmemberdesc(K45)). I have an offset.

Does anybody has something to provide?

Thanks you in advance for your help!

Kind Regards,

Bastien

Local_member.png (28.0 kB)
Excel.png (13.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2016 at 07:42 AM

    Hello Bastien......in Future Please provide the screenshots in English!

    Without providing the row and column headers how should we understand the formula??? Please provide them in the screenshot! And where have you added the local member? In 1st report or 2nd report? Where do you want the local member to be? before column axis?

    Your current local member has not been applied, from the screenshot I see! Tick the "Apply" option.

    Regards,

    JP

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2016 at 12:25 PM

    Hi guys!

    Thank you so much for your help!

    JP your solution works perfectly it is the good formula to insert !

    Kind Regards!

    Bastien

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hey Bastien,

      Are you using only single formatting sheet to both the reports?? I would recommend to use 2 formatting sheets, so that the formula convergence doesn't happen!.

      Moreover the second report to me appears to be partly dynamic and partly static. Static because of members in report and dynamic local members.

      I guess if you use 2 formatting sheets then there is no need to include all members in formatting sheet and then format them!

      For the local member formula....try to work with the formula on excel first! Since you have given a screenshot I am not able to test it....But might be the conditions are not completed.....Check that. Do you get any error for that formula?

      Regards,

      JP

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2016 at 02:44 PM

    Hi guys!

    Sorry for late reply, I was trying to make it work.

    @JP: I have 2 formatting sheets. I am quite sure I must include the members to color rows (to respect the specs)...

    Now I don't have issue with the first report. Only with the 2nd one.

    As shown below :

    The formula in OI58 still test with P$53 (cell in the first report). It is the same issue that we have from the beginning. So I have put the formula in the 2nd formatting sheet :

    With OH53 as we said. But it does not work..

    Do not know why the formatting sheet does not override in this case..

    Is there something different from the previous case?

    @BPC user : It is not acceptable and unfortunately the memberdesc will not override the local member of the 1st report??

    Thank you for your time guys!

    Regards,

    Bastien


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Bastien....In the second formatting sheet, the local members name seem to be EN_TETE_COL etc. But in the report screenshot I see ECART_1 and so on.....Is this the reason it is not overriding?

      Plus look at the priority of the formats applied priority to row or priority to column in formatting sheet! The local members in 2nd report are in column, have you added the loacl member in column section?? Sorry since the screenshot is not in English...I am asking you this..

      Look at these option...apart from this I don't know any possible reason for the formula to not get applied.

      Regards,

      JP

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.