Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

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

Need assistance using FTE as a dimension

Accepted answer
11
Views
1
Comments
Sushma9
Sushma9 Rank 1 - Community Starter
edited Jan 16, 2026 7:59AM in Oracle Fusion AI Data Platform Forum

we have a use case to use FTE to define fulltime/parttime as we cannot use Assignment category column due to data issues.

trying to create an FTE dimension column - if its 1 then fulltime else parttime.

this only works on person level, not able to use it on a tile or chart

Tagged:

Best Answer

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics & AI Coach
    Answer ✓

    Hi @MSushma ,

    Thank you for the question. We might need a little more information on what the problem is if it's limited to a tile or chart.

    If you are able to successfully use the Headcount and Full-Time Equivalent (FTE) data with a person ID and other fields in a tabular workbook, then you should be able to create a tile of chart using it.

    Regards,

    John