Analytics Software

Hi friends,

I did this simple report in obiee 10g(i.e)

*"NATIONALITY COUNT IN DEPARTMENT WISE"*

For that i used the following tables:

per_all_assignments_f----->fact table

hr_all_organization_units----->dim table(containing departments)

per_all_people_f---------------->dim table(containing nationality)

I made all the mappings in the physical diagram, as also viewed my report in BI answers

It shows the following results like

NATIONALITY---------------------------------------------------------------------COUNT(NATIONALITY)

AUS------------------------------------------------------------------------------------------------24
AFR------------------------------------------------------------------------------------------------25
PHQ_VB-------------------------------------------------------------------------------------------40
SH_VT----------------------------------------------------------------------------------------------4

The problem is for me it is showing the above results, but the nationality column is of various codes of the country.

Since i doesnt want the code of the nationalitian to display in the results..i need the meaning of each and every nationality..

like,

AUS------------------------Australian
AFR-------------------------African
PHQ_VB----------------------Germanian(assigned)

Since i know that the meaning for the nationalitian is available in "FND_LOOKUP_VALUES"...okay..

I can import "FND_LOOKUP_VALUES" table to the physical layer...but how i can able to give the mapping to the fact table in my physical diagram...

In my report the fact table is "per_all_assignments_f"

As my fact table doesnt contains any matching column corresponding to the dimension table "FND_LOOKUP_VALUES".....

Then how i can give mappings to the fact column???? for viewing the full meaning of the nationalitian in my report.....

Help me friends...

All izz Well
GTA...