You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Extracting all Columns from BIP Query without creating layout?

edited Sep 14, 2017 12:54PM in General Transactional Reporting (OTBI) 2 comments


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  


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!