Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Field is in DM but not showing on BI Publisher to add to template

Accepted answer
286
Views
9
Comments
Sean-B-01
Sean-B-01 Rank 4 - Community Specialist
edited September 2024 in Oracle Analytics Publisher

I'm trying to add a field to a BIP report and the field is included in the DM. When I open the template and access BIP and select field to add it to the template the field isn't available as an option. Does anyone have any troubleshooting tips on how to get this field to display?

Tagged:

Best Answer

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead
    Answer ✓

    Yes, if you upload the sample file to the BIP Plugin in Word.

    You should be able to select the data element using the Field dialog.

    Rgds,

    Kevin

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @Sean-B-01

    No, I didn't faced this issue.

    Can you share me your BIP version ?

    Are you facing issue while mapping the xml column field or not able to see the same in xml file.

    Regards,

    Arjun

  • Sandeep S. Chauhan-Oracle
    Sandeep S. Chauhan-Oracle Rank 5 - Community Champion

    Hi @Sean-B-01 , I think you are facing this issue with XPT layout template. I would suggest to regenerate the XML data in Data model → View Data → View (Make sure new field is available) and click "Save as Sample Data" . Now try adding the new field in the template.

  • Jared Lonsbury
    Jared Lonsbury Rank 1 - Community Starter

    This might not be the issue, but if the field value is NULL in your date model (even if the column appears) that field will not show up when creating your report via the BI plugin for Word.

  • Sean-B-01
    Sean-B-01 Rank 4 - Community Specialist

    Hi @Mallikarjuna Kuppauru-Oracle ,

    I can't find where to exaactly check my BIP version, I know it's 64 bit and was downloaded & installed on this computer in July 2024.

    My issue is that I took on this Data Model and report to make a small change for an end user, the field they would like to see in the report is already in the Data Model, I didn't have to make any changes. When I open the report in BIP with the associated DM, the field doesn't show up to add to the report.

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    What type of template are you modifying: RTF, XPT, Excel..?

    Open the sample data file in the data model, is there data in the field you ant to add?

    Rgds,

    Kevin

  • Sean-B-01
    Sean-B-01 Rank 4 - Community Specialist

    Hey @Kevin M-Oracle

    I'm using an RTF template, data shows for the field in the sample data for the model.

    I can export the sample data and attach it to the RTF template, would you suggest that as the workaround for my issue?

    Thanks,

    Sean

  • erp_expert03
    erp_expert03 Rank 1 - Community Starter

    I haev same issue, i added a column in data model, saved sample data, column not null, downloaded RTF template, when I go to Field Browser, my new column is not present.

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    You have to edit the RTF an add the new fields.

    Rgds,

    Kevin