You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI - Pivot with multiple information types (Email Type, Phone Type)

Received Response
edited Apr 10, 2019 2:58PM in Reporting and Analytics for HCM 3 comments



We have a report with some personal information on it. Among other columns in report we do have Email (incl. Email Type) , Address ( incl. Adress Type) and Phone numbers.

Unfortunatley, whenever there is information type with multiple entries, e.g. address, all columns after this column in report will get duplication of the rows despite the fact that supression is switched on and the values are the same. We had a bit of play in terms of sorting to put these 3 types of info at the end of the report,s till not ideal. In simple terms if switched off supression, in case of  dummy employee with 2 address types and 3 email types we will get 6 lines for this dummy employee. 


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!