Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Data from 2 Tables

Received Response
1
Views
2
Comments
Md. Altas
Md. Altas Rank 3 - Community Apprentice
edited Aug 13, 2024 6:16PM in Oracle Analytics Forum

Hi All

I am working on the work order report.

We store line information in another table.

There are some work order where Line is not assigned yet and when I create report the Line records show BLANK.


Is there any way I can show 'UNASSIGNED' word if the line is blank?

For example: -

WO1 - L1

WO2 - L1

WO3 - L2

WO4-L1

WO5 - < No information - blank record>


I want to show this as following -

WO1 - L1

WO2 - L1

WO3 - L2

WO4-L1

WO5 - UNASSIGNED


Thanks

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics & AI Lead

    This is the resulta of your bi analysis?

    If the answer is yes. Apply this:

    Ifnull( your column status assigment, 'unassigned')

    Let me know your results.

    Kind regards

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    use a key of 0 (ZERO) in your dimension for unassigned ... then you preserve the inner joins AND it's easier to find the rows in your table maintenance when the key needs to be set ... set up all your dimensions like this where you might have an unassigned key relationship.

    IE

    Status_Dim

    Key | Status

    0 | Unassigned

    1 | Closed

    2 | Open

    3 | Pending

    4 | Held

    5 | Canceled