BPC report based on owner property(multiple owners)

[former_member247531]

Hi Experts,

We have few costcentre's and the each costcentre has mutiple managers.

User want to select manager name and they want to see their only relavant cost centre's .

For example below are the costcentre's and owners, if user selects "BEN", then in the report they want to see only A,C, D cost centre's.

As this is a one to many relationship, could you please help me on how to acheive this.

How do we maintain multiple managers for 1 costcenter?

Thanks for your help.

Regards,

Srikant

[former_member186338 · Accepted solution]

You can store multiple owners in a single property (comma separated list with [...])

OWNER

[BEN]

[ANDY]

[SIMON],[BEN]

[BEN],[ANDY]

Then you can use LIKE:

=EPMDimensionOverride("000","COST_CENTER","OWNER LIKE '*[BEN]*'")

It's better to use square brackets.

[former_member247531]

Hi Vadim,

Perfect, thanks alot for your help.

Regards,

Srikant