Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How can I extract data by creating dataflow ?
Hi Community,
I need to download data from DV but as you all know there's a limitation on 1000 lines. My workbook is large so I am looking for an alternate method for data download in one go except for dividing data into chunks. So I came across a solution, by creating dataflow we can download over 1000 lines of data. But I don't know the process or steps for it. So it would be great if someone can guide me with the same.
Best Answer
-
@User_2QQI0 can we get more insights on your requirements here ?
What is limitation in dv for 1000 lines? is that Dataset file-based ?
if we get more details we can suggest best Options for youI hope you elaborate more about the requirements so we can help
0
Answers
-
@User_2QQI0 - Data flows serve to combine, organize, and integrate data into datasets. Please refer to the document below to review all available options in data flows for integrating and organizing your data.
1 -
Posting only a title isn't going to get you many replies.
The more time you invest in writing a full question, the more chances to get a valid reply you get.
For example things like what kind of "extract" do you have in mind? Let's not turn this into an XY problem: state your need and products you are having available, instead of thinking data flows is the thing you need and you just need to figure out how to make it work the way you decided it should.
Also, please update your profile by setting a "profile name" (also following the Oracle rules for employees to identify as Oracle).
Edit: OP now edited the question to add some content…
2 -
About Data Flows
2 -
Max rows exported to formatted reports for a classic report/dashboard is set to 1000 for a 1 OCPU instance. Based on your description that you are hitting 1000 row limit, I presume you have a 1 OCPU instance. If yes and If you are running a production workload, its strongly recommended that you scale up your OCPU.
The row limit for export for formatted and non-formatted reports is documented here :
As for your statement about finding a solution using dataflows to overcome this limit, what is this solution that you are referring to? share details.
Thanks
Gayathri
2
