Hi, You look for the BI Apps warehouse schema table? (you posted in the OBIA category) Or you look for that info in your Fusion application? If this is the case, you should post your question in the forum covering Fusion HCM: https://community.oracle.com/customerconnect It's a separate forum covering a number of cloud…

Hi Marco, No, no need to repost it :) Just to confirm: is your question at least somehow linked to OTBI? Because maybe that's not correct… As far as google tells me, Simphony is the Oracle's Cloud POS solution. It isn't an Oracle Analytics product by itself, but I assume it does come embedded with some form of analytics…

@Prabhjeet Kaur , Fusion and related elements like PVO are covered in a separate, independent, forum: https://community.oracle.com/customerconnect 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…

@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: https://community.oracle.com/products/oracleanalytics/discussion/10895/oas-dv-dataset-scheduling-and-moving-using-ftp-location

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 https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server to see if an idea about that already exists. If you can find it,…

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 https://forums.virtualbox.org/index.php

https://community.oracle.com/products/oracleanalytics/discussion/comment/69208#Comment_69208 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…

Please do not double post, the answer is still the same… https://community.oracle.com/products/oracleanalytics/discussion/26406/unable-to-find-bicc-pvo-names-for-tables-oss-ent-plan-estimates-oss-entitlement-plans

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: https://community.oracle.com/customerconnect You will see there are a lot of categories, but in many of those Fusion categories you will find one about…

The Rest API for export is for DV workbooks: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acapi/api-catalog-workbooks.html For a "classic" analysis, you should explore the SOAP APIs:…