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

Map default_movement in accounts dimension to a movement member in data exchange

Summary:
We have created customized movement dimension members for our current client and utilized the default movement attribute in the account dimension. However, we encountered an error when attempting to use SQL to pull the default movement member to the movement dimension. Below is the SQL query (in the code snippet) and the corresponding error message:

SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Content (please ensure you mask any confidential information):

I would like to confirm the correct tables for the account and movement dimensions. Additionally, I am interested in knowing whether the data exchange supports these tables and attributes.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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