Account Override in Cube View

[nidhi]

We are trying to Override account member in Column.

we have 2 accounts being called in a single column, her we need to Override only 1 account member from the list of 2 accounts.

Below is the reference CV.

In the below screenshot we are having 2 accounts "A#100 and A#200" in Col2, here we need to Override only A#100 Account member with "A#300"

Currently problem which we are facing is it overrides both "A#100" and "A#200" with A#300.

Please let me know if we can overcome this by using some Business rules?

Thanks in advance!

Nidhi 

[chul]

You're correct, overrides will replace the entire row. In your override, you can list both accounts you want to see (e.g. A#200, A#300).

[nidhi]

Thanks for the response.

But here I want to replace only one account with different account, another should not get override.

[ryannelissa]

Is there a reason you don't want to split Col 2 into two separate columns? Then you will be able to override account 100 without touching the second account.  

[nidhi]

We have more than 4 columns to override, because of maximum column limitation we are looking for an workaround.

[chul]

Your best bet would be to use an XFBR rule to run the logic and return what's needed in the cube view.