Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

Hi Prasanna. Please try to run this and check the logs for some more detailed error information. https://blogs.oracle.com/analyticscloud/4-steps-to-oracle-data-visualization-diagnostics-support Cheers Fernando

in DV Tool Dataflow Fails at Join Step Comment by FPonte Jan 9, 2020 8:28PM
Hi Prasannasrinivasan. I was expecting to see some extra information on that error. Questions: Are the attributes in the JOIN of the same data type? If they are not maybe is necessary to add an additional step to make them to be of the same data type. Are you able to run a Data Flow for each one of the files in its…

in DV Tool Dataflow Fails at Join Step Comment by FPonte Jan 9, 2020 8:51AM
Hi Prasannasrinivasan Are you able to share the entire error message with us, please? Cheers Fernando

in DV Tool Dataflow Fails at Join Step Comment by FPonte Jan 9, 2020 1:05AM
Hi Chethana. Thanks for your reply. Again, assuming that you are not doing any complex transformation in the Data Flow. What happens if you run a query in the database with the same join in the data flow? Are you able to run that and see the time it takes to return all rows? My suggestion is to instead of losing more time…

in How to extract "SQL Query" that is internally run by a dataflow in OAC-Autonomous Comment by FPonte Jan 8, 2020 8:19PM
Hi Chethana. Questions: Assuming that you want to see the query the data flow is running, I imagine that you want to verify the performance against the database (Autonomou DW) right? Are the tables in the same database? Is the join between columns with the same data type? Are the columns indexed? Please, give us a little…

in How to extract "SQL Query" that is internally run by a dataflow in OAC-Autonomous Comment by FPonte Jan 8, 2020 9:44AM
Hi Bipul. The only way I think this is possible is using SubTemplates together with an IF-ELSE statement in a master template. Check this. Calling a Subtemplate from a Main Template https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-43E24DE3-F1DE-47E1-8B2F-C8ED59D619BA.htm#BIPRD3064 Cheers Fernando

in Same Data Model - Different RTF Templates - How can a template be picked dynamically based on a valu Comment by FPonte Jan 7, 2020 10:40PM
Hi all. Adding for Prasanna comments. OAC Documentation explains better the Limits on the Plan Your Service section https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsom/create-services-oracle-analytics-cloud.html#GUID-164D8568-9AE3-4A74-9F1A-0D87B78713C9 Cheers Fernando Ponte

in Development environment. OAAC Remove Row limit Comment by FPonte Dec 19, 2019 10:43PM
Hi Mthompson. Did you try looking at the BI Publisher log? Should be on the following folder: BI Publisher: [DOMAIN_HOME]/servers/bi_server1/logs/bipublisher/bipublisher.log Another option is to get the View Engine Log file from the Data Model and investigate if there are no errors there. Cheers Fernando

in BI Publisher Bursting - failure log? Comment by FPonte Dec 19, 2019 1:26AM
Hi Brian. Please have a look at these Docs. Oracle Support Document 2288114.1 (OAC : How to increase number of rows for Exported to CSV/Excel in Oracle Analytics Cloud Service) Oracle Support Document 2397833.1 (OAC : What Is The Mapping Between The Compute Shapes and DefaultRowsDisplayedInDownload, CubeMaxRecords,…

in How do I resolve: FETCH FIRST 500001 ROWS ONLY Comment by FPonte Dec 19, 2019 12:53AM
Hello Ankitkumar. Not sure which Subject Area you are looking for but check the following doc. OTBI Audit Reports - where to find Created By, Last Updated By, Creation Date (Doc ID 2419093.1)It may give you what you need. Cheers Fernando

in Incremental Load in Data-Sync Comment by FPonte Dec 5, 2019 10:03PM
Hi Srekan. Yes, there is. Navigate to your Report Template, click on the table that contains your data and on the Table tab options change the value on "Rows to Display" (see image). If you are using a PivotTable, I don't think that is possible. Cheers Fernando

in Date with time data changes after exporting to Excel from BI publisher report - using NON RTF method Comment by FPonte Nov 11, 2019 8:04PM
Hi Srekan. Looks like you didn't get any reply on this. It is a RTF template you are working with? Have a look at the following options. https://docs.oracle.com/cd/E80149_01/bip/BIPRD/GUID-F8B5ACA1-6054-4028-8AC4-2BC43E12332F.htm#BIPRD2583 Cheers Fernando

in Date with time data changes after exporting to Excel from BI publisher report - using NON RTF method Comment by FPonte Nov 5, 2019 6:58AM
Hi Ibrahim. My two cents. You may try to create your own for the Desktop version. https://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/dvdesktop/viz_plugin/dvd_sdk.html Cheer Fernando

in Oracle Data Visualization: KPI arrow indicator Comment by FPonte Nov 4, 2019 8:13PM
Hi Duncan. Looks like the objective of this report is to export data using DV? Please correct me if I'm wrong. If that is the case please look at this. https://docs.oracle.com/en/cloud/paas/bi-cloud/bilug/write-visualization-data-csv-or-txt-file.html If it is not I'm not sure what the user is trying to see with this amount…

in Data Visualization return row limit (caching) in table view Comment by FPonte Oct 16, 2019 1:18AM
Hi Chethana. This may help. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/configure-notifications.html#GUID-885DF71A-6873-4B86-8EC5-771BC667EDDE Cheers Fernando

in How to create alerts and notifications in OAC? Comment by FPonte Oct 2, 2019 12:45AM
Hi Zunaira Please have a look on how to get more details from Oracle DV Desktop on this post. https://blogs.oracle.com/analyticscloud/4-steps-to-oracle-data-visualization-diagnostics-support Best Regards Fernando Ponte

in Error In Oracle Data Visualization Desktop Comment by FPonte Oct 2, 2019 12:36AM
Hi Atif. I'm assuming the SQL Query works fine when running in SQL Developer or other SQL tool right? Are you able to click on "View Data" and then "View Engine Log" and upload to the thread so we can investigate a little better. Please, if you want to remove any sensitive information from the log (server name, etc...), do…

in Parameters Failed to Load on BIP Using List of Value Comment by FPonte Nov 15, 2018 2:32AM
Hi Reddy. Sorry I was on leave. Check this on how to use conditional regions. https://docs.oracle.com/cd/E23549_01/bi.1111/e13881/T527073T564393.htm#tb_condr Cheers. Fernando

in Watermarks in fusion BI Publisher RTF Template Comment by FPonte Oct 10, 2018 11:57PM
Data Set Connection

in Changing the Data model connection to point to different database and data not being reflected Comment by FPonte Sep 17, 2018 11:15PM
Hi Prakash. It is just a hunch. See the images on my sample data model. First image is the Data Model Default Data Source Second image is the Data Set Data Source. Just check if is the correct one on the data set. May not be the problem but worth checking. Cheers. Fernando

in Changing the Data model connection to point to different database and data not being reflected Comment by FPonte Sep 17, 2018 11:15PM

More Comments

MFA for Oracle Community

Welcome to the Oracle Analytics Community

FPonte Rank 6 - Analytics Lead

Comments