Data from 2 Tables

Md. Altas

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

cesar.advincula.o

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

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