Not able to drill through to source while connected to ADB cube in ERP
We are not able to drill through to source from ARCS after connecting to ADB cube in ERP (Direct Connection) .
We have a client requirement to connect to ADB cube in ERP to fetch EOD baalnces each day. We have done all the configurations accordingly and was able to successfully pull balances from ERP . While performing drill through to source from ARCS GL balance, we land into an error Cannot perform cube view operation. Essbase Error(1260046): Unknown Member null used in query on ERP side. In this context, I would like to know if its feasible to drill thru to source after connecting to ADB cube or is there anything I am missing to make drill thru functionality work properly here.