Dynamic filter in BPC input form

[Former Member]

Hi experts,

I have created in input form that contains the following dimensions :

Columns :

TIME (P1, P2, P3)

Lines :

PROFIT_CENTER (Profit center 1, Profit center 2)

DISTRIB_CHANNEL (Channel 1, Channel 2)

I need to display only channels that are related to each Profit Center.

For example, :

                                                     P1      P2       P3

Profit center 1        Channel1        

                             Channel2

Profit center 2        Channel3

                            Channel 4

The problem is that when I create the input form, I get all the Channels by Profit center which means :

                                                     P1      P2       P3

Profit center 1        Channel 1        

                            Channel 2

                            Channel 3

                            Channel 4

Profit center 2        Channel 1        

                            Channel 2

                            Channel 3

                            Channel 4

I have created a property Profit center in the dimension DISTRIB_CHANNEL to use the filter function in the input form but it's not working.

How can I perform this ? Is it possible to apply a dynamic filter or something ?

I'm working with SAP BPC 10.0 NW for HANA (CPMBPC 801 SP05 and EPM Add-in SP19)

Thanks

Maha

[anil_agrawal]

Hi Maha,

There can be two possible ways for your query

1)  If You can maintain  the master data , Use Dimension Property option in EPM Member Selector where you have to maintain a property for the preferred combination.

Or

2) You can use the exclude member tab in EPM Report editor  by excluding the combinations that are not required .

[former_member186338]

Hi Maha,

Why not to use search? This question is asked each month

First of all, the relation is one to many or many to many?

Is it possible to have:

Profit center 1        Channel1        

                             Channel2

                             Channel5

Profit center 2        Channel3

                            Channel 4

                             Channel5

Vadim

[Former Member]

Hi Vadim,

Thanks for your reply

Yes it's possible, N - N relation

Maha

[former_member186338]

For N-N there is no direct way, you can't store N-N relationship in some property.

Please read this:

Vadim