I would set up the Audit Logging, then build and ORDS endpoint on top of the audit data to source the relevant data via API.

Hi @HanselM4, Few things to check: * User is a native IDCS user account that is not federated with another Identity Provider * Host Name should follow this pattern <cloud_name>.analytics.ocp.oraclecloud.com * SSL should be checked & the Trust Store password is: changeit Give that a shot - once you confirm the connection is…

Is this process as easy as exporting & importing a workbook with the underlying dataset? I imagine if you're moving a dataset built on an ADW table across instances you would have to make sure your secondary instance is configured to connect to the respective ADW instance (i.e. Uploading the wallet, creating a connection…

@Sahithi Kolasani-Oracle : https://medium.com/p/1799f6ba4626

Hi Bret, Thank you for the suggestion. We've tried this and it gets us 95% of the way there. While setting the Subject Area permissions in classic restricts user's abilities to select the Subject Area during a 'Create Workbook' process flow. However, the limitation with this configuration is with workbooks that are already…

This may be more trouble than its worth, however, it looks like there is a lot of flexibility in passing filters in OAC DV Embedded Content within an Oracle APEX application. This is the best blog I've found that walks through the process of embedding the DV, as well as passing through filters via APEX items. I imagine you…

Are you getting any error message on the calculation? Do you have any of the session logs to see what this computes to?

Hi Gianni, For additional context, the groups are mapped to custom application roles, so I've referenced to them synonymously. I have Presentation Layer permissions with the following configuration AuthenticatedUser -> No Access to Headcount Analytics & Finance Analytics (otherwise all subject area' are accessible)…

@Amrita Gupta-Oracle - any luck with the proposed solution?

Hi @Amrita Gupta-Oracle, I haven't tested the theory, but you might be able to leverage some of the functionality explained in this article to have APEX dynamically update the name of the column of the embedded analysis. You'll see a piece of the article where they're define a function to dynamically change an embedded…