Forum Discussion

nidhi's avatar
nidhi
New Contributor II
2 years ago

Account Override in Cube View

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 

 

 

Cube View
Reports
  • chul's avatar
    chul
    Contributor III
    2 years ago

    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's avatar
      nidhi
      New Contributor II
      2 years ago

      Thanks for the response.

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

      • ryannelissa's avatar
        ryannelissa
        New Contributor III
        2 years ago

        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.