BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Fan Trap -more than 3 tables


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
DWH
Principal Member
Principal Member



Joined: 25 Apr 2006

Posts: 244



PostPosted: Wed Aug 09, 2017 7:53 am 
Post subject: Fan Trap -more than 3 tables

I see Fan Trap in more than 3 tables in the design
A-->B-->C-->D-->E

A is storing a count for detail in B and B is storing a count for C and C is storing a count for D and D is storing a count for E.

Any suggestions on how to resolve.
Back to top
Andreas
Forum Advocate
Forum Advocate



Joined: 20 Jun 2002

medal_silver.gif*2medal_gold.gif
Posts: 17326
Location: *** BEEP ...Dreaming of Africa... leave No message ; ) BEEP ***


flag
PostPosted: Wed Aug 09, 2017 2:04 pm 
Post subject: Re: Fan Trap -more than 3 tables

Are those Aggregate (summary) tables by chance?
_________________
Follow me on Twitter
Reading "The Design Of Everyday Things" by Don Norman
Focusing on Data Visualization, Design Thinking, SAP DesignStudio + scripting, SAP BI 4.x platform & architecture, SAP connectivity, Data Modeling, and SAP HANA Certified Associate
Back to top
DWH
Principal Member
Principal Member



Joined: 25 Apr 2006

Posts: 244



PostPosted: Wed Aug 09, 2017 9:13 pm 
Post subject: Re: Fan Trap -more than 3 tables

Hi Andreas

Table A

H_ID (Primary key)
Sts
Sts rsn
H_COMB_CNT (measure)


Table B
H_ID (Primary key)
H_COMB_SEQ (Primary key)
D_IND
D_AMT
H_SEC_CNT(measure)



Table C
H_ID (Primary key)
H_COMB_SEQ(Primary key)
SEC_SEQ (Primary key)
UPD_DT
CRT_DT
SEC_ITM_CNT(measure)


Table D
H_ID (Primary key)
H_COMB_SEQ(Primary key)
SEC_SEQ (Primary key)
SEC_ITM_SEQ(primary Key)
SEC TYPE
UPD_DT
CRT_DT
ITM_ATR_CNT(measure)


Table E
H_ID (Primary key)
H_COMB_SEQ(Primary key)
SEC_SEQ (Primary key)
SEC_ITM_SEQ(primary Key)
ITM_ATR_SEQ(Primary Key)
UPD_DT
CRT_DT
ATR_CD (Dimension)
ATR_VAL (Dimension)


A-->B-->C-->D-->E


This is the sample structure . But the primary key is on each level. will it still result in Fan trap?

E is Detail level for D and D is detail for C and goes on.
Back to top
Derf
Principal Member
Principal Member



Joined: 16 May 2011

Posts: 201
Location: Montreal


flag
PostPosted: Fri Aug 11, 2017 9:48 am 
Post subject: Re: Fan Trap -more than 3 tables

Your only two fields are dates? You dont need to worry about fan traps.

Only measures will be distorted by that kind of fan trap.

_________________
The cake is a lie.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0105 seconds using 18 queries. (SQL 0.0031 Parse 0.0002 Other 0.0072)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo