Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Fetching Personal and work email in same OTBI report

Submitted
368
Views
13
Comments
2»

Comments

  • AshishERPCloud
    AshishERPCloud Rank 5 - Community Champion

    Please check below link:

    https://cloudcustomerconnect.oracle.com/posts/a9ee75411c

    I have posted your Analysis XML there so you may post messages there

    Kind Regards

    Ashish

  • Nirmal Kumar L
    Nirmal Kumar L Rank 3 - Community Apprentice

    Ok Ashish. Thank you

  • RichardChan
    RichardChan Rank 6 - Analytics Lead

    Do you mean side by side ?

    1) Request that these fields are created as separate columns in the RPD then drag and drop them side by side as usual

    2) Create a UNION with generic email plus a hard coded column with email type of "PERSONAL" ,"WORK" then pivot on the email type column