Oracle Analytics and AI

Dataset created from DataFlow gets added to a workbook but no fields appear under the dataset

Has anyone else had this issue? We have a large dataset created from a dataflow that we pull into a workbook. The dataset appears in the data panel, but none of the fields appear. If we open the dataset, we see all the fields and the data, but they just won't show in the workbook. Oddly, we tried a strange workaround where we pull this dataset into another dataflow, simply add a Save step, run it and create a replicated dataset. That dataset and all the fields appear in the workbook. it's very strange.

Find more posts tagged with

Data Flow

Dataset

missing fields

dataset fields not appearing

Accepted answers

All comments

Gianni Ceresa

Hi,

What product (name, OAS or OAC, and version) are you using?

And what does "large" mean in your case? How many columns and rows approximatively?

Thanks :)

Bret Grinslade - Oracle Analytics-Oracle

One troubleshooting step can be to delete the output dataset and try re-running the data flow. Note — you will need to reapply sharing permissions on the output dataset after running it for other users to access it.

MJC

@Gianni Ceresa about 85 columns and close to a million rows, OAC (current version)

MJC

some additional context: We experienced this issue again. these were the replication steps. We created a data flow and ran it. then, we needed to create a second data flow that was similar to the first, so rather than recreate it from scratch, we did a "Save As" on the original and updated from there. We gave the dataset in the Save step a new name, ran it, then experienced the issue again that I originally described. I ran it a second time, and I noticed it updated the dataset from the original data flow. It seems like it is some sort of caching issue when you do a Save As on a data flow to create a new one. I tried this again from scratch but this time created the second flow without doing a save as, and I had no issue