Skip to Content
0

Get Member based on specific property

Oct 12, 2016 at 11:24 AM

96

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Priyanka Jagtap Dec 02, 2016 at 07:01 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Dec 02, 2016 at 08:01 AM
0

Please also provide screenshot of your TIME dimension with businessday property

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

P.S. What BPC system are you using? MS or NW?

0
Dipal Patel Dec 02, 2016 at 11:56 PM
0

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


timedimension.jpg (395.1 kB)
Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Dec 03, 2016 at 07:35 AM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
Dipal Patel Dec 05, 2016 at 03:49 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded