Skip to Content

Get Member based on specific property

Hello Experts

Is it possible to get member based on specific property?

Scenario: In time dimension, I have businessday property. In BPC report, I want to get Prior Business day based on Context selection.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Dec 02, 2016 at 07:01 AM

    Dipal,

    Scenario: In time dimension, I have businessday property. In BPC report, I want to get Prior Business day based on Context selection. - Can you explain this with an example?


    Regards,

    JP

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 02, 2016 at 08:01 AM

    Please also provide screenshot of your TIME dimension with businessday property

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 02, 2016 at 11:56 PM

    Hello

    We are using BPC MS 10 version. I have attached screenshot from time dimension.

    The requirement is, when I select "2016.DEC.05" in the Context, I need to get Prior member(Based on BusinessDay Property) which is "2016.DEC.02". I cannot use Memberoffset because it will pull "2016.DEC.04" as Prior member. Thanks for your time.

    timedimension.jpg

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 03, 2016 at 07:35 AM

    First: If you are using BPC MS - then please remove the tag: SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver.

    Second - how do you want to use previous business day in the report?

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 05, 2016 at 03:49 PM

    Hi Vadim

    In the EPM Report, I want to show previous business day and selected date from the Context.

    when I select "2016.DEC.05" in the Context, Prior business day should be "2016.DEC.02".

    Thanks

    Add comment
    10|10000 characters needed characters exceeded