Categories
- All Categories
- 70 Oracle Analytics News
- 6 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 37 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Fetching Personal and work email in same OTBI report
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
Comments
-
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
0 -
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
0 -
Can you please share the XML and the results you got.
Some of the experts here would be glad to help.
Kind Regards
Ashish
0 -
Thanks Ashish for your suggestion. Please find the attached output file below.
0 -
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
0 -
I image file I attached is in pivot table only Ashish.
Thanks,
Nirmal kumar
0 -
Please post your XML
0 -
Sorry for the delay. Attached the XML below
Thanks,
Nirmal Kumar
0 -
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)
0 -
I tried running this and I could not find the Pivot Option.
0