General OBIEE

Get Involved. Join the Conversation.


    Aaron Leggett
    Extracting all Columns from BIP Query without creating...
    Topic posted September 14, 2017 by Aaron LeggettGold Trophy: 10,000+ Points, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Reports, Data Models, Report Layouts, Report Output 
    356 Views, 2 Comments
    Extracting all Columns from BIP Query without creating layout?

    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 :(