Oracle Cloud Blog

In this blog, we are going to see how to generate output using Excel Templates in Fusion BI Publisher I am going to show this using sample data. This is my sample data Click "Export" button to download the XML file. This is my XML File Open a blank Excel file and save it as type "Excel 97-2003 Workbook" (.xls) I have created 3 tabs "Summary", "Detail" and "XDO_METADATA" XDO_METADATA tab is mandatory. Place the below text in XDO_METADATA tab Version ARU-dbdrv Extractor Version Template Code Template Type TYPE_EXCEL_TEMPLATE Preprocess XSLT File Last Modified Date Last Modified By Data Constraints: In the "Detail" tab create Header row as shown below Now add the XDO tags Select the blank ...

In this blog, we are going to see how to create Fusion BI Data Model using Excel File as a Data Source First and foremost, Oracle supports only .xls (not .xlsx) files in BI Data Model as of now. So use only .xls files. Format the data to be usable in BI Data Model The data should have a header for all the columns as shown below We can also have multiple tables (of data) in a single excel file as shown below When we use multiple tables (of data), define each table with a distinct name. Select the table (including header and data) and go to "Formulas" tab and then click "Define Name". The Name should start with BIP* Once the excel file is ready upload it to the BI Data Model Give a Name to the Data Set, select "Local" as Data Source and Click Upload Icon as shown below Once uploaded Select the "Sheet Name" and "Table Name" and click "OK". I have created 4 tables BIP_Name, BIP_Position, BIP_Grade ...