Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

OBIEE - Add a column and populate it with customized text

Received Response
391
Views
3
Comments
JHaden3
JHaden3 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:19PM in Oracle Analytics Forum

I'm new to OBIEE, simpler is better please.  I have to add some new columns to an Analysis and populate them with our company address.  I have added a field called "Address Line 4" (that we do not use) to the analysis five times as shown in the image below.  I want to populate the columns with Employer Name, Address, etc.  How can I do that?

pastedImage_0.png

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    If what you want is that every single row has the same value, edit the formula of the columns, and there inside you enter your text with single quotes around:   ' Your employer name '

    You need the single quotes to tell OBIEE it's a static text, and not something to evaluate as LSQL code.

  • JHaden3
    JHaden3 Rank 3 - Community Apprentice

    Exactly what I needed.  I was not using single quotes.  Thank you so Much!!!

  • JHaden3
    JHaden3 Rank 3 - Community Apprentice

    Thank you both!