Manage revenue with Impact: Page 2

Posted September 1, 1999
By

Kevin Strehlo


(Page 2 of 7)

Conforming dimensions. Brio had to source the product table from two different product tables. One table supplied three of the five product hierarchy levels, another the other two levels. A manually created mapping table then related the two.

For Organization, the dimension table was sourced from a single source system, but the fact tables did not always contain the business key values (AE Name and RD Name) required to find the matching organization record. By using a site_id lookup into a staging table that mapped site_id to a close proximity of the business key, most instances resolved to a single organization record. In some cases, multiple Str_org rows matched these two values and special rules had to be developed to determine the appropriate one to use.


Page 2 of 7

Previous Page
1 2 3 4 5 6 7
Next Page





0 Comments (click to add your comment)
Comment and Contribute

 


(Maximum characters: 1200). You have characters left.