Categories
- All Categories
- 141 Oracle Analytics News
- 26 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 52 Oracle Analytics Trainings
- 11 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
FDI: Timestamp column values are not getting extracted during BI Publisher Data Augmentation
Hi,
I am trying to utilize the BI Publisher data in FDI. I have created the simple BIP report and trying to load that data using data augmentation. But when I execute the step, the data got loaded successfully. But for the timestamp columns are loaded with null values. Could you please help me on this?
Answers
-
Hi @Sathyaprakash M,
We will probably need a little more information to answer this.
What is the datatype in the source?
Try entering a Date Format and a different Timestamp format.
0 -
@Sathyaprakash M - I could see you have already set CSV Timestamp Format from the screen shot. But, unsure when it was set, before running Refresh metadata or after. Kindly follow below steps in same order and let us know the feedback. Thank you.
1. Navigate Manage Connections > BI Publisher Connection > Edit > Update the CSV Timestamp Format to yyyy-MM-dd'T'HH:mm:ss.SSSZ
Please refer
2. Refresh Metadata
3. Reset cache as mentioned in the document
4. Refresh data and verify.
0 -
Hi @JohnW-Oracle,
I have attached the screenshots above, from BIP report, I am trying to extract the DATE_FROM column and it is in timestamp format. In the BIP Connection, I had given the timestamp format as yyyy-MM-dd'T'HH:mm:ss.SSSZ and after the data augmentation, the timestamp column values are showing null value and rest of the columns are loaded with actual data.
Screenshot details:
- BIP Connection details(which includes the timestamp format)
- Actual BIP report(from Fusion)
- ADW Table(after dataload)
0 -
@Sumanth V -Oracle - Initially I had set the timestamp format in the BIP Connection and after that I did the metadata refresh and data extraction
0 -
Hi @Sathyaprakash M,
For '2. Actual BIP report(from Fusion)', there is no Timestamp in BIP so you should look back to the datatype in the Fusion source.
Regards,
John
0 -
Hi @JohnW-Oracle,
I have checked the BIP datatype in the data augmentation page and it is in the timestamp format. Could you please help how to load these data type into FDI?
0 -
@Sathyaprakash M Were you able to resolve this issue?
I am facing same issue.
0 -
Hi @Sathyaprakash ,
Try setting the CSV format as yyyy-MM-dd'T'hh:mm:ss in manage connections and refresh the metadata, try re-running the augmentation again
1 -
Hi @phaniphani,
The action plan that you provided has worked for me. Thank you so much !
1 -
@Sathyaprakash M, you can also test in your instance,
0
