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.
Tagged:
0