Hi All,
I am encountering an issue while loading data to an ASO application using Export Mode (Replace) in Data Management.
Issue:
The load fails during the partial clear step with the following error:
Cannot Clear Partial Data.
Essbase Error(1260046): Unknown Member [Department].[D_111] used in query
What I've verified so far:
Member D_111 exists in the target ASO application's Department dimension.
The application outline has been refreshed/deployed.
Data Management mappings are valid Like Mapping:(* -> D_*).
The member is still active and present in the source data.
The load succeeds in Merge Mode.
The load fails only in Export:Replace Mode during the "Clear Partial Data" operation.
D_111 is a shared member.
From the process log, Data Management generates a large MDX clear statement that includes:
[Department].[D_111]
before issuing the partial clear, and Essbase reports D_111 as an unknown member.
Questions:
Has anyone encountered Essbase Error 1260046 during ASO partial clears involving shared members?
Are there known limitations with Data Management's generated clear-region MDX when shared members are included?
Is there a recommended approach to handling shared members in ASO Replace-mode loads?
Has anyone resolved this without converting the load to Merge mode?
Any insights or similar experiences would be greatly appreciated.
Thanks!