Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems linking dimension tables and fact tables in SSAS cube

Status
Not open for further replies.

juanvg1972

IS-IT--Management
Dec 24, 2008
10
ES
I have a problem with SSAS trying to relate tables.

I have this tables:

1) hc_routes (airplanes routes):

id_route, id_aeroline, id_airport_source, id_airport_destination
PK: id_route

2) co_route_equipments (planes of each route)

id_route, id_equipments
PK: id_route, id_equipments (I have N equipments for each id_route)

3) dm_equipments

id_equipment, desc_equipment
PK: id_equipment

4) dm_airport
id_airport, ....(atributes)
PK: id_airport

5) dm_aeroline
id_aeroline, ....(atributes)
P‌K: id_aeroline

I have made a data source and a cube with this tables. I define metrics for hc_routes y co_route_equipments
(count of routes).
In the 'dimension usage' I can link:
- hc_routes with dm_airpors and dm_aeroline
- co_route_equipments with dm_equipments

I would like to relate dm_equipments with hc_routes but I don't know how...
I want to count how many routes has a equipment, but filtering by airport or airline then
I need to use hc_routes

The relation needed is:

d‌m_equipment - (id_equipment) 1:N -> co_route_equipment ->(id_route) 1: 1 -> hc_routes‌

z_imagen1_udxld4.png

z_imagen2_irt7zp.png


Any advice will be greatly appreciated
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top