Oracle Transactional Business Intelligence
Extracting all Columns from BIP Query without creating layout?
I have to extract all the columns from 11 different tables for our finances guys to sift through and see what data they want. Some of these tables have 100 or so columns and I really don't want to tediously have to drag and drop each column in via the report creator. Is there a simpler way to extract all the data from a data model?
Also, I can't seem to get the BI Publisher tools working for Microsoft Office so won't be able to utilise any ideas using that i'm afraid
If you create a report template with CSV format then you don't have to drag and drop any columns and it can extract more than 60 columns.
You can download the BI Publisher desktop tool from the below link,
The following link has the details to create a RTF template.
In the section, “126.96.36.199 Step 2: Selecting Table Data” while creating the table if you click on the highlighted button all the datamodel columns will be added to the report
Refer to attached image.
Let us know if it works.