OBIEE Step by Step Guide

January 21, 2010

BI Apps — Supplier Dimensions Explained

Across all the BI Apps packages suppliers are always involved. The Supplier Family in OBAW has been stored in different tables.

Most of the important ones that need your attention are:

1. w_supplier_d

2. w_supplier_product_d

3. w_supplier_account_d

While w_supplier_d dimension helps in understanding the supplier profile like supplier number, supplier name, w_supplier_account_d gives you more info about account info like bill of exchange limit, vendor account number, alternate account number, payment terms agreed upon, payment currency for this supplier and so on.

So What about w_supplier_product_d? Its Supplier Product Info. Contains product catalog info like product info, lead times, product lot size, payment terms, purchasing department involved with this supplier.

Any idea why the w_supplier_d dimension is not mentioned in data model reference guide of OBI Apps.. Only Oracle knows 🙂

Advertisements

2 Comments »

  1. W_PARTY_D contains all the entities

    Comment by Chetan — March 12, 2010 @ 1:21 pm

    • Supplier is based on W_PARTY_D and W_PARTY_ORG_D (with the Supplier_flg = ‘Y’)

      Comment by arosalesar — May 25, 2010 @ 7:01 am


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: