DataModel Help

[AbhijitBansode]

Hi Team,

Refering to above image:

Fact table contains records at Building as well as Room level (There can be zero to many rooms in one building).

Two dimension table viz., Building and Room related to each other using BuildingId column.

I need to conenct these two dimensions with fact.

Can't directly connect Id with BuildingId coz, individual Room details can't be retrived in that case, also can't directly connect Id with RoomId coz, individual Building details can't be retrived in that case.

Please help me to ransform this model by maintaining relation between Building and Room.

Please find attache qvw eith sample data.

Thanks,

Abhijit

[kaushiknsolanki]

HI,

I would recommend you to divide the Fact in to 2, one for Building and one for Rooms.

You shouldn't have different gran data in one Fact table.

Regards,

Kaushik Solanki

[#3]

Hi,

You can refer to this post for mix granularity Fact table

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/26/mixed-granularity

Regards,

Vivek