Skip to content

Oracle Communities

Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Poll: Oracle Analytics Community Website Satisfaction Tell us about your satisfaction with our newly redesigned Oracle Analytics Community Website.

Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Not able to replace Null string to blank in BIP for teradata query

Received Response

21

Views

1

Comments

3323115

3323115 Rank 2 - Community Beginner

Mar 5, 2017 8:00AM in Oracle Analytics Cloud and Server

Summary

Not able to replace Null string to blank in BIP for teradata query

Content

Hi ,

In the BI Publisher parameter, for Teradata query, I need to replace NULL character string with blank space

I tried oreplace, but its failing.

erm.empl_full_name in oreplace(:pvar_officer1),'NULL','')

But data model is failing to lead. The requirement is when NULL string is coming for erm.empl_full_name, it should replace by blank & run the query

0

Answers

Venkat Thota - BIP Rank 7 - Analytics Coach

Mar 6, 2017 8:00AM

please post query then will provide you better one as per business rules. Thanks

0