topic Re: Data Model Issue in QlikView

Data Model Issue

sibin_jacob — Mon, 11 Feb 2013 16:11:06 GMT

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	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

Re: Data Model Issue

Mon, 11 Feb 2013 20:27:45 GMT

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.

Re: Data Model Issue

sibin_jacob — Tue, 12 Feb 2013 05:04:15 GMT

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

Re: Data Model Issue

Tue, 12 Feb 2013 13:54:17 GMT

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.