Oracle Analytics Publisher

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

Categories

BI Publisher report doesn't fetch data for a global level function.

Received Response
57
Views
6
Comments
User_63UA4
User_63UA4 ✭
edited September 9 in Oracle Analytics Publisher

I have created some global level functions to a DM and have been using a external template for report, I could see the data in the template viewer while building the template but when I upload the same template back in the OAC and run the report I don't see the expected output I have been using several global level functions and this is happening with only couple of functions/fields. Did anyone face the same issue? please share your thoughts on this one

I feel the issue is with the Summary function, I am using integer data type with that function. Please let me know if anyone used summary global function before.

Tagged:

Answers

  • Sandeep S. Chauhan-Oracle
    Sandeep S. Chauhan-Oracle ✭✭✭✭

    You should generate the output as Data(XML) and verify if you are getting all the missing columns in the XML data file. If those missing columns are appearing in XML fille, then there should be issue with layout template, correct your layout template for example column name, proper XPATH should be used if those are defined within the repeating loop, etc.

  • User_63UA4
    User_63UA4 ✭

    yes I have done that, I am able to see the expected output when I test it out using the template viewer but when I deploy the same template in the cloud and run the report instead of actual data I get '0's in that field.

  • Kevin M-Oracle
    Kevin M-Oracle ✭✭✭✭

    The template viewer does not execute global functions.

    It just uses static XML data and runs it against the layout template.

    This issue is occurring during the data generation phase.

    So you have to troubleshoot the global function in the Data Model.

    The data engine log is a good resource to see why the functions are not returning values.

    Rgds,

    Kevin

  • User_63UA4
    User_63UA4 ✭
    image.png

    I do see the data in my data model, as there is data in G_3 Total row but when I run the report I see '0' instead of 91 and it's happening with only the last two columns I'm able to fetch the report fields for all other columns in the G_3 Total

  • User_63UA4
    User_63UA4 ✭

    I am able to see the data in my data model, xml file downloaded after running the DM and template viewer while building the template but not in the report from OAC. I have tried recreating template, recreating DM and report too

  • Kevin M-Oracle
    Kevin M-Oracle ✭✭✭✭

    Again, if you do not see the data you expect, the data engine log can be a very helpful tool in troubleshooting your custom data model.

    Rgds,

    Kevin