While running DV workbook I am unable to export the output in excel format. It only shows exporting as excel and the process keeps on running for more the an hour although the data volume is very less and I get output in CSV instantly .
@Anand Singh Hi Anand,
Thank you for asking your question in the Oracle Analytics Community. This question requires additional customer specific context and detailed analysis. Please open a Service Request through My Oracle Support so we can better assist you.
@Anand Singh - Please let us know if the behavior is seen for a specific visualization or workbook. Also confirm if you are using OAC or OAS.
Sumanth V -Oracle I am getting this issue in some workbooks and in few workbook i was able to get the export in excel. I am using OAC.
Hi @Anand Singh,
The Formatted Excel format does have a 25k limit. So, in your Workbook, make sure you are returning all rows. Scroll down to the last record and check how many records have returned.
Regards,
John
Hi @Anand Singh
We have an KM note for the same also documentation for limit on downloads -
FAW:FDI:FDIP Export To Excel Is Exporting Only 25000 Rows For Visualizations (Doc ID 3027775.1)
Arjun
Thanks @JohnW-Oracle and @Mallikarjuna Kuppauru-Oracle , for the reply but in our case even a single row in DV workbook is not getting exported in excel , csv still works .
Description: Join the OCI Enterprise AI Product Management team for a deep dive into the latest product roadmap updates and upcoming innovations. During this webinar, we’ll cover key roadmap highlights, showcase product demos, and share insights into what’s ahead for OCI Enterprise AI. The session will conclude with a live…
Hi! I am looking for audit logging for Analytics objects, such as users creating, modifying, or deleting datasets, dataflows, schedules, etc. The traditional Presentation Services component provides such logging in domains/oas/servers/obips1/logs/auditjson.log, which contains audit information for catalog objects,…
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
Once I select that value from the list box Region I created, I want to filter the table by my selection. See the images