Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Drill Down from ARCS to GL gives Error "Cannot perform cube view operation. Essbase Error(1260046):

in Account Reconciliation 2 comments

Build an integration between ERP GL and ARCS using Data exchange. The balances are coming over without issues but when using drill through to source, it is giving an error (One actual example given below)

Cannot perform cube view operation. Essbase Error(1260046): Unknown Member [All Company Values].[011001400CAD01] used in query

After further investigation, it was observed that 011001400CAD01 is the profile dimensions added as Merge ID in the Map Dimension portion of the
integration. (Profile comprises Company-Account-Intercompany; Merge Id defined as Company-Account-Intercompany-Currency)

I tried adding a source expression to add a prefix between the Company and Account Dimension and the same prefix was showing in the error message in the expected position.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!