Hello,
Is it possible to export data from FAW to Excel for use in another application? Is there any internal feature available for this purpose? If not, what would be the suggested solution?
Please refer :
Export Your Oracle Analytics Workbook to Excel
https://docs.oracle.com/en/cloud/paas/analytics-cloud/tutorial-export-to-excel/index.html#before_you_begin
Hi Enio! I'll leave the answer on how to do this to @Krithika Raghavan-Oracle and others in our organization, just curious what you're wanting to do that requires moving the data out of Fusion Analytics? The more we understand about your use case, the better we are able to help. Thanks!
Yes, you can export Table/Pivot view data from FAW OAC DV to Excel Manually.
@RanaAshutosh-Oracle Thank you, I really appreciated your response. Could you please tell me the reference for better research?
@Emily Cikovsky-Oracle Thanks for the answer. I'm just researching FAW and have this question.
@Enio Lacerda ,
There is an option in System Settings of FAW's console to enable excel export for a table or pivot table. By default it's disabled but can be enabled by a FAW administrator.
Once, this is enabled you should be able to see the excel option listed when you try export functionality for Table and Pivot views in OAC DV.
@Enio Lacerda As mentioned by Emily, it would really help to understand your use case. Excel is supported, but there is a rowlimit. Please refer to documentation for the limit. CSV lets you export larger data sets.
Hello. We are using the HCM - HR Help Desk Requests Overview subject area in FDI for building workbooks. We need to modify the calculation for ticket Resolution Time to "pause" the counter during non-business hours. We don't want the tickets to age, when the person the ticket is assigned to is not working, and have our…
We are building dashboards in FDI, using HCM data. Can anyone advise on best practice for designing front-end access to FDI for different user groups (e.g., Executive, Line Manager, non-Managers, etc.)? Not from the security configuration side, but from the design planning side. We have granted access to only one group by…
Hi All, Previously, I used Data Actions → Analytics Link to navigate between two canvases in FDI. However, I can no longer find this option in the current FDI interface. Has anyone else experienced this? What is the recommended way to create canvas-to-canvas navigation now? Thanks in advance!
Hello, I need to grant users access to FDI without giving them the module security groups, such as ERP, HCM, etc. In FDI, I have other external connections, and I don't want them to see any other modules, so my question is: Is there any other FAW security group that grants access to FDI without allowing users to see the…
With the release of Fusion Operational Analytics, I understand that OTBI Subject Areas will be made available within FDI, but I'd like to know the following: 1) Can I migrate OTBI reports and/or dashboards over to FDI for use by FDI consumers? Are they brought through the OAC Classic layer of the FDI/OAC platform? If not,…