I checked the DataSource and tested the connection. That's working just fine. Connects successfully On Fri, Mar 30, 2018 at 7:17 AM, community-admin <

We OUD and Active Directory (AD). The Security area of the JDBC connection has no role to choose from to grant the access. Do I have to manually type in the roles and then grant them access? Shouldn't there be a list I can choose who to grant access to? As you can tell I am a BIP novice and trying to soak it all in. Thank…

The DataSource is correct and the same for all the LOVs . I tested the connection and it connects successfully. I checked both objects datamodel/report and Consumer has permissions. Not sure where to look next On Thu, Mar 29, 2018 at 9:11 AM, community-admin <

On Thu, Mar 29, 2018 at 10:45 AM, community-admin <

I tried it and analyze was the answer. Thank you very much for helping oout and making me a happy camper. On Tue, Feb 27, 2018 at 2:23 PM, community-admin <

Thank you YGUTTIKONDA. Interactive is set as the default format. The format is being set as PDF in the go url link. I am not sure how to code it to have interactive as the default display format of the report. &_xf=pdf&_xautorun=true On Tue, Feb 27, 2018 at 1:07 PM, community-admin <

Thank you. That helps. On Tue, Feb 27, 2018 at 1:44 PM, community-admin <

I tried changing pdf to xpt and got this error

I hit that limit when I tried exporting about 2 million rows. CSV will export the 1,048576 rows and truncate the rest. Does Excel have the same limit as CSV? Also default row limit in BI Publisher shows as 1 million but with a box that allows you to change that value. Not sure what value to increase that limit to with…

I was trying to use the interactive one on the system using a data model. Is that xml or xdo?. Looks like I may have to go the Excel route since I need about 100 columns in the report. With the Excel template can I still source my data from the database? On Fri, Feb 2, 2018 at 6:15 AM, community-admin <

When you use the Excel template you have to download your data and save in Excel sheets? Can you still use the database as you data source and use an Excel template? On Fri, Feb 2, 2018 at 7:08 AM, community-admin <

Thank you On Fri, Feb 2, 2018 at 12:20 PM, community-admin <

Sorry about that. Not sure why it will not work for you. I have attached the image. Hope you are able to view it. On Tue, Jan 30, 2018 at 10:39 AM, community-admin <

Hi Kavitha, I am using the following Oracle BI Publisher 11.1.1.9.0 (build:20171003.2259). See below a screenshot of the error. Redacted are just parameter fields and report name. I hope this helps. Thank you On Mon, Jan 29, 2018 at 11:56 PM, community-admin <

Thank you. This is helpful. I will try it out. On Mon, Nov 4, 2019 at 10:28 PM community-admin <

I will be hanging out with my Admin today to see if we can find the root cause of this issue. Will give update if resolved. On Fri, Sep 13, 2019 at 12:04 AM community-admin <

Thank you for your response. I looked in the job manager and below screenshot shows job completed fine. However, still no email sent out. I will speak to the admin to check the smtp server details. On Thu, Sep 12, 2019 at 2:24 PM community-admin <

Apparently it was an easy fix I needed. The report space trimming issue is resolved. I went to column properties --> data format --> Treat text as: Plain Text (don't break spaces)

Thank you SonPat99. Sorting achieved by using SQL query with an order by clause. On Thu, Jun 14, 2018 at 12:06 AM, community-admin <