Thursday, May 08, 2008

Difference between accessing fact table and lookup table in Grouping option of Metric creation

There is another important difference between accessing a fact table and a lookup table. If a value, such as April sales, is missing from a fact table, the row still exists in the table and is reported as null or zero. If that same value is missing in a lookup table, the April row does not exist. The previous or next value (March or May) is reported, depending on whether the level is set to beginning or ending value.

---
Please post your comment on this.

0 comments:

Post a Comment

Note: Only a member of this blog may post a comment.