We are attempting to populate the Order XML payload using the orders that need to be navigated from Oracle Analytics Cloud (OAC). As part of this effort, we have evaluated the following approaches:
- Semantic Model Approach – This approach was not feasible because of the CLOB limitation, as is it only supports payloads only up to 32 KB.
- OAC to BI Publisher Navigation Approach – We also evaluated this approach; however, it did not fully meet our requirements.
Apart from these approaches, are there any alternative methods that are more compatible, provide better performance, and ensures that all OAC users who have access to the report can also access the corresponding XML payload?
