Extracting all Columns from BIP Query without creating layout?

Aaron Leggett

Content

Hi Guys 

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  

Thanks

HarishS

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.

Regards

Harish

Manoj Madhavan

You can download the BI Publisher desktop tool from the below link,

http://www.oracle.com/technetwork/middleware/bi-publisher/downloads/index.html

 

The following link has the details to create a RTF template.

http://docs.oracle.com/cd/E25178_01/bi.1111/e22254/create_rft_bldr..htm

 

In the section, “5.4.2.2 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.

 

MANOJ

Dataterrain

www.dataterrain.com

 

Abhilash K - Deloitte USI

Hi Aaron,

I think you should try using BICC for this. It helps extract good amount of raw data from tables.

Thanks,

Abhilash

Nathan CCC

Hi Aaron,

As Harish said. Yes you can do this a simple way. Yes a report must have at least one layout. But the bit you are missing is that that layout can have no columns in it.  If all you want is data with no format then you do NOT need to tediously have to drag and drop each column in. So create your data model, create your report, add an empty layout using the online editor (you no not need to upload anything), then restrict the layout to output format XML and CSV. Done it took only a few seconds to build the report. Your output will be all the columns in your data model in the order they are in in the data model. XML and CSV always ignore the layout.