How to do multiple aliases to a lookup table

I need a way to display a text value for a number. I saw a post that said they had done it via multiple aliases to the lookup table. How do I do that?
IE I need details.
Example: I have a query that returns severity as a number, but I want to display as text.
I am very new to Birt, so any help would be great.
Thanks

Find more posts tagged with

Comments

bhanley

When you say "display as text" do you mean you want 70 to equate to a standard string? Such that when I encounter 70 in a cell, I really want to display "Billing" and when I encounter 60 in a cell I display "Overhead"?

Do I have the problem stated correctly? If so, where do the mapped values come from? That will help me lay out the proper solution.

Thanks.

eoverton

You have the problem correct.
The mapped values come from another DataSource that is a csv file.
The original DataSource is a Oracle Database I only have read-only access to.
Thanks
Ed

bhanley

Create the two data sets, and then create a Joint Data Set that you will actually use in the report. The Joint Data Set will feature a join between the CSV Set and the Oracle set. The join will bring the string value represented by the code into the overall union.

That should give you all the data you need in one consolidated data set.

eoverton

I Tried that, but the Joint Data Set has no columns. I used inner join.
What am I doing wrong?

bhanley

When you preview the results of each Data set do you see results?

When you set up the joint data set did you define the two columns that are to serve as the keys used in the join?

eoverton

The preview works correctly.
I set the Master table on the left and select the column I want matched.
I set the Lookup table on the right and select the corresponding column.
After I press finish, the output columns is correct, but the DataSet has no columns. Also when I try and edit a column already in the layout. The new DataSet does not show in the avaliable datasets in the expression builder.