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

Shashi kant Singh shared this question 1 month ago
Answered

Comments (5)

photo
1

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

photo
1

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

photo
1

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

photo
1

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

photo
1

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