How to solve fan trap. how to find if it is afan trap?

building semantic layer
1

Hi,

I have four dimension tables i.e.
1.member table
2.state
3.county
4.zip
the relation between these tables is like

state------->county--------->zip-------->member
1 N 1 N 1 N(relation is like this)

Please suggest me if the above structure forms fan trap or not.

if it forms fan trap please help me how to solve fan trap as per above senario…

in report level we required report like summary report.i.e.

we have agegroup and memberid in member table and zip code in zip table and county in county table state in state table…

based on agegroup we need how many members are there in each state…drill down should be on state.

hirarchiey should be state—county—zipcode…

Please help me on this…

thanks
gangabo

gangabo (BOB member since 2011-04-27)

2

Hi,

In the above scenario, there is no fan trap because I see no measures there. Fan trap occurs only when there are measures.

So, let us know if there are any measures and where - from which table(s) - they are defined.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

thanks for your help…

there are no measures in above tables.

only we are counting members from member table based on age group.

we are generating summary report like
for certain age group and state how many members are there…

in the report we need age group and member count and state objects in ot report and we need to drill down on state…

all these tables state ,county adn Zip tables are look up tables…to get member count from each sate county and zip…

thanks
gangabo

gangabo (BOB member since 2011-04-27)