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
361
Views
13
Comments
Nirmal Kumar L
Nirmal Kumar L Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence Idea Lab

Description

Fetching Personal and work email in same OTBI report

Use Case and Business Need

Hi Experts,

How to fetch both personal email and work email in a single OTBI/Analysis report. Is it feasible and how we have to do that?

Original Idea Number: 644cf2ddb7

Tagged:
1
Up
1 votes

Submitted · Last Updated

«1

Comments

  • AshishERPCloud
    AshishERPCloud Rank 5 - Community Champion

    Hi Nirmal,

    Check this link ( this one shows how to pull home phone, work phone in same row...something similar needs to be done for emails too)

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

    Hope this helps!

    Kind Regards

    Ashish

     

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

    Hi Ashish,

    Thanks for your quick response. I tried this method but it is not working. If you are aware of it, can you explain it?

    Thanks,

    Nirmal Kumar

  • AshishERPCloud
    AshishERPCloud Rank 5 - Community Champion

    Can you please share the XML and the results you got.

    Some of the experts here would be glad to help.

    Kind Regards

    Ashish

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

    Thanks Ashish for your suggestion. Please find the attached output file below.

  • AshishERPCloud
    AshishERPCloud Rank 5 - Community Champion

    Have you tried the pivot option suggestion mentioned in below link:

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

    May you post the XML used and this screen-shot on above link

    Kind Regards

    Ashish

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

    I image file I attached is in pivot table only Ashish.

    Thanks,

    Nirmal kumar

  • AshishERPCloud
    AshishERPCloud Rank 5 - Community Champion

    Please post your XML

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

    Sorry for the delay. Attached the XML below

    Thanks,

    Nirmal Kumar

  • AshishERPCloud
    AshishERPCloud Rank 5 - Community Champion

    Seems you have passed on the XML Data. I am looking for the XML Analysis (on Advanced Tab)

    On Advanced Tab under XML you would find corresponding XML version of the query which gets generated as a result of the OTBI Report created. Copy that same (save it in text file and send)

  • AshishERPCloud
    AshishERPCloud Rank 5 - Community Champion

    I tried running this and I could not find the Pivot Option.