Data Model Issue

[sibin_jacob]

Nation	Region	District	Team
Nation	RG01	D01	T01
Nation	RG01	D01	T02
Nation	RG01	D02	T03
Nation	RG01	D02	T04
Nation	RG01	D02	T05
Nation	RG02	D03	T06

Geo_Dim Table

In my application I need to show summarized data. So in my data model I am keeping data at team level. I am processing physician level data in backend (Using Sql) and keeping the summarized data in Team Level. Using this team level data I am calculating the district, Region and Nation Level values in Front end (Qlikview expression). But now I am facing some data level issues in district level values because duplication of physician (One physician is present in two teams). So I need to keep all Geography level data in fact table. I have one ‘Geo_Dim’ table contains the Team, District, Region and Nation relations(Alignment) I am facing problem to relate the ‘Geo_Dim’ table to my fact table.

Fact_table

Geo	Geo_Type	Vol	Vol Chg	New Vol	New VolChg	ProductID	SegmentID	PeriodID
Nation	Nation					1	2	1
RG01	Region					1	2	1
RG2	Region					1	2	1
D01	District					1	2	1
D02	District					1	2	1
D03	District					1	2	1
T01	Team					1	2	1
T02	Team					1	2	1
T03	Team					1	2	1
T04	Team					1	2	1
T05	Team					1	2	1

I need to keep all geography level data and need a relationship with Geo_Dim. IF I am selecting one district or Region need to show all the teams in that perticular district.

What all are changes I need to do in this data structure?

Thanks,

Sibin Jacob.C

[#2]

Sibin:

What problem you are facing in joining your Geo_Dim to the Fact. What is the structure of your Geo_Dim table.

I created a small sample but don't how to attach it to this reply. Please let me know how can i attach my qvw

I can attach an image, tell me if you want something like this.

[sibin_jacob]

Hai Chand,

Use advanced editor to attach the files.

In the top of reply box, click on 'Use advanced editor' option.

Thanks,

Sibin Jacob.C

[#4]

Please find attached Physicians_tables.xlsx. In this i have created 2 dimensions and one fact.

Also find attached Physician.qvw

Let me know if this will work for you.