Skip to main content

Posts

Showing posts with the label Fusion BI CSV

Do you know how to create Data Model and Report from CSV Input File in Oracle Fusion?

In this blog, we are going to see how to create Fusion BI Data Model using CSV File as a Data Source First prepare the CSV file with your data. You can use any of the 4 delimiters Comma(,) Tab( ) Semicolon(;) Pipe(|) When I open the CSV file using Notepad++, the data looks like below To upload the CSV file to BI Data Model, select below option in the "Data Sets" Enter a name for the Data Set, Select "Local" and upload the file. If your data has headers, then check the "The first row is a column header" Select your CSV Delimiter, in my case I have selected "Comma(,)" As we did not include headers in our data, the Data Model assigns default header columns Column1, Column2.... etc This is how the Table View of the Data looks like. Save Data Model, Click "Save As Sample Data" button and Click "Create Report" button Select "Use Report Editor" and click "Finish" Select ...