This discussion is archived
3 Replies Latest reply: Mar 11, 2013 9:24 AM by metalray RSS

Oracle BI Publisher no columns loaded from data model

metalray Newbie
Currently Being Moderated
Hello Guys,
I use Oracle BI Publisher 11g. Have created a data model by using
the JDBC thin connection to a 11g database. The creation of the data model
worked fine using a SQL query. Now in the report creation wizard, I select
the "guide me" option to see how nice the wizard is.
The problem comes here, on the second window I should select the columns
but I only read "no columns available". Why is that?
  • 1. Re: Oracle BI Publisher no columns loaded from data model
    metalray Newbie
    Currently Being Moderated
    When I skip the wizard and try to create a RTF template
    I get the following error "XML Parsing Error: no element found".
    The xml sample data file for the data model was created and I can view it.
  • 2. Re: Oracle BI Publisher no columns loaded from data model
    982496 Journeyer
    Currently Being Moderated
    Hi Metalray


    For BIP report sample XML data is importent. with sample data you cannot generate the BIP reports.

    Follow the below steps, you can achieve your expected BIP output

    After crating data set in the data medel save the data model then click on
    --get XML output option on right side of the top-corner.
    -- then selet no. for the nuber of rows to return dropdown option,
    --then click on Run. Then save the sample data by clicking on Save as sample data option.
    --then it will take you to the data model page, now again save the data model
    --and use it for creating the reports.

    Now you were able to see the available columns in the the second window of guide me option

    please mark if it helps you..
  • 3. Re: Oracle BI Publisher no columns loaded from data model
    metalray Newbie
    Currently Being Moderated
    Thanks for you reply. I did this a million times but it does not work. I can design the report when I dont use the wizard, the colums show fine then but not using the wizard.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points