Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Textual Facts in the fact table

2 posters

Go down

Textual Facts in the fact table Empty Textual Facts in the fact table

Post  bandik Thu Jun 24, 2010 3:23 pm

Its a new financial 'capital markets' dimensional reporting model (for IPO - raise money for an issuer by issuing new equity common stock securities) that's in design stage. There are some textual attributes of the grain of several fact tables for which there are no related dimensions example 'sales comments', 'broker comments', 'pricing comments' etc. The grain is '1 row per issue per issuer'. These columns are free text fields in front end (OLTP). No complex rollups, slicing etc are intended on these columns but several reports need these columns.

Example : For deal_details_fact table - grain is - 1 row per deal per issuer. The dimensions are issuer, security type, deal country, deal currency date, broker etc.

To accomodate textual facts - I am creating a separate dimension 'Deal_details_Dimension' table where all the textual attributes for the deal is stored.

Is this a good design ?

Any advise here is highly appreciated. Thanks.

bandik

Posts : 4
Join date : 2010-06-24

Back to top Go down

Textual Facts in the fact table Empty Re: Textual Facts in the fact table

Post  John Simon Thu Jun 24, 2010 6:31 pm

You've hit the nail on the head. Keep those attributes in a dimension table to keep your fact table narrow (and so more performant).

John

John Simon

Posts : 186
Join date : 2009-05-29
Location : Melbourne, Australia

http://jsimonbi.wordpress.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum