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

Question

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.

Kevin M-Oracle · Answer

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

Eshwar Kappala · Answer

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

Eshwar Kappala · Answer

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