How to link and display island data?

[fionna51]

Hi,

I have an island table which is actually some criteria of calculation. The table looks like:

Year	Program	Rating	Payment
2014	p1	1	100
2014	p1	2	200
2014	p1	3	300
2014	p2	1	50
2014	p2	2	100
2014	p2	3	150
2015	p1	1	110

In my fact table, I do have Year, Program fields. For a selected Hospital, if calendar year is 2014 and Program=p1, I want to display the Rating and Payment as criteria. Now I load above table as island table. I do not know how to link it to my selection. Usually a hospital can have multiple program, one rating for each program. But as criteria, when user select this hospital, certain year and program, we need to show complete criteria, which means all ratings and related payments for selected year and program. (actually hospital not matter)

[JoaquinLazaro]

Hi  fionna51:

A data island is conceptually an isolated table, then it's unlinked from the data model.

Maybe, you need link this table to the master calendar or other facts table and use SET ANALYSIS in the expressions of your charts !!!

Hope this helps you

Joaquín

[b_garside]

You will need a new Key either composite or a new unique ID field.

Composite will work if you have like fields from the other tables(s) and it can create a unique ID per row.

You have to ask your self what type of data needs to be linked from this table how unique does it need to be to properly pull from it.

[Anonymous]

I reckon your "Data Island" table needs to be linked to your Fact table  This can done by ensuring the fields you wish to link by have the same name in both your tables.

Or you could put the "Data Island" data into a Mapping Load table and then use ApplyMap()  to add the Rating and Amount data into your Fact table.