@Prabhjeet Kaur , Fusion and related elements like PVO are covered in a separate, independent, forum: If you look at the list of categories there (top menu), you can see that there are many analytics and reporting categories related to Fusion. You can ask questions about Fusion PVOs in there as it's the forum covering that…

@Marco Gaspar Silva , no need to repost your question, it has been moved to the OTBI category.

@Hugo Forbes , No need to repost your question, it has been moved to the OTBI category.

@User_U8Q9Z , you are in the right forum. What @Gaurav Bharadwaj-Oracle meant is that it could be the wrong category. And if it's the case, with more details, your question will be moved to the right category. But you are in the right forum (there is only a single Oracle Analytics forum, all the rest is categories allowing…

Hi, Welcome to the Oracle Analytics community and forum. Just to be sure on the topic of your question: which part of Oracle Analytics are you thinking about? DV (data visualization) workbooks? "Classic" analyses and dashboards? Or Publisher? I'm asking because currently the question is in the Publisher category, but you…

Just being "picky" on @KDR solution: use a UNION ALL instead of UNION. UNION will enforce a distinct constraint on the overall result to remove any possible duplicate, which is maybe not what you want. And even if your records are already unique and nothing will be lost, it does take quite some time based on how heavy is…

Hi, Is it really not working? The error you have is not really an error, it is just telling you that your "query" wasn't expected to return any column, while now it does return 2 columns. If you run it in the Issue SQL page, you can see the 2 columns: Somehow it looks like your old agent was executing a query expecting no…

For anyone with a similar requirement, up-vote this idea:

Same comment as before: the feature is not there, it just doesn't exist like it doesn't exist on-premises. Therefore you need to request the feature to be added to the product via an idea. The challenge is to know where you should raise the idea: in the OAC category or in the FDI category? The feature doesn't exist in OAC,…

Hi, If you are asking for a "classic" agent to do that, then that's a new feature that you are requesting. Publisher can do it already. You should look in to see if an idea about that already exists. If you can find it, up-vote it. If you don't find it, then post the new idea so the request for this feature will be…

Hi Roger, Are you saying that this screen is empty in your RPD? There isn't a single feature listed for your database of type "Apache Spark SQL"? If that's the case, it doesn't sound right at all… I don't have a 6.4 model admin tool around, but I'm quite sure it wasn't a new thing in that version, therefore the features…

Hi, Welcome to the Oracle Analytics community and forum. The best you can do is to change some settings in the "features" tab of the physical database object in the semantic model, that can impact how the system generate some queries (and there are some features related to extraction of the week of year from a date, worth…

No worries, you now have the right link for the VirtualBox forum :)

Hi, Welcome to the Oracle Analytics community and forum. You are in the wrong place, this forum is only about Oracle Analytics products, and VirtualBox isn't one of them. If you need help with VirtualBox and look for a forum, you should visit

It's also possible that by doing a drill in a pivot your Excel file contains lot of "hidden" data that reference back to that action and therefore the data isn't really a simple table as you maybe see on screen. If you manage to confirm the issue is always on a file you got by drilling into a pivot, you can then post an…

Please do not double post, the answer is still the same…

Hi, BICC and PVOs aren't an Oracle Analytics product. They are part of Fusion. Fusion and a few other cloud applications are covered in a parallel, but independent, forum: You will see there are a lot of categories, but in many of those Fusion categories you will find one about analytics or reporting. You can ask your data…

The Rest API for export is for DV workbooks: For a "classic" analysis, you should explore the SOAP APIs:

Hi, "classic" agents can't write to OCI Object Storage from OAC. DV export also doesn't write to OCI Object Storage. Therefore you can't "natively" do it from there. What you could do, for DV, would be to have a script that export via the Rest API and then write to your OCI Object Storage. But you will need to write the…

So, if your Contracts table had 0-1 rows for each supplier, it would be very simple, because that's just a simple snowflake you need "flat" into a single logical dimension. You do that by adding the 2 tables in the same logical table source of your logical dimension. The tool is smart enough to query the second (Contracts)…