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.
Thursday, May 08, 2008
Difference between accessing fact table and lookup table in Grouping option of Metric creation
Posted by
Ashish Tiwari
@ GMT
10:19 AM
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.