10-20-2023 07:29 AM
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
10-20-2023 11:40 AM
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).
10-23-2023 01:15 AM
Thanks for the response.
But here I want to replace only one account with different account, another should not get override.
10-23-2023 10:55 AM
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.
10-25-2023 02:04 AM
We have more than 4 columns to override, because of maximum column limitation we are looking for an workaround.
10-25-2023 11:11 AM
Your best bet would be to use an XFBR rule to run the logic and return what's needed in the cube view.