Stack Overflow
Stack Overflow

Questions tagged [fact]

A fact or fact table is the central table in a Star or Snowflake schema of a data warehouse. A fact table stores quantitative information for analysis and is often denormalized. It measures the business operations in the organization. It is included in every data warehouse or data mart.

A fact or fact table is the central table in a Star or Snowflake schema of a data warehouse. A fact table stores quantitative information for analysis and is often denormalized. It measures the business operations in the organization. It is included in every data warehouse or data mart.

Facts are the measurements that result from a business process event and are almost always numeric. A single fact table rows has a one-to-one relationship to a measurement event as described by the fact table's grain. Fact table corresponds to a physical observable event.

Within a fact table, only fact consistent with the decraled grain are allowed. The fact table work with dimension tables. The fact table holds the ways in which the fact table data can be analyzed. There are two type of columns in there - foreign key columns for join with the dimensions and the measures columns, containing the data analyzed.

Example

In retail sales transaction, the quantity of a product sold and its extended price are good facts. Store manager's salary is disallowed in the fact table.

Links

182 questions
1
vote
3 answers

How to print all the facts?

I am stuck for this problem... isAt(keys, room3). isAt(book, room3). isAt(keys, room6). isAt(keys, room4). currently, room3 have keys and book. I want to print keys and book. I tried this code and apparently prints only one. (just keys) look :-…
drunktiger
  • 23
  • 3
1
vote
1 answer

Adding a string as a measure in SSAS OLAP cube

I have a form which depending upon a center can have different questions. The answers to these questions are saved as string (nvarchar) in the transactional system. Some questions have answers which need to be a analyzed and need to be part of…
AM96
  • 43
  • 7
1
vote
0 answers

How to add facts to JESS working memory when a event happend out of Jess

How can I do to add new dynamic facts to working memory? for Example: If I have a rule like this: (deftemplate person(slot idPerson)(slot age)(slot like)) (defrule sports "Give a discount on sport items" (person {age >18 && age<30}{like…
Wilisumo
  • 33
  • 4
1
vote
1 answer

Convert XMLdata to facts

Part of my config-file is as follows: /home//Werk/Divers/Prolog/XMLdata/ apl_id dns_id apl_naam_kort
Ben Engbers
  • 433
  • 3
  • 12
1
vote
1 answer

Should I combine similar business processes into one fact table?

I am pretty new to data warehousing, so I'm a little unclear on some aspects of design. My business sells memberships. People join to become a member, and of course resign to no longer be a member. We have join date and the resign date as…
user2125820
  • 11
  • 2
1
vote
3 answers

“every class in java extends the MetaClass Object” does it imply that every subclass causes a Diamond issue

These two facts in java Fact 1 “Every class in java by default extends the java meta class Object” and Fact 2 “Multiple inheritance is not allowed in java” read more about diamond proble here Java inheritance are quiet confusing Suppose…
veer7
  • 20,074
  • 9
  • 46
  • 74
1
vote
1 answer

How do you remove one facts in CLIPS?

How do you remove one facts in CLIPS? The fact would be entered by a person and compared with the base was present, it deletes. I tried so: (defrule Deleting::ruleDeleteOneSynSoftgoal "This rule delete one synsoftagoal found in the basis of fact." …
user3174846
  • 13
  • 1
  • 5
1
vote
2 answers

How to modify a Jess multislot fact in working memory

I have some rules in my Jess code which i want to modify two facts in the working memory. The facts which have been asserted are: (assert (analysis (reasons $?c) (total ?t)))) reasons $?c is a multislot and I want to add to this multislot if needed…
Zain
  • 15
  • 3
1
vote
1 answer

Data Warehouse - Storing historical data in Fact table

I am a beginner to DataWarehousing. We have created a data mart, a star schema design to load quarterly data. We have been loading the current data as and when approved by the business for that quarter. Now we have a requirement to go back and load…
user3357452
  • 11
  • 1
  • 2
1
vote
3 answers

Associate list with a name

I have searched all over the internet and on StackOverflow for the answer but I have no idea. I really don't get how to use Prolog and I find it really confusing. I have the solutions in my head but cant write them in Prolog which is very…
user2945719
  • 11
  • 2
1
vote
1 answer

How to remove duplicate facts in Prolog

I am writing a rule in Prolog to create a fact, pit(x,y). This rule below is called three times from my main function, and it is inserting three pits in which none of them is at (1,1) or (1,2) or (2,1) but the problem is that sometimes 2 pits have…
user2843720
  • 53
  • 1
  • 3
1
vote
2 answers

Fact table designing for SSAS

I'm designing a fact table for SSAS and this is the first time I'm trying my hand at this as this is to be a prototype system just to show what could be done and to show to someone to decide if it what they are after. I've made up some data and am…
user1663003
  • 149
  • 1
  • 10
1
vote
1 answer

Microsoft research on fact extraction from the web?

Some time ago I had accidentally found website which was apparently product of Microsoft research on fact extraction from the web, more specifically from the Wikipedia. Right now I would like to have better look into how it works, but the problem is…
spacemonkey
  • 167
  • 1
  • 2
  • 8
1
vote
1 answer

Reversing facts in prolog and display them

If I have the following: friends(tim,joe). if i go: ?- friends(X,Y). I would get: X=tim Y=joe What would I have to print the following with out adding any new facts X=tim Y=joe X=joe Y=tim
spikestar
  • 163
  • 1
  • 3
  • 10
1
vote
1 answer

SSAS is a periodic snapshot the right choice

I'm a newbie to SSAS. I have a database which has an agreement table in which the status of the agreements changes over time. This is stored in the agreement log. the status can be any combination over an extended period of time. One set of…
user1102550
  • 543
  • 1
  • 7
  • 24
1 2 3
…
12 13