Oracle Cloud Data Management - Issue with Shared Members in Source Filters
I have built a data integration between PBCS and PCMCS cloud using data management. I have selected @Level0Descendants of Revenue Accounts in Data Load Rule source filters. Some of the members under this parent are defined as a shared member elsewhere in an alternate rollup (These shared members does not fall under the Revenue accounts which I selected).
Now, while I am trying to run the integration it is giving me an error Essbase error(1260046): Unknown member Revenue Accounts used in query.
I tried using qualified member name still it did not work. Only workaround I have is to select the members under Revenue Accounts individually. Any inputs are appreciated. Thank you.😊