My clients are desperate for this functionality! Must need!

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…

Based on the thread, I'm assuming all Analysis and Dashboards are in the Classic OBIEE view. If that is the case you can set the export property at the dashboard/analysis level. When working in the Data Visualization side of OAC, I haven't found a simple way to limit exports of the canvases.

This can be easily accomplished by using a Text Box and adding a hyperlink.

You should be able to manually change the appearance of these values to remove the decimal. If you select the Measures tab then navigate to your measure and change the Number Format, you can remove the decimal.

What type of databases are you using? I've ran into situations where I was pulling data from 2 different ADW's and was required to load the cwallet.sso file from a Regional Wallet to the OAC Connections Console. May be worth a try...

What is the error message you're receiving?

The method below is only feasible with a small amount of Products. You could create a separate analysis for each product grouping and in the measure parameter you can filter to specific products: MAVG(FILTER(SALES USING PRODUCT = 'P1'), 5) Otherwise, you can use the EVALUATE_AGGR function which allows Aggregate Functions…

To my knowledge, there aren't OAC API's that allow you to source reports directly from your catalog and attach them to an ODI process. The process Indranil laid out is the best practice standard we follow for sharing OAC reports. Everything would still be driven via the configuration table, however, in this case you are…

Are all 3 instances leveraging the same IDCS instance to control IAM?

Typically this would be handled by creating your own Date dimension with your custom defined Financial year