what is fact less fact ? give me one example?

[mvn.balu]

what is fact less fact ? give me one example?
please help me

[RobsWalker68]

Hi,

A Fact less fact table is  used to record an event such as employee count as an example.  There is a short Ralph Kimball article on factless facts which explains the concept.

http://www.ralphkimball.com/html/articles_search/articles1996/9609d05.html

Rgds

Rob

[jive]

Hi,
The best example I can give you is the one we have in the project I work now. We have one table where we stock the intervention done by our people, the intervention don't have a specific dimension and it's ok. So, in that table we don't have any number just intervention_name, ho_do_it_name, date and some other information. When we do a report based on the number of intervention by type we regroup the intervention_name and count(ho_do_it), If we want to know how different people involve in a case we do the same but we do a count(distinct ho_do_it) . That's the best example I can give you. We dont'used at any moment numeric values.
Regards Jacques

[Lynn]

<channeling author=Jane Austen>

It was everyday implied but never declared! A true gentleman DBA would make his assertions and intentions clear from the outset. It shows a certain wont of character to leave affairs, as such, in a vague state.

Were it only deemed prudent and honorable to provide a column populated with a numeral one. I shall find it difficult to make my way in the world, having few means at my disposal as it is! It is no mean feat to satisfy such a simple request. Then a person of modest means, such as a query studio author, may (to use a crude expression) "drag and drop" the metric thus getting a correct count for whatever dimensions such a soul might elect to filter upon!

We can only urge the right course of action in the dearest hope for Pride, not Prejudice and, of course, Sense and Sensibility!

</channeling>

[MFGF]

Lynn,

I saw this post in isolation and mistook it for spam. I was just about to delete it and ban the offending user when I spotted it was you, and I looked closer.

What a spamtastic prose everyday implied did you use uggboots. :)

MF.

[Lynn]

Lynn,

I saw this post in isolation and mistook it for spam. I was just about to delete it and ban the offending user when I spotted it was you, and I looked closer.

What a spamtastic prose everyday implied did you use uggboots. :)

MF.

I suppose a poor choice of author for this audience. I should have gone with Mickey Spillane (a la Mike Hammer) or perhaps just the sports page from the newspaper.

Actually I made this same comment in another thread about factless facts and just decided to try saying it differently. Got carried away. I'll try to behave myself from now on...

[RobsWalker68]

Lynn,

I think it is quite ironic that an American nearly got themself banned from this site for being cultured.   Lol, the beauty of Jane Austen.


Rob

[MFGF]

I think it is quite ironic that an American nearly got themself banned from this site for being cultured.

<gasp!>  Oh Rob, you're in BIG trouble when Lynn sees this!!!  :o :D ;)

[RobsWalker68]

I know, Lynn is going to kill me :'( :) ;)

[Lynn]

I know, Lynn is going to kill me :'( :) ;)

On the contrary! From now on I will be true to the American spirit and only refer to "The Simpsons" or reality TV shows. If I feel the need to go highbrow I'll reference Spongebob Squarepants.

;D