Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 272 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Oracle Analytics Cloud - SmartView Capabilities
I'm looking to export reports into Excel for purposes of refreshing the report frequently for most up to date data. I have experience doing this with TRC and FCC, but am unsure of OAC's ability to do this. Some articles say that the refresh capability is doable, but you have to build/recreate the report in excel (no export feature). Just looking for some guidance - can you export directly from OAC into a SmartView enabled excel workbook and refresh the file for new data?
Answers
-
Hi @User_65672 ,
Welcome to the Oracle Analytics community and forum.
You can't export a "refreshable report via SmartView" from OAC.
SmartView should be seen as a different "interface" to query data accessible in OAC.
But from SmartView you should be able, if I'm not wrong, to point to an existing object in OAC (in my memory it was working with "classic" analyses) and that will get you started without needing to recreate everything from scratch.
But it's a number of years I didn't use SmartView with OAC, therefore I'm maybe remembering a bit wrong :D
From this doc it looks like what I remember about SmartView…
0
