Oracle Transactional Business Intelligence

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

OTBI Analysis Seniority Dates pulled into 1 row

Received Response
2
Views
1
Comments

Please, I need help

I will like to create an Analysis into a table that shows respective dates of under each respective Seniority Date Rule column. Currently the analysis shows
Seniority Date Rules and Seniority Dates in multiple rows for each Person

The columns should be
Column 1) - Person Number

Column 2) - HR Status

Column 3) - Length Of Service (- respective seniority dates will be populated under this column)

Column 4) - Benefits Date (- respective seniority dates will be populated under this column)

Column 5) - Enterprise Seniority Date (- respective seniority dates will be populated under this column)

OTBI Catalog attached for reference.

Answers

  • AlvinTanCH
    AlvinTanCH Rank 1 - Community Starter

    Hi All, just to be clear. I need this to be a table because I need to include other columns into the table