Skip to Content

BPC 10 NW - Report shows incorrect member property

Hi dear BPC experts,

I am using BPC 10 for NW, and facing an issue which only occurs in one report.

When I check "PERIOD" property on time dimension for member 2015.N1, it shows the correct value "TOTAL".

However, when I open this particular report, it gets wrongly configured.

I check then the same member property through "EPMMemberProperty formula in excel, and it displays the value "YEAR" (which is rather odd, since that's the value for another property of that same member).

Has anyone already faced this issue? Can you please help?

Many thanks,

AB.

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    Posted on Dec 06, 2014 at 05:53 AM

    Hi Andre,

    I have faced the similar issue and issue is resolved by following below steps.

    Cache has to be cleared.

    Run the Tcode SE38 and execute the below programs:

    UJXO_CLEAN_CACHE

    UJXO_CLEAN_DIM_CACHE

    UJXO_CLEAN_TDH_DIM_CACHE

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 03, 2014 at 03:14 PM

    Hi Andre,

    If you search the forum you can see exactly same issue posted on 27th of November:

    No solution, but may be specific SP issue...

    Vadim

    Or may be language specific?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 03, 2014 at 04:07 PM

    Vadim,

    I have the same SP18 (with no Patch). The language is not the same (spanish vs portuguese).

    I'll update my EPM version to 19 and check if the problem is solved. Neverthless, I find it strange, since it only happens in this specific report, others work just fine.

    Thank you,

    AB.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2014 at 03:06 PM

    Hi Andre,

    Please send some screen shots.

    Andy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 03, 2014 at 03:27 PM

    Andy, Vadim,

    Thank you for your quick responses.

    You can see here the dimension configuration:

    And the difference in excel:

    @ Vadim, I don't think so, because it has never happened before, I have very similar input schedules on this model and none of them have the same problem. Plus, I am just using the EPMMemberProperty formula to check the difference above. I use, in my report, property filters which should work (they work on other models and reports), but not on this specific report.

    I think he's looking at "LEVEL" property, which actually has that value on the member.

    Any thoughts?

    Many thanks,

    AB


    dimensionprop.png (27.1 kB)
    reportprop.png (47.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • In the provided link the issue is exactly the same:

      Instead of PAIS_ORIGEN property value the EPMMemberProperty function returns the value of another property: PATTERN

      In your case instead of PERIOD property value the EPMMemberProperty function returns the value of another property: LEVEL

      What can be common between your system and the system of another post author?

      Vadim

      Corrected: LEVEL!

  • Posted on Dec 04, 2014 at 08:17 AM

    Hi Lucas,

    Thanks, I've already done that and surely will test it. However, our client users are the company directors' themselves, and we cannot allow the possibility of asking them to delete a folder 😊

    Found a workaround by deriving the time dimension through some hidden cells on the report, not the cleanest solution, but it'll work.

    Thank you all for your help!

    Best regards,

    AB.

    Add a comment
    10|10000 characters needed characters exceeded

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.