I have a report in OTBI that uses the Workforce Management - Processed Time Cards Real Time subject area. Two fields are included in the query, Absence Type and Hours Type, along with Processed Hours. What is happening is the output shows the Absence Type in one column and the other Hours Type in a separate column, and the hours for each are in one column. I would like to show both the Absence Type and Hours Type result values in one column. Here is a sample of the output attached and below it how I want it to show. How it currently shows PP Start Date PP End Date Job Name Absence Type Hours Type Hours 11/03/24 11/16/24 Sr LNG and Propane Tech On Call 19 11/03/24 11/16/24 Sr LNG and Propane Tech Holiday US 8 11/03/24 11/16/24 Sr LNG and Propane Tech-2nd 6 mo Doubletime 2_0 Premium 3 11/03/24 11/16/24 Sr LNG and Propane Tech-2nd 6 mo Doubletime 2_0 Straight 3 11/03/24 11/16/24 Sr LNG and Propane Tech-2nd 6 mo Regular Pay 72 11/03/24 11/16/24 Sr LNG and Propane Tech-2nd 6 mo Holiday US 8 How I want it to show PP Start Date PP End Date Job Name Hours Type Hours 11/03/24 11/16/24 Sr LNG and Propane Tech On Call 19 11/03/24 11/16/24 Sr LNG and Propane Tech Holiday US 8 11/03/24 11/16/24 Sr LNG and Propane Tech-2nd 6 mo Doubletime 2_0 Premium 3 11/03/24 11/16/24 Sr LNG and Propane Tech-2nd 6 mo Doubletime 2_0 Straight 3 11/03/24 11/16/24 Sr LNG and Propane Tech-2nd 6 mo Regular Pay 72 11/03/24 11/16/24 Sr LNG and Propane Tech-2nd 6 mo Holiday US 8

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to Show Two Columns As One

Julie Mandel

I have a report in OTBI that uses the Workforce Management - Processed Time Cards Real Time subject area. Two fields are included in the query, Absence Type and Hours Type, along with Processed Hours. What is happening is the output shows the Absence Type in one column and the other Hours Type in a separate column, and the hours for each are in one column. I would like to show both the Absence Type and Hours Type result values in one column. Here is a sample of the output attached and below it how I want it to show.

How it currently shows

PP Start Date	PP End Date	Job Name	Absence Type	Hours Type	Hours
11/03/24	11/16/24	Sr LNG and Propane Tech		On Call	19
11/03/24	11/16/24	Sr LNG and Propane Tech	Holiday US		8
11/03/24	11/16/24	Sr LNG and Propane Tech-2nd 6 mo		Doubletime 2_0 Premium	3
11/03/24	11/16/24	Sr LNG and Propane Tech-2nd 6 mo		Doubletime 2_0 Straight	3
11/03/24	11/16/24	Sr LNG and Propane Tech-2nd 6 mo		Regular Pay	72
11/03/24	11/16/24	Sr LNG and Propane Tech-2nd 6 mo	Holiday US		8

How I want it to show

PP Start Date	PP End Date	Job Name	Hours Type	Hours
11/03/24	11/16/24	Sr LNG and Propane Tech	On Call	19
11/03/24	11/16/24	Sr LNG and Propane Tech	Holiday US	8
11/03/24	11/16/24	Sr LNG and Propane Tech-2nd 6 mo	Doubletime 2_0 Premium	3
11/03/24	11/16/24	Sr LNG and Propane Tech-2nd 6 mo	Doubletime 2_0 Straight	3
11/03/24	11/16/24	Sr LNG and Propane Tech-2nd 6 mo	Regular Pay	72
11/03/24	11/16/24	Sr LNG and Propane Tech-2nd 6 mo	Holiday US	8

Find more posts tagged with

HCM

HCM Analytics Content

OTBI

Accepted answers

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/62186#Comment_62186

Just remove other two and keep only the concatenated one.

All comments

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24146/how-to-show-two-columns-as-one

Can you try below?

Add a field to the report > Field Settings > Edit Formula. Edit the formula and use concat function to concatenate the columns:

CONCAT("Processed Time Entry Details"."Payroll Time Type Name","Expenditure Type"."Resource Type Name")

Set the column header from Column properties:

Thanks.

Julie Mandel

Unfortunately, that does not solve the issue. Using exactly what you indicated, it did combine some data, but the second portion of the data is not any I am using. I did try the same by concatenating The Absence Type Name with the Payroll Type Name, but that does not actually cause all of the element names to be in one column. I need a way to ensure the Absence and Non Absence element names are in one column and the hours are in one column as my second example shows. I think someone said you have to use filters, but I do not know the actual steps to make that happen.

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/62180#Comment_62180

Can you paste a screen shot of what you see after using CONCAT?

Thanks.

Julie Mandel

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/62182#Comment_62182

I can see data is coming as expected in Test column. What is the expectation?

Thanks.

Julie Mandel

The element names, whether Absence or Non Absence, should be in a single column not in two separate columns

Julie Mandel

As you can see, Absence Type is a separate field from the Hours Type. It does not appear there is a single field that will capture both absence and non absence element names so you have to have both of these, but I want it to only show in one column for the description.

Julie Mandel

Oh my goodness, it is a Monday. Yes, I think that will work. My apologies!

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/62186#Comment_62186

Just remove other two and keep only the concatenated one.