yellow fin bi is unable to recognize user defined data type of PostgreSQL sql

Hi Shashi,

Thanks for reaching out. Can you be more specific in your inquiry? Yellowfin BI does in fact interact with PL/SQL.

Where are you inputting scripts that you are not getting results? What is the error message in the application? What are actually attempting to do?

I look forward to your response.

Regards,

Mike

Hi Mike,

I am not talking about PL/SQL that is a language, I am talking about POSTGRE SQL database. so whenever I am importing and user defined column of POSTGRE SQL database in Yellow-fin BI, every time it is taking as unknown datatype and I have to create the calculation every time to display the data.

for e.g . I have imported one user defined data type CITY then it coming blank in the output in Yellow fin

but when I am creating the calculated field using the CITY column CITY::text then I am able to see the column data in Yellow fin.

Hope you get my query.

Thanks

Shashi kant Singh

Hi Shashi,

Before moving forward, may I ask what organization you are with? We don't seem to have anyone linked to your name or e-mail address.

Thanks,

Mike

Hi Shashi,

I just wanted to check in and see how things are going with this and if you could please respond to my previous inquiry if issue still persists.

Regards,

Mike

Hi Shahsi,

I'm going to go ahead and mark this one as Answered since I haven't heard back from you, but if you have further questions or concerns on this, if you respond, it will re-open the case and put it back in my queue and I'll be happy to help.

Regards,

Mike