I suggest that you create a test user that has the correct custom application role as it is quite possible that your account might have other roles granted to it. I'm assuming that you will have admin access as you mentioned that you made changes to the semantic model.

How are you testing this? Are you using a user that has the correctly granted application roles? Have you checked th query logs to see if the filtering is applied to your queries?

agreed. The current process is quite convoluted to get an id of an object.

I agree with this feature request which will help simplify the automation of a number of OAC administrator tasks including backup and disaster recovery as well as catalog artifact deployment. This is one step that adds complexity to the automation process.

depends on what you mean by reports. If you mean BI Publisher reports then there’s a different way of tracking these if you mean classic dashboard and analyses as well as the data visualisation workbooks then usage tracking is the way to go.

A feature that enables you to dynamically show/hide visualisations in your workbook will be included in the upcoming November 2024 update. This might give you another means of achieving your requirements.

Your screenshot of data and visualisation screenshot seem to be of 2 different sets of data. The visualisation should just return the data with the nulls as you can see below. Can you provide more information on what you're trying to do?

This is because the data behind the sankey chart in the YouTube video seems to have a hierarchical structure where certain financial metrics roll up into higher-level metrics.

is this a screenshot from OAC? I don't believe it is as OAC automatically aligns the left and right of the sankey chart. I have attached a screenshot of a sankey chart with 3 categories similar to your screenshot and as you can see it lines up the left and right sides automatically.

Your best bet would be to make use of the Oracle Analytics REST API that retrieves catalog items by type. You will probably have to use the API for each item type (workbook, dataset, analyses etc) that you require.

This YouTube video demonstrates how you can import your Spatial Studio map layer into DV (it's based on an old version of OAC but the fundamental principles should still apply to newer OAC versions). @Philippe Lions-Oracle might be able to give more information on this.

For an analysis to run for 10 minutes would suggest that there is a large volume of data being processed. Reducing the data volumes being processed can help improve performance and potentially clear these types of issues. Do you actually need to return all that data or is there a chance that a redesign can reduce the data…

As @Gianni Ceresa said, you can use the double column descriptor id feature in your rpd/semantic model. If your underlying data source isn't from an rpd/semantic model, you won't be able to use the double column descriptor id column feature. Double Column feature.

In that case, an SR might be the best line of action as there seems to be something fundamentally wrong in your environment.

@User_HM2WL, I think you may have missed out your question.

@user6091159, did you do a check consistency test? Are you able to convert the model to a binary rpd file and open in the admin tool? It's also well worth opening an SR for this in parallel.

The storage size for Oracle Analytics Cloud data files is 250 GB. This is shared across all users. The limit is 50 GB for a single user. OAC Sizing options: 

do you know if your instance is possibly being updated to the September 2024 update? It's worth checking if this might be what's causing this.

Will there be any details on the rollout dates? Is the rollout just OCPU based? My other question is this feature dependent on the September 2024 update?

if I understand correctly, your code populates the parameter. If so you need to check the Exclude option of your filter and then also add your parameter to the filter section of your visualisations. In the example above, I can set the value of the Exclude Year parameter and once it's added to the filter section of the…