ORA-18516
The attribute string referenced in the base measure "string" must be determined by the JOIN level "string".
Cause
The specified attribute is not determined by the analytic view (AV) JOIN level. Therefore, there is no value to use for the aggregation.
Action
Remove the invalid attribute reference or modify the DDL so that the attribute is determined by the JOIN level.