Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

etext - Can elements in a CONCATENATION section be formatted using rpad and format_date functions

Received Response
54
Views
2
Comments
Josephine Abel
Josephine Abel Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

etext - Can elements in a CONCATENATION section be formatted using rpad and format_date functions

Content

I have a requirement where an etext template has to be developed for a benefit carrier.

Every time I use a function such as decode, rpad etc, concatenated elements does not work. I have a simple concatenation section as shown below:

Does anyone know if this is possible

<DEFINE
  CONCATENATION>

CAT_LTD

<BASE
  LEVEL>

Benefit_Enrollment_Results_DG

<ELEMENT>

If Plan=’LTD’ THEN

RPAD('456', 10, 'x')

End If

<DELIMITER>

'
  '

<END
  DEFINE CONCATENATION>

CAT_LTD

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    It should work. I have used RPAD in concatenation it worked for me...may I know where you are facing issue?

    It will be helpful if you can upload sample e-text rtf and xml file

  • Josephine Abel
    Josephine Abel Rank 2 - Community Beginner

    Thank you, not sure what happened last week, but I'm able to get it working now.

    Thanks again.